Search results for query: *

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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