Search results

I have 11 tables, and each record in each table has lots and lots of fields...over 20 memo fields alone for each. I need to build a report that combines one record from each table, but includes all fields associated with each record. Any suggestions on how to start building a report that...

Jack...thank you, works fine. Have a great weekend.

Simple question...I have a table that has a field called "Control_num" that is defined as a number. There's another field in the same table that has a field called "tr_num". Upon entering the "tr_num" field, I simply want the highest number that appears in any of the records in the...

sure, send me the example... smiller@becu.org

I realize you can position a MsgBox, but is there anyway to control its size?

Where can I obtain information on how to access/choose functions in Outlook and incorporate them in Access? In a previous message reference was made to the Outlook Object Model...where that might be found?

I'm using Access97. You know those application icons that are part of Access? I know how to make other icons flash using the timer, but is there any way to address the icons/bitmaps which are part of Access to include those in my code?

If you're in a form, and have a button to open up another form, how do you close the current form and open up the new form at the same time?

Thanks Keith, I ended up going with MHM's suggestion and just am opening another session even though i really didn't (and don't) want to do that...the opendatabase command still has me stumped cause i don't want to open up another workspace, just use the current one, but can't "afford" to spend...

Access 97; need assistance on OpenDatabase I have 2 databases, one called "legal" and one called "contract_review". When the user enters "legal", a form comes up which gives the user the option to go to the other database, eg contract_review...i created a button on the form and put the...

In the code in a form, after closing the current database, I want to open up a new database...I have no problem closing the current database, but am totally frustrated in using the opendatabase command to open up the new database...i've searched through all past messages and definitely do not...

thanks, i finally figured it out.

I'm using a combo box in several forms, but it will only pull up the first instance of a vendor who appears multiple times on the list...i don't believe i have any unique setting turned on...could someone give me a clue...??? the combo box lists the vendor name and each of his contracts and...

When entering a prompt in a msgbox function, is there anyway to use a password mask, eg so when the user types a response, "****" appear rather than the letters or numbers?

Solved my problem...thanks

Ok, i'd like a copy...sounds useful... srm4@earthlink.net

The following line is generating the error: Run time error 3464...Data type mismatch in criteria expression: Set rst = db.OpenRecordset("SELECT X FROM audit WHERE [X] = '" & Me.x & "';") "X" is defined as a number in the audit table. Me.X is off a form that is based on the audit table so why...

Your suggestions were GREAT. Thank you very much!

Well, I was trying to keep this easy, but since I only know 49.3% of what I'm doing... Say for example I have a form called "test" and it contains a field called "test_field" from a table called "test". Then say I have another table called "staff_relations" which contains several fields, one...

Ok, I'm confused. I have a parent file and 6 child tables, they all are related with enforced integrity, etc. They have a common field on which the primary key exists. I'm creating a new record in the parent in a form, and then after i update but before I close, I'm trying to use recordset to...