Search:

Type: Posts; User: jmnees; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Thread: VBA vs Macro

    by jmnees
    Replies
    2
    Views
    769

    VBA vs Macro

    I have the following code in the AfterUpdate event in a modal form. The code runs fine in VBA, but if I try putting the code in a macro with the Requery action I get an error 2950. Is there some...
  2. Replies
    5
    Views
    841

    Sorry about that. Function...

    Sorry about that.

    Function fncRmvNonAlphaNmrc(strInput As String) As String

    Dim i As Integer
    Dim strOutput As String

    strOutput = vbNullString

    If Len(strInput...
  3. Replies
    5
    Views
    841

    I'm having problems with a query in Access...

    I'm having problems with a query in Access 2007,running under Windows 7.

    select * from
    tblInventory
    WHERE fncRmvNonAlphaNmrc(UCase(Dscrptn)) = "KB"
    AND ID = 1833
    AND Len(Dscrptn) > 0

    I...
  4. Replies
    3
    Views
    788

    I've written a couple of simple functions that I...

    I've written a couple of simple functions that I need to use in Excel spreadsheets to transform some text into a specific format that we use. The function works well, I created a module, coded the...
  5. Replies
    4
    Views
    466

    Hans, I tried that one, no luck, got the same...

    Hans,

    I tried that one, no luck, got the same 2001 run-time error. Any other suggestions?

    Thanks...
  6. Replies
    4
    Views
    466

    I've got a problem formatting a string that...

    I've got a problem formatting a string that contains a date. I'm trying to set the form filter property when the error occurs, the recordsource is a query. I know it's probably something small that...
  7. Replies
    5
    Views
    1,841

    If you try to assign the RowSource property in...

    If you try to assign the RowSource property in for example the On Open event of the report, you will get an error message. You can only set the RowSource in design view, whether interactively or...
  8. Replies
    5
    Views
    1,841

    Although a chart object has a RowSource property,...

    Although a chart object has a RowSource property, this cannot be only be set using VBA if the report is opened in design view, not when it is opened in preview mode or being printed. So you can't use...
  9. Replies
    5
    Views
    1,841

    I need to change the RowSource property for a pie...

    I need to change the RowSource property for a pie chart that I have in a sub-report. The chart is in the Report Header section of the main report.

    Main report: rptAccountSmry
    Sub report:...
  10. Replies
    1
    Views
    376

    I need help designing a form that will be used to...

    I need help designing a form that will be used to define filter criteria for a report.

    I'd like to have a main form with a subform in datasheet view. The user would use filter by form (subform)...
  11. Replies
    2
    Views
    406

    That works, thanks for the help...

    That works, thanks for the help...
  12. Replies
    2
    Views
    406

    I'm having a little problem with an additional...

    I'm having a little problem with an additional monitor I attached to my Toshiba laptop. I set the "Extend my Windows desktop" and thought I was cool, I dragged the control panel over to the...
  13. thanks for the reply...

    thanks for the reply...
  14. Thread: Report problem

    by jmnees
    Replies
    6
    Views
    468

    Just figured it out. I hard coded each label and...

    Just figured it out. I hard coded each label and text box (there were actual several, I just listed a couple for an example) to False and compiled. I got an error "Invalid Qualifier", never saw...
  15. Thread: Report problem

    by jmnees
    Replies
    6
    Views
    468

    Still the same thing. I added an IF statement in...

    Still the same thing. I added an IF statement in the Format event, the checkbox value is referenced correctly, it comes accross correctly. The visible property of the labels and text boxes is not...
  16. Thread: Report problem

    by jmnees
    Replies
    6
    Views
    468

    Yeah, that's exactly what I'm trying to do. The...

    Yeah, that's exactly what I'm trying to do. The checkbox is on a form that I run the report from. I had tried .Value with no success. I changed it back to .Value from .Enabled, but still no luck. ...
  17. Thread: Report problem

    by jmnees
    Replies
    6
    Views
    468

    I have the following code in the Open event of a...

    I have the following code in the Open event of a report:

    Me.ClientReference.Visible = Forms![frmMain]![chkIncldMnfstDtls].Enabled
    Me.lblClientReference.Visible =...
  18. Isn't there a way to get Windows Explorer to load...

    Isn't there a way to get Windows Explorer to load the "Folders" tree by default in the left hand pane instead of "File and Folder", "Other places", and "Details"?

    Also, I have an HP Officejet that...
  19. Replies
    5
    Views
    1,035

    Yeah, I've rebooted several times with no luck. ...

    Yeah, I've rebooted several times with no luck.

    Here's the scarey part, I copied one of the databases from my laptop to a backup pc, opened the the db on the backup pc, opened the table and...
  20. Replies
    5
    Views
    1,035

    I have a problem. Every time I open a table in...

    I have a problem. Every time I open a table in design view and try to edit the indexes I get an error.

    "The table is already opened by another user..." and then it opens a form based on the...
  21. Replies
    2
    Views
    371

    Re: Recordset Loops (2002/XP)

    Combos huh? Never seen that before, very cool.
  22. Replies
    2
    Views
    371

    Recordset Loops (2002/XP)

    I need to calculate the total combinations of rows from three single field tables, preferably without repetition, and store the results in a table. I’m not sure how to accomplish this, I’ve...
  23. Replies
    1
    Views
    489

    Scientific notation (2002/XP)

    I have a column in a table (text data type), containing serial numbers, the original data was imported from several .csv files (created in excel and saved as .csv format). This is old data, when...
  24. Replies
    3
    Views
    385

    Re: Highlight current row (2002)

    Edited by HansV to reduce picture in size - please don't post pictures larger than 640 x 480 pixels.

    I downloaded the database you referred to in post 680,964. I don't know what I'm doing wrong,...
  25. Replies
    3
    Views
    385

    Highlight current row (2002)

    I have a very simple continuos form that I want to have the selected row highlighted. I set up conditional formatting for each textbox and that works well, but it only formats the active textbox. I...
Results 1 to 25 of 144
Page 1 of 6 1 2 3 4