Search results

I was joking that GHudson's post should be on it cos it's so good!

It should be on the Microsoft KnowledgeBase, over 3 years and still going strong on all my databases :-) GHudson......R E S P E C T

Hi, I have a piece of code which is something like that below. I have 12 command buttons (Button1, Button2 etc) which will use this same code, with 2 exceptions. The 'FollowOnCreated1' and 'Outstanding Tasks1' fieldnames will vary depending on the command button that's pressed. In other words...

Finally got it to work. Here it is: Private Sub SpellcheckComments_Click() Dim ctl As Control For Each ctl In Forms!JobCards!Tab2.Controls 'Comment: Go to Tab 2 'Comment: Loop through all textboxes except the two below. Also ignore blank fields If (ctl.ControlType =...

Because a returned job card can have up to 15 comments. Each of these comments is then assigned to a different person and has a corresponding status box. This allows them to report by any conbination. Suppose I could put it in the AfterUpdate event of each textbox. Just thought there might a...

I have 15 fields beginning with the word Comment. (i.e. comment, comment1, comment2 etc) What Im trying to do is create a spellcheck command button that will only check these fields and only on the current record. I've managed to find this piece of code to do the actual check: With...

Good call Rich, worked well when hooked up with another query. Thanks again

Ive got a query (SearchCriteria) whose data looks like this: Call ID....Problem Source............Problem Source2 15366.... Complaint.................... 15224....Collateral Order............Complaint 15734....Delivery....................... 15733....Delivery......................Order Taken...

Jon K youre a legend, your code works brilliantly. Thanks so much

I have a query which is based on another (SearchCriteria2)...the SQL is as below: SELECT SearchCriteria2.[Problem Source], Sum(SearchCriteria2.[CountOfProblem Source]) AS [SumOfCountOfProblem Source] FROM SearchCriteria2 GROUP BY SearchCriteria2.[Problem Source]; This gives an output like...

OK after LOTS of experimenting here's what seems to be working. Does this make sense?! SELECT Log2000.[Call ID], Customers.ID FROM Customers INNER JOIN Log2000 ON Customers.CustomerNumber = Log2000.Customer WHERE ((([Customers].[ID]=[Forms]![SearchMarkets]![Market] Or...

Thanks for your suggestions, tried both but still the same result. Head-wrecking stuff!

I have a query which is based on 2 tables (Log2000 & Customers) and criteria is entered by the user via a form called 'SearchMarkets'. In concept, if the user chooses a 'Market' on this form, the query uses that value, otherwise it runs everything. My SQL looks like this: SELECT Log2000.[Call...

Yes its the two added together

Hi all, I have a 'StartDate' field which must always fall on a Monday and is based on a previous date + interval. If this StartDate falls on a day of the week other than Monday, I need to add the appropriate number of days to bring it to the following Monday. This can be done using 6 Update...

Thanks Colin but not clear how this would work though. Do I need a seperate update query as well?

Hi, I have around 50 jobs on a table. These have a 'start date' of various dates in a year. A field called 'complete' indicates whether a job has been closed off or not and a field called 'frequency' determines how often the jobs recurr (in days). I need a query (which I'll run every night)...

Hi, can someone please give me some inspiration on this? I need a piece of VBA that will generate a table of all weekend dates for a particular calendar year. Thanks

Works great Pat, thanks a lot

Hi, not sure if this is possible or the most economical approach but here goes: I have a lookup table (tblHolidays) with a list of holiday dates (fieldname "HolidayDate") in it. I need an update query that can check all "StartDate" values on a table called "tblMasterLog" and where this date...