Recent content by applevacross

Tools>Security>User-level security wizard. or you can code the form manually with security perms.

You might be correct on the formatting aspect, as I have built this entire DB with only one table containing approx 8000 records. There is really nothing to the combo it is controlled by the the power supply serial field from the table and this is the row source: SELECT...

I have a combo box which contains all power supply serial numbers. When a power supply gets re-issued to a laptop, I want the serial that gets replaced in this combo to be able to be reused later as opposed to just getting written over. Is this possible without having to creat another table for...

Thanks gol4, I actually tried that one earlier and would think it to would be the best option. But how would I go about integrating it into my current db? I tried but nothing would function properly. Any Ideas?

WinXP Pro, Access 2000 I need to create an advanced search,This search will be it's own form with a subform. Ideally I'd like to create a text box search where I can put in any criteria relating to the database table. Meaning, If I want only hp laserjet printers, I can enter that and the...

Thanks PH, what does [field N] identify? Thank you, I appreciate your help!

Hi all, I am currently using a frame with two radio buttons controlling two combos to switch between search requests. I can enter by name or switch to serial and enter likewise. The output is generated in a sub-form of all records by that name or serial. Mostly name, since of course serial is...

Windows XP Pro/Office 2000 I was able to output to excel before fine, now all of a sudden I cannot. I keep getting a message when I go Tools>Office Links>Analyze with MS Excel: "Cannot access "xxxvac_Inv_DBQuery.xls" It's wierd. It won't output the data, but it still creates the spreadsheet...

Really no need to password protect. Only make Admin and yourself able to utilize by going into security users/groups and remove them from that form. Or just make the users/groups read only users. Hope this helps.

No, no you are correct. I spoke it the way I understand which doesn't mean others will. Sorry about that. You deciphered properly and helped me do what needed to be done. Thank you much, Two Stars for you!

Great, thank you. Shall I link the tables though?

Thank you Remou, Yes, I would like to two seperate combo boxes to update the fields within the current table. I tried doing the second part yesterday by importing my excel spreadsheet, then converting into a new table. I'm just not sure what to do from there. Do I link the tables and then...

Good morning all, I'm updating some data in my DB and have been requested to make a combo box with default values to choose from. I've already got two fields in my table; NT USername, and Full Name. I don't want to touch the default data, instead, I want the value from the combo box on the...

This is basically a user environment question. Does anybody know if Lotus has any plans for the future to integrate their email client with outlook and the office suite? There are so many issues which certainly is par for the course; all things considered. However, Notes seems to be a very...

Hi guys, thank you for your reply This is a local replica and is set to sync every 2 minutes. It worked before, but here's some info I have recently learned. She loaded the Outlook Damo. Management found out and ordered her to remove it. Since then, she's had all kinds of problems. We've...