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!

Register Log in
  • Congratulations Rhinorhino 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. mike1975

    Dates Problem

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

    Show all Dates

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

    Show all 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...
  4. mike1975

    Limiting Reservations

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

    How many working days in a date range?

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

    Limiting Reservations

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

    Static Boolean Trouble!

    Help Anybody??
  8. mike1975

    Static Boolean Trouble!

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

    Static Boolean Trouble!

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

    Multiple Table Problem

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

    Control Tab Problem

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

    Control Tab Problem

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

    Control Tab Problem

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

    Help with a Form

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

    Help with a Form

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

    Reports Using more than one query

    Hi, I am trying to create a report that will need to pull data from two queries. Basically the report is monitoring the results of enquiries made to our business. I have two tables one table contains details of the original enquiry ie what product they were interested in etc the second table...
  17. mike1975

    STOP A DOUBLE BOOKING

    Thanks for that - I am still struggling though. The way I was hoping to do it was to maybe if I was to concatenate the date field,time field, and bay field and then do a check to see whether that already existed - i could use that concatenated field to check on(this could be the primary key...
  18. mike1975

    STOP A DOUBLE BOOKING

    I am trying to setup an apllication that allows users to make reservations to one of two bays on a certain date from a set number of time slots. I have a table containing customer details and one which contains details of bookings. I am trying to create a form where new bookings can be entered...
  19. mike1975

    RESERVATIONS - I don't know where to start

    HELP! I am trying to create a database that deals with reservations. Basically I have two bays that can be reserved at different times of the day on different days. I am not sure how to handle this so that a user can see current reservations and is prevented from making a reservation where a...
  20. mike1975

    Email code??

    Can anyone supply with me some code that will enable me to send an email to a supplier when the suppliers email is held in a supplier table - Basically i want to put in the supplier code in the orders table - hit a button and the data shown on the form will be sent to that supplier.

Part and Inventory Search

Back
Top