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...

Got it !!! Set Limit To List" = "No" Thanks anyway. ajm

Combo box error Hi I've come across the same problem. I changed the recordset type on the form, and it now allows me to enter something into the box. However i am getting a box saying . . "The text you have entered isn't an item in the list". The data source for the combo box is indeed a list...

Me ?? Hi I thought "me" was a reserved word - ie indicating the current object. I've just had a look at my Before Update property on the subform and it reads =Audit_TrailSub([Me]) MS Access has added the square brackets not . . . me (as in "ajm", the author of this posting - not the subform)...

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...

Figured it Hi For anyone who may have a similar problem . . . I figured that the Style was a background image, but couldn't find where to turn it off. At the very top of the form, in the left corner (at the corner where the two rulers meet) left-mouse click on the tiny black square and hit...

My mistake Yep - sorry, I must have hit "Post Reply" instead of "New Thread". ajm

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...

Form background colour 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...

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...

How to link them up Hi Thanks for that - I have made the changes to the Query as you suggested SELECT * FROM KeyDocuments WHERE categoryid=Forms!Frm_KeyDocsByCategory.LB_Categories and created a Listbox "LB_Categories" on the form - Frm_KeyDocsByCategory. But I can't get the query to run...

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];"...

Ace thanks Thats ace. many thanks !!!

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...