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

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

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

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 All, Thanks in advance for the help. I'm starting a new business and have developed (if you can call Access Development) an Access Database in the 2010 edition. I am a novice and need to know how I am going to be able to the following; 1. Allow multiple users access to the database...

Hi Guys, Hope your all well. I've got a Request table in my database which has an ActionTime field. This field contains the time I want a reminder box to appear and say 'Call XX'. I think it's something along the lines of an timer pointing at the field with an event when the time occurs...

Hi Guys, Thanks in advance for your help with this. I've modified some code online and am by no means a programmer, but dabbled in the attempt. I am getting a parameter value error, which from my research means their is a unassigned null value. I have input some code for the only var lookup...

Hi Guys, Hoping you can help. I'd like to have a bit of code that will email all overdue requests, that have been correspondingly ticked by the user. This emails the email included in the email field in the requests table. I'd like the email to included the Request Id, Open Date, Expected...

Hi All, I have a bound form which is has bound cells and combos to the required fields. I have an 'Add Record' button and a 'Clear Fields' button. Underneath this I have an unbound subform, showing all requests; by unbound I mean I haven't related anything when I placed the subform of the...

Hi Guys, I'm a bit stuck. I have two combo boxes one is called cmbRequestType and the other cmbRequestTo. RequestTo has an After Update code that sources the data specific to the selection made in cmbRequesType. I want to be able to store the completed form at the end of the users journey...

Hi All, I'm hoping you could help me here. I want to save selected areas on a form into the relevant fields in a table and am clueless how to after creating row sources not related to the form I require the information store in i.e. one dependent combo box fulling event names into it when...

Hi Guys, I'm really new to this so all your help and comments are really appreciated, thanks in advanced! I had spent 12 hours doing this:banghead: earlier today but to my satisfaction I've figured out one part of the puzzle; how to create 1 cascading combo box. I have a Request form which has...