Recent content by halem2

  1. halem2

    Running Queries with code

    I'm connecting to a tbl in a db (db1) to get information to create another tbl in a different db (db2). The information is employee demographics so what I did in order to have my own employee table in db2 was to create a make table qry to create the original employee table. I do not use the...
  2. halem2

    Running Queries with code

    I just tried it but it errors out since it is a select query Cannot execute a select query. (Error 3065) You tried to use the Execute method with a select query. The Execute method is valid only with action queries. Select queries contain a SELECT statement and can return records; action...
  3. halem2

    Running Queries with code

    Hi All: long time no ask! Running MS Access 2003. I'm trying to run a couple of queries using code and it works fine but when it runs you can actually see the query window open and close really fast. How can I run it without showing the query window? This is my simple code...
  4. halem2

    field from another form

    thanks for the prompt reply. I've been messing with the forms!fieldName format a little and your link confirmed my rookie suspicions. Now, does it matter if the form I'm reading the info from is hidden?
  5. halem2

    field from another form

    Hi All: running MS Access 2003. I have two forms: a login form and form B. The login form has two fields: User and Password. When the user logs in, I hide the login form and open another form. How can I refer to the login name on the login form from another form? In other words, I need...
  6. halem2

    Reseting autonumber to start again from 1

    Lol !!!!!!!!!!!!!!!!!
  7. halem2

    Reseting autonumber to start again from 1

    No...I copy and pasted the table structure...
  8. halem2

    Disable Shift Key

    ghudson First: awesome! I have used it in other db's and it rocks! Question: I'm trying to use it in a new db but it is not hiding the db even when the password entered is wrong. I have not selected tools\startup\display db window. I also ensured I have DAO 6.0 in the references... What...
  9. halem2

    Reseting autonumber to start again from 1

    I followed WKALO's suggestion and it does work like a charm. Thanks!:D
  10. halem2

    Report Table of Content

    Ok... I'm using WinRar now
  11. halem2

    Report Table of Content

    yes I am using winzip
  12. halem2

    Report Table of Content

    here it is again.
  13. halem2

    Report Table of Content

    here it is. I cleaned it up to make it as small as possible.
  14. halem2

    Report Table of Content

    Keith: I already have the force new page and the group header repeats on every page
  15. halem2

    Report Table of Content

    Ok.. I searched the posts and found the MS article about creating the TOC using functions. I'm now getting an error when I move to the last page of the report (447 pages) It reads "Error 3163. The field is too small to accept the amount on data you attempted to add". Any ideas? When I...
Top Bottom