Search results

Hi Not sure what you're trying to do but the reason your query doesn't return any records is: In table Candidate, field ID contains S01, S02, S03 Table Vacancy, field ID contains J01, J02, J03, J04, J05, J06 Table Skill, field ID contains Access, Latin, Occam, Unix. In your query you've...

Hi there I assume the Engineer's name is being selected from a combo box. I would include the telephone number as a hidden column in the combo box (ie make the column width = 0). Then in the combo box's AfterUpdate event, put the following line: txtTelephoneNo = Me.cmbEngineer.column(1)...

Hi there You haven't defined your search criteria correctly. Try this: stLinkCriteria = "[ClmNoSearch] = " & Me!C_NUMBER & " and [ClmRepSearch] = " & Me!C_REP DoCmd.OpenForm "Mod C", , stLinkCriteria hth shay :cool:

Hi Not sure which version you are using - in A97 you can do it using the RunApp action. hth shay :cool:

Hi Sorry I wasn't able to get back to you. We've had floods here and we've not been able to get into the office since the new year. Today, we've had to sit on hay bales on a trailer and be towed into the office by a friendly farmer and his tractor! Anyway, glad to hear you've sorted out the...

Hi Try putting the following in the control source of your report's text box... =iif ((isnull[FirstName] and isnull[LastName]), [Title], Trim([FirstName] & ", " & [LastName] & " " & [Title]) ) hth shay :cool:

Hi there An alternative solution... I think we're all agreed that macros are best avoided but if you want to stick with what you already have, in your macro change the View property of your OpenReport call to 'Print Preview'. This will open the report on screen and allow users to step through...

Hi there I've created a quick example for you. Here's what you'll need to do to try it. 1. Create a table called tblUsers with text fields Username and Password. 2. Create a form called frmUsers with text boxes for username (txtUsername), password (txtCurrentPassword), new password...

Hi In the Company criteria box of your query put Like ([Type in the first letter of the Company's name] & "*") hth shay :cool:

A happy new year to you! Julie Try this: SELECT TOP 10 Count(tblPatients.PatientId) AS CountOfPatientId, tblPatients.PatientId FROM tblPatients GROUP BY tblPatients.PatientId ORDER BY Count(tblPatients.PatientId) DESC; hth shay :cool:

Happy new year everyone! Hi all Sorry but did I miss something here? The original question was answered by Rich but it seems that bodhran1 has opted to use code for this basic Access task. Just wondered if there was particular reason? shay :cool:

I wasn't suggesting that you change your reports to forms! From your post I wasn't sure how you print your invoices - you might be printing by opening the report directly or by clicking a button on a form. If you are printing from a form, I suggest you include a new text box for the invoice...

Try Me![your subform].Form.recordsource="some sql.........;" Me.Refresh hth shay :cool:

I'd nothing much to do today so I've knocked up a demo file (A97) for you. Can't take credit for the code for moving things between list boxes - pinched it from a db I downloaded from some web site! hth shay :cool:

Try Select Case left(ProductID, 2) Case "am" SupplierID = "1" Case "kk" SupplierID = "2" Case "sm" SupplierID = "3" End Select hth shay :cool:

Wouldn't it be easier to print the reports after 31 December? Then you wouldn't need to change anything as Year(Now) would then be 2003. You'll still have a problem printing the Jan 2004 invoices, however. For a proper solution, if you are printing the reports from a form (eg frmPrintInvoices)...

Try this ... Private Sub Form_Current() Me.LocationId.SetFocus Me.AreaLocation.Enabled = (Me.LocationId.Text <> "Hamilton") End Sub Private Sub LocationId_AfterUpdate() Form_Current End Sub hth shay :cool:

Suggest you create a table containing the IDs of students for whom you want labels and include this table in your query, joined to your current table by Student ID. You could create a form with a combo/list box (bound to the Student ID field in the new table) from which you select the students...

Hi Couple of points: Selecting a reference from the combo box won't automatically move you to the correct record - this is why the content of your text box doesn't change. You say you 'click delete' - does this mean you've create a command button and if so, what code have you put behind it? shay

Put this is the control source of your text box: ="phone " & format([CPhone], "(000) 000-0000") & " " & [CExtension] hth shay :cool: