Recent content by storer

I would like to use a query that includes an ole object (signatures) and merge it with a Word document but all I get is "Long binary or text value" where the signature should be. I have tried the Microsoft Knowledge Base and the Keyword search for this sight but can't find an answer...

Thanks for your helpful comments! The database already is seperated between front and back with only the back end replicated. Only about 20% of the tables contain data that both locations use and require syncronizing. I would like to use your idea of creating a generic database and...

When syncronizing 2 replicas, I received 2 error messages, the first said they weren't from the same set (they are!), the second saying that the one database was not a replicated database. When I looked, much to my horror, it had "lost" it's replica status! Out of desperation and...

Thanks for your help! It works great!

I have a report where I would like a number, which is the result of a calculated field, to always round up. If the answer is 8, I would like the report to read "8". If the answer is 8.3, I would like the report to read "9". Currently, 8.3 rounds down to 8 and 8.6 rounds up...

Looking for code that will shut down a database that is shared on a network when there has been no "activity" for a specified time. Users tend to get into database for info and then leave it up while they do other things...go to lunch,etc... Makes it run slower for those using it and...

I have a front-end/back-end application on a network with several users. When trying to merge a query ( it has parameters) with a word document, user occassionally gets the error message "File in use. FrontEnd.mde is locked for editing by "another user". Click notify to open as...

We have a front end back end application. Front end is mde and back end is mdb and replicated. Most of the data entry is done at a location an hour away from my office. The back end is on a server that, until just a few days ago, had 64 mb memory, runs on windows 98 and Access 2000. Front...

thanks for your help! I realize my problem was in the one to many relationship. After looking closer at the tables, the information they contained and how they related to each other, they should really have a one to one relationship...which also fixed my problem!

Have a subform that is based on a query with 2 tables that have a one to many relationship. The key from the one side is the link between the main form and subform. I can add records to the subform fine, but when I delete (do have cascading update and delete turned on)only the record from the...

Thanks Terry, I'll check out those sources. I did try to delete the ldb file but didn't work.

We have a database with front end linked to back end on a network. It is like this on the server and then each work station has its own front end linked through the network to the back end. Twice, when I've wanted to replace the front end because of revisions, I couldn't because the ldb file...

thanks! I'll give that a try!

Does anyone know if a wizard exists, (or knows of the code) that would take information from a table regarding the arrival and departure dates of groups (i.e. the Boy Scouts are arriving on Friday, May 25 and leaving on sunday, May 27) and place them on a calendar. There could be more than one...

I imported the back end into a new database so it wasn't replicated anymore and converted it back to 97...and the missing fields were there! I then converted it back to 2000, fields still there and then replicated it and that seems to be where the fields are disappearing, or rather relocating...