Search results

I am trying to grab dates in a certain range inputted by the user on a form and grab from and to date criteria but I try and the dates are acting like numbers, I have tryed to enclose form reference like #[forms].[frmVAT].[txtFrom]# but syntax error. DOnt know what to do. please help I want...

Basically I have a query that I've created to sum up multiple fields from a table, the only problem is I have a number field that is a company number that is repeated within my table for other contacts from the same company, that is then picked up by the query. I dont want this to be repeated...

I got help yesterday with a problem and got help working it out or so I thought, heres whats happening OK here it is the code, test this and tell me why it won't work it makes no sense. Basically this is executed on a button click from a form and the values serviceno and start are normally...

Here my statement: DoCmd.RunSQL "INSERT INTO [timesheet header](flag) VALUES(-1) WHERE [timesheet header].SERVICE_COMPANY_NO = serviceno AND [timesheet header].PERIOD_STARTING = start; I know the syntax of this querys is probly well off but i have tried so many different ways but can't get it...

I have made a validation routine to check through my data to see the values within my table are correct using the code below. I know theres errors in my table yet no errors are found. I know its something to do with my referencing of these table fields :RS![C/F] & [BalanceC/F] as when I step...

I need HELP! O(o_o)O --------------------------- I am suriously stuck, Debugging code without documentation is a nightmare for trainee programmers. Basically I need to loop a record set called Summary and Validate all informtion containned within it, I assume the way I can accomplish the task...

Basically I want to create a form that allows the users to select there formatting preference for all my database forms. I want the users selection to be replicated through out the whole database on all forms but I dont want to indivdually reference and assign all controls within my database...

Basically am new to Access so am lookin for help Heres my problem, I'm tryin to create a form with a button which opens up a common dialog box and when I select a graphic file with the dialog it will update my database with a new path to the file I open and possible display the new image on the...

Basically am new to Access so am lookin for help Heres my problem, I'm tryin to create a form with a button which opens up a common dialog box and when I select a graphic file with the dialog it will update my database with a new path to the file I open and possible display the new image on the...