Recent content by browninaz

Thank you, that is exactly what I was looking for. Love this forum!

Hello Everyone, Just wanted to know if there is a better way to write this procedure: Private Sub cmdCancel_Click() 'This line does not allow the user to close form if any field is populated If Not IsNull(Me.ClientFirst) Or Not IsNull(Me.ClientLast) Or Not IsNull(Me.ClientMainPhone) _...

Thanks again Mark, I will have to take a closer look at my table structure and relationships, and try and conceptualize the advice that you just gave me.

Thanks Mark for the response, I have tblPurchaseDetails, which contains the foreign key from tblEquipment, the foreign key from tblSupplies, and the foreign key from tblOffices. I then created a query from tblPurchaseDetails, which contain only numbers in the fields from tblEquipment...

Hello Everyone, I have a multiple items form that displays purchases for a certain area. The purchases include items from two tables, with two different numbers. I have just learned how to use the =DLookUp function, but I would like to eliminate multiple controls on each line by using one text...

Nevermind. Thanks for all who looked at this post. I found the answer. =DLookUp

Hello everyone, This is probably an easy question for most. I have created a multiple items form from a query that I created from tblPurchaseDetails. In this query, I have a field EquipmentDetailsNum that is in the purchase details table that derives from tblEquipment, but I would like to...

sneuberg, thank you so much! That did it.

sneuberg, that looks like it will be awesome! Give me a little while to implement and I will let you know if it works.

Thanks sneuberg for the quick response, I don't think that was quite what I was looking for. I need to find a way to not execute the code for the forms that are not open or being used. I have very little VBA coding knowledge, and I was fortunate enough to obtain the code that I do have already...

Hello everyone, When I update the data in frmPurchasesEquipment, I get the run-time error message: Microsoft Access cannot find the referenced form’frmPurchasesLivestockPlants’. I have requery code set to refresh the data in my combo boxes on 3 separate modal dialogue forms that the same...

Thanks a million arnelgp... This worked like a champ! I have been banging my head on this now on and off for some time. This saves me a bunch of time consuming work-arounds. I love this forum!

Hello everyone, The answer to this would make my month! Let me see if I can explain this clearly. I have a user form that has two unbound text box controls (txtSupplierName and txtSupplierNum) that have default values set from another form that opens this form. On the form that has the two...

Thanks Doc Man, It was (is) a Windows issue. Ever since the update, I've been exterminating.

Hello everyone, If designing and formatting my simple little database isn't time consuming enough, I have spent the past couple of hours trying to figure out this little conundrum: I have recently started, just within the past few days, having an issue with opening two .accdb files at once...