Search results

Hopefully a simple Query / SQL problem :-) I have a query that returns: id Weight EXP1(weight * 2) ------------------------------- 1 12 24 1 05 10 1 02 04 2 10 20 3 05 10 3 02 04 4 10 20 Is there a easy...

Slightly stuck on some VBA, and ive been looking at it for a bit too long for anything to make any sense :( I’m trying to select a value in a record with the ID in a Textbox, compare the returned value with another again stored in a Textbox, and then update the record. Below is a rough...

I have a data Entry form that enters information into many different tables. This works fine. To save and exit the form I have a save button with the following code connected onClick: MsgBox "Please Collect The Print Out" DoCmd.Close DoCmd.OpenForm ("Main Menu") This saves the data that has...

Hello I’m after a bit of help again. a) Is there a way to check to see if a Query is empty? – IE I have a form that takes information from a Query, and I don’t want this form to load id the Query is empty. b) Is there a way of checking with statement if a field still says “(AutoNumber)”...

First off im not 100% sure if this is the right place, as its too do with Forms and VBA, so sorry if its in the wrong place. I have a form (Dispatch) with a subform on it (Dispatch - Sub(Status)). The "Dispatch" form has searchable data, whist the "Dispatch - Sub(Status)" subform is a data...