Search results for query: *

Hi there, Below is a routine to create unique IDs from a flat file, which enables direct importing into Access. The problem is that it takes a long time (approx 2 mins for 330 lines) to execute. Is there someone REALLY bright out there that can help me speed this up? I don't know much about...

Hi there, I have 2 tables, I want to find the matching records (based on 5 different fields) and then update the first table with the ID from the second WHERE the records match (i.e. into a foreign key field). Any advice? Nathan

Hi, I have built a database with autonumbers, to test whether or not it is better to use them. I have all my data in one big table with 28 different columns and 280 lines (for testing purposes). I want to split it up and distribute it into 8 different tables. How do I maintain relationships if...

Hi! I am trying to create a query that shows all unique records in a staging table based on "x" no of fields. This is for importing so I need this list of unique fields which is a subset of the staging table. Then I need to compare this list to the destination table and only add...

Hi there, sounds like a simple question, but the answer is not apparent. How do you sort chronologically by date in Excel? Thanks, Nathan

Hi there, I am getting "You do not have exclusive access to this database. Your changes will not be saved". This seems to have arisen when I tried to setup a switchboard. The switchboard itself has not been displayed or does it work at all. How do I fix this problem so I can do more...

Hi all, I was following a thread recently discussing the merits of normalisation at: http://www.tek-tips.com/viewthread.cfm?spid=705&newpid=705&sqid=404856 I think there is a specifc case in which it could be useful to include redundant data. It specifically relates to queries. Say for...

Hello, I have a main form: frmMasterTimesheet. Then I have created a subform, sbfrmJobDetails, which is linked to the Parent form. Now I have a 3rd form sbfrmTimesheet. from this subform, how do I refer to sbfrmJobDetails? Basically I want to click on subfrom 1 and have the linked stuff...

Hello all, How do you sync a subform based on the same key? eg. link subform A to mainform by primary key. THen link subform B to subform A, by subform A's foreign key and subform B's primary key? It should be very simple, but it is doing my head in! Thanks, Nathan

Hi there, I am trying to sync two subforms. How do you refer to a row and col in a subform? I will then put this as the criteria for the query on the second subform and then simply requery at the onclick event in the first subform. Thanks! Nathan

Hi there, this is probably easily solvable, but I am having major difficulties updating my subform. My main form has a query which includes 2 tables, which are linked by a 1 to many relationship. I want my subform to display all job details (sub form) for each contractor(main form). I have...

Hi there, My combo box doesn't show then record I select in it! Help! Nathan

Greetings, I have 2 databases with the same tables, the same field setups and the same relationships. The first database records all historical data (called A). The second one is a staging database, which records one month's worth of data (called B). I am trying to build a program to import the...

Hi there, I have a combo box, with a number of fields in (to be displayed in other unbound text fields). The field that I want shown is no 5 in the list. Now the problem is that it shows up no problemo in the combo box drop down list, but once clicked on it is not displayed in the...

I have a table and a query. The table has contractor name plus 5 dates for each contractor. This has the latest dates. The query is made up of 4 different tables to draw display the same columsn as the table. THe problem is that the column I need to "compare" by - contractor name is...

Hello, Okay, how do you display field 1, group by field 2 and sum field 3 in a query? I can't seem to display field 1. It gives me "You have tried to execute a query that does not include the specified expression "field1" as part of an aggregate function." Help! I have...

Hello, There must be a really simple answer to this question: In a query with many "information rows" how do you display those rows, group by one field, and show the totals (grouped by that one field) for other fields. I get "You tried to execute a query that doesn't include...

Hi there, I have a temporary table with 28 fields, which need to be split up into 9 different tables. The fields are grouped together according to the 9 tables, including space for a primary key in this temporary table. How do I: 1. Check to see if entries in col 1 and col 2 in the temp table...

Greetings, I am trying to import a large excel file into multiple tables in Access. If have managed to assign unique ids to sets of data within the Excel file so that the fields in the Excel file directly reflect those in the tables. I have also managed to import that file into a staging table...

Greetings All, When having to import data into an Access DB, it might be required that that data is already uniquely identified so that relationships can be maintained. This becomes very difficult when one dataset has to be imported into many different tables. By setting all the Table IDs so...