Search results for query: *

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

I thought about that as well Can I select the already available source when configuring the box and have the selection save into the field I want it to [not the newly appended fields]? Reason being; The name and NT name fields are already fields within the table. Management decided on a...

I have two combo boxes I would like to create. The information in one is UserName, the other is NT USerName I did a system audit and created an RTF file which has 4000 of each. I'd like to add these to my value lists without having to manually add the quotes and semi colon. Is there a way to...

I know with outlook there was a problem regarding Service pack 2 where emails wouldn't come in until you clicked on another email or sent an email. The solution for that was to do the office service packs. Here I seem to have the same problem with a user where they do not see any new emails...

Can I send you donations? It's people like you that will eventually make me like you. That's perfect. Sorry I'm learning the ropes. Thanks again!

Hi PH, here is the chunk of code from the vb editor on the before update procedures of both text boxes. I don't seem to be getting the data back at the table: Private Sub Combo96_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone...