2000 organizations, including eBay, Ericsson, and Lockheed Martin, now work smarter with Corporate Accounts. Save over 36%!

 

Having problems asking a question? Have a general question about Experts Exchange? Let us know!

 
Time Tested MS Access Solutions: 151 - 175 of 8048
 
Delay or sleep function?
What is the best way to pause in Access VBA?  There are two goals here.   1.  Sleep for x seconds (without hogging the resources).  [30 pts]   2.  Use the Shell command to do a task such as ...
Cannot open database -- VBA Project corrupt
Getting the following message when I open the database: "The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA pro...
Access 2007 Combo Box populate multiple fields in form
Hi everyone. I need help. I have a combo box in my form that i want to populate multiple text boxes after you select your selection in the combo box. Here is my set up. The Fields that need...
Math Functions in Access
Hi all, I need to be able to use some common math functions in a select statement (query) I am writing. Sin() and Cos() work just fine. Atan() and Asin don't work (MS Access doesn't r...
Microsoft Access Hospital/Health Care Sample Database
I've been contracted to work on a large scale database for a local physicians pratice that meets at 4 locations. I'm looking for a sample healthcare employee Access Database, so that I can beg...
Date Greater than In SQL Query
I would like to only show data if a date is greater than the specified date. This is the line in question: WHERE (((tblInventory.ConsumedDate)=[Forms]![frmReportInOutTimeframe]![txtDateEnd...
Increase listbox row height and wrap text
I have a listbox that displays results of a query. The first description field can be lengthy and I want to show at least two or more lines. I searched for code to increase the width of the ...
Access Report to PDF without Save As Dialog
I have an Access database that I have created a form where the user can check multiple reports and when I press a button I need it to export each as a PDF. Here's the catch. I want the user to...
Jet DB engine stopped the process because you and another user are attempting to change the same data at the same time
I've been researching this problem on this site and see many others have experienced it.  I think I'm dead in the water, but wanted to ping you guys to make sure before going to a (very old) b...
Run-time error 2501:The OpenReport action was canceled (Microsoft Visual Basic pop-up ) when click on OK button in previous Microsoft Office Access pop-up  window - The OpenReport action was canceled
I am computer technicain supporting building with over 2000 users.One of them created Office 97mdb file and converted to Microsoft Acceess 2003.After convertion, some of the users having probl...
Access VBA - Call Sub Routine In Sub-Form from Master Form
I've been looking for this for some time and it must be my question language that's the problem. How do I call a sub routine on a sub form from a master form? I'd have thought that it'd ...
Open Excel via vba and Sort A specific Sheet
Access 2003 Excel 2003 I want to open an excel workbook, Select a ashett and sort it by Column C I do not need to see excel do this. I can't get this to work Public Sub sortExcel() ...
Use VBA code to relink / change linked tables.
Hi, Is there anyway I can use VBA code in MS ACCESS to remove a linked table and connect a linked table? I need the linking code (or procedure if it's big enough) to go in the following: ...
How to use Decimal Data Type in VBA code
I need to record Purchase Order line item quantities to 2 decimal places. In the past I've always used a double data type and forced rounding to 2 decimal places in my forms. I've been toying ...
Show Hidden table in Access
Hi, I accidentally changed the property of one of my tables in Access to Hidden and now I have no idea how to "undo" that property because I can no longer see the table.  Advice?
Cannot add a local intranet site
I am trying to open an access database from a networked drive and I recieve the message, "Microsoft Access cannot open this file. This file is located outside your intranet or on an unrestrict...
How To Combine Tables in Access
Hi.....could you please tell me step by step how to combine tables with the excat same fields in Access. I read somehting aboutn a UNION query but have no idea how to do it. Thanks.
Multiline comments in VBA?
I know how to do a single-line comment in VBA: 'This is a comment Usually when I do multiple lines I just begin each line with a single quote: 'This is comment line 1 'This is commen...
Runtime Error: 94 Invalid Use of Null
Hey everyone! This code was working fine. I have tested it and it worked...it has worked for about a week now. I get an email the other day telling me there is an error with my Access DB. T...
"Automation Error" "The specified Module could not be found."
Hi All, We've just upgraded from Win NT to Win 2k Pro, for some reason I get "Automation Error" "The specified Module could not be found." on the following code:     Dim fs     Set fs =...
Convert Inches to Fractions
I will like to create a table listing the ft and inches on one column, list the converted fraction in the next column and finally list the conversion in decimal places in the last column as sh...
Oracle Error ORA-00972; Identifier Too Long for Oracle tables that are linked through MS Access 97
Description of the issue We have an issue in which end users cannot filter or sort Microsoft Access tables that are links to Oracle tables for which the schema+tablename exceeds 30 characters...
Access 2007 keeps "installing and configuring" every time I open an Access app
Like it says, really! Most times when I open Access or one of its apps, a dialog box comes up telling me that it is installing, configuring, etc... it. The app then opnes but the following pro...
IMPORT XML Data To Access 2003
Hi there! I want to "append the XML data to an existing table" and it is easy to do it "manually" through File > Get External Data > Import > *.XML (chosen) > (Import Options) "Append D...
Access 2003 Error 3197 and there is no solution !
Hello, I have a database .mdb which has got corrupted (Error 3197). I can't open it. I have tried and searched any solution, but apparently there is no one. Can somebody help me, please? ...