Search results

I need to open a database from a hyperlink in Internet Explorer. Here's my link: file://c:/databases/dbname.accdb If I put the above in the Windows Start Run it opens. If I enter into the web browser address bar it opens. Anybody know why it won't open from a link? Thanks in advance, Derek

When you select the print button on a form an input box asks you how many labels you want to print. Print/Preview report pops up, shows label, sheets, etc...when the users selects the print button, most of the time only the first sheet prints. If he prints again they all print. Anyone ever seen...

ok...that's beyond me, but I'll look into it...Thanks

pbaldy, You are correct, that works. But how come I can't grab the <> from the form? If I place them directly in the query it works. I would like to have the query grab them from the form. DT

If I put this in the criteria field (minus the quotes) "<>8" the query works find. If I try to capture the same info coming from a form with this in the criteria field (minus the quotes) "[Forms]![formname]![textfield]" it doesn't work. Any suggestions? Thanks in advance. DT

Yes, everybody is out of the database when compacting. I'll check on the permissions...thanks for the help.

When compacting a database on a network an extra database is created and left called db1.mdb. I don't see this problem when compacting locally. Any suggestions? Thanks

I'm having a terrible time with this database. It's a certification database. I need the subforms to show all training available (no comboboxes). I know I'm over thinking this thing but I have hit a wall. Here is a some info about the database: Example: EmpID 21445 EmpName Jon Doe...

David, I am doing something similar. I ended up creating a VB front end for the end user and the database for the managers. We are getting weights from a scale. The problem we are having (not really a problem) is that they user has to press a button on the scale to get the info and press a...

Question: Is it possible to see if a database has stopped running (errored out, timed out, or if code builder is open) thru another database. I know how to look for the .LDB file to see if the database is open...but is it possible to know if it's broken? The reason I ask is that I have a...

I have built a requisition database. When the user fills out the form they email a snapshot of the report to their supervisor for approval. I need to find a way for the supervisor to approve requisition without openening the database. Does anyone know if this possible? Thanks, DT

Thanks for the links...anyone else?

Does anyone out there have any helpful info to the advantages of splitting databases? We are in the process of converting from 97 to 2003. I usually split my databases and would like to present the advantages to splitting them to other users and our Database Administrator. Thanks, DT

I've split the database and have a version table in the FE and a linked version table to the BE. On start up if the version numbers are different the user is asked to update the database. The problem I have is after the database FE is copied over (batfile) the Version numbers are still different...

I'm trying to do the same thing with some databases. The problem I have is after the database FE is copied over the Version numbers are still different because the Master FE is still showing different Versions. How did you get around this? Thanks, DT

I have a database split with a frontend (FE) and backend (BE). Both reside on our network. I give a copy of the FE to all users. The FE is linked to itself so if I make a change to the network copy the next time a user opens theirs it tells them to close down and it recopies itself. This works...

We have an excel form that gets info from another piece of software. I've been asked to do this: Example when cell A3 in excel shows a "1" then add cells A1, A2 and A3 to an access (97) table: cell A1 cell A2 cell A3 info info 1 Is this possible? Thanks, DT

Thanks for the help...I got it fixed. I convinced the IT dept. to let me put a Front End of the database on all the pc's. Created a .bat file and got it copied out. Now I can update/compact the Front End on the network and when the user opens their copy it will tell them they need to update...

Hi- I have a form in a database that is just a look up form (you cannot add or delete records). How can I prevent this (see below or attachment) from happening? ********************************************************* 'FormName' has been changed since the last time you opened it, either by...

We have a database (Access 97) that's shared across a network. I have a routine that will close the database when I want. The problem is, there is one form that won't shut down. The form is just a search form. No adding to it is possible. I get this message...