Search results

Mmmm... very interesting.... Is there any way to adapt this so that if a user selects 5 out of 30 check boxes, these can be the selections for a report? For example, Set up 10 options that can be checked and become rows in a report and have another 3 checkboxes that can become the value? That...

Hi all, On my report I have a field called "Region" I am doing a sub total of this using the GroupFooter. I want the label of the text box to be the Region in question and then the text "subtotal". E.g. Asia Subtotal Europe Subtotal I tried the following: =Region & "Subtotal:" But it...

boblarson, do you have an example of this? It is exactly what I would like to do, but have no idea where to start... I have a large query which contains audit trail type data for staff members... I would like the user to be able to select which dates they want to be able to run a report...

all sorted (my quotes were wrong): SELECT Tbl_MAIN_Staff_Details.ID, Tbl_MAIN_Staff_Details.Last_Name, Tbl_MAIN_Staff_Details.First_Name FROM Tbl_MAIN_Staff_Details WHERE ((Tbl_MAIN_Staff_Details.Last_Name Like forms!test!txt_Last_Name & "*" And Tbl_MAIN_Staff_Details.First_Name Like...

Panic over, Incase anyone has a similar situation, code was: SELECT Tbl_MAIN_Staff_Details.ID, Tbl_MAIN_Staff_Details.Last_Name, Tbl_MAIN_Staff_Details.First_Name FROM Tbl_MAIN_Staff_Details WHERE ((Tbl_MAIN_Staff_Details.Last_Name Like forms!test!txt_Last_Name & "*" And...

Hello's This is a duplicate post as I couldn't work out how to move it from the "Forms" forum, apologies, but Im really stuck with this.... I have a form with 2 unbound text boxes. First Name (txt_First_Name) Last Name (txt_Last_Name) I have a combo box on the same form which I would like to...

Does anyone know how to move a post to another forum? Think this might fit better in the VBA one? Thanks, Mandy

The following code works: SELECT Tbl_MAIN_Staff_Details.ID, Tbl_MAIN_Staff_Details.Last_Name, Tbl_MAIN_Staff_Details.First_Name FROM Tbl_MAIN_Staff_Details WHERE ((Tbl_MAIN_Staff_Details.Last_Name Like forms!test!txt_Last_Name And Tbl_MAIN_Staff_Details.First_Name Like...

Hello's I have a form with 2 unbound text boxes. First Name (txt_First_Name) Last Name (txt_Last_Name) I have a combo box on the same form which I would like to be filtered by the values entered into the 2 unbound boxes. So : First Name: M Last Name: Jones Should populate the combo box...

Hi, I found that I needed to set.focus to the control, and then run the code I was trying to run. I thought it was a problem with the event I was using, but after readin the help files, I realised it was my code. Mandy

Thanks, Do you have a good website / link etc that explains the diff between all the different events on a forms properties? For example, I cant assign values using the "on_Open" event, and I cant assign my code to the "On_Current" event either.... I just wanted to read something so I could...

All sorted, I needed: If ctl.Name <> Forms!frmStaffDetails_ComboBox.ActiveControl.Name Then

Hi all, This code works fine in a private sub Dim ctl As Control If ctl.Name <> ActiveControl.Name Then when I put it in a public sub it doesn't work... How do I need to update the syntax of the code? Thanks, Mandy

Ken, Im intrigued.... A call procedure? I'll do anything to keep this code as short and maintainable as possible!

I updated the code to the following, hence I already use an if statement, Im not sure how to adapt to include your code (if ctl.name<>activecontrol.name then) If I could get the code to skip if the ctl = "Employee_Indicator" this would also work as I never need to disable that field... My idea...

I have this working great with the button, When I change it to be on the On_Change of a combobox that determines if they are all enabled, or all disabled, it will not allow me to change it to enabled = false. It says "you cant disable a control while it has focus" Is there any way to set the...

thats great stuff... thanks so much! Mandy

Hi all, This might be a double post, but no-one in the VBA forum seems to know... When opening a form, how do I set the value of all of the ComboBoxes and Text Boxes to be enabled = false (without having to individually name them all?) I will then enable the ones I want to enable based on...

Mmmm.... I think the only bit I need guidance on is: Is it possible to set all of the text boxes and combo boxes on a form to be enabled = false at the same time? Without having to list and name them all individually Then I can go through and enable the ones I want, when I want them :)...

Hi All, I have 2 fields which will determine which fields on a form are enabled. 1) [Employee Indicator] "Employee" or "Non employee 2) [Employee Status] "Active" or "Inactive" If the person is an "Employee" and "Inactive" then only 1 field should be enabled called [Inactive_Status] all...