Recent content by WillJ

Hi Guys, I have a query that records a status update, and the date it was made by an employee etc. The table has a secondary key related to ... lets say a project table. E.g. Status Id; EmployeeID;ProjectsID;Status;Date I want to calculate the average amount of days it takes for a status...

Hi Guys, I'm getting a Name(hash) error when I try to set up a control source to a calculted query. I'd like to just be able to create a form and the write in the control source as it look neater (and it the right way to do it) then subforming a query for one text box. I presently have tried in...

:mad: Hi guys, For some reason I open the database and today when I click on a form it dosne't open. The bottom left hand action ribbon states "calculating", no error comes up and I can only open the form in Design view and then go through to the form in form view. When I click the button on...

Hi Baldy, Back again, by the way thank you for all your help and making your site available to everyone, it's straight forward and has really helped me develop (no pun intended); I'm trying to get a Pdf to export based on the Booing form ID as you can see below the argument has the Where...

Sorry, thanks Baldy, if I need any more help I'll ask. Cheers :)

Apart from that would you expect the above code to pull up the related BookingFormId ... ?

It also goes straight to printing ... No filters or anything set.

This is from the Booking Form. It's a button on click event; Private Sub btnTestPreviewReport_Click() strBID = Me.BookingFormID DoCmd.OpenReport "rptCBF", acViewNormal, , strBID, acWindowNormal End Sub This is the OnLoad statements I have in the rptCBF; Private Sub Report_Load() If Not...

Hi Guys & Girls, Hoping you can help me out here, I'm having a nightmare! I have a booking sequence. Sales representatives take an order on a booking form and then then click a button to draw up the related report. 1)The form is showing all Booking forms, not the specific one just taken. Do...

Hi There, I've come up against a bit of a problem. I have a sales form. The sales form has many Call, Meetings and Emails linked to each sales record. I want to total all the number of calls, meeting and email records related to the sales record to give a total- Touches. I've created 3...

Poorly all be it!

Hi pr2-eugin; What I am trying to do is pass an ID field to another field in another form. I have used an OpenArgs statement which works fine when I only transfer one or more values from the same form. What I am want to be able to do is allow a user who clicks from the Sales form on the call...

Hi Guys & Girls,:banghead: Thanks in advance for your help. I presently have this problem. I have a reminders form that Opens from a variety of different forms, for arguments sake let's say Production and Meeting both have a button with an OnClick events then leads to the following line of...

You are a star : ). Thanks, works a treat now!

Hi All, Thanks inf advance for the help with this, I've spent a fair bit of time playing around with it but nothing seems to be working. I am trying to send a report in PDF format using the SendObject command, this will execute when a check box is ticked. The Error I get is; 'Compile error...