Search results for query: *

I am having trouble with only some of my wizards in MS Access 2003. For example, I try to use the 'Find Unmatched Query Wizard' and it takes me through the usual steps but no fields are shown from either table that was chosen to make a match. Also, when I try to create a subform from an...

I did a test and found that when I update the data in the DM I delete a table then import the new one into the database and then make it replicable. I guess this resets the table in comparison to the other replicas and that is why the data is getting overidden. So my question would be how...

Scenario: System data changes at least once per week. Multi users can change data any number of times. I have a Design Master(DM) that is a BE that accepts the data (table) changes which I control. There is a Hub replica of the DM on the local server. There is a Server replica of the Hub with...

Scenario: Access 2003 Datasheet view form Control is a text box- PN I have 6 conditions for this text box. The 'Select Case' works in the On Format Event in one of my reports but the same does not work when putting into the datasheet view form. I have placed it in the On Current, On Open, and...

Scenario: Currently calling the function SynchronizeDBs in the On Open Event of the Start-up form. The function is called out as follows: =SynchronizeDBs("C:\Documents and Settings\...\IDB HubR1.mdb","\\ww007\...IDB Hub.mdb",1) The function code is: Function SynchronizeDBs(strDBName As...

Thank you very much Remou!

I am looking to change the Tables Property/Attribute to "Replicable" through code. I see a lot of threads that address changing field properties of a table but cannot find this subject. I need to import tables into my main hub (BE that feeds other replicated hubs). When I import the tables...

Scenario: FE database on laptop that has linked tables to the server. AutoExec macro initiates the links. My problem is that if not connected to the server the db fails because it cannot find the links. 1. How can it check for a proper link prior to running the AutoExec macros? 2. If a...

Thanks both were helpful.

Scenario: Main Form: fMain Sub Form: fsub1 and fsub2 2 tables: tbl1 and tbl2 Query: qryAppendtbl2 After 2 fields are chosen on fMain, fsub1 will display an ID that is indexed into tbl1. fsub2 needs that index number from fsub1 so the records can be synched in reports. NO record exists on tbl2...

Remou: I cannot remember if I tried on the AfterInsert event. I will do so. Missinglinq: You read correctly. All based on the same table. I am not an access guru, I am basically learning as I go. A lot of additions have happened on the fly. I guess its not the best, but what I have right now.

Scenario: Main form (1)- frm1 based on tbl01 User enters 3 parameters to filter by p1,p2,p3 Subforms (6)- fsub1-fsub6 (each with its own tab) also based on tbl01 ALL subforms are Linked to frm1 through 2 fields (p2,p3) When the 3 parameters are chosen fsub1 will list the basic info associated...