Search results for query: *

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, 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...

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...

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...

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...

I have read a lot of articles on DAO to ADO but cannot seem to find information on how to migrate my 'DBEngine.Idle dbRefreshCache', 'DBEngine.Workspace.BeginTrans' and 'DBEngine.Workspace.CommitTrans dbForceOSFlush' to ADO. These are vital on our network to get good response with our VB6...

I am using VB6 and CR9. In VB6 I have added references to CRAXDRT (Crystal Reports 9 ActiveX Designer Run Time Library) and CRVIEWER9Lib/CRVIEWER9LibCtl (both say Crystal Report Viewer Control9). My problem is that whenever I select a CR item, in code, while programming, I can never find HELP...

I have a password protected payroll database in MS Access 97. I want to open it up for other employees to make their own queries and reports. My idea was to create a parallel database with read-only links to certain payroll tables. Any approved non-payroll employee could use this 2nd read-only...

I have a VB6 program using an Access97 database through ADO and DAO. I added CR9 RDC to view/print several predesigned .RPTs. My problem is I want to feed the .RPTs different table names than the ones that they were originally created to use. The different tables are all identical formats. I...

I recently added CR9Dev to my PC and when I opened my VB6 project I noticed under References that there was a whole new list of Crystal Report references. My observations on the VB6 references are... A) The path shown in the references window for a selected reference is cut off because the...

I am using VB6 and CR9Dev. I create my reports outside VB6 using CR9Dev and save them as .RPT files in a shared folder on our network. In VB6 I use RDC and the viewer to review a report and/or print it. My problem is that this works great on my machine but not on others. I see references made in...

I want to print a payroll register report showing the types of taxes and deductions that were taken out of an employees paycheck. There are 4 basic fields: strTaxCode curTaxAmount strDedCode and curDedAmount. The fields are paired, code and amount (strTaxCode="StateNY" and curTaxAmount=$123.45)...

I am writing a VB6 payroll program using Access97 for my database on a network. My problem is odd errors that seem to have no clear relationship to the place the program stops BUT always go away if I put a 1-5 second pause in front of the database operation where the program stopped. I think I...

I must put our agency manual on our company intranet website. The manual is 25 MS Word docs. One doc for each chapter and a master doc that simply has links to the other 24 docs in sequence. I wanted to convert this to a single PDF that would appear as a single manual online but would allow us...