Search results

Text27 = DLookup("SumOfSumOfDocCount", "SumTotalPerf", "DateReceived = #" & Me.Text23 & "# AND BookedInID = " & BookedInID & "") Not working, however when I use the code below I can pull the value that matches the date but canr add the BookedInID as a criteria aswell?? Text27 =...

The ID is a numerical value

Text27 = DLookup("SumOfSumOfDocCount", "SumTotalPerf", "DateReceived = #" & Me.Text23 _ & "# AND BookedInID = '" & BookedInID & "'")

Thanks for your help but no it hasnt really helped, still getting no value

Hi Im having a problem pulling some data from a query to populate text boxes in a form Text27 = DLookup("'SumOfSumOfDocCount'", "SumTotalPerf", "DateReceived=" & Forms.Tracker.Text23.Value & "AND 'BookedInID'=" & Forms.Tracker.BookedInID.Value) Im trying to pull the sum of document count from...

No sorry!?

How do I do that?

Ok im making progress, I can save and requery but it doesnt alter the record i selected from the list it changes the next entry above it leaving the old entry unchanged and the new entry below???

Bound and re queried I can do, force saved im not so sure?

I have tried me.list.requery after the textbox update but nothing happens

Hi guys I hope someone can help me, I have a list of products that I display in a listbox, when I double click a product its details display in the appropriate text boxes for me to edit but when I edit the value in the text box it does not change in the listbox, why is this? Thanks in advance

Hi all, I am trying to create a Special Recorded tracking database where a member of staff will log the tracker number into the database and then at a later date someone can come and update the data, what I want to do is scan the tracker barcode with a scan gun and its details appear for...

Works a treat, Thanks!

I have an access database which records stationery orders made by different departments within the business, once the order is complete a combobox is used to set the status of the order to "Pending" once this is done the Facilities manager will open the database and extract the "Pending" orders...