Search results

Perfect, thanks for your help Antony

Thanks for coming back to me, but unfortuately i'm not that skilled in VBA, hence why I came to ask here. Thanks Antony

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

Thanks for your help, much appreciated!

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

Hello again!, I want to add another control element to my code above which has manager level so only certain users can access a specific menu. I have in the table an extra column which contains either User or Manager. I need to add a D lookup in there and a messsgae to say if anyone other than...

Runtime error 3075 syntax error in string '[username=2]' Hi, I am trying to make a username and password form that logs you onto my database. I have a small form with an unbound combo box that you can select username and then underneath another text box to type a password. Underneath that I...

Reference text box from form to a query Hi, This seems pretty easy and have done it in the past, but i'm trying to reference a text box on a form in a normal query. The code I have is [Forms]![ProjectdetailsT]![Text154]. I just keep getting an "enter parameter value" box when I try to run my...

Hi, Please find attached DB Regards Antony

Re: Append records from Subform http://www.mediafire.com/?233yarazau7as4b Hi, ok. Here is a copy of my DB above. If you look at the QuoteDetailT form you will see a button at the top of the page that says "Create Job". This button runs an append query for the current record in the form, and...

Ok let me try and explain. I have a quote table that Contains customer info. I have a subcontractor table. I have a materials table and a labour table. All of Which are linked in a relationship via the quote ref and are part Of a main form. I have a button that runs an append Query that takes...

Hi, thanks for replying. I have an append query That appends records from a sub form. The problem I have is it doesn't append all the records. It only appends the First record to the destination table, and I don't know why?. Any suggestions? Thanks

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]!

Print record as report problem Thanks for all your help much appreciated. I now have a new problem I need help with if you could. I have this code: Private Sub Command52_Click() Dim strReportName As String Dim strCriteria As String strReportName = "QuoteDetailsT1" strCriteria = "

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