Hi,
Thanks for your response, here's the query [qryEnterCosts]
SELECT qryJobs.JobID, qryJobs.AdHocJo b, qryJobs.JobNumb er, qryJobs.Country , qryJobs.Destina tion, qryJobs.DelDest ID, qryJobs.COMPANY , qryJobs.Supplie rID, qryJobs.Supplie rName, qryJobs.JobType Name, qryJobs.FullPro dCode, qryJobs.QtyCopi es, qryJobs.[Total Weight], tblSupplierInvo ices.InvoiceNum ber, tblSupplierInvo ices.InvoiceAmo unt, qryJobs.SE_Coll ectionCharge, qryJobs.SE_PPCo st,...
Neil Chinneck
Last Activity: Aug 31 '10, 12:19 AM
Joined: Jul 11 '10
Location:
-
Open a query based on filtered form
Hi everyone,
I'm looking for some help please. I have a continuous form, with several fields which can be filtered using combo boxes. Once the user has filtered the form, I want them to enter values into a series of text boxes and then use these values to update the filtered records, and only the filtered records.
I have an update query, but I'm struggling to get the query to match up to the filtered form i.e. show the... -
Thanks very much for the reply; it seems like an odd thing for Access to do, but I guess I'll have to live with it.
ThanksLeave a comment:
-
Just to update:
If I open the form and filter on a date (16/09/2010) from the PackingDate field manually, then look at the filter, it looks like this:
((qryEnterCosts .PackingDate=#9/16/2010#))
So I could probably get around it by switching the day/month around in my code, but I do not see why it should be treating the date like this when it filters?
Thanks
NeilLeave a comment:
-
Date problem: day/month getting switched on filter
Hi everyone,
I have a weird problem, and I cannot work out what's going on.
I have a continuous form (frmEnterCosts) based on a query (qryEnterCosts) . I have series of unbound combo boxes to filter various fields on this form, one of which (cboFilterPacki ngDate) filters the field 'PackingDate', which is a Date field.
There is a command button which takes the contents of each combo box to build the filter... -
Jim,
Thanks for the suggestion, but that's pretty much what I'm doing at the moment, except that I'm using transparency, and a text box behind the row fields to do the highlighting, rather than conditional formatting. My issue is the actual date that would go in the txtPackDate (in your example) box. This needs to be not the lowest available date (as this might be a date in the past) but the lowest date after today's date i.e. the next...Leave a comment:
-
How to select the next upcoming date from a date field
Hello everyone, this is my first post.
I have a continuous form with several fields displayed, one of which is called 'PackingDate'. What I want to do his highlight the records with the next upcoming packing date.
So far, I've got to the stage where I can highlight those records with the earliest date by adapting this bit of code (http://www.tek-tips.com/faqs.cfm?fid=18 04) and using the Min([PackingDate]) as the reference,...
No activity results to display
Leave a comment: