Search results

You mind sharing (1) with me. It would save me so much time.

Good idea. Have you coded it before?

Im exploring running query and sending emails on a scheduled basis to select recipients. Does anyone have experience with this? Is it difficult? Current procedure is to run it with a button. Looking forward to feedback. Private Sub Command38_Click() ' acFormatHTML, acFormatRTF...

This worked out good with the delete query and added the code to run it in the existing set. Even with years of experience never had to use it until today. I like both methods. Thanks so much.

Killing the existing table in access not the import file

I have to add a step to kill the last import of the file. Essentially, it will replace the existing table in the import. Do I use the kill file code? Code is as follows: DoCmd.TransferSpreadsheet acImport, 10, _ "Portal Mail List", CurrentProject.Path & "\Portal Mail List.xlsx", True MsgBox...

This looks like the way to go. https://support.microsoft.com/en-us/kb/132379

Anyone have a tool tip template I can look at. I have an advanced form with buttons and date fields. The users need to be able to hover over and get a brief overview of what the buttons and fields will deliver. Need some ideas. Thanks

Posted twice. Middle name is Michael. Thanks. I'll try to figure it out.

Perfect. Already have the column set up with date and have done that in the past. Im having a problem populating it on the form. Should be MaxOfDate Appended?

I have users run an append query from a button. Is there anyway I could have the date the query was last run displayed on the form by the button? Or if you know an option or alternative please share. Thanks.

I need to run an initial query which will have to go to one target table, and every time the query is run thereafter it will have to only yield new results not already on the target table. I have to enable users to run it by a click of a button. Some of the data is more than 100000 rows so...

I ended up trying it out but was able to get an append query to do it. How do you recomend I bypass the past the rows message for the users?

Users will press a button through a command. I would have to have the data export and update to the table at the same time. 2nd run would be the same but only new data so the 2nd would be only the data not present in the 1st run. Does this make sense.

worked like a charm. Thanks.

Im getting a message "Database was unable to append all the data table" in a database and cant seem to troubleshoot the problem. Does anyone know the VBA to bypass it after the event is run. I think it is because someone was in the database as the linked table was being updated.

I have a question for you. It is something I havent done before. I have to create an interface for users to be able to run queries which I can do. The trick is the queries will have to populate into a table. The queries will then be run weekly finding new only the new entries since it was...

Yes it is but I inherited the db. Im not going to change it.

Too many fields and check boxes per year would be too crowded and would not be clean.

I think I found your code