Search results for query: *

I'm trying to get some code to open an Access database file from within Excel. I don't need to open a specific table or form, I just need to open the database and the user can decide what they want to do from there. I've tried the following code, but I'm not having any luck. I have just been...

I am trying to modify a database. The only problem is that there's a column with numbers formatted as text in a couple of tables. In one table there are leading zeros, but not in the other table. So, the query isn't working correctly, I'm assuming because it doesn't find a match due to the...

Don't get me wrong, I appreciate the help. Also, I shouldn't have even posted to the other board anyway, but you should have just said that in a little more respectful tone. Everyone makes mistakes here and there.

No need to get an attitude. You could have said the same thing, but in a more respectful tone. It's called people skills.

Thank You

I created a make table query. I now want the resultant table to have a different name and renaming the query doesn't work. Also, I know how to rename a table, but that won't change the fact that everytime I run the query, it will give me the original name. Where can I go to change the name of...

I created a make table query. I now want the resultant table to have a different name and renaming the query doesn't work. Where can I go to change the name of the table that the query creates, or will I just have to redo the query? Thanks in advance for any help.

In Excel, when you share a workbook the minimum you can set the save time for is 5 minutes. This can lead to multiple people trying to add information to the same row without knowing that someone else is editing the same cells. Is there anyway to reduce this problem of multiple people editing...

I have a parameter query, where the user is prompted for a week number, and the query displays a list of all records with the inputted week number. The query will display the response time (in days) and week number for all records. I need to get an average response time for all the records in...