Search results

Just for your reference, this is what i have. Added the text box and set the auto-refresh timer. Problems: 1) After Form refreshes, the scan_gun_out and printer_out boxes stay enabled as to if you close the form and open it again they are disabled. When the boxes are enabled, any employee...

Hey CJ, Thanks for all the help with this DB. But i think i have to start from scratch again. These combo-boxes are just killing me. Have to go with something where an employee has to scan in and out everything manually (no drop-down lists) to ensure the integrity of the process. People get...

Works great, thanks !! Is there also a simple code to refresh the form after some time so when the next employee uses the form, its all blank? right now when an employee checks something out, his/her name stays in the Employee_ID combo-box. I've tried the form.timeinterval = 300000 and...

I've tried using the =MID function in the Employee_ID combo box Control Source, but it didn't worked. The employee id is 100 and the whole scannable id is VFI100LCN. So i used =Mid([BCode],4,3) in Employee_ID control source but it gave me run-time error om "Employee_ID.Value = BCode.Text" that i...

Thank you CJ, it's working :) Now lol You suggested to use =Right in your previous post, i tried but that didn't worked. Is the code gonna go to somewhere else in combo box ?? It's a really good idea and i want to use it. Also, can i apply the same concept of adding text boxes to the other...

CJ, So the textbox (BCode) is working to EmployeeID but the scan_gun_out and Printer_out are disabled and scan_gun_in and printer_in are enabled. how can change that to like it was before? please see attached.

Thank you CJ, I'm gonna try this now and let you know how it went !!!

Hi CJ, Thanks for the quick reply. Yes, exactly what i want but is there a way i can prevent them from selecting it manually from the drop-down list? Also how can i edit the code where employees must scan-in their equipment. In other words, they shouldn't see what was checked under their name...

Thank you both for the suggestions and i apologize for not doing a good job on explaining. let me take another shot on this: - Currently users are selecting their names from the drop-down menu and then check out a scan-gun and a printer. When the same user comes back to check-in the equipment...

Thanks rzw0wr, but i don't want to lock it as i still want the user input when they try to check out any equipment and same as checking-in. And certainly want it to be visible. Missinglinq - Converting this combobox to a textbox is not working, not sure why but it';s just not. Maybe because i...

Hello Everyone, I need help with my attached db. Currently everything is working great but i need to make some changes where user should not see the drop-down lists and instead of selecting their names from the list, they must scan it in. Just trying to put more control on. * if the drop-down...

Made few changes as you suggested in the code and now everything is working great. Thank you so much for helping me in this project !!!!

Hi CJ, thanks for the code and its working very good. But seems like as i'm trying new scenarios, some new problems are coming up. Example, when a employee tries to check-in a Gun or a Scanner; the same gun or scanner serial number shows up in Gun-Out and Printer-Out fields. Also the form...

So i was trying to add a third table (Employee Info) to itemscheckedout query so i can have Employee names there but that didn't worked. it looked simple but ahhh didnt worked. What would you suggest in this case?

Still need few refinements. 1. How can i add Employee name in Table2 and ItemsCheckedout, need it for reporting purposes. 2. i want the Form to refresh automatically after an employee checks-out or in any equipment. 3. Do want to make another query for equipment checked-in to see the...

Thank you very much CJ. I'm gonna try to input all the data and test it a few times with different scenarios. It's working beautifully rite now . . . . thanks again !!!

Hi CJ, Appreciate all your time helping me with this. Answers to your questions: 1. I want to limit only 1 employee can check-out more than 1 gun to himself. 2. No to printers. One employee 1 printer. 3. The Status field i thought should be helpful in programming. Whenever a employee will...

Hi CJ, I have made some modifications to my existing table. please see attached and let me know if you can help. Thanks s9y

Yes, exactly the same. The code i have is checking for duplicate entries but how to check-in again thats the problem.

Hi CJ, Employee_ID is Text Time_Stamp is set to Now() It will be 3 entries for 3 equipment check-in and outs. Also the check-in and check-outs will not input on the same row of the table. Different entries to keeping things separate. I hope this helps you helping me. Thanks s9y