Search results

  1. browninaz

    Help cleaning up this code

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

    Help cleaning up this code

    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) _...
  3. browninaz

    Using =DLookUp for multiple fields

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

    Using =DLookUp for multiple fields

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

    Using =DLookUp for multiple fields

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

    Populating a text box control with data from a field in a table

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

    Populating a text box control with data from a field in a table

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

    Run-time error ‘2450’:

    sneuberg, thank you so much! That did it.
  9. browninaz

    Run-time error ‘2450’:

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

    Run-time error ‘2450’:

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

    Run-time error ‘2450’:

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

    Getting a combo box to show an update to a new record in a table

    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!
  13. browninaz

    Getting a combo box to show an update to a new record in a table

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

    Problem Opening Two .accdb Files At Once

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

    Problem Opening Two .accdb Files At Once

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

    Textbox controls not loading when form opens

    Hello everyone, I am having a hard time with this project that I'm working on at the moment. I have created a modal dialogue form that has a macro set to open another form and close the current form at the same time. The form that is being opened has textbox controls that have the default...
  17. browninaz

    Textbox control not filling when default value is set

    OK everyone, I have a bit of a quandary here. I have 3 tables, tblClients, tblClientDetails, and tblSchedulingDetails. I have a field in tblClientDetails to contain the client number from tblClients, and I have two fields in tblSchedulingDetails to contain the client number and the client...
  18. browninaz

    Command Button Spacing

    Thanks spikepl, After 5 years of playing with MS Access. Hmmm.... The arrange menu, I've never really used it, but I am sure that it will be a new tool in my arsenal.
  19. browninaz

    Command Button Spacing

    Hello everyone, Simple question for most, How do I equally space buttons on my forms using the property sheet in design view? I have been using the ruler, but it can be a pain sometimes. Thanks to all who know more than me...
  20. browninaz

    Simple Input Mask Expression for No Duplicate Entries

    Thanks guys for the quick comments. The controls are bound to a table, and if I must, I will throw some code In that control. Here's where the less than intermediate user gibberish starts... With the right code, If the control is bound to a table, will the code I apply to the control apply to...
Top Bottom