User Profile

Collapse

Profile Sidebar

Collapse
Light1
Light1
Last Activity: Jun 17 '08, 09:48 AM
Joined: Feb 27 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Light1
    replied to Compile error - Invalid qualifier
    I did find out where to do the step through and find out the whole error message which says the form is either closed or doesn't exist. I know the spelling of the form is correct, so I am trying to find where else it might be breaking.
    See more | Go to post

    Leave a comment:


  • Light1
    replied to Compile error - Invalid qualifier
    Thanks for your help. I did alter it and although it does not show the same error, it does highlight the same line. When I put my cursor over it now, it shows this beneath it:
    Current Project...=<The expression you entered refers to an object that ...

    I couldn't find a way to view the rest of that statement - if there was more to it. Do you know what that means?

    Thanks also for pointing out some of the other...
    See more | Go to post

    Leave a comment:


  • Light1
    started a topic Compile error - Invalid qualifier

    Compile error - Invalid qualifier

    My form (frmERLogs) for this project (ER Log Book) has a combo box (cboMedicalReco rdNumber) that I want to be able to double click on to bring up a new form (frmPatientInfo rmation) when a name is not already in the list. When I double click on that combo box, I get this message 'Compile error - Invalid qualifier'. Below is the coding for the double click event:
    [code=vb]Private Sub cboMedicalRecor dNumber_DblClic k(Cancel As Integer)
    ...
    See more | Go to post
    Last edited by Stewart Ross; Mar 14 '08, 11:52 AM. Reason: code tags added

  • Light1
    replied to Updating table from a form
    Sorry, I am completely new to Access other than classes about 6 or 7 years ago. This is the first project for me and I really did not know how much was needed to report this problem.

    Overall Objective: I work for a small hospital. Our ER department is still manually writing down their information in a log book and they want to automate it. They do have a registration desk that keeps track of patient information and that is already...
    See more | Go to post

    Leave a comment:


  • Light1
    started a topic Updating table from a form

    Updating table from a form

    I am working in Access 2003. I have a form that pulls information from a couple of tables. When the user chooses a selection from the dropdown menu of a combo box, it is putting that information back in to the table as a duplicate of a record that is already there. (Example - a field has 3 choices - good, fair, stable - after using it a couple of times and choosing good, would now have good in the drop down menu several times). I only want the...
    See more | Go to post

  • Light1
    replied to Report error - Operand without an operator
    It worked. Thank you - I really appreciate your quick response....
    See more | Go to post

    Leave a comment:


  • Light1
    started a topic Report error - Operand without an operator

    Report error - Operand without an operator

    Hi - I am completely new to access - this is my first project and I have a question that is probably extremely easy for most.

    I am trying to take two fields of information and combine them in to one field on a report. I have the following code in the Control Source:
    =[tblAdmittingNur se.First Name]&” “&[tblAdmittingNur se.Last Name]
    I receive the error "You may have entered an operand without an operator"...
    See more | Go to post
No activity results to display
Show More
Working...