Search results for query: *

I have been banging my head against the wall on this one. I have a VBA function that get a users username and department. That function works fine. I have some code that needs to run when the DB is first opened so I used an autoexec macro that calls a VBA function: public function db_open()...

I have two table tblA and tblB. tblB was made by selecting distinct First and Last name from tblA. So tblB has 500 rows and tblA has 800 rows. Now I want to add the Country of birth to tblB with an update query joining tblA and tblB on first and last name. Already you can see the conflict, there...

­I have a Access 2010 database that is basically a front end for a MySQL database. There are some local queries and forms and VBA code. For some reason the database will only let one person use it at a time. I checked that the default open mode is not set to exclusive. I've never set anything to...

So I am turning off full menus and the nav bar in my database to prevent users from mucking stuff up. But I am trying to make myself a backdoor so I can make changes. I added this bit of code: if user = "admin" then CurrentDb.Properties("AllowFullMenus") = true...

I am saving my access database as a accde file to lock it down from users. Everything works fine, just how I wanted, but the icon for the file looks like the Access record locking file icon. Is that normal? I feel like users will be confused by that.

I just had an idea, that might just be a stroke of genius. I am working on a database that I want to have different levels or permissions. I want people to just use the forms and reports I create for them. These will only let you access certain things. All objects will be hidden in the...

I am working on making a set of forms that will change depending on the privileges of the user. I can get the persons username then determine their privileges from a table. So how can I use that to hide certain forms or tabs if the person doesn't have the privilege to use them? e.x. if person is...

I hooked up an HP OfficeJet printer to the LAN at work. The printer shows up with the other network printers, and everything looks fine. But when I send it a print job it just prints out garbage until it is rebooted. By garbage I mean blank pages or pages with a couple strange characters on it...

Often I have to work on users computers, and I need to do things as administrator. Usually I have to switch to my admin account and do the work, then ask them to log in to see if it is working on their account. Is there a way to work as an administrator temporarily while still logged in to their...

I have a desktop with a failing hard drive. The OS still boots and the system seems fine except the diagnostics say the hard drive is failing. I want to get ahead of the problem and image the hard drive before it gets any worse. I am setting it up to image now, so I'm not even sure if that will...

I installed Windows 7 64-bit on a computer that was previously running Win7 32-bit. Everything ran fine and I was installing the basic software we put on all our systems. I was in a hurry and received an error when trying to install two programs at the same time. No problem, this has happened...

I just graduated college with a math degree and landed a job in the IT field. I am pretty good with computers, but I have never really had the opportunity to deal with them in this kind of scale. My boss keeps talking about VPN, LDAP, Internet Protocol stuff, among other things that are over my...

I want to create a trigger in my database to track the changes in some of my more important tables. I would like to be able to find out what type of action was taken( e.g. UPDATE DELETE or INSERT). Is there any sort of variable or function I could include in my trigger to return this...

I am trying to use vba to create an empty record in a table, so it will generate an id in the autonumber field. Then I want to get that number so I can use it to update a mapping table. I have: rst.addnew rst.update How can I get the unique id of the record that was created. I don't want to...

I am trying to run this If statement in a query. IIf(InStr(1,[CandidateTypeE],"Dele")>=1,"Delegate", IIf(InStr(1,[CandidateTypeE],"Faci")>=1,"Facilitator", IIf(InStr(1,[CandidateTypeE],"Observer")>=1,"Observer","Ungrouped"))) AS CandidateTypeX And I keep getting an Invalid Procedure Call...

I have created a SQL Server View that limits the data a person can see based on information about them stored in another table. I am using this view as a record source for a form in Access. This form takes something like 15 seconds to load because the view is kind of complex. The view is dynamic...

I have a finance database in Microsoft SQL Server and I am constructing a front end in Access. I am building a check request form that allows people to enter new check requests and also lets them browse through past requests. I created a function in SQL Server that gets the users username and...