Search results

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

Ok, I take that back. I've tried placing the code on various events, enter, exit, before Up, after up etc ... but they all seem to allow me to input a name incorrectly and the error box only occurs when editing the now duplicate input record. The code is below, I've adjusted it for my purposes...

Hey Hth, I started writing a long winded reply becuase there was an error, however it is now resovled! Thank you very much for all your help. Could you explain to me why you've used the OrgId in the string link criteria? Thanks :)!

Hi All, Hope every one is well and thank you muchly in advanced for your help. I'm entering company information into my form and I want to write some validation that searches my company name field in my company table and does not all the user to enter the same name twice. The company name is a...

Hi, Yep that answers my query perfectly, thanks. And, sorry, didn't mean to call you JS, JD :p.

Another quick question JS. If I want to ensure that multiple users can use the database, how do I go about securing the integrity of the data, i.e. if one user add data or changes data that the other user will then see the updated version ... is this automatic?