Search results for query: *

I have an Access db with linked tables from SQL server. There is password security on the SQL db. Everytime the Access db is closed the link to the SQL db is broken. Upon reopening Access I receive the message "ODBC--connection to 'SQL Server W01' failed." Is there a way to get around this issue...

I am trying to edit some code to prevent duplicate entries in a database based on two fields instead of just one. I would like to check the Fuel Usage table for records that match both the invoice number and date purchased. Any ideas on how to add the date purchased as criteria for duplicates in...

I am using the following code to check if the invoice being entered already exists within the db. I get the "compile error: User-defined type not defined" What is the solution to this eorror? Thanks in advance for your help! :) Dim SID As String Dim stLinkCriteria As String Dim rsc As...

I need a report to be automatically emailed after it is generated by a report generator. I'd like a command button that, when clicked opens a Microsoft Outlook email window with the report as an attachment. I have searched the FAQs for an answer but only found a solution for COBOL. Anyone have a...

Hello everyone. I tried searching the forum for this but had some trouble finding anything. Is it possible to display the current time, active to the second (you can see the seconds move)? Any help you can provide would be much appreciated. Thank you. Chew

Hello everyone. I have a report that when opened, appears behind three forms. These forms must then be closed to get to the report to review and then print. However, the totals are then lost and "#Error#" shows up on the report. I do not want to simply change the modal property on these forms. I...

I have taken over someone's db and I'm trying to get a certain report to generate. Everytime I click on the print button I get the run-time error 3307: The number of colums in the two selected tables or queries of a union query do not match. Is this one of those error messages that don't explain...

I am trying to add four different subreports to a single report but only the first two subreports show up when I preview it. I need the ability to break out totals. I have a grand total and need to show the totals of the four different categories within that grand total. Is it possible to have...

Upon opening my database the following error message pops up: "AO Index is not an index in this table." What causes this error and what does it mean?

Is it possible to write vbscript to exit the Access app. then log off the user? I have had issues with some users forgetting to log off at the end of their shift and the laptops then becoming locked. Among other reasons, I need the users to log off so the computer doesn't become locked when the...

I have had an issue with users forgetting to log off on their laptops when their shift is over causing the computer to become locked. A password is then needed to unlock it. This prevents the next person on shift from using the laptop. Is it possible to automatically log off a user after exiting...

I have been trying to figure out the cause of this message I have started getting when I try to run some code that prints reports. The message: "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." This...

Good morning, I have a listbox on a form that when double clicked, puts the value of the bound column of that particular record into a textbox. What I want to know is how, or is it even possible to put the value of the second column into another textbox? For example... Me.txtName.Value =...

Is it possible to assign a value to a variable in a report upon opening a report? My problem is that some numbers are being double counted because within the SQL i'm using they exist twice in a related table. I want to take the single number and make calculations with it. Anyone understand what...

I have a database that is currently being used on 3 different PCs on a network. I put shortcuts to the db on all 3 for easy access to the file which exists on the network. Soon the db is going to be sent out into the field on 3 lap tops. I am wondering what is the best way to reconcile all the...

I have a report that draws data from two separate tables which are linked on the claim number. What's happening is that in the tblRecovered there is often more than one of the same claim number. So it appears in the report as many times as it appears in the table. However, I only want the amount...

I have a report which totals dollar amounts from claim numbers. I don't want dollar values which come from the same claim number included in the total. I know how to set the hide duplicates property but the number is still included in the total. How do I omit these values?

The database I am working with outputs only one type of report. I would like to have the margins set so that the user is not required to make any changes to the report before printing (in some cases it may not be previewed - I may use acViewNormal). I am sure there is a way of doing this but I...

I am trying to run an SQL statement from vb but keep getting the error 2342 - A RunSQL action requires an argument consisting of an SQL statement. I stored the SQL in a variable and tried using DoCmd.RunSQL. The code... Dim mySQL As String mySQL = "Select [LKP_tblRouteCodes].[Route Number]"...

I have a form with combo and text boxes which submits data into my table fine. The problem is that after closing and reopening the form I can't go to those records using the navigator buttons. On every open the form shows that there are no records. I am sure I am missing something simple here...