Search results

Thank you for responding. You want a temporary landing pad for you to then be able to decide which record is the one you want to use? Answer: Yes. If I could create a form where it would display the results of the BagNumber was = to the search criteria before running the Private Sub...

I’ve been working with DLookup on a form but wanted to see if I could expand on it further. When this database idea first came about, we were only processing about 100 bags in our system. We are now processing about 5000 bags. The bags are shipped to us from an outside location with numbers...

Thank you JHB... What happens when your query returns more values than what is on the list.... For example. I am doing an inventory of fuel for 50 cars. One car may have 2 transactions while another has 15. If I limit my temp table to 10, where would the additional 5 records go? How would i...

can you post a sample of the database?

I have been working with the below code for a few days but havent been able to reach my desired results. The code forces horizontal lines, but wont put it in the detail section on print preview, only the page header. I would like to force ten rows in the details section every time the report...

I believe they started the database based on a Access 2010 web template that tracks employees contact info. The program is shared over an exisiting windows enviornment network without a sharepoint sever. The program is used more for viewing information than gathering. At most, maybe 5 people...

that was exactly it. thank you both

Thank you for the response. I am still producing an error outlined in my attachments. 10.png shows the macro 11.png shows that the control name doesn't exist 12.png shows the macro single step 13.png shows the control name that I am attempting to refer too. Any ideas on what I am doing wrong?

pbaldy, did you get a chance to look at the sample data?

pbaldy, I have attached a sample database. I didn't create it, but was asked if the password features could be added. The password box is next to Edit Details. Thank you!

Thank you, I was able to fit that in my current macro outlined in the attachment "good". Working with the same text box, I was attempting to enable a navigation button. I have attached 3 additional attachments [help1, help2, and help3] outlined below. Is it possible to activate a navigation...

If you could, I am not sure where you are referring to. I have never played with a web database before and find it rather frustrating so far!

I am working with a 2010 Web Database that I recently took over. A request came in to see if I could password protect a certain form from opening with the appropriate password entered in an input box. This wouldn’t be a problem in VBA, however I am not exactly sure how to implement this in a...

With this database, it is shared on the network. The calculation when running the looop is pretty slow, maybe up to 5-10 seconds per click. Is there a faster way?

Got this to work, hopefully i'll be error free for the rest of the day! Else LResponse = MsgBox("Continue?", vbYesNo, "Property Information") If LResponse = vbYes Then rst.Edit rst![PropertyStatus] = 3 rst![DateOut] = date...

thank you for the attempt

Hello, I am working with an AfterUpdate check box. What am I am attempting to do is just before the highlighted red text is ask the user, do you wish to make the changes. I have a main form that feeds into a subform. The upper part of the subform is a continuous form while the form footer...

Did you check the settings from the subform, where it links the master to child?

I ended up duplicating what you did before the midline else statement and it works. The question is, is this the correct way of handling that? Thank you again. Private Sub Process_AfterUpdate() Dim dbs As Database, rst As DAO.Recordset Set dbs = CurrentDb If [Out to Mag Court] = -1 Then...

JHB, Thank you! I added the DAO.Recordset because it would produce and error and highlight rst.edit The only issue comes when unchecking the box. The code update only the first record and doesn't cycle through all the records like the first part of the code. Any suggestions? Private Sub...