Search results

  1. C

    Next record button on a form

    I'll add your suggestion. Thanks for providing the complete code!!
  2. C

    Next record button on a form

    Hello, I have a command button on a form to go to the next record. If the current record is the EOF, the command will create a new record. What's the easiest way to display a message that their are no more records, and prevent a new record from being created.
  3. C

    multiple criteria in DLookup

    I appreciate all your help. I think I tried every possible syntax, and nothing seemded to work. Here's the code I wrote: Dim varX As Long Dim strtest As String varX = DLookup("SKICPart", "ICPart", "ID ='" & [ISBNBW] & "'") strtest = "FKICPart = " & varX & " And...
  4. C

    multiple criteria in DLookup

    I've resorted to using VBA code behind the form to retrive these values. It worked the first time. You think it's a problem with Access 2010 Dlookup?
  5. C

    multiple criteria in DLookup

    Yes. What does that tell you.
  6. C

    multiple criteria in DLookup

    Here's what I've tried. I don't think I've written, an FKICPart can exist in muliple warehouses. I've been separating the criteria to make sure they both work on their own. If I use this statement, =DLookUp("OnHandQty","ICPartWarehouse","WarehouseNo =3"), this works properly. If I manipulate the...
  7. C

    multiple criteria in DLookup

    I noticed that I had an incorrect field name previously. Here's the last criteria I tried. "[FKICPart] = '" & [text190] & "' And [WarehouseNo] = " & 3)
  8. C

    multiple criteria in DLookup

    Thanks for your assistance.
  9. C

    multiple criteria in DLookup

    I had to zip the file. The form is frmMasterTitle. On the tab "BWLookup". Text192 is the dlookup statement I'm working on. I'm been testing different things, so what's their is not what you've previously recommended.
  10. C

    multiple criteria in DLookup

    For the field name WarehouseNumber it will be 3. For the field name FKICPart it will be from a textbox on the form, text180.
  11. C

    multiple criteria in DLookup

    Thanks for the quick reply. I think I didn't give you all the information needed. Both of the criterias are fields within the table. So both FKICPart and WarehouseNumber are the field names within the table ICPartWarehouse.
  12. C

    multiple criteria in DLookup

    Are you able to have 2 criterias in a DLookup statement? Here's the vital info: Expr: OnHandQty table name: ICPartWarehouse criteria: FKICPart = me.FKICPart and WarehouseNumber = 3 Here's what I have so far: =DLookUp("OnHandQty","ICPartWarehouse",????) Thanks for your assistance!!
  13. C

    Strange Problem

    Thanks. I'll keep that in mind.
  14. C

    Strange Problem

    I like your writing. Thanks. The most confusing thing about this, I've run this process on my computer over 100 times, and it's worked correctly everytime. I install on the customer's computer, and their is a problem the first time. For any future databases, I'll remember what you wrote that the...
  15. C

    Strange Problem

    Isn't that what my insert statement suppose to being doing?
  16. C

    Strange Problem

    I’ve created a DB for a customer. I’ve executed a particular form at least 100 times on my computer and it has always executed properly. On my customer’s computer, it will not execute properly all the time. I’ve been unable to determine what is causing the problem. Here are the details: Table...
  17. C

    passing variable from modal form to main form

    I figured it out.
  18. C

    passing variable from modal form to main form

    On my main form, I have a search option that opens a modal form. When the modal form is opened, the main form remains open. The modal form determines a variable. Clicking ok on the modal form, passes the focus back to the main form and closes the modal form. How do I reload the main form based...
  19. C

    all fields visible false

    THANKS!! So I know in the future, will controls refer to every item on the form?
  20. C

    all fields visible false

    When the user opens the form, I don't want the fields to be displayed. I want them to select either to add a new item or update an existing item. Then after their selection, I will make visible the fields they need. The error message is: run time error '2455'. You entered an expression that...
Back
Top Bottom