Search results for query: *

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

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 Is there any way of using a street map program with access 2000?

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

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

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

Help I am completely clueless (please don't tell my wife). I am a newbie to access and programming, the Tek tips board has been a great help. I have key word searched calendar, control, active x and a variety of combinations. I also looked at the FAQ's. I still am clueless on how to get a...

Hi Happy New Year to one and all. I hope I have a simple question. I am using a parameter query to input a range of dates. HAVING (((Date_last_done.Date_last_done) Between [Beginning Date ] And [Ending Date ])) I have a report based upon the query. The user has no access to the query with...

I want to thank everyone for sharing their knowledge with us newbies freely and kindly whether we asked questions or just snooped thru the threads quietly. As a new user to access 2000, I have learned alot by reading the different threads and doing keyword searches prior to creating a new...

Hi I am trying to parameter query by zip code. Some of my zip codes are 5 digit lengths and some are 9 digits. When I do a parameter query ie 91324 I only get the addresses that match 91324 but not 91324-1234 etc. I have gone thru the threads searching for zip and did not see any suggestions...

Hi I am a newbie to access 2000. I am trying to create a query to calulate a new date + interval. I have done several searches of the Tek-Tips with different key words before asking this. I would like the user to be able to enter a start date and interval ie 14 and let access calculate appts...

Hi I am a newbie to access 2000. I just found Tab controls. When I tried them I was only able to display 2 tabs. How do you display more than 2? Can more than 1 tab control be used on a form? Thank you Mark

Hi I am trying to create a recuring schedule. For example client 1 is every 2 weeks, client 2 every 5 weeks, client 3 is every 9 weeks, client 4 is every 4 weeks, etc. I have several tables one contains the date client was last done another contains the name of the client and interval of appt...

Hi I am a lightweight when it comes to access. I have no clue about code. I am trying to create an aging report (accounts recievable) past due 1 to 15 days, 16 to 30 days, 31 to 60 days etc. I have tried variations of date(), date()<15, etc. I would greatly appreciate any help. Thank you...