Search results

arnelgp - no warning or option to allow!

Gasman - this gives me a message "The macros in this project are disabled...." so i think my last post is correct, but i can't change the settings as they are greyed out. i'm guessing this has been set by our IT dept but something has changed since friday! i'll enquire with them... thanks

i'm wondering if its my macro settings.. the macro security settings are greyed out. but then i have other working macros...? UPDATE - the macros that were working on friday have now stopped working!?

thanks for the quick responses! arnelgp - this isn't doing anything missinglinq - still not working and no msgbox pops up - this is leading me to think i'm missing something really basic! also not sure if relevant but the full event list is not showing - so "On Current" isn't showing as an...

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...

PS. I changed it to months using "mm"

Thanks Minty - that makes sense but i'm getting a #Func! result!

Thanks everyone. I think on reflection i might just add the absence stuff into the headcount database and make it more of a general staff database.

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...

I should clarify - the apend query works for adding new records but doesn't update existing records or remove deleted records

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'll give that a try thanks for your help, much appreciated!

Yeah it only started working again today (pulling in 13th) i have "Format(IIf(Weekday(Date())=2,DateAdd("d",-3,Date()),DateAdd("d",-1,Date())),"mm/dd/yyyy")" in the criteria section of a query under "Date Completed" field thanks Dani

Thanks for the response Minty I'm working on a national company system so don't have access to update my regional settings but assume they will be set to UK. Not sure from link what else i can do to resolve? many thanks

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...

i used this solution: Format(IIF(Weekday(date())=2,DateAdd("d",-3,Date()),DateAdd("d",-1,Date())), "mm/dd/yyyy") in my own database after searching for the same issue as OP it worked perfectly for the first couple of weeks and then one day just stopped working!? i thought at first it might...

Hi CJ Thanks for your reply. Fortunately i'm the only one in the office that really knows how to use Access (albeit have never used the F11 shortcut before..:banghead:). So my reason for hiding menus is more just for aesthetics and usability. Noted for future though, every day is a school...

Perfect, problem solved!! Thanks for the quick and helpful response