Search results

Thanks CJ, I have changed these from Group to Where. Also thanks for the advice on the where clause as I haven't used it before so you explanation will assist when I am making future queries. Regards David :-)

Hi Paul & CJ, I have added the DueDate to the next column and have added the Where clause. This has given the exact result which I am looking for. Thank you both for your help. Regards David.

Hi Paul, yes the data is showing exactly what I need. However, only want to show the data for certain months EG: from 01-06-2015 to 31-07-2015. I dont want to show all records in the database. Hope this makes sense? Regards David.

Hi All, I am trying to create a Totals Query which returns a data set between two dates. So far I have managed to select the data I want (Please see attached screenshot). However, I only want to select records between a date range working on my field [DueDate]. If I add the due date field to the...

Hi JHB, I think I have resolved. I added the following parameters to the crosstab query: Parameter Data Type [Begin Date:] Date/Time [End Date:] Date/Time I then inserted the [DueDate] field into the query and added the following criteria: Between [Begin Date:] And [End...

Hi JHB, thanks for the code. I have tried it and it looks like it is working which is great and shows the results I am looking for (See Attached Screenshot). Appreciate your help. The only thing I have to resolve now is to set a criteria for the DueDate. I only want to find records between two...

I have two fields: 1) DueDate 2) JobType I want to create a query or report with Month&Year in the left hand row and JobType in the column header with a count of job types under the headers Example: PPM Electrical PPM HVAC PPM Fire Alarm Apr-2015 15...

Hi Spikepl, I just noticed the following line in your earlier post which said: throw out this line: On Error GoTo Err_Command214_Click I have done this and I now get the option to debug. The error message I now get is Run-Time Error 438 Object doesn't support this property or method. The line...

Hi Spikepl, I appreciate you taking the time to look at my question. You are correct I do not fully understand why the code is not working as I'm not that familiar with VBA and took the code from an old database. I am looking for an alternative piece of code that will do the same job on my new...

Hi Spikepl, it does not give the option to open the debug window as no line triggers the message (Usually the line at fault is highlighted in yellow in the debug window but not in this case?) It just displays the error message. If we ignore my code, do you know any code that I can use to get the...

I have two forms, both of which have a field called JobID (Form A is the primary Key and Form B is the linked field - Relationship: One to Many). Form A = FrmJobs Form B = FrmPurchaseOrders I have put a command button on Form A. When I click the button I need it to open Form B and then...

Problem solved I had the following in After Update: Private Sub Form_AfterUpdate() Forms![FrmQuotations].Requery End Sub Wakey Wakey Dave Collins :-)

When I add a record in the subform and then move to the next record whilst still in the subform, the main form jumps back to its first record? I then have to move back to the right record in the main form to update the next record in the subform. Is there anyway to fix this? I want to move to...

Hi Namliam, I am only storing the information in 1 x table but have 2 x fields which use that same information. SUBFORM - In the table for job updates, a new record is created each time an employee changes the job status. They select a value change from the ComboBox JobStatus which gets its...

I have a main form and a subform. Both forms have the field called JobID in common. Both forms have a field called JobStatus. Can anyone provide the easiest solution so that After I Update the field called JobStatus in the subform, it changes the field called JobStatus in the main form to...

Thanks RG, I did download the sample DB from PBaldy so will try to replicate on my DB. I didn't get much of a chance to try today as it was busy in the office. I'm aiming to get the DB working by the end of next week so hopefully it will be ready to roll. Thanks for everyone's assistance. Dave 🚴

Hi Libre, thanks for the coding. If I can't get RGs solution to work then I'll give yours a try. I don't have any programming experience but I'll give it a go. I'm trying to get a new DB in place as the old one I created years back has had its day. I'm nearly there with the new one so just...

Thanks RG, I will give this a try. Thanks for your help on this issue. Dave :)

Perhaps my original coding is incorrect. Is there any coding or macro that I can apply to a button to perform the same action that I am trying to achieve. Eg: Click a command button from Form "A" that opens Form "B" and gives the JobID in form "B" the same value as JobID in Form "A"? (Both...

It is a numeric field in both tables. Thanks for your help so far. I have left the office now so will continue to try and resolve tomorrow. Dave