Search results for query: *

No, I grabbed the userid using the CurrentUser property when the user logs on, so I already know which user it is. What I want to do now is: using that userid, get the User's name from the Users table and print it on the letter...

Hi all I have a form that I print letters from. I want the name of the current User to be printed on the letter when it is printed. I have a table with user names and userid, and I have a field for userid in my main table. How can I tell the program to give me the user name from the user...

go to Tools / Security / User and Group Accounts, find the user and click Clear Password.

Hi all I have a form with two check boxes, that are bound to two separate fields in a table. When I click on checkbox1 I disable a command button2, when I click checkbox2 I enable that button and disable command1. Works perfectly - except when I navigate through the records then whatever state...

Thanks a lot

I have table set up with two fields: code# & description. On a form I have a drop-down box that selects the code# and I want a text box right next to it that shows the description of the code# I selected. How do I do that? Thanks in advance.

I have two tables that may or not have identical records (both with the same index). Is there a way in Access that I could merge both tables while eliminating any duplicates, or just update the record if is found in the other table?? Thanks

Thanks that worked perfectly

I have a form on which I have a few combo boxes. What I want to do is display different text in a textbox depending on the criteria in the combo boxes. However, when I put the code in the AfterUpdate event of the combo it gives me an error say something about Focus. The code is as follows: '...

Thanks Kevin Worked like a charm.

I have created a form to accept data from the user. I have two hidden text boxes that update the Current User and Date. When a new record is added everything works fine but when I am making changes to an existing record those two fields retain the old date and the old User. How can I get...

Hi all I have a table with over 4000 records and I was just given a second table with the exact records as the first but with a new field added. I created a new field in my orignal table and now need to update it (my orignal table) with the data from the new table (about 2000 records have...

No it is not an MDE it is actually an .mdb with workgroup security. I tried logging in as Admin, but I still could not make any changes and when I checked the owner of the tables they were all 'Unknown'.

Hi All, I inherited a database that was written some time ago, I can open the database and run the frontend ok. Problem is I now need to make changes to a few of the forms in the database but I can't view the design of any form or table much less make a change. I tried creating a new database...

Hi all, I have a database setup and shared on two computers. When I opened the database today and tried to open one of my forms I got this message: 'The Microsoft Jet Engine stopped the process because you and another user are attempting to change the same data at the same time." I...

Thanks man

Hi all, I just converted my database from 97 to 2000. Everything look fine but none of the buttons on the forms work. When I tried looking at the code it gives me this error 'Error accessing file. Network connection may have been lost.' My network connection is fine. When i tried adding a...

Thank You LameId I could export the tables and the Queries but I only have Open/Run permissions on the Forms, Reports and Macros. Is there a way I can manipulate the workgroup file or is there anything else i could try?

We have an Access database that we can't change anything in the design b/c the creator resigned and didn't leave the password. I created a new Workgroup file (.mdw) with one user (Admin no password) but still doesn't have permissions to change the design (can look at everything though). Is...

I am using a database that was created by a another user. I made changes to a report but when I run the program the changes are not reflected in the preview or print. Do I need to recompile the Report? And if so how do i do that? P.S. Everything was created in Access 97 including the form...