Search results for query: *

Hi, Worked like a charm...Thanks! "Computerized God, it's the New Religion...send in the child for connection." -Black sabbath

Hi, I am creating an Access database that I want to make as automated as possible for my users. I have them running a "utility" database that simply performs Compact and Repair on the main database, then opens the main database, then closes itself. After a little tweaking I got this to work...

Hi, I don't understand...what do you mean by REC codes? REC is a field (Primary Key) of the main table. Thanks.

Hi, Please ignore my question above...I found the answer. The spreadsheet is using the report's textbox names as the column headers....DUH. Thanks.

Hi, I am having an odd issue when exporting a report to Excel. The field labels on some of the columns are listed at "Text20", "Text21", etc, while others have simply the database field names as one would expect. There seems no rhyme or reason for it; am I missing something? Any help would...

Hi, Is there a way around this? Do you have any idea why this may be happening? In the event that there is no way to create this relationship through code, would it be just as effective to create a join within a query instead for all of the queries that require this relationship? Thanks!

Hi Again, Actually, I made a mistake: it was generating an error; I simply had it disabled. the code is as follows: 'Create Relationship for INS_CustomersOnly_Table - AP1DB2A_Table_Revised Dim dbs As Database, rel As Relation, fld As Field...

Hi, OK, I used this code and it produced no errors, but the relationship doesn't show under TOOLS | RELATIONSHIPS. Is it supposed to, and if not, how do I know it worked? Thanks.

Hi, No I hadn't...thanks!!

Hi, I am creating an Access project and I want it to be as automated as possible for end users. On a certain step it has become necessary to create a one-to-many relationship: is this possible through VBA? I've looked everywhere...any help would be greatly appreciated.