Search results

Hello, I am using the autonumber type in my table. I have accidentally deleted a few records, but would like to sequencially continue the autonumbering. However, Access just continues from where it left off. I would like to reset the autonumber back to 1. How do I do that?

Hello, I am reading the following code and don't know what the '#' character is for. Any help would be great. stSQLArchive = "INSERT INTO [Transaction Archive] " & _ "SELECT Transactions.* FROM Transactions " & _ "WHERE ((Transactions.Date)<= #" & dtmCutOff & "# " & _...

Thanks that helped alot. I used a macro instead, but it lead me to the right direction. I am new to access. I am not having problems learning it, its just the lack of experience. Thanks for all the help everybody.

Sorry, but I dont know what you mean by re-query the listbox?

NO NO, I am trying to take another value from the form (text box) and use it in a query (as a criteria) to retrieve the information I want listed in the listbox. Therefore, I have to run the query in the "row source" property of the listbox. Because queries returned in the "row source"...

I can't run that query in the onCurrent event because the query results are supposed to be used for the listbox "row source" property. Any other suggestions

I had no idea that you can run queries directly from the event properties. Let me give it a try thanks

I am not using any events to trigger the query. I am assuming access automatically runs the query when the form is opened. This query is manually typed/entered in the "row source" property for a listbox. It seems that this query only runs once by default. As soon as I open the form, the...

I am trying to use a field value from the active record for a query in the "row source" property for a listbox. The query I entered works, but when I traverse to next or previous records, the query will not use the new field value from the current record to refresh the query. Is there a way to...