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 Wanet Telecoms Ltd 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. MLHab306

    invalid arguement error

    Hi I figured out what I think may have been my problem. I started by opening each query and seeing what was working. Then I opened up each table until I was getting the error. After deleting the bad record, I recieved no more error messages.
  2. MLHab306

    invalid arguement error

    Hi I am getting a "invalid arguement" error. I wrote the template and I have no idea where I should even start looking or what to look for. I tried exiting and rebooting. I tried it in both open shift key mode and autoexec mode. Still get the same error. I can open up the forms in design...
  3. MLHab306

    comparison query same field name multiple times

    What I am trying to do is do like a year end cpmparison report, comparing the same fields but with different date ranges in the same report. Date range number of products sold total sales 1/1/02 to 12/31/02 1904 $100,403 1/1/03 to 12/31/03 2310...
  4. MLHab306

    comparison query same field name multiple times

    Hi I am trying to set up a comparison query. for example date range 1/1/03 to 12/31/03 1/1/04 to 12/31/04 1/1/05 to 12/31/05 thanks for your help. Mark
  5. MLHab306

    Booking/apointment program in Access

    Hi I actually wrote and is using an access 2000 appoinment book for my little mobile dog grooming business. I have it set up in both a front and back end ( 2 files) Send me your email and I'll try to download it for you. Then you can offer suggestions and improvements. I have not been able...
  6. MLHab306

    using a mapping program w/ access 2000

    Hi Is there any way of using a street map program with access 2000?
  7. MLHab306

    Online tutorials

    The sites listed look pretty good. Still the best one I have found is this one itself. Tek seems to have the widest user base I have seen. Most of the responses I have read are very informative. I have done many key word searches with good success. I have learned the most about Access from...
  8. MLHab306

    Only 8 switchboard items allowed?

    Hi What I did in my database was create a blank form with a tab card layout, then populated the different cards with command buttons linking to the various forms. Then I made this the autoexec, so when the database is started by a user all they see on the screen is the tab cards and buttons...
  9. MLHab306

    different operating systems affect microsoft access querys and report

    Hi I hope that someone else has seen this before. I have a microsoft access 2000 that I have written. The orginal computer has win ME o/s. The database runs fine on win ME. I copied my database and installed it on both a win 2000 pro o/s system (desktop) and win 98 o/s system (laptop...
  10. MLHab306

    Chart microsoft access

    Hi I am trying to do a chart? in microsoft access to do a stock style chart. I am trying to make a ? to plot blocks of hours during the day. mon 7 am 8:30 am 12 tue 8:30 1:00 etc. any suggestions Mark
  11. MLHab306

    multiple parameter query statement in the same query Access 2k

    Thank you for responding so quickly. What I am trying to do is a deposit slip for a small business based on a database that I already created. Sometimes clients send me checks several weeks after the appointment. When I do a deposit slip I can tell it do a certain range for example 1/20 to...
  12. MLHab306

    multiple parameter query statement in the same query Access 2k

    Hi I think this is a simple question but I cant find the answer in help. What I am trying to do is: Use a parmater query to first sort for the date range then enter in a paramter query if a particluar client is not in the date range. date range: 1/20 to 1/26 who is not in date range: smith...
  13. MLHab306

    query sort order on a text field

    Hi Thank you for responding so quickly. I have created almost everything in this database by using the wizards. I am clueless where this statement should be placed. Where would I place it? Thank you Mark
  14. MLHab306

    query sort order on a text field

    ...92 44 4:30 to 5:30 93 53 4:30 to 7:30 94 62 4:30 to 8:30 95 30 5:00 to 7:00 100 31 5:00 to 8:00 101 32 5:00 to 9:00 102 33 TFY 103 ***************** Query used to generate report. SELECT Date_last_done.Date_last_done, Customers.GateCode, Appt_Time_look_up.Sort...
  15. MLHab306

    unpopulate subform does not output to report

    Hi I have a main form (client info) with 2 subforms linked to different tables (appt date with fees) and (dog type and inst) . When I enter info into the client info and appt date but not in the dog type it does not appear in my report. If I enter dog type with the client info and appt date...
  16. MLHab306

    call list with > 30 days but < 365 days

    Thank you for responding so quickly. I'll print up your response and give it a try. Mark
  17. MLHab306

    call list with > 30 days but < 365 days

    ...Between Date()-365 And Date()-30) AND ((Date_last_done.Holiday) Is Null) AND ((Date_last_done.Comments) Not Like "xmas*") AND ((Date_last_done.Payment_type)=1 Or (Date_last_done.Payment_type)=2 Or (Date_last_done.Payment_type)=3 Or (Date_last_done.Payment_type)=4 Or...
  18. MLHab306

    time bomb access for 30 days etc

    Hi As a newbie to Access 2k, i have always wondered how to time bomb a database. Limiting a demo use of 30 days, 45 days etc. I have been assembling my own database and would like to try it out. Mark
  19. MLHab306

    Send a report as attachement by email

    I have the same problem. Access looks for Outlook. I use AOL because my wife likes it. So When I try to email a report I get an error message and outlook pops up and asks to make it the default email program. To work around this I print the report to file and email the attachment. Mark a...
  20. MLHab306

    Create file w/hidden tables

    Hi This is my first attempt at answering a tek tips questions. So here goes. I hope it is what you are looking for. I would suggest trying the help with the key word hide. That is how I found the info below Show or hide system objects in the Database window by default Microsoft Access...

Part and Inventory Search

Back
Top