Search results

Do you have an example of how this works, also would this change records if you were just navigating through?

Hi All, I've attached my DB in a hope to make things clearer. I want the "Technician" & "Date" Field's to remember the last value when a new record is started. i.e If John has 20 jobs to input he doesn't need to set his name and date every time? The reason for this database is to improve...

Thanks again Paul, sorted.

Sorry, to clarify, I now need to run a report that contains records for all three status's . So I need to have the one report show all open calls regardless of date and the same with pending but then I only want the show closed calls from a specific range of dates

Sorry I'm confused as to how to do this. In theory I no longer require the combo box option I just need to be able to display. me.status = "Open/Reopened" All calls me.status = "Pending" All calls me.status = "Closed" Either between specific dates...

I have a field set to Memo and when I try and export my report to excel it only copies a set amount of text. Is there a way to export everything within the field?

Hi All I need to run a report containing several rules. I need to have all records with the field as "Open/Reopened" and "Pending" displayed in my report and the I want to select the date of which "Closed" records to display. I currently have a form which allows me to search by date and...

I just get an error that it's an invalid syntax

Thank you but this doesn't include the same day. It will only displays records with tomorrows date and onwards.

Hi All I know how to create a filter for past dates, I also know how to do one for Future dates but how on earth do you do it for todays date as well. I.e I only want to show records for today and the future, not the past Everytime I try and just cancel everything out and no records show. Thanks

relooked at this and if you start with 02/01/2013 that wouldn't work Sorry Paul I was naughty and assumed 01/01/2013 was the same

Ahhhh Just seen the issue! If I select between 01/01/2013 & 23/01/2013 It will return empty but I start from the previous month i.e 31/12/2012 until 23/01/2013 it will return the correct data. Do you know why this is happening? :D

I did and didn't find any error Here is the file Thank you

Ok so I've been up all night trying to sort this and I only have 3hrs to rectify it but I have now managed to lose the "Enter Parameter Value" popup for "DateReceived" field but it still won't display any records within the report. I'm really desperate now and will even consider trying a...

That's nearly got it but it's still not liking the "DateRaised" strSQL = "SELECT FaultTable.* FROM FaultTable WHERE ((Status = '" & StatusCmbBox & "') AND (DateRaised BETWEEN #" & txtDateFrom & "# AND #" & txtDateUntil & "#))" I can't for the life of me figure it out...

SELECT Status FROM FaultTable WHERE ((Status = 'Open/Reopened') AND (DateRaised BETWEEN #01/01/2013# AND #31/01/2013#)) The source table is called FaultTable Ahhh where you said "theFields" should that contain every field in the report? there's about ten, if so how do i list them all i.e. do...

Sorry Paul, I'm struggling to even get that to work tonight. I followed the instructions but still couldn't achieve success

I can't get that to work either but I have managed to stop it printing, I keep getting a pop up box that reads "Enter Parameter Value"

Not sure what I've done wrong but it prints the report each time I click GenQuery and then it still prints it with records outside the parameters set

Regarding the first issue, I managed to achieve showing all status's for the previous month but I struggled to find the code to write at simply in SQL view so that I could specify to always show "Open" calls The second question I can't get my head around how to achieve this to start with, do...