Search results

Aha! Now it works! Thank you. So, the code that I have is: Option Compare Database Option Explicit ---------------- Private Sub cmdOpenReport_Click() On Error GoTo Err_cmdOpenReport_Click Dim strWhere As String Dim ctl As Control Dim varItem As Variant 'make...

I have sorted it! Thank you - that's ace. I was having problems, becuaseI had failed to set the On_Click to 'Event Procedure' (so it wasn't doing anything). It now works a treat! Andy

Ah, no! The intervention form is boud to an intervention table, which contains a foreign key - so that you can link the intervention record to a patient if needed. You have two routes to record an intervention: 1) open intervention (sub)form on its own - recors an intervention in the...

Hi I want to create a report that shows how many times a field has received a particular response in a certiain time period Eg The form collects info - - field 1: person A, B or C (drop down list) - field 2: date - field 3: option x, y, or z (drop down list) I want to show Each month...

[My understanding of coding is nil (as you'll know if you have seen my other posts), so sorry if this query is too simple and should be posted elsewhere!] I have a form that displays a list of 'active' records that are read/accessed on a different form - like a menu, showing the title/date of...

I tried! It did this - attached. Also, once I have replaced the code (as you suggested) how do I get rid of the yellow arrow and highlighting? Andy

OK... I will try. Andy

Now, when attempting to leave the coding window this line Private Sub cmdOpenReport_Click() turns yellow, gains a yellow arrow pointing at it and I can't use the form A

Here is an image to show the problem. Also, when creating the multiselect list box, what is the difference between multiselect=simple or =extended; and what on Earth is IME Sentence Mode, which I notice you have set to Phrase Predict? I couldn't immediately see that anything else has been...

I have amended the code for the button on the multiselect box form to say: DoCmd.OpenReport "rptEmployees", acPreview, , "EmpID IN(" & strWhere & ")" AND DateField >= #" & Forms!frmOpenReport.txtFromDate & "# AND DateField <=#" & Forms!frmOpenReport.txtToDate & "#" This turns the text red...

Very groovy What do you do if you don't embed them?

OK, I'll try make sure that I use: DoCmd.RunCommand acCmdSaveRecord. Thank you.

Cool. Thanks. Am I essentially correct in the rest of how I create it - fields not linked to a table etc? A

Ah... OK - that might be an issue!

So, I can use DoCmd.RunCommand acCmdSaveRecord, assuming that noone is running Access 97. I am trying to make the database work across Access 2003, 2007 and 2010. I have noticed that Close buttons don't always work! I think that they are more succesful if created in 2003! Thanks Andy

Hi Based on what you have suggested, I have in my mind a vision of a form with four 'bits': 1) multiselect box based on active employees from a query 2) text entry box to enter a date (typed or date picker) for From Date 3) text entry box to enter a date (typed or date picker) for To Date 4)...

If I create a save button in Access 2010 the code is: DoCmd.RunCommand acCmdSaveRecord If I create a save button in Access 2003 the code is: DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 I'm sure that there are other issues for buttons created using the wizard...

Thank you! It was just for the menus (with few buttons) but I'll be careful! A

That's ace. Thank you.

I have played around with the Multiselect box example from http://www.baldyweb.com/multiselect.htm - 1) added a yes/no field in the employee table to show employees that are 'active'; 2) created a query to display only 'active' employees 3) altered the code in Row Source for the multiselect...