Recent content by CapnOats

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...

found the prob immediatley before the sql section i assign data into all the variables - however i forgot assDate so that part of the sql string appeared as 20040722, 'se 2004-050', v3-cc-west-l2-181D-f', , 88.8, 'Mike', 'The Customer', 20040801, No, 0, No, 0, 0, 0 so there ends up being a...

the whole sql statement - it worked in the design new query window but when i put "" round it and start substituting test values out and "&variableName&" in its place Regards, Mike

the dates are actually integers not date types - im importing lots of data from linked tables from different types of sql servers and it was easier just to define a number like 20040721 and convert to that. i had the query working when i added a temp query and built it there, using real values...

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...

Thanks for the help, but no, it still deonst seem to be working, it really is quite odd. Ive tried several other things as well, including calendar.Today and calendar.Refresh, but still no further on. Regards, Mike

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...

If you open up My Computer, go to Tools->Map Network Drive.. a box will pop up. In the Drive: ComboBox there will be a list of all drives and any associated network paths there. HTH, Mike

I actually managed to do it by using combo boxes for all the input boxes and fudging a few queries here and there. Next time I want to do it cleanly, ill keep your tip in mind. It looks like it does exactly what I want. Thanks very much. Mike

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...

yeah, that work spot on - and thats my database finished! two days early, meaning - two days extra testing! oh the delights and joys of data entry! thanks very much Regards, Mike

how do you append all the data from a table tho? i was looking at something like INSERT INTO Work SELECT * FROM Work_Backup the syntax is not right i know, but that sort of idea - im working on another part of the db right now so i can test it any idea if this sort of thing would work...

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...

its ok, i worked out where the error is occuring - ill post back here for everyone once i work out a way around it Regards, Mike

that works brilliantly but now DoCmd.RunSQL "INSERT INTO Work VALUES ('" & seRefText & "', '" & fmRefText & "', '" & techCombo & "', '" & hoursText & "') WHERE Job.[FM Reference] = '" & fmRefText & "' AND Job.[SE Reference] = '" & seRefText & "';" doesnt work - missing semicolon at end of...