Search results

I’m attempting to set up a database to record employee training. I’ve set up the autolookup query (pic attached) to help form a set of default training courses/procedures that are mandatory for each department – if Department A requires eg CPR, Fire Safety and Working at Height training, the...

Hi Attempting to adapt some VBA in order to sequentially number a field (named Code) based upon whether another field (txtimagename) is either blank or Is Null. Code I have to date for a button on my form: Dim dbc As Database Dim rst As Recordset Dim i As Long i = 1 Set...

Hi Is it possible to include a Dcount function in a query (qrySurveyDetail) to sequentially number records where a text field (ImageName) is not null? RecordID 67 68 57 71 ImageName Image Image No Image Image Dcount Number 1 2 Blank 3 The RecordID for each record, although...

Hi, I've been working on a report for several weeks and have yet to come up with a solution for the following setup. On the main (parent) report I have Contact Name and address fields with a subform (SubReport1) which have been successfully linked. SubReport1 has a child subreport...

Hi Is it possible to prevent the AfterUpdate event firing on a main form when a subform on the same form has been selected? Have tried Screen.ActiveControl.Name to identify if the subform has received the focus but it appears that the main form AfterUpdate event fires and the last control to...

Hi I've embedded a Windows Media Player (WMP) active x control in the header of a continuous form. Works well until I either scroll through the records or click on different records - the WMP decreases in size until it's no bigger than a postage stamp. I've looked at various settings both in...

Could someone please assist with the following issue with a chart (on a form) that is based on a crosstab query. Row source for the chart is a crosstab query that counts the number of records based on the level of risk. (High, Medium and Low). I'd obviously like the bar chart colours to appear...

Unsure whether I've grasped the concept of a union query but I'd appreciate confirmation that I'm on the correct track. I have one query that is populated automatically (DataLoggerQuery) with several parameters being captured in the underlying table. I'd like to populate the underlying table...

Hi, has anyone had experience with importing/linking Access to an Advantage database. I'm able to import tables from Advantage into Access (the underlying data I can't edit because it's linked) but would ideally like to be able to manipulate data in Advantage from Access. Is this possible?

I've got 10 small images in a report that appear depending upon whether a tick box (for each image) has been ticked. I'd like to have all of them in a row and in the event eg Image 8 is unticked, Image 9 and 10 (if both of them are ticked) move to the left to fill in the gap. Usually there are...

Upon loading and referencing an ActiveX object in the VBA window, I've tried to change the location of the object in the Tools ] References list by browsing to another version of the object in a different folder. However the location details always revert back to the original location no matter...

I have some code in the open event of a form that opens a msgbox but the msgbox takes focus and has to be acknowledged before the form appears. I would like the form to appear first and then for the msgbox to automatically open. Is this possible?

Hi I’m attempting to open a form at a certain record where the value of an unbound textbox (txtBarcode) is equal to the primary field (signinID). All works well until I attempt to modify the OnLoad, OnOpen events etc of the form that I’m finding the record within...

Hi Been trying to open Form2 via a button on a subform (Subform1) which resides on MainForm1. I also want to filter the data based upon a value (Field1) on MainForm1 - been struggling with referencing mainform value despite looking at various posts/websites. Code so far (will work if button...

Hi Been struggling for a couple of days now, I want to reference a page called Completion on a tab control (TabCtl220) on a form called permittoworkform and select it - all this from a button on another form. I don't want to put any code in the OnLoad event, for example, as I'd like to have...

I'm working in Access 2000. I have a continuous form "SecondarySupplierForm" that is opened from command buttons in individual records in several other forms. When a user clicks the button, "SecondarySupplierForm" opens, filtered to show just the records related to the 'SupplierNumber' of the...

I’d like to develop the following code in order to trigger another section of code (in this case ‘Mail_CDO’) not only when the cell value is greater than 7000 but also in the event that A1’s value remains the same for,say, more than 10 minutes. Any ideas? Private Sub Worksheet_Change(ByVal...

I’ve created a cross tab query that obtains the total of faults on any date inputted as part of an underlying parameter query – so far so good. However I’d like to generate a chart that reveals the trend for such faults – the only way I can think of doing this is to somehow automate an append...

Hello I've got lots of unbound checkboxes on a page of a tab control - upon navigating to a different page, the remnants of the border colour of some of the checkboxes remain visible (please see attached) Any ideas how to overcome this issue (apart from removing checkboxes and changing their...

Hi I'd like to add an image of a PDA to a form, add unbound checkboxes with their labels relating to different parts of the device. Upon clicking the various parts, a subform record will be added for that particular item. For example, if the antenna and screen were checked the subform records...