Search results

Hi, I have two combo box (cb1, and cb2) I would like to enable and disable cb2 when certain values in cb1 is selected. cb1 I have two fields ( ID ,Reason). I used the following code, which works great when I use one value after the like statement. ( when I select ID 1 on cb1 it disables cb2)...

pbaldy thank you for the information. The only way i can do this is on the form itself. There is notting that can be coded on the table field itself?

I have a table called tbl_Employess. The table is use to track a daily checklist. I have one field label " Check_Complete" which is a yes/no and another called "Resolution". I would like under "check_complete" when someone selects NO, it will automatically put "Turn over to other shift" in the...

I am planning to designing a database to record daily events. The main table will have the Date and a combobox of what i want to enter ( options are employee, equipment,complains). The idea is i select one option from the combobox (example i select employee) it will load that sub form and i...

everyone have a great halloween

Everyone thank you for your help, i change docmd.save to just say the record, and everything works great. :)

Yes the shortcut leads them to the same front end. Does all user have to copy this front end to there workstation? That will be the only solution?

I have a split database with the backend on a network. And a font end short cut that multiple users access. User select there name and log in which bring them to their home page using "Tempvars" from the logon form . The database works find when one user is one it they can add or update their...

arnelgp a thank you a million times. I learn something new. Thank you for all your help.

arnelgp, I created another db, using a department table that has a list of department name and a column with amount of available slots for that department.

say if department 100 has 15 spot, dept 200 has 5, dept 150 has 20 , dept 236 has 20 . can i use the same code and change the value?

arnelgp a millon thanks. thank you for all your help. I am wondering if each department would to have different slot amount, would you use this same appoach?

arnelgp , thank you. i attached my database ,please let me know if you need additation information.

arnelgp i never used udf and recordset, any way you can give me an example how and where to use it

Hello from nyc

Galaxies Thank You for your reply. I have it with four fields. Below is how the master_bid query looks. Each employee types in their department request. I how this helps. If you need addition information let me know. BID_ID EMPLOYEE NAME | 1ST | 2ND | 3RD | 4TH | DATE OF HIRE...

I have a master query called [Master_Bid] that returns an employee request for department change . Each employee gets to pick four different departments label 1,2,3,4. Also each employee has their hire date attached to their request. The query is arranged from oldest hire date to newest. Since...

Spikepl - you are right, i should get to the point and indicate where am getting stuck. One the student record there is date of birth so i will use that instead of age.When a student bid i can see their names on the clubs they want, but since its limited on space (10 students per club), i...

I have a student database where they can sign up for clubs. Each club has 10 slots, and each student has four options to sign up for different clubs. Attached to each student record is their age. I would like to use their age (oldest to youngest) to list them for a club. Since each club has...

phaldy thank you, was able to use DLookup()