Search results

Hi Tim, Not sure if this is the sort of thing you are looking for. http://www.acc-technology.com/iowiz.htm Anthony.

Message now appearing:- I now get the message:- Syntax error (missing operator) in query expression '[creationdate] = 27/10/2004 AND [DatasetName] = 'Learner Dataset' AND [CreationTime] = '14:31:41'.

Syntax Error (Missing Operator) Hi Electric Ant, Thanks for the relply, think i'm getting closer. I now get the message:- Syntax error (missing operator) in query expression '[creationdate] = 27/10/2004 AND [DatasetName] = Learner Dataset AND [CreationTime] = '14:31:41'. Any Ideas, Ant.

Hi Adaytay, I have changed the mistakes but unfortunately still nothing happens. Thanks for the reply. Ant.

Hi all, Have tried searching the forums but to no avail. I have a table the records imports to the database. It records the Name, Time Created, Date Created, Time Imported and Date Imported. When I import the a file to the database the Name, Time Created and Date Created are stored in...

Create a query with all the fields you require and then try pasting the following as the field in your query:- Expr1: =IIf(([dbo_vwSpotPositionMoveByBranchDealerCurrencyPortfo lio]![Portfolio])="MTDPAL"," ",[dbo_vwSpotPositionMoveByBranchDealerCurrencyPortfo lio]![Portfolio]) Then just...

Not really, Are you using the IIF statement in a query? Ant.

Hi gumbira, Should you have a space in the word Portfo lio? Ant.

I have a database which records vehicles passing through a weighbridge and records the date and time of weighing. What I am trying to do is create a query which shows all vehicles that have been weighed between two dates and times. What I have so far is select blah from blah WHERE...

Hi Brian, Sorry I haven't replied - been running around like a headless chicken for the past week. It works fine - Just haven't had the time to put in place yet though. Thanks again for your time and effort, much appreciated. Regards, Taff :)

OOPS!!! Try again. Ant.

Hi Brian, Thanks for the again for the reply. I tried what you said but I am not sure if i have done it correctly. I have attached what I have done. Regards, Anthony.

Hi Brian, Thanks for the reply, am a bit unsure how to do that. Could you please give me a bit more info. Many thanks, Ant.

Hi all, Really unsure how to word this so I have attached a sample of what I am trying to do. I have three tables:- tblStudents - Learn_ID Provi_ID Surname Forename tblSchemes - Learn_ID Provi_ID Lprog_ID Type_LPG ElwaOffi tblQuals - Learn_ID Provi_ID Lprog_ID Lacti_ID StartDte EEnddte...

One more question, How do you delay events from happening and cause them to be 2 or maybe three seconds apart? Ant.

Thanks again Mile-O-Phile, Works great. Ant.

Hi all, I have a form with Five labels on lbl1 to lbl5. What I would like to happen is have all five labels appear one at a time with a one second gap in between. Have tried on the on timer event but I seem to have all labels appear at once. Thanks Ant.

Hi all, I have a report, and when the report opens I would like to disable the menu's and only allow the user to close the report, prefferable without closing the application. Is this possible? Thanks Ant.

What was it?

Can you post a sample of your application. Ant.