Recent content by paul1707

Hi Neil, Just as you suspected, the suburb was from the jobs table and not the suburb table, added the suburb table to the query and pointed the suburb to the suburb table and all is good! It works as it should and is reporting correctly. Thanks Neil and Paul

Yes i have checked the result in the report and it is the same. I grouped the report by InstLastName and SchedInstallDate and set the sort order on the date and the suburb. The Date is correct but the Suburb is not. Thanks

Hi All, I hope you are all well. I am trying to get a query to sort on 3 variables. The first two are sorting correctly but the third isn't. The query is run from a table and the data is only used for a report. I have enclosed the sql, am i asking to much? (Still a little new to access)...

Hi, i am just going through this at the moment so i will share what i have so far. Firstly you need the addon for the ability to save/send in pdf format. Do a search in the msdn and you will find it. It is free. Install that. Next you create your button and you can create either a macro...

Hi All, I was just wondering if someone could cast their eye over this and tell me where i have gone wrong. I am using a filter form to select a user and a date for a report. I have it working with the DoCmd.OpenReport (the commented line) but are having trouble converting it to the...

Hi Chris, Thanks for that, i solved it a little earlier with: Private Sub Command3_Click() If DCount("*", "qryBuilderJobsAlloc") > 0 Then DoCmd.OpenForm "frmBuilderJobsAlloc", windowmode:=acDialog Exit Sub Else MsgBox "No Records To Display" End If End Sub This works a treat as i'm sure...

Thanks for that, what i am trying to achieve is to have a command button which will open a form based on a query. If the query returns no records, the open form section can be cancelled out and a msg sent to the user stating nothing to do. I guess me question is: how do i check the query for...

Hi All, Can someone please tell me if this is the correct syntax for testing a query for records? if forms!frmName.recordsetclone.eof then Thank for your time.

Hi All, I have a form which is used to display the results of a filtered query. The query displays jobs where an installer hasn't been allocated (Filter on IsNull) When i open the form frmAllocateJobs which i have set to allow additions to "no", if a user selects an installer from the...

Hi CodeMaster, This code works fine, i was hoping to add the cbo box to the code to enable a form filter for a report. I worked out another way of doing it. Yes there were #'s around the date. Thanks again

Thanks Bob, I changed the date format from "#mm/dd/yyyy#" to "\#mm\/dd\/yyyy\#" and it works. I am now going to lookup what the "\" means in a date reference. Thank you again for your help Bob, i am learning a lot from you.

Thanks again Bob, The line: Const conDateFormat As String = "#mm/dd/yyyy#" If i use it in this context i get a 3075 syntax error (missing operator) in the DoCmd. line. If i use the original line - Const conDateFormat = "\#mm\/dd\/yyyy\#" i get no error and it seems to be correct and...

Thanks again Bob, The code returns a compile error/syntax error. I have double checked it and its the same. Thank you

Hi All, I have been wrestling with this for a while now and time constraints are pushing me to a resolution. I have a form filter for a report that has a cboInstaller and a txtStartDate and txtEndDate. I am trying to shape the following code but keep getting syntax error missing operator...

Hi All, I have a form frmInstSelJob which i would like to firstly select an option from a cbo and then use the code below to do the date range for the report. Could someone please point me in the right direction, i have been looking at this for the last 6 hours and can't make sense of it...