Search results

I have a report in my database which uses a query as the record source. The query has a parameter called [Manager Initials] - when the user types in the manager's initials the report runs and shows the details specific for that manager. I would like to create a form (or most likely set up a...

Many thanks DBGuy!

I've figured it out - I set the validation rule on the checkbox as follows: Not IsNull([ActualBilledDate]) and then entered a message in the Validation Text property. Seems to work perfectly! Thanks for your help!

Nope conditional formatting doesn't work on checkboxes unfortunaely :( I'll look into what a validation rule is.

Is it possible to use conditional formatting on a checkbox? Ideally the checkbox would be visible at all times, but it wouldn't let you check the box unless the date field has been filled in.

I have a checkbox on a form called 'Close Job'. I would like to prevent this checkbox from being checked/ticked unless a date has been entered in the 'Actual Billed Date' field which is also on the report. Can this be done? The icing on the cake would be for the form to display a popup...

Thanks Minty - I went with your second option above. Works perfectly.

Thanks Minty - I think I follow. On a double click of the Yes box when it opens the budget form, how do I get it so that it opens the budget form containing the budget details specific to that job?

Basically the View Budget button currently shows for each record. If you click on the button for a row where the 'Has Budget' column shows a 'Yes' it takes you to the budget form for that record. If you click on the button for a record where there is a 'No' in the 'Has Budget' column it takes...

I came across this site which seems to describe the same thing but I couldn't get it to work with my form: https://bytes.com/topic/access/answers/879744-hide-command-button-if-field-null What would the way be to achieve this with text boxes so that it opens the appropriate form when clicked on?

I have a button on a form which is configured to display a separate form to view budget details when it is clicked on: This works well however I only want the button to be visible if there is a 'Yes' in the 'Has Budget?' field on the form. The name of the button is ViewBudget and the control...

I've figured it out. I was picking the Expression option for the After Update action on the combo box :o. Went back in and used your code via the Code Builder option instead and this works a treat.:cool: On to the next stage now - I'll no doubt have a few more queries! Thanks again for...

I get where you're coming from - so after selecting the staff member from the combo box the After Update property would tell Access to look up the rate from the appropriate column and then place it in the BudgetRate field on both the form and on tblBudgetStaff? I changed the Control Source of...

On the new budget subform, when you select a staff member from the StaffSelect combo, this automatically populates the StaffID field on tblBudgetStaff. When I added the combo box to the form I configured it via the wizard to add the StaffID number to the StaffID field on tblBudgetStaff. This...

The hourly rate is already part of the combo data/rowsource - the BudgetRate field on the form recognises the value. I just can't work out how to get the value to populate the corresponding BudgetRate field on tblBudgetStaff. isladogs mentioned about using an update query or SQL statement...

Would an update query or SQL statement be able to add the staff member's hourly rate to the appropriate field on tblBudgetStaff, given that the new row on tblBudgetStaff wouldn't exist at that point (as the record will not have been saved)? Sorry this is my first go at creating an Access...

I did think of that, however from time to time staff hourly rates change and we need to record the rate that it was when the budget was set up.

Ok here we go... The StaffSelect combo box is linked to the StaffID field on tblBudgetStaff and this gets populated in the table as expected. The BudgetRate field on the form gets populated with the staff member's hourly rate after they are selected from the StaffSelect dropdown. This is...

Things are going pretty well. I've got the sub-form in place and linked to the parent form and everything seems to be doing what it should. There's just one problem with the sub-form: the BudgetRate field on the form gets automatically populated with the hourly rate of the staff member, which...

I've done that and it seems to work great. If I manually enter the corresponding JobID (I will need to change this to a lookup to make it easier for users) and then start adding StaffID's, BudgetRates etc. on as many rows as required, the BudgetID field from the master form automatically...