HELP!! Microsoft Access isn't launching all of the time. It's hit or miss and not reproducible. This started happening within the last 2 weeks. Task Manager shows it open. There is a lock file created. It's just not visible on the computer. It's happening with many different databases. I've seen...
I'm trying set the query criteria from a textbox on a form. It's a Status field in the query. 1 = Open, 2 = Closed. If I set the criteria to "1" it shows all open, "2" and it shows all closed and "1" or "2" it shows all. The problem I'm having is setting these in the form. I've set the query to...
I inherited a database. I want to change all the text/criteria in one column from * to ISSUE. Why they used the * I'm not sure. The problem I'm running into is that because the text is a wildcard it changes all the info to ISSUE. Suggestions?
Thanks
MS Office sp1
Attached is the error message we get when trying to email pdf of a report in Access (using SendObject). This was working until last week. There was an MS Office sp1 installed. If I shut down Outlook, I can email from Access but the To:, Subject Line and Body Message are empty...
I've been asked to get some percentages of how many of each CardVal by Dept. The query looks like this:
CardID CardVal Dept
1 F 21
2 F 21
3 U 21
4 IP 21
5 F 21
6 U 21
Is...
MS Access 2007.
Our barcodes are missing when we email a report as a pdf file using VBA. If we print/preview a report and email the report the barcode still exists. Here is the code I'm using in VBA:
DoCmd.SendObject acSendReport, "Report_Name", "PDF Format(*.pdf)"...
This one has me...
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...
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
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...
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
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 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
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...
I can get my Treeview form to work like this:
-Parent
--child
--child...
What I need is this:
-Parent
--child
--child
--child1
--child1
Here's the code for the first example:
.Add , , "Work Orders", "Work Orders", "Right"
.Add "Work Orders", tvwChild, , "Standard...