Search results

  1. O

    How can i create a Combo Box that displays reports based on my selection

    Could you show me a sample Thanks very much Pat, I'm not expert in VB Codes so could you kindly show a sample Syntax or DB? Your help is much appreciated.
  2. O

    How can i create a Combo Box that displays reports based on my selection

    hello all good people, How can I create a Combo Box that opens a specific report based on my selection. For example i have a form Combo Box Called STATUS which has three options (Open, Hold, Complete). I want to be able to view a report everytime i select any of the three options. Note that...
  3. O

    I want to automatically change the value in a Combo Box

    It works Thanks very much mmitchell for the clue, it works well. I do appreciate the time you took to reply. Good day,
  4. O

    I want to automatically change the value in a Combo Box

    Here is more clarification Thanks for the reply, Your are right that's what i want and here is more details: I attached the DB for further clarification. Now i have RadioFrm, what i need is that whenever i select a Physical ID under Issued Temporary Equipment in that form, the status field...
  5. O

    I want to automatically change the value in a Combo Box

    I have a combo box on a form (RepairFrm) that its Control Source is another table (EquipTbl). This combo box has two options, either Available or Loaned. I want to be able to automatically set the value to LOANED when i choose any record from the (EquipTbl). This is to indicate that the...
  6. O

    How can i generate an auto #

    It works great!!!!! Great....it works, thanks very much WayneRyan. That was a great help. Appreciate it. Good day
  7. O

    How can i generate an auto #

    How do i use the DMax function Thanks but how do I use the DMax function? I want that 04-001 number appear every time i click on new entry button in the Control # Field. your help is much appreciated.
  8. O

    How can i generate an auto #

    Hello, How can i generate a record auto number which starts with the year and then three digits that increments every time i add a new record, looks like 04-001. Thanks
  9. O

    Employee's records are deleted when i delete the Course

    Thanks very much but now how can i register two employees in the same class, the way it is structured now don't allow me to do so. I also need to know how i create a combo box from which i can select a report by unit. Ur help is much appreciated.
  10. O

    Employee's records are deleted when i delete the Course

    Hello to all of you excellent supporters. I have a problem with my employee training database. I have a form to schedule an employee for a course. When i check employee's training schedule and delete any course employee is registered at, it delete the employee's records from the database...
  11. O

    How can I set a weekly Date Criteria

    Great, many thanks Thanks very much Mile-O-Phile, it worked, that's exactly what i need.
  12. O

    How can I set a weekly Date Criteria

    Greetings to all, I need help in a date criteria in a query, What's the criteria if i want to pull a weekly report based on date field. let's say i want the report to view the items from Monday to Sunday. Your quick help is much appreciated. Good day,
  13. O

    Automatic Date Query

    It works fine Hi, Thanks very much for both of you, it workd, this is excactly what i needed. This is really a very nice Forum that i like to spend hours reading through. Thanks,
  14. O

    Automatic Date Query

    Thank Rich very much, but i think there is a slight problem, i did what you told me, but i get #Error in the ToBeCompleted Field. What can i do to fix the problem? By the way i have an input mask and i removed it but i still get the same #Error? Thanks very much
  15. O

    Automatic Date Query

    Hi, Can you please help me on this ASAP, In a form, I have two date fields (AssignedDate & ToBeCompletedDate). What i want is whenever i enter the Assigned date, the ToBeCompletedDate field is automatically filled out with a date that is A WEEK AFTER THE ASSIGNED DATE. I'm sure I can use...
  16. O

    Problem with a Combo Box

    Hi, I'm working on a Service Order Database, and I have a Combo Box named Status with entries (In progress, Complete, Pending, Cancelled) and there is an Event Procedure (After Update) for this combo Box that makes another Combo Box named Reason appear ONLY when i select Pending, then i have to...
  17. O

    Show a Combo Box when an Item is Selected

    Greetings Mr. Hicks, It worked just perfect, thanks very very much for the help. This is really a great web site to visit. Once again, i appreciate it.
  18. O

    Show a Combo Box when an Item is Selected

    Thanks Jim, I tried what you told me but it did not work, in fact the Reason Field is a Combo Box not a Text Box, and i tried cboReason instead of tbxReason and it did not work either. It was refering to a macro error. Can you help please. I do appreciate it. Regards,:)
  19. O

    Show a Combo Box when an Item is Selected

    HI, I need this help please, I have a combo Box that contains some Status items like Completed, In progress, and pending. I have another Field named Reason. How can i make the Field Reason appear ONLY when I select the pending item from the Combo Box. Your help is appreciated.:)
  20. O

    How Can I add a password to a Form

    Hi, How can i add an ID and password to a form, so only authorized users can add entry to the form. Help is much appreciated.
Back
Top Bottom