Search results

I have a user form and want a label and text box to appear subject to the answer of a combo box so if the answer selected in the combo box is "Other" a label and text box will appear for the user to add in additional information i found code online but it isn't working: Private Sub...

I need to work out sick pay entitlement which is done based on length of service I have a field called "Start Date" I want to add a field called "Sick Pay Entitlement" that will auto-populate subject to "Start Date" eg. 2 years or less = 6 Weeks 2-5 years = 13 Weeks 5 years + = 26 Weeks What...

Hi all I have a database containing staff information - eg. name, dept, shift pattern etc I am creating a new database to record absence I want to lift some of the staff information from the staff database and put it into the absence database to save re-keying. ideally, when I update the...

I have a report which contains a "fieldID" I also have a form which contains the same "fieldID" I had set an openform macro on the report using where condition [fieldID]=[Reports]![rptName]![fieldID] to open the form at the corresponding record it worked perfectly then i mistakenly...

I'm trying to open a form at a specific record based on the results of a query. i have the query set up to find the records based on 2 drop down lists on another form the query runs correctly on its own i have tried to add a macro to a button to open the form at the record identified by the...

i need to pull data for "yesterday" but excluding weekends i found the following solution on another thread: Format(IIf(Weekday(Date())=2,DateAdd("d",-3,Date()),DateAdd("d",-1,Date())),"mm/dd/yyyy") it worked perfectly at first however... it only seems to work in the second half of the...

Hi, I have a split database which i set up for other users - so i disabled "display navigation pane" and "allow full menus" and have a modal switchboard. The database contains sensitive info so i added a password. Because of this, "shift/open" no longer works to access the hidden objects and...