Showcase your knowledge about Apple's newest OS. Write a how-to or share a tip or trick about Snow Leopard and earn unlimited points!

 

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

 
Time Tested MS Access Solutions: 7976 - 8000 of 8064
 
Automate the import of reports into an mde database
I have created a distributed mde database file that in the future I may wish to add further reports to is there a way to automate the import of these reports without the need to re-distibute t...
access - cartesian product??????
how to avoid cartesian product while getting values through sum of the two columns from two tables? Both the tables have the same structure!!! Any one Please help me! If U need I will s...
DoCmd.FindNext loop killer
I want to kill a loop with findnext.  I think. I have a field that has two unique numbers in it, on some occasions (What can I say, it's not my fault - I'm not the designer...). I wish t...
can't build link between unbound forms
Hi, When I tried to link a child field with a master field, an erro message pop up "can't build link between unbound forms". How could I make my form and subform as bound? Thanks a lot.
Drag/Drop File onto Form field to get file path
Is there a way to drag and drop a file from the Microsoft File Explorer onto some sort of Access form field such that the corresponding table field will end up containing the full path to that...
The office assistant has stopped responding
I started getting this message a couple of hours ago, intermittently. I don't even, or didn't, have the darn thing enabled. I follow the on screen suggestion which is to enable it again. I...
Delete multiple tables in Access
I copied the code below from a solution someone posted on here to delete a single table.  Can someone show me how to modify this to delete multiple tables?  For example, let's say I have table...
How do I convert a date to an integer?
Hello Experts, There are many posts explaining how to convert an integer to a date, but how do I convert a date to an integer? i.e.  01/14/2004 = 38,000 Thanks!
Dlookup count field.
I am using access 2000. I have a PC inventory database that I am using. When I bring up the main menu which is not linked to a table, I would like a field to show how many machines are free. I...
VBA Cleanup
I have an Access .adp data project that prints spreadsheets in excel. I've noticed in task manager that the EXCEL.EXE process is still running even after I close the spread sheet. Am I miss...
MS Access Search Function
Dear Experts: I have a form name "customers", it have CusotmerID, CustomerName, BillingAddress ... When I add a search function, it only search for CusotmerID, that's the primer key. How ...
Link to mapped coordinates
Is there a way to take the geocoded X,Y coordinates from a database record and open a mapquest or other mapping site's map of the X,Y coordinate location?
Adding new records to an Access form
I'm trying to add new records to a form I created from a query of four tables.  I can view all the records in the form but I can't add any.  I have checked allow additions to yes and all the t...
Linking Access 2003 to Outlook Public Folder Errors
I am trying to link Access to a contact folder located in Exchanges public folders. I go through the wizard and sometimes I get the error "The MAPI store 'folder name' is known but is not avai...
Union query based on nested subqueries
I'm trying to create a union query based on two nested subqueries and am getting an invalid procedure call. Here's the SQL: SELECT [lngVehId], [strEvalCatK], [Test 1], [Test 2], [Test 3...
import csv with ado or transferText problems
Couple of questions here to see if you guys/girls can help me. I've got to import a CSV file automatically (as in fully automated, select the file locations, sort the file etc) and i've seen a...
sql server trim whole database
Is there a way to trim beginning and trailing spaces, tabs, and new lines from a whole db?
MS ACCESS Databases too slow
Hello Experts I have a software that utilizes two Access Databases. One of them is a little over 1 MB in size and the other one is a little less than 1 MB. It takes a considerably long time...
Access Database, VBA: Need to capture last update date of Access databases
My project is to determine the Date Modified date of several hundred Access databases. This is the date which appears in detail view of files and folders in Windows Explorer, as well as in the...
MS Access - Running Total
Hi, Can anyone help me do a running total? I have a table with four columns. New_Accounts, Resolved_Accounts, Ending_Week and Total_recs. I have a query which looks at a table and then counts...
MS ACCESS 2003 sQL - Need to Find Middle Number within Max and Min range
MS ACCESS 2003 sQL - Need to Find Middle Number within Max and Min range of a field with 5485 records.  The field contains numbers within the range of approx -123.777 and  -88.888.  I am tryin...
allowAdditions False means no controls
I have a new Access2003 application that I am delivering to customers.  One of the forms is bound to a table that starts out with no records. Not all users are able to insert new records in...
Menu Bar has disappeared, how do I get it back?
Hi I am using MS access and the menu bar has disappeared.  When I say menu bar I mean the one with: File Edit View Insert Tools Window Help along the top of the window. I thought ...
Postcode Formatting
How do I write a query to format postcodes so that they are XXnn nXX.  Currently some are xxnnnxx etc. ?  I also need to make sure there is a space after the last number before a letter for ex...
Print MS Access report to CutePDF
Hi everyone, Here is the sample code that im using from cutePDF's site to supress the save as dialog box.  No matter what i do, the dialog box displays. The other thing is that this regi...