Recent content by ashleybyrdnc

I am trying to run an append query in access from excel, but i need to turn the warrings off in access so you don't have to say yes through all the warnings. I have tried a bunch of diff things and nothing is working here is where I am right now. here is my code in excel Sub UpdateDatabase()...

What I have done is create a custom form in outlook and I need to be able to get the data into Access. I really don't care where the marco resides in Access or in Outlook. I have seen all the code for importing contacts but I am trying to pull data from emails/ then on top of that from...

Is the NameOfSubformControl the name of the subform? because I am still getting the same error with NCRB2010DefectsSubform.Form!Combo28

I am trying to base one combo box (Combo28) off of another combo box (Combo16) value in a subform (NCRB2010Defects subform!). It works when I have the subform open by itself but when I put it in (NCRB2010) another form it gives me the following error enter parameter Forms!NCRB2010Defects...

I am using a Multi Select List box on a form and based on what is selected in the list box and also a date range field I want a query to pull up. Below is my code so far: My problem is coming when I tell the SQL to also pull Between my two dates that are on the form plus the it gives me an...

I want to have a Form where a list of Sales Reps with a Check Box appear. If the check box is selected I would like a certain date and the rep name appended to a table. Any Ideas where to start?

I have a form that when you click in it places =Now() is placed in field1, Then once you close the record it places another =Now() in field2 in (Database1). Then this table is appended to another database (datebase2) at the end of the day. Later on if a change is made to any record in...

I think thats my problem my code isn't working!

I have a form, that when I create a new record it puts a a =Now() time stamp in the Date Field, but I would like for that time to be updated if anything on the record is changed, later on. How do I update that time?

I have a table that has multiple Account Numbers and their Balances, I need to only pull the records that have the largest value. Example: Acct# Balance 2 $1.00 2 $500.00 2 $300.00 3 $25.00...

Using Access 2000 Nope I am using Access 2000, I had seen that 2003 had problems with Environ() I don't know what my problem is, But I think I have found a way around using it, its definately not the best way but I think it will work! thanks for your help.

I have been trying to use Environ("username") as criteria in a query to return the computer's login name. (Note I have a table with all the usersname) I can use it in a msg box in VB code to return the usersname, but not when I make it my criteria in a query, I get the error Message...

I am trying to pull information in a query based on the computers login using Environ("Username"). What I have done is set up a table with all the users login names and then their first, last name etc. I have a query where I want to pull just the user information on the computer I am on...

Environ("Username") gives error Brian, I opened your database and it gives me the error "undefined function 'Environ' in expression. Which is the same error I get every time I try this or to run any other function. I am useing Access 2000, does any one have an idea why this is happening?

Doesn't work Everything I have tried doesn't work. Would someone please take a look at my database and see what I am doing wrong. When you open Form Label, I want it to pull the network's username and then return that persons first and last name from the Associates Table PLEASE HELP!!!