Search results

  1. A

    Running An Append Query From Excel in Access Help

    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()...
  2. A

    Importing Outlook Data into Access

    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...
  3. A

    Basing one combo box on another - doesn't work in subform

    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...
  4. A

    Multi Select VBA Code SQL Question

    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...
  5. A

    Query/Form Question

    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?
  6. A

    Date Issues

    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...
  7. A

    Update =Date() on Form Load

    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?
  8. A

    Return Greatest Value

    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...
  9. A

    Environ("Username") Gives Error

    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...
  10. A

    Environ("Username")

    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...
  11. A

    Setting Environ("username") = to a Value in a table

    Sorry you guys, I am new the VB in Access and have spent about 30 min searching for this and can't figure it out. I need to Pull the User ID or the Network ID, which I have done useing Environ("username") and make sure that ID is in a table call associates and then pull the relationships with...
Top Bottom