Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: cmgrn
  • Order by date
  1. cmgrn

    DoCmd.PrintOut dialog box with Cancel causing problems

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

    Form Controls Wizard vs DB Prop ReplicateProject

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

    access table with odbc link to sqlsvr shows repeated data in records

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

    access table with odbc link to sqlsvr shows repeated data in records

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

    VBA Coding blocked by error 3734: DB placed in locked state

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

    VBA Coding blocked by error 3734: DB placed in locked state

    ...Excluded Individuals/Entities for matches against Astor's employees Set dbAstor36Main = OpenDatabase(conAstor36Main) strSQL = "SELECT * FROM [" & conEmployees & "] ORDER BY [LastName], [FirstName], [MiddleName];" Set rsEmp = dbAstor36Main.OpenRecordset(strSQL) With rsEmp...
  7. cmgrn

    Database shifts to locked while vba coding and testing.

    ...Excluded Individuals/Entities for matches against Astor's employees Set dbAstor36Main = OpenDatabase(conAstor36Main) strSQL = "SELECT * FROM [" & conEmployees & "] ORDER BY [LastName], [FirstName], [MiddleName];" Set rsEmp = dbAstor36Main.OpenRecordset(strSQL) With rsEmp...
  8. cmgrn

    Does Access have "AutoExit" for jobs when it closes?

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

    Access2002 db to db read-only table links?

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

    Access97 vs AccessXP(2002) changes list

    Thanks
  11. cmgrn

    Access97 vs AccessXP(2002) changes list

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

    get webpage url and insert into webpage <base> statement

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

    get webpage url and insert into webpage <base> statement

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

    VBENLR98.CHM and WinXP

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

    FP 2002 database connection file type problem

    ...problem is that when I select Browse to find my database, the browse window, "Database Files in Current Web", shows no available file types (like *.mdb), has an empty drop-down list and won't allow me to type an entry. I know my database is there but the window is blank and I have no clue how...
  16. cmgrn

    ADO vs DAO DBEngine Idle, BeginTrans, CommitTrans

    Thanks! I'll give them try.
  17. cmgrn

    ADO vs DAO DBEngine Idle, BeginTrans, CommitTrans

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

    CR9 programming help not in 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...
  19. cmgrn

    Parallel Databases

    Thanks GingerR! That's another area/problem we need to give serious thought to. We are coming off a legacy system that had limited access and tight user controls and, by comparison, our network seems like a nightmare of new accesses, permissions and relationships.
  20. cmgrn

    Parallel Databases

    Thanks everyone! Got some new direction to follow. At present I am only using the MS Access database password protection. I wrote a vb6 dll with a GetPassword routine that I use to feed the password to my open database commands in my vb and access projects. I figured that when other people used...

Part and Inventory Search

Back
Top