Search results

Thanks for the response. I've been out of town for a week, thinking about this on and off. I think for now, I'll let the query calc the trade month. If trades are always entered in a form, I'd calc the month upon data entry and store it. But we will be imported from excel directly into the...

Thank you so much. After 40-50 hours working on this, alone, I got to the point where syntax (if this the right word)was half my problem. I followed yours and I was able to complete. If you would be so kind... when I got it working, my queries go from <1 second to 14 seconds, on a 1.6GHz pc...

I am trying to be able to group columnar results by accounting month or by calendar month in reports/queries. User gets popup form and clicks on start and end month, as well as 'Accounting' or 'Calendar'. The trade date on each record is compared to the underlying calendar table of the...

I have 2 combo boxes. Ater an entry is made in the first, the second requeries and displays relevent choices. This works on PC @ work, but when I e-mail it home to use, the second box display does not show the entry when I go in to change or view data, yet the table was updated correctly. Any...

Thank you so much. I tried Docmd.requery in several places, unsuccessfully, thinking I had to refresh the data. As a beginner, I still don't know the difference between a Docmd.requery and putting a "combobox.rowsource =........" in Form_Current. I'm afraid I'll waste another 5-10 hours...

6 hours spent. Doing something dumb. Pulling my hair out. Any ideas? TblClients contains pkClientID TblAccounts contains pkAccountID TblClients has 1-to-many relat. with TblAccounts This part works: In Add mode, client opens frmOrders, picks a client (say TST) from list displayed in...

Pat, many thanks. Between these articles I'm sure I'll be able to get a solution. Brian

I new at this, trying to keep writing code to a minimum. I need to be able to generate queries and reports based on an accounting month (ie the month ends 3 business days before the last business day, assuming no holidays) in addition to queries/reports based on calendar month. I created a...