Aric Green
Last Activity: Mar 30 '10, 04:46 PM
Joined: Jan 25 '08
Location:
-
I figured out that I needed to use DLookup. Works like a charm. Thanks. -
Using environ(username)
I have an employee table with a "USER" and "GROUP" field. The 'USER" field matches the environ(usernam e) for the current windows user. I have a form that shows the environ(usernam e) in a textbox called "txtUser". I need a textbox on the same form to show the "GROUP" that corresponds to the "USER" from the employee table. This will allow me to control what forms a user will be able to access... -
If you don't have very many users a simple way would be to code the on change or after update (can't rememer which one off the top of my head) something like below. Also need to change the combobox for the department to a textbox. I hope this will help.
...Code:if comboboxUser is "Name1" then textbox = "Department 1" else if comboboxUser is "Name2"then textbox = "Department 2"
Leave a comment:
-
How are you planning on setting this up? Is it going to be on a network?Leave a comment:
-
I would suggest leaving it it the 2003 format. I am assuming that you have not gone into the trust center and changed the Macro security. To do that click the office button (round button in top left), click access options then click on trust center, click the trust center settings button, click macro settings, change it to enable all macros. Hope that will help you out.Leave a comment:
-
Aric Green replied to Office 2007 error "Microsoft Office has encoutered a problem and needs to close"in AccessWe have sp1 along with all office updates and windows updates installed. This is not only an Access problem. It is also giving my users the same error at random while using Word and Excel.
Thanks.Leave a comment:
-
Aric Green started a topic Office 2007 error "Microsoft Office has encoutered a problem and needs to close"in AccessOffice 2007 error "Microsoft Office has encoutered a problem and needs to close"
At work we have upgraded to Office 2007. Our users are getting an error message at random while using Excel and Word. “Microsoft Office (Appname) has encountered a problem and needs to close. We are sorry about the inconvenience.” All computers are have the same software and all updates loaded. This error appears completely at random while the user is in the middle of working.
I am also having this message pop up in some of my Access... -
Access Report Calculations
I just want to see if I am thinking about this correctly. I have a report that shows Time In, Time Out, And Total Time Seen. I have a text box down at the bottom that adds the Time Seen column on the report. I then formated the text box hh:nn to give me total hours and min spent with customers. All goes well until the time adds up to more then 24 hours. If I format the text box to dd:hh:nn it gives me one day less then if I add the times up... -
Access 2K7
I have several access 2K3 databases and we are getting ready to upgrade to 2K7 at work. One problem that I have encountered in my testing phase is that I have several buttons on different forms that when clicked will open another form and close the current form.
Example
-----
doCmd.OpenForm "frmSignInMenu" , acNormal
doCmd.Close acForm, "frmMainMen u", acSaveNo
-----
The problem that I... -
The reason that I want the data split into different tables is that we have different sections here at work and they all need only access to certain information. I have all the tables in a password protected back end file with only the tables that are needed linked into there mde file. I finally figured out how to get it to work the way that I need. Again, I greatly appreciate the article as it was very useful to me and will benefit me in the...Leave a comment:
-
Thanks ADezii. That is what I was thinking but it was not working. I figured it out though. I was creating a new record on the form and using the query to append the ID NUMBER to other tables to create a record automatically on them to use later. I wasn't requerying the form and going back to the record before running the append querys so it was not creating the new record in the other tables. Now that I have figured this out I just have to...Leave a comment:
-
Query A Table Using A Value From A Form
I have a form that contains customer information. I want to use the ID_NUMBER to query another table (when I click a button) to return the record that matches that ID_NUMBER. What is the easiest way to do this? -
Why not just set the default value for the fields on your form?Leave a comment:
-
Thanks for the article, it will be very helpfull to me. Once I figure out how to normalize the tables I still want to keep my data in a couple of different tables. How do I get it to automatically create a record all other tables with the same ID NUMBER from the customer information table when I create a record in the customer information table? The ID NUMBER is an autonumber field.
ThanksLeave a comment:
-
Just taking a quick look I would say I need to set up a relationship between the customer info table's ID NUMBER field and all the ohter table's ID NUMBER fields. Is that a 1 to 1? Anyway the reason that I have several tables is that I needed over 255 fields in a table and access will not allow it. I can not reduce the number of fields any. They are all needed and all different.Leave a comment:
-
Right now there are no relationships with these tables. I just want all tables to have a record created with the ID NUMBER field matching that of the customer information table when I create a new record there. I am new to relationships. Just not sure if there is an easy way to do this using relationships. If not how would I get it to do what I want?Leave a comment:
-
Automatically Update ID Number
I have a customer information table that contains an autonumber field called ID NUMBER that is the primary key. The table also contains name, address, etc. I have 5 other tables that will be used for other information. All other tables have an ID NUMBER field and I would like it to create a new record automatically with the ID NUMBER fields set the same as the customer information table's when I add a new record to the customer information table.... -
That is a good tip. It will not work in this case because ApproveIt makes you sign each record one at a time. I can use this elsewhere though. I ended up mailmerging it with a word document and have them digiatally sign that.Leave a comment:
-
Microsoft Access and ApproveIt
I am wondering if anyone knows a way to make ApproveIt 5.7.4 work with Access. I know that I could analyze the data to excel or word and use ApproveIt to digitally sign there but I want to be able to do this inside of access. I have a database that I assign cards to our employees and I want them to be able to digitally sign for them with their smart card. -
Works great. I had been trying to figure out how to do this for a couple of days now. I wish I would have came here for help first.
Thanks,
AricLeave a comment:
No activity results to display
Leave a comment: