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

Hi When I run this query, it does not output in chronological order. Some times it will put a client with a time of 7:00 to 9:00 after someone scheduled 11:00 to 3:00. The time ranges are in a seperate table. ( 4 tables are used in this query. This is the table that I think is the problem...

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

Happy New Year to the best Microsoft Access 2k on the web. I am creating a scheduling book in access 2k. I am trying to create a call list for clients that have not been done in a minimum of 30 days up to 365 days. When I run the query I still on occasion get those done within the last 30...

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