Recent content by Electric Ant

Thanks for that. Will try it now.

I've got a problem with the order in which records appear in my form, and I just can't figure out what is wrong. It's probably obvious but I've been staring at it for too long now. I have a Parent form with several child forms on different pages. I've got a module to create records that appear...

I'm quite new to this Access malarky and not very clued up about SQL, but try breaking up the SQL statement to see which bit is causing the problem ie. just execute sql1$ first then sql$= sql1$ & sql2$, then sql$=sql1$ & sql2$ & sql3$ In your original code you had # 's in it?? Is that anything...

Do you need single quotes in there somewhere? like sql2$ = " AND [DatasetName] = ' " & Me!txtDatasetName & "'"

How about something like....... Dim cnndb As Connection Dim rst1 As ADODB.Recordset Dim sql$ Dim sql1$ Dim sql2$ Dim sql3$ sql1$ = "SELECT * FROM tblImportDetails WHERE [CreationDate] = " & Me!txtCreationDate sql2$ = " AND [DatasetName] = " & Me!txtDatasetName sql3$ = " AND [CreationTime] =...

Hello Danny I'm new to Access so this may be the wrong way of doing it but it worked for me. 1) I also created most of my form with a wizard and it didn't always lookup like I wanted it too. One way I found of changing it by experimenting was to go to your form in design view. If you have a...

I'm new to the forum so hello and thanks in advance for any help. I don't have much experience of Access but can wing it. In the last two weeks have been working on a database specifically for data entry using Access 2000/XP so we can automate data checking and to have user friendly data entry...