Search results

Thanks SJ Thanks, I got it to work just as your second reply came. I appreciate the extra tip on the code. I have written this entire database from trial and error. Here is a story for you. I work for the government. I used to have a computer business. I can build and program PC's blind...

Take me one step further please... OK so if my combo box is as stated below....where do I throw in the extra quotes...I tried it and got the old syntax error of death.. Private Sub Combo110_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs =...

I have a glitch in my database that I have worked around for months. I would like to rectify it now. My lookup for names works great except for those rare names with apostrophes like O'neil or O'brian. Although I can select the name in the box, the lookup won't work. I have to select the...

This place is awesome Thanks Adam Fleck....that worked like a charm. One of these days I am going to take a bonofide VB course. Unfortunately, even if I did take the course, I would not have the time to go back and fix all the "bad code," working as it is, that I have already created over four...

Would work but That would work but I have three options...here is the code The user inputs an expiry date, selects a tool from the inventory and after so a messsage pops up confirming the issuance of the tool to that person. If the expiry date is missing, it will prompt you for an expiry date...

unfortunately no I have never used the is not null before either. I want one thing to happen if the field is not null and something else if it is null.

da forgot the line If Response = vbYes And (Forms!Officer Comments![Expire]) Is Not Null Then

This is a stupid question but one I can't remember the answer two. How do I fix this line due to the fact that my form name is two words. It won't recognize the "officer comments" form because it is two words. Tried officer_comments tried (officer comments) tried [officer comments] tried...

Thanks for all the advise....The local install may be possible but unlikely. They may do it for testing as you suggested but it would never remain that way. I can only hope that they solve the issue. After all it only took six months to build and it only holds four years worth of data for 900...

If either the renaming of files as stated on the microsoft page, or the upgrade prior to SP# was NOT performed......is there a way to go back and fix this? I noticed that uninstalling SP3 is not an option so how does one go back and repair the damage? I just talked to my IT guy again. They...

OK I NEED TO SAY THIS IN FAIRNESS The three or four people that I work with in IT are very helpfull. In fact they stretch things to the limit to help me. It is the people they deal with that make things impossible. They keep tightening the reigns every month. I work for the federal...

I am 99.999999% sure it is server. I used to have local before the move. The reason being, that I was a building attatched down the street via fiber optic cable. The building was old and oftened lost power, and I wanted to be able to work for a living =-). Getting it installed local is...

Well I especially found this part interesting on the microsoft page: I am willing to bet large sums of money on the fact that it wasn't done. They don't like me using access, and they especially don't like the fact that I create databases that other individuals use with it. I have been fighting...

I'll be honest, as computer savy as I am, I am not familiar with how they have this network rigged. It would appear that the office program is spread all over the place with portions of it residing on the workstations and parts on the server. I know that the workstations check the server on...

OK..I took the liberty of walking upstairs into their office (waiting for an email reply was out of the question). It was service pack three for office 2000. Again, it was just an idea from one of the IT guys that this may have casued my errors. He is having issues with a program he created...

It is definately an access 2000 formated databse. I am definately using windows 2000. As for the service pack.....all I can tell you is this.....When I pleated with IT about my plite, they informed me that in the move to the new building they had updated office to service pack 3. Since we...

I'll make this short and sweet. I work for a large corporation. We moved to a very new and nice building with updated servers that are extrodinary. Somewhere in the move they addedd service pack three. The database I have was built in access 2000 on a workstation with NT 4 on it. I now have...

did that I had opened and closed the db many times with no effect. The name was actually timeadmin. Maybe anything starting with time messes access up. As I am learning VB as I go, the hassle was that I thought I had a problem with code the whole time. Makes me wonder if other code I have...

buggy Figure this one out. I changed the name of the form from timeadmin to aa....out of desperation.....and it worked. Why it wouldn't work with the name timeadmin and it will with the form name aa (I just picked the name out of a hat)...is beyond me. Whatever, it can be called aa now that...

I will try to be short winded. I have a databse that works. However, I want to open a different form if the user is admin (username admin) than all the other users. What I have does not work. It opens the regular form that all the others use. Regular user form = time admin form = timeadmin...