Recent content by mike1975

Hi all, I have a dataabase that contains orders of products. I have a report that will show for any given month the number of order and deliveries for each day. To do this I have seperate queries that count the no of orders, deliveries and cancellations on each day. I then pull these queries...

Thanks for the replies, I was hoping that I would not have to create a table with all the possible dates in - however I cannot see another workable solution. Is there a quick way to create such a table and maybe build some kind of routine so that it will automatically add the next months dates...

I will try and make this as clear as possible. Basically I have a databast that tracks orders and ultimately deliveries. I would like a query to show the activities on a range of dates. My orders table holds the order date and the delivery date. However I need to produce a report that will show...

Thanks for the ideas guys! In an ideal world I would like the application to do the following, 1/ User adds a new course to courses table, that table contains number of spaces(n); 2/ On the bookings form have a section that would have (n) number of booking spaces for that course -once it was...

Try the datediff functions; datediff("w",[startdate],[enddate]) The "w" should make it only include weekdays! There are lots of FAQ's on this subject; try 'weekdays' or 'datdiff' in a keywork search. MIKE

Help please! I am trying to create an application for our organisation that will allow people to book onto various courses. I have created following tables; 1/ Employee records 2/ Courses - courses that are available, date, time, location, MAXIMUM NUMBER OF SPACES 3/ Bookings table, contains...

Help Anybody??

Thanks Alex, The code works fine just stuck on how to add that tantalising next stage!! MIKE

I am using the code below to run a report every wednesday, I would really like the report to run every Wednesday and Thursday at say 19:00 hours. Any help as to how to ammend this code would be helpful. dim MyDate,MyWeekday static bSent as boolean MyDate=Date MyWeekday = Weekday(MyDate...

I have a database that links across our network into other databases. It links to the same table in each 'networked' database so therefore I have eight linked tables in my master database. Each table has exactly the same properties and field names. My question is this: Is there anyway that I...

Hang on - I spoke too soon!! I need the page to remain deactivated for each record! At the moment when I check the box it activates all the records regardless of whether the check box is checked on that record or not! MIKE

Thanks for the tips guys - I have it working now! Stand by for more questions no doubt!!!

I have a Control Tab on a form that has three pages on it. On my first page I have a check box that is called finance, I also have a corresponding page on the tab control called Finance. Basically I want to make the finance page become enabled or disabled depending on whether or not the finance...

Thanks Mangro, I used the second method to sort it out - really simple as it often is! Mant thanks - MIKE

I have a form where the user has to pick out a salesreps code. I have the combo box working just fine so that they can do this, I would like to create a text box next to the combo box that will display the reps name rather than the code. I imagine I would have to use some form of lookup but I am...