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...
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...
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...
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...
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...
Is there a way to find out who updated a record without having the person actually select their name from a list noting they updated that record? Reason being; my manager has requested I put this in the DB w/out the users knowing, (I guess he wants accountability).
Ex. John Doe opens the form...
I have 5 users in our Pittsburgh airport terminal who's printer refuses to stay on the manually set default printer for their location. For some reason after restart it goes back to the previously set default printer which is in another airport terminal. These are not roaming profiles either...
I have a user who when entering the user name, ex. john doe, a list opens prompting to select the proper john doe address, (ex. jdoe@msn.com, john_doe@yahoo.com, doe,j@excite.com).
She selects the proper address then hits send.
However, it opens another list asking her to choose the proper...
Access 2000 WinXP Pro
Good afternoon all, I'm looking for your expert knowledge.
I've created a form which is pretty simple. Each time a request for hardware of software comes in through the intranet, I enter that data into the database form. I created a macro "submit" button which will...
Good morning all, I have a search frame which is set to toggle between two combo boxes 1 to search for user, 1 to search for serial.
I'd like the user combo on click to open my subform and show all records held by that particular person, ie. computer, laptop, monitor etc. I'm guessing I can...
Does anyone know if there is an easy way to fill over 1000 empty cells in the same column on my main table with the same value? Besides of course going one at a time and pasting? this would be greatly appreciated.
As always thank you for your help!
I've created a combo box with the combo box wizard. It is currently set to lookup the record by the value set which is serial #. However, I've been asked to have this searchable two ways. Management wants to be able to search by either username or serial. How can I set this up to be able to do...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.