Search results

Doh!!!!! That's it, Thanks Legend. To have the Delivery due sort activate when the form opens, do I call that function in the open form event?

Yep, button values match Case # Values. Yep Field names are correct too. Here is Form with Delivery Due Selected, and its not sorted. (as an example) Here is Data on Delivery Due Here is Code (I reduced it down to one sort to see where problem is) Private Sub FrameSortOptions_Click()...

Cool, Things are flashing now so I think nearly there. It doesn't appear to know which option button is which, so its not sorting or its sorting incorrectly. Do I need to state what each Case is at the start of the code? thanks

G'day mate, Yes I know what value each one is, I'm not sure how to add that into my code. Can you assist there? thanks

Hi, I have a Form that I would like to be able to sort by means of an option group. I have tried a few different versions of code, but I am out of my depth I think, :) Form Looks like this One of the select case code I have tried is Private Sub FrameSortOptions_Click() Select Case...

Awesome mate, Thank you, very informative.

Thank you, Looks like that is working.

Thanks for the additional information. What/How should I change this? thanks

Hello, I have an EmployeeT and a JobInfoT. The JobInfoT is holding the ID number on multiple employees and is showing their ID instead of the Employee name. If I relate one of the ID job JobInfoT to the EmployeeT then I can get the correct result in my form. However If I have more than one...

Hello, Thank you for the suggestion, but still no luck.

Just an Update... I also tried to put the query into the back end section of the database and change the connection to this location. Unfortunately same error.

Hello everyone, Using Excel and Access 2010.. I have created a connection from Excel into and Access Query using the "from other sources\from Microsoft query" option. (Images ConnectionType and ConnectionType02) This then pulls in data from an access database query and Excel uses this data to...

I think I solved it with this.

This is for entering a new job into my schedule. I run this query to see what other jobs are being tech detailed on the corresponding date. So its like I get the dispatch due date for job, then Look at the Tech detail due date for that job im trying to enter, then query that date to report on...

Hello, Ill do my best to explain what i am trying to achieve. I have a query which looks at an entered date being the date of Dispatch for several types of jobs. The types of jobs then have dates that a certain process has to be done by to achieve the dispatch date. I want to be able to count...

Hello, I have a basic report which shows when a client is to be followed up on by a date. It shows when the last contact was and some notes of that contact. The query has a filter 'dates from' and 'dates to' based on the follow up date. See screen shot of query; Query01.jpg Works fine and shows...

Hello, (access 2010) I have a text box in a report (see screen shot) Control Source as follows as per screenshot: Total Jobs:=DCount("jobid","qryFSales") Total Invoice Amount:=Sum([invoice_amount]) Avg Invoice Amount:=Sum([invoice_amount])/[txtTotalJobs] RTA...

Solved the date issue 4/ with =[Forms]![reports_list]![txtTo] This is most likely all basic stuff, but have to start somewhere..

I have made some changes and I think i have things working. Can someone clarify please. 2/ I want to breakdown the invoice amount of RTA Jobs and Assembled Jobs. RTA Jobs: =Sum(IIf([Assembled]=0,[invoice_amount],0)) Assembled Jobs: =Sum(IIf([Assembled]=-1,[invoice_amount],0)) what i am still...

Thanks Trevor, Is this to count the jobs that are checked? If so what do I change it to for jobs that are NOT checked? Is this correct? =Count(IIf(Nz([Assembled],0)=0,1,Null)) Yes is -1 and No is 0?? Are you able to assist with any of the other issues? Appreciate your input, thank you. Jason.