Search results

I am not sure what you are trying to do but say you have a form with a command button called command2 and a text box called TextboxwiththeName You input a name on the textbox, then on click of the command button, this will go through the records if there is a same name, and then it will...

Check your first post. http://www.access-programmers.co.uk/forums/showthread.php?t=81370 (you posted this too in the query?) Pat is going to get you. :)

SELECT Table1.Time, Table1.Temp, Table1.Humid FROM Table1 WHERE (((Table1.Time)<>0) AND (([Table1]![Time] Mod 60)=0)); if you wish to get the average only of the above query: SELECT Avg([mod].Temp) AS AvgOfTemp, Avg([mod].Humid) AS AvgOfHumid FROM [SELECT Table1.Time, Table1.Temp...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vb98/html/vbmsgobjNoLicense.asp

Do you mean movelast? Is this a one-user program? can you post your code?

DoCmd.OpenTable "Mytable", acViewPreview DoCmd.OpenTable "mytable", acViewNormal

cut and paste the sql syntax

Are you talking about hiding the three other button on a form? OR Create a query with only one field?

If you wish to check the syntax, before running the sql , put it in a messagebox.

Edit the relationship: Uncheck the delete.

Did you create the program using your copy of Access 2000 or did you cut and paste it from some Access program?

dim db as dao.database dim rst rst as dao.recordset Set db = CurrentDb() Set Rst = db.opentable("Select * from Mytable") If Rst.RecordCount > 0 Then Rst.MoveFirst Do...

Have you tried compact and repair? I think thats a corrupt table. REcheck your code or table set up. (Ken Higgs was asking how many records.) IF you cant fix it, copy the structure to a fresh table then create an append query. If the corrupted data is number 23, append 1 to 22. then...

you can use a combobox.

Thanks for responding John. I'll give that a try.

Thanks a lot Pat. :D

One of the commandments of Access: Thou shalt not use Autonumber if the field is meant to have meaning for thy users. I have experienced that problem before. Believe me it always come back. I dont know if the commandment was the reason but i fixed it following the commandment, so far...

I can create multiple primary keys for a table MANUALLY (by highlighting several field then pressing the key icon) BUT I cant recreate it by code. HELP. Set NewFld = tdfnew.CreateField("TaskID", dbLong) Set idxNew = tdfnew.CreateIndex("TaskIDIndex")...

Are you using the autonumber ID as a meaningful data? - like it presents a primary key? Why 42? Check the code behind if its copying a data of 42 somewhere, maybe the current record or something else.

Create a command button on a form use the wizard. Specify that the command button will open a report. it will generate a code that looks like this: Private Sub Command1_Click() On Error GoTo Err_Command1_Click Dim stDocName As String stDocName = "MyReport" DoCmd.OpenReport...