Recent content by David92595

In SQL there is a timestamp datatype. You can give the column any name you like. Though I always call mine TimeStamp...just to keep it simple. Once you create the column in SQL, update your access table(s) with Linked Table Manager under the External data tab. That's all that you'll need...

I didn't see anywhere that you specifically mentioned that you had a split database with a SQL back end. Your issue just reminds me of when I made the switch to a SQL BE and an Access FE. With a SQL BE you must have a timestamp field or you get the exact issue you are reporting. Truthfully...

Do you have a timestamp field in the table?

Hello Jeanette, I hope this message see you well. I was looking at my old conversations regarding Albert’s mail merge. I have been tasked with finding a way to select multiple documents from Albert’s mail merge menu to merge at once. Do you know how this can be accomplished? Or a good forum...

My apologies, I will do so in the future. David92595

Hello, I am having problems opening up a windows shell to a file path in a Module Function. I have it working as a sub, but am trying to convert to a module so it can be centrally located. I can get a basic explorer window to open RetVal = Shell("explorer.exe ") However, when I try to put in...

Hello, Basics: I'm running a SQL server 2008 R2 back end with an Access 2007 Front end. I need to find a way to attach documents via my access front end. I've done some research and there seems to be quite the debate about how this should be done. I don't have a full understanding about the...

Follow up question: Before I posted, I converted the macro I was using to a module, which is how I got the code I posted. Now that I've made the changes to the code, how to I call the function inside the module. Module Name is: TS_Search Public Function name is: TS_Search() Does it...

You forgot quotes before [TS], :D Thank you for the explaination, you've helped me solve more than one problem today, of that I'm sure. Thanks! David92595

Hello, I'm in the (not) fun process of having to change the data type of our PK to accommodate new requirements set by our clients. So far the switch has been surprisingly painless, except for my current problem. Basics: Running Access 2007 Front end, SQL 2008 R2 Backend. I have an unbound...

I don't think the perfect solution was figured out. But I was able to find some kind of a work around. I created a unbound combo box with an action after update with a macro. Action: SearchForRecord Argument: ="[ID] = " & Str(Nz(Screen.ActiveControl,0)) This has worked for my users...

I'm not indexing for queries. I'm indexing for data entry, and different parts of of different records are being added at different points. So I need a way to have our employees find the record in our DB so they can add addition information to a record. Having the table be the control source is...

I'm not running a query. I'm trying to index a table so searches, in our access front end will run quicker. we are currently having to wait a minute plus for a search, of a table of only 14,000 rows.

I tried your suggestion. Downside, it over rode the PK clustered index. So now our files are all out of order (they were ordered by PK). How do I create non clustered index's while still maintaining the clustered index as the primary index? David92595

Q: How many fields are you adding to this index? A: there are about 7 fields total that I've added to the index. They are our most searched by fields, Loan number, address, state, File status, ect. Q: Does it have to be a text search using a full text index? it would be much quicker to do...