Search results

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

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.

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...

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?

Yes. What does that tell you.

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...

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

Thanks for your assistance.

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.

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

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.

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!!

Thanks. I'll keep that in mind.

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...

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

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...

I figured it out.

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...

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

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...