Search results for query: *

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...

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...

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...

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...

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...

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...

When I converted a 97 database back and front ends to 2000, there seemed to be no problem, at first. Then I noticed problems with code and the occassional expression in a query where there use to be a field! Then I find the field that was there in 97 is not in the table in 2000! I can still...

I converted 2 97 databases to 2000 and made mde files on my computer at work, had no problem. (actually, I did discover that one field in one table was dropped. It showed up in the forms and queries as an expression. I did the conversion again and it was fine, unless there is another field...

In the Access 97 help files, I found some info on "greatly enhancing performance when opening the main database and opening tables and forms by forcing the linked database to remain open. To do this create an empty table in the linked database (back end?) and link the table in the main...

In Access help files, I found the following regarding improving performance of linked tables: "Create an empty table in the linked database and link the table in the main database." I'm not clear on which is the "main database," the back end or front end? I'm assuming it's...

We have 2 registration databases in Access on a network, with 4-5 users. I think by most standards, they are not that big (the larger one is approx. 35,000KB) Within the next 6 months or so we plan to combine, or link the databases. Sometimes, it can run slow (or at least doesn't zip along)...

I have a replicated database on an offsite computer. Reports with date functions in the query (i.e. <date()) and reports that are grouped by month based on a date get the message &quot;Function isn't available in expression in query expression...&quot; I had the gal make a new query and use...

I want to use an expression to generate a deposit amount due. If the total due is for $1656 and I want to figure a deposit of 30%, when I use =[totaldue]*.30 i get 496.80 I would like to make the number round off to the next dollar, 497 or even better, be able to...

I have windows NT at work. We have Windows 98 at home and my husband is forever running the defrag. He says I should do this at work, but can't on Windows NT. He's concerned that I'm going to crash and lose everything. Our company's technical support doesn't think it's necessary but I...

In my office, I am the only one with Windows NT and the computers are networked (I am not the server.) Using Network Neighborhood, I can get into my co-worker's computers but when she tries to access mine she gets the message:&quot;//my computer is not accessible&quot; and then &quot;No...

I have a database on Access that is for registration of groups and individuals for events at a year round camp. My office is an hour away from the site where the database will be primarily used. I plan to have the back end on the server, which at this time is Access 97 and front ends on...

I would like to have either a message box or form popup when I enter a new record and already have an existing record that has the same first and last name. For example, If I enter Tom Jones and I already have a record for a Tom Jones, the message would let me know that and show me his address...