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!

  • Congratulations strongm 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: *

  1. jays35

    Creating a search query to for letter and numeric values.

    How would I do this from the query builder?
  2. jays35

    Creating a search query to for letter and numeric values.

    From the sample data below, I want to have the query returns only the bottom three records (there are several thousand records similar to the sample below). Currently I have the criteria set to LIKE "U2*" and I would like for it to also return anything with a number "2" followed by a letter and...
  3. jays35

    12 Hour Shift Crossing Midnight

    Thanks!
  4. jays35

    12 Hour Shift Crossing Midnight

    How do I set up my Overnight Calendar for my 12 hour shift that works from 5 PM - 5 AM M-F? Will this calnedar also work for the same schedule, but 7 days a week? Thanks in advance! Dave
  5. jays35

    Access Table problems

    I hope that I can explain my problem well enough to get some help. I have a table of data that when I open the table to view the contents, there is nothing there, no data to view. I get the data from an Excel spreadsheet that is down loaded to me weekly. Now here is what is puzzeling to me...
  6. jays35

    Access Help Book/Reference

    What type of book or manual would anyone recommend for a beginner/intermediate type user? I would like buy one that I can use for reference and help. Any ideas? Thanks
  7. jays35

    Access for PDA

    Need a program to be able read Access database on my Palm Pilot. Any ideas or free downloads? Thanks
  8. jays35

    Compact & repair a db on closing

    Where do I access that thread or do a search?
  9. jays35

    Compact & repair a db on closing

    What would that code be?
  10. jays35

    Compact & repair a db on closing

    Is there a way to compact and repair a db when you close it?
  11. jays35

    Database size

    One other question, how often do I need to do this?
  12. jays35

    Database size

    Thanks again for the information. I am trying to learn as I go. Thanks
  13. jays35

    Database size

    I created a database with two tabels for my business cards. About 2 days ago I emailed to my house and it was about 5 megs. I added about 3 forms the next day and I was going to email it to my house again but it had increased to 21 megs. What have I done? One table has company information...
  14. jays35

    Logon: NEED HELP

    I can't even start Access to do this. Before the program starts it ask for a logon and pwd.
  15. jays35

    Logon: NEED HELP

    I have been looked out of Access when I try to start it. It ask for a username and pwd. I did not set a user name or pwd. I can't get Access to start to chage or look to see if there is a pwd. I have not reloaded the software yet. Any ideas on how to get past the logon popup? Thanks
  16. jays35

    I am having trouble with my switchb

    I am having trouble with my switchboard. I am new to using Access and I have a few problems every now and then. I have pasted the error below: Thanks Dave Private Sub FillOptions() ' Fill in the options for this switchboard page. ' The number of buttons on the form. Const...
  17. jays35

    Job Sheet Assignment & Time Sheet

    I want to be able to assign maintenance jobs, maintenance personel and be able to keep track of time. I will have jobs that will require more than one person. How do I create this db and assign jobs and personel. For example: Job 1 Tom and Steve 4 hours each I would then...
  18. jays35

    Help with error message

    I will the next time it happens. Thanks again Dave
  19. jays35

    Converting 97 db to 2000 db

    Thanks for all the help. I am trying to learn on my own and this makes it a lot easier. Can 97 and 2000 be ran on the same machine? Dave
  20. jays35

    Help with error message

    I received this error on Access 2000 and tried to figure it out with no luck. Here is the error message: Object variable or With block variable not set. I went to help, but could not get the problem resolved. Any suggestions? Dave

Part and Inventory Search

Back
Top