Search results

Hi, Please can someone help me where i'm going wrong with the code below. I'm trying to output a report to PDF from a form and save it to the current windows logged on users profile in Teams, but I keep getting a runtime 2501 error the outputto action was cancelled. Thanks in advance Private...

Hi, I have created a form from a crosstab query which is a 52 week planeer. The weeks are displayed in the column titles Week1, 2 , 3 and so on. I need to highlight the current week of the year so that a user knows exactly what week he/she is working on. Anybody know thwe solution. without the...

hi, i'm trying to do a nested iif statement on a query. I have 2 dates target start and completion date, I also have a Status column. by default the status should be "Due" unless completion date is blank but has passed the target date then it should be "Overdue". If a date has been entered into...

Hi, I have an append query which pulls records from a subform within a main form. Only trouble is it only pulls the first record. How do I pull all records?. Really stuck on this. Hope someone can help. In my criteria box my expression is [forms]!

Hi all, hope someone can help. I have a form which contains various info. What i'm interested in is I have a button called (Create Job), when pressed displays a message box yes/no then depending which option you choose (Yes) runs a query based on that form. What I have on the current form is a...