Search results

You can add extra fields in crosstab queries

Try this Private Sub Command4_Click() DoCmd.TransferText acExportFixed, "VDU", "qryVDU", "C:\FHM\VDU.txt", No DoCmd.CancelEvent Dim strFilename As String strFilename = InputBox("Enter VDU File Name:", "FHM") If len(strfilename)>0 then strFilename = "C:\FHM\" & strFilename Dim...

What is the description of error

It adopted the control of data source you have to change it manually if there are combo boxes or list boxes in data source

You can use same criteria in update query which you are using to get records for form

You can use update query to update data in table

You can make it yourself creat a text box then creat 2 button and add picture to them instead of text on click of button you can change the value in text box

what control you are using in report for showing venue field and what version of access you are using

Add all three tables in the query grid creat proper joins and select the fields you want in the query

Can you tell some detail about table and data on which you want to make query

Try following Sql SELECT Team.TeamName, Activity.ActivityName, StaffActivity.ActivityHours, StaffActivity.ActivityDate FROM Team INNER JOIN ((Staff INNER JOIN (Activity INNER JOIN StaffActivity ON Activity.ActivityId = StaffActivity.ActivityId) ON Staff.StaffId = StaffActivity.StaffId)...

Instead of writing code in control source of text box use some vba event to populate text box (such as form open event) like me.textbox1=DCount("[UID]","[qTesting]","[Test Subject]='Numeracy' And [Test Level]='Entry Level' and [Passed]=Yes") me.textbox2= ....... and so on

Open the form properties while you are in design view and there you can find this property

you can use force new page property

Instead of using the code just go to form properties and set its "Cycle" property to current record.

Does some relation exist between two tables

try form wizard and in the sub form use linked pop up form that will automatically do the coding for you

You can make a string at opening of report For example Dim StrFooter as string if Forms!MasterTable.TriageOptionsSmoking = "Yes" Then strfooter="-Patient needs to stop smoking." end if if Forms!MasterTable.TriageOptionsSomething = "Yes" Then strfooter=StrFooter & vbcrlf & "-Some More...

Have a look at my custom message box sample Here

what criterea are you using