Search results for query: *

Great. This is not an autonumber field. It is merely a manual input field by the end user so this code should work wonders. Thanks alot.

What would be the code that I need to add?

I have a form [form1] and a field [number]. The number is set as the key and to not allow duplicates. However there is not a message telling me that the number is duplicated until after i have completed the entire form and either move on to the next record or close it. I need something to run...

Thanks Rolliee. That is what I did and it worked well. Thanks again. Chad

I replicated a database and now it has data errors. I copied the s_GUID and filtered the records and deleted it. But the data error does not go away. Now both databases have data errors but when i copy the s_GUID and try to filter it, it does not show a record to update or delete. What...

I have a database (Banking+.mdb) on my Main Server and a replicate on our Branch Server. The reason I do replicates is that between the branch and the main bank there is a full T1 line however I can only have 8 Channels for all data which translates into about 448Kbps. When I replicate at...

If I open an Excel or Word file in Windows Explorer I get the following error when it loads. (<document name> is being used by <user name>. Do you want to make a copy?) If I open the file by starting Word or Excel and go to FILE and OPEN then this error does not occur. Any suggestions for...

The code worked magic. Now I can update automatically. Thanks!!!

I have a database in Access 97. I made it replicable and made a replica at our branch server in a different city. Every day before I go home I have to manually synchronize them so they get our changes and we get theirs. Is there a way to automate the synchronization process to occur at a...

Hey! It worked without having to code the on exit. When I first tried the code i tried it on a sample database with the same fields but it wasn't working right. As soon as I got back to work and tried it on the real database it worked like a charm thanks for your help SMerrill!!!!!!

And how do I do that?

Thanks! SMerrill! It works &quot;sort of&quot;. When a change is made to the memo field the Checkbox doesn't update until you go to a different record and then go back. For some reason it's not updating like it should. Any suggestions?

I'm trying to get a checkbox to check or uncheck depending on if there is information in a memo field. This is what I've done so far. I have a single check box bound to field [e]. I have a memo field bound to field [except]. I've created a macro &quot;e&quot; with a condition of...