Search results for query: *

Morning, (Well, it is here at least. Im designing a query which selects five fields to display as columns in the table view in access. Problem is, one of the columns doesnt show, no matter if it's via a hand typed SQL statement or a design view made query. Strange, I know. I investigated...

Afternoon all, Wondering if one of you good people could give us a hand with my SQL string. The debugger says there's a problem with the sql statement and that's all it says - pretty helpful :) I've looked over my code, but i've prob over-looked the error - if you could see what's a miss it...

Hopefully someone has com across this control before and could shed some light on my situation. I have an ActiveX Calendar Control 11.0 ( class:MSCAL.Calendar.7) on a form in access, below it is a label. In the Form's onOpen event i have the following code dateLabel.Caption = Format(Date...

Hi all, The problem I am having is with a data entry form in my database. The form is used to update hours worked on a job. First a siteReference is chosen from a combo box called "seRefText". This then fills another combo box, "fmRefText", with all the possible jobs for this site. The...

Help me obi-tek-tip-kenobi, your my only hope. What im trying to do is make a temp table Work_Backup from Work, then remove some data from Work_Backup, clear Work entirely and then copy all the data from Work_Backup, back to Work. Now, I can get it all to work perfectly right up until the...

Can anyone here shed some light on this problem whenever the code below is run the following error appears Runtime error 3061 Too few parameters. Expected 2. This is the code that causes it, the long line of SQL is where it stops. Dim Db As DAO.Database Dim strSQL As String Set Db =...

Hopefully someone can help me out with this one... All im trying to do is use the value of a textbox as an SQL query with the DoCmd.RunSQL but every time I try and get it to work, it throws up and error of "A RunSQL action requires an argument consisting of an SQL statement." The value of the...

After my last plea for help, hopefully ill get another helpful comment. I have a table called work which contains the fields "FM Reference", "Designer" and "Hours Worked". What I am needing is a query that will overwrite an existing record if the FM Ref and Designer equal that supplied and...

Right here goes... I have two tables, one named job, one named work. The job table describes the jobs gving them a unique reference called fmRef. The each record in the work table lists the designer that worked on the job, the job's ref (fmRef) and the hours worked. The problem is, is that...