Search results

Beautiful, worked like a charm. Thank you.

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

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

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

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

That is exactly what I am looking for. Thank you very much. I will look a little harder next time.

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

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

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

Do I set all 3 to index (no duplicates)? If I do that, it will reject the record if there are dupes in any of the 3 fields. I need it to reject only if all 3 fields are the same. I appreciate your time.

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

Thank you, the DISTINCT key wasn't nessessary. The query is pulling the info as expected.

This Query is pulling Info from the crosstab and a table. The crosstab is used because the table I have to import has the products in the records so each node is listed 4 times per date. Is there a better way of doing this?

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

I'm running into a problem of pulling the newest date for all nodes. All I want to pull is the newest date. If the node isn't included in the newest update it has been dropped. I don't need a history of that for the query as it is kept in the table. It is in a true date/time field.

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