Search results

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

Will this do the job Bob? Const conDateFormat = "\#mm\/dd\/yyyy\#"

Dates out of wack Hi Again Bob, It would seem that the dates aren't working as i would like. I have neclosed the code for the on click with the commented error trapping. The report as shown in the gif is for the month of June but shows all the jobs for May. Private Sub cmSIOK_Click()...

Hi Bob, It does appear to be working, i will do some more checking on it when i put in some more data. I have a head full of flu so i'm probably seeing things..... I can't thank you enough for your patience Bob. Thank you again.

That section ok. Hi Bob, Thanks for looking over that. The one you are looking at seems to be working ok, i will do some further testing when i get some more data in it. The error is in the frmInstSelJob date range selector. Thanks again. Paul1707

Bob could you have a look at this and let me know if it's right for a date range after a lastname selection. It is returning jobs outside the date range specified. DoCmd.OpenReport "rptAllJobs", acViewPreview, , "[InstLastName]='" & Me.Combo6 & "' And [SchedInstallDate] Between #" & Me.txtFrom...