Search results

Hi I have some code in a function that I want to run BEFORE a form (FormB) is displayed to the user. FormB is called up by clicking on a button from another form (FormA), but when I display the ActiveForm . . . Dim MyFormPO As Form Set MyFormPO = Screen.ActiveForm MsgBox "here!!-" &...

Hi guys This is a good one, so any help is most welcome . . . A hardware company has been to a client and installed a new server. On the old server was an Access database including a number of linked databases. Each linked database has a set of mail merge letters set up initiated via buttons and...

Hi Ive downloaded and installed the AuditTrail zip file as mentioned in a different thread. It works fine on my main form, but I also have a subform on that form. I am trying to pass "ME" as a parameter to a second function ((Audit_TrailSub(Frm as form)) on the Before Update command ie...

Hi We have created some forms using (in some cases) the form wizard. As you may know you have to select a "Background Style" when using the wizard. Now we want to change the background from one of these styles to a colour - but when we select it in Properties and try to apply it, it seems to...

Hi We have a number of forms in our database. Each one is opened from a Main menu form or one of a number of sub-menu forms. However, after a while we are realising that every time we are using a form unless we specifically close it, it stays open. How would we automatically close a form when...

Hi We have generated a query to produce us a report from our database. The parameter to that report is a Foreign Key in the main query table, and we would like to present it as a drop-down box from the table in which it is the primary key. EG our query "select * from Maintable where FK=[FKid];"...

Hi I have a main table in my database. For each record in this table there may exist 0, 1 or many records linked to it in a secondary table. I have created a form for viewing the records in the main table, and now want to link to a second form that displays the records in the secondary table, if...

Hi I've used Access as a datasource to websites for a few years now, but never with an Access Form before. I have a table with a Foreign Key set up to link back to a second table (with id and textfield). I have built a form for the first table and want a combo/list box to display the details...