Search results

I would stick the following code behind the combo box: If Me.MyCombo = "Yes" Then Me.MyCombo.BackColor = vbRed Me.MyCombo.ForeColor = vbWhite Else Me.MyCombo.BackColor = vbWhite Me.MyCombo.ForeColor = vbBlack End If There might be a better way but I think that should work. shay

Many thanks for the replies. Opening the form in Dialog mode is the simplest solution I think. I did once know this but months away from Access has resulted in it a memory lapse!! Regards shay :cool:

Hi I've not used Access for a while and need some help... I'm writing code to import data from an Excel spreadsheet. The data will not necessarily be in the correct units, so the plan is to import the data to a temporary table, display all the determinands which are in the wrong units and give...

Hi You could try the adapting the following code: Dim TableName As String, x TableName = "tblRates" & cmbMonth & cmbYear (cmbMonth and cmbYear refer to your two combo boxes) x = DCount("*", TableName) MsgBox x But personally I would have just one table, tblRates, with...

Worked a treat. Thanks mate! shay :cool:

Hi I'm using a listbox with the multiselect property set to 1 (simple multiple selection). How do I reset the listbox ie clear the selection? Can't find anything in the help text. TIA shay :cool:

You need the page break before the Branch Header so force new page BEFORE section. shay :cool:

Thanks for that Rich but the article wasn't quite what I was looking for as it describes how to print separately the odd and even pages of a report. My report has around 10 groups and what I want to do is start printing each one on an odd page. From the KB article, I know how to identify when...

Hi all Report's written and working fine apart from one thing. It starts printing each section on a new page but, because in our efforts to save trees we have double-sided printers, I sometimes get two one-page section reports back-to-back but each one has to go to a different person! I need...

Another solution... Hi I've attached an alternative solution for you to use or ignore as you please! There's any number of ways to code a problem but always try to avoid having to repeat code. If you need the same piece of code in more than one place, write a separate sub or function and call...

I work on (a copy of) their live file. Not saying that's the best approach but it works well enough for our situation. shay

Many thanks. Shay :cool:

Hi My back-end mdbs only contain data tables so very rarely need updating. If this ever occurs, the customer has to suspend use of the system until the change is made and the new file supplied but we're usually talking minutes rather than hours or days. hth shay :cool:

Hi How do you reset the hidden attribute once you've already set it to True and can no longer see the table in the Access window? shay :confused:

Hi I'd create a function Public Function CheckInput(KeyAscii As Integer) CheckInput = IIf((KeyAscii = vbKeyDelete Or KeyAscii = vbKeyBack Or (KeyAscii >= 48 And KeyAscii <= 57)), KeyAscii, vbKeyClear) End Function and then put the following line of code KeyAscii = CheckInput(KeyAscii)...

It's a bit late to join this debate but ... I normally use a command button to switch my forms between read-only and editable. Give the following code a try: Private Sub cmdAllowEdits_Click() With Me.cmdAllowEdits If .Caption Like "*Read-only*" Then .Caption = "Click...

Hi Has anyone managed to sucessfully use their own command button to apply a filter? In my example, as soon as you click the Filter by form button, every other button is disabled and I can't use the Apply filter button! I'd prefer not to use a custom menu or toolbar so any suggestions...

... so why not include year([yourdatefield]) and group on both? shay :cool:

Hi Put txtToday = Date() in your option group's afterupdate event. hth shay :cool:

Hi Eric I have worked out why the .Requery wasn't working. When you have a form and subform, you need to define the Link Child and Master fields to keep the data in synch - you do not have to keep redefining the recordsource for the suform as you have with qryDynamic_QBF. I got your Search by...