Recent content by cmgrn

I have MS Access 2002 unbound form that is only 2 pages long and has a Submit step that prints the form, sends the data to excel and clears the form. I am using "DoCmd.PrintOut" because it gives me a perfect snapshot of the form and its entries BUT it also shows a dialog box ("Printing page 1...

I am using Access 2002 on Win XP. While working on a form, when I tried to add a new frame, I started getting the message "The database has been placed in a state by user 'Admin' on machine 'AHFC-RHI-104R' that prevents it from being opened or locked" for no apparent reason (the message window...

Hi, Thanks! I went back and checked and the linked Access table had a single field marked as a unique index when the field itself is not unique to every record. Then, I used SQL Server Management Studio to check for the real index of the view that I was linking to but it doesn't seem to have...

Hi, I have an MS Access 2002 table with an odbc link to an SQL Server 2005 view. If I open the table in datasheet view and look at an employee's 3 records, they all appear identical. If I use a make-table query and write all the linked table's records to a work table then the employee's 3...

Hi Redid thread because I noticed I had placed it in the wrong forum and could not find a way to move or remove it. I have used db.close for years going back to a97 days and never had a problem. I believe it just closes the local object before I blow it away but I tried your idea and it did not...

This week my access 2002 has started blocking me from the code, test, code, test that I use constantly. I am using vba and dao 3.6 to code a function in a module. After coding, I run the function to sample results then return to coding BUT this week access stops me from returning to coding with...

This week my access 2002 has started blocking me from the code, test, code, test that I use constantly. I am using vba and dao 3.6 to code a function in a module. After coding, I run the function to sample results then return to coding BUT this week access stops me from returning to coding with...

I use "AutoExec" to record users in a history table as they start using my db(s) but would like to know how I can automatically record users as they exit. Is there an "AutoExit" type of macro that I can use to run a job when a user leaves a db? I use Environ, db.Name, Date and Time to record...

I would like to give someone in our company a database with links to important tables in our main database so he can query and report until his fingers drop off ...BUT... I would like the links to be read-only so he cannot accidently alter and/or destroy the base data. I do not use any access...

Thanks

I am looking for a list of the day-to-day differences in Access97 vs Access2002. I loved a97 but a2002 is a pain because standard queries and practices that I used in a97 now return different results in a2002. Queries were straight-forward before but now using the same style of query design...

My dev box was Notepad and the internet until I found CoffeeCup. I will look into both ideas. :) Thanks for your help and time! Mike

I am new to HTML and am writing my webpages on my pc at work then copying them into our company intranet folder for viewing. Is there a way to specify a "keyword" that would retrieve a webpage's current location to place in the <base> statement so when I move a webpage it will automatically pick...

I am trying to use the FileSystemObject (Scripting Runtime reference) in my Access97 application VBA module on my WinXP Pro machine (with IE6) at work but whenever I highlight a keyword to reference help using F1 I get the message "The C:\WINDOWS\system32\VBENLR98.CHM file is not a Windows Help...

I am trying to connect an MS Access 97 database to my FrontPage 2002 web site I am creating on my local hard drive. In FP, I select Tools > Web Settings... and then in the settings window I select the Database tab and the Add option. The next window, "New Database Connection", is where I enter...