Search results

  1. V

    combo default value not updating textbox

    I have a combobox that autofills a textbox that is working properly using AfterUpdate, based of a users table with username, firstname, lastname, location. The cboUsername will autofill txtLocation when I choose a user. The problem that i am having is that I have the default value of...
  2. V

    auto ID record from 2 boxes on form

    I have a simple form for data entry. ID: autonumber Date: shortdate (textbox, yesterdays date by default) AspectID: text (combo box from user table, 2 column with ID# and concated first and lastname, bound to column 1) various other record entries It all enters into table easily enough, but...
  3. V

    Security record

    I've been reading through posts the last couple of days, and have found elaborate resolutions to what I need. What I am looking for: I have a fairly simple database with Access security-wizard setup. What I would like to have, is a table of users logging in. All I want to know is who is using...
  4. V

    Speed issue, Query takes 7-8 min

    I'm running this query off a table of about 1.5mil records. If I leave the date parameter off It comes up under a minute. When I add it back, it takes 5 minutes before the query even starts running. All the fields used in filtering the query are indexed. Any ideas to speed this up? SELECT...
  5. V

    Combo box to also select all options

    I am having an issue with a combo box on a form with the following query. It works exactly as it should, but unfortunatly, I need a little more. cboASC is off a table, cboQCode is from values, If I don't fill 1 of the combo boxes I get a blank record (just fields). What I need is an option to...
  6. V

    Update query issue (new to Access)

    I've found myself having to start using Access due to record limits. My reports come to me in Excel and go out in Excel, but by sheer quantity I need to store records in Access. My problem is in an Update Query: I import records into a 'DoNotDelete' table and then run an update query to the...
  7. V

    Remove colon from MAC address

    When TableA is imported from Excel, it has the MAC address as xxxxxxxxxxxx. When TableB is imported from Excel, it has the MAC address as xx:xx:xx:xx:xx:xx. In a query the TableA and TableB are joined by the MAC address. Obviously I get no results from TableB because they aren't the same. How...
  8. V

    I need to match 3 fields for duplicate

    I am exporting an Oracle report to excel, and using an Access macro to import into a table. The records contain some duplicate info that I do want to capture, but I don't want to import the same records. (I import the file on one day, and someone comes in and imports the same file later)...
  9. V

    Dates are killing me!

    Thanks for the help. I'm getting through this db. I am trying to get user input of start date and End date for the following: SELECT [ASC Cust Count_Crosstab].Node, [Oracle Account TC].[Q Code] AS [Q5 TCs], [ASC Cust Count_Crosstab].Video, [Oracle Account TC].[Check In Date] FROM [ASC Cust...
  10. V

    only pull the newest date from a table

    I have a crosstab query that I ONLY need the newest date from the table I'm pulling from reguardless of what it is for. Here is what I have: TRANSFORM Max([Cust Count].[Active Customers]) AS [MaxOfActive Customers] SELECT [Cust Count].Node, Sum([Cust Count].[Active Customers]) AS [Total Of...
Back
Top Bottom