Search results

Hello all, I converted an old database from 97 to 2002. But now it doesn't work the way it used to. If someone with extensive module knowledge would help me, i would appreciate it. I'll try and attach it here. Everything is the way it was, I just changed the names to protect the innocent. :)...

Hello, I keep getting this error when opening up a database. What can I check to find and fix the problem? TIA

This database is all messed up. I added a field named useridunclass, and it passed the 'stuck' point but now it's looking for a UserHostName. How is it possible that these fields are missing?

I don't know why it was deleted...I will add it.

Also, the getUser is supposed to be the currently logged on user... So that the database automatically parses that info to a value. ?? I don't even know if I can explain it right...

What can i do if there's no useridunclass field in table tblusers?

I'm trying to use a database that i had at an old job to a new place. The db contains a lot of DLookup code. In this environment, i keep getting a lot of errors because of the DLookups. Is there a way i can change them to something less complicated? One of the DLookup lines go something like...

Hello all, I have a DB that's giving me errors. The first line that shows with an error is: CallerID = Nz(DLookup("[useridunclass]", "[tblusers", "[useridunclass] = getuser() ")) Can someone please explain what this is? Thank you. I can't find the 'useridunclass' anywhere in the modules or...

How can I change a data field name in one table and have the changes propagate thorughout the whole database? Is this even possible or will I have to go through all my tables, queries and forms one-by-one to do it? TIA

Thanks Fornatian... that fixed it. :)

Help, I have this form that updates my database when I enter a new record, but If I close it and re-open it, it will display just a blank new record. I cannot browse my previous records.... I have to open the table it updates in order to view/edit the previous records... any help? TIA

Thanks Wayne... I will try and do this... I do have a tblInfo with all the user's information and a tblUserLog which is the one that has the info after they call the helpdesk... I tried the subform thing above and it didn't work the way i need it... Thanks

I do have the info in a table... A subform?

Thanks Pat... I will probably have to do the query thing that you mention because the properties thing didn't work. :( I will try and use links from now on... :)

I'll try that. Thanks.

Hello everyone, I'm creating a form for a help desk type of database. I have the users list down on a combo box in the form. I want the form to automatically fill in the user's extension, workstation id, userid, etc when I select the user from the drop-down list. Is there a way to do this...

Hello everyone... I'm creating a type of help desk form in order to keep track of calls, etc. I have the form but when I add a combo box to it, the contents of the box are not sorted. If I look in the table where the values are coming from, they are sorted aphabetically. Why don't they show...