OK.
The code worked on my database because I am searching the equivalent of the text of the Article rather than a table of keywords. My text is only a few lines long for each record. Your situation is obviously much larger.
Anyway, I have worked out a method that should help you.
It requires a second Public Function to count the number of keywords to search for and combines that with the number of keywords found (using the...
kepston
Last Activity: Sep 30 '10, 01:11 PM
Joined: May 7 '07
Location:
-
Can you post a link to the other discussion for me please?...Leave a comment:
-
To step through your code you need to set a breakpoint - press F9 on a line of code (or Menu bar, Debug, Toggle Breakpoint. Or click in the vertical grey bar to the left of the code line), a brown spot will appear in the vertical grey bar and the line of code will be highlighted brown.
When the code is executed, it will run until the breakpoint is encountered.
From that point you can step through line by line, using F8 (other options...Leave a comment:
-
I have been doing something similar.
The code (quoted here) worked for me.
Are you separating your search keywords with commas?
Have you tried to debug the code yourself, using the 'step through' facility within VBA?...Leave a comment:
-
I'm glad you have a solution, anyway....Leave a comment:
-
Always glad to help....Leave a comment:
-
You will have to select specific fields e.g. customer and Max(calldate) and GROUP BY customer.
That should get you closer....Leave a comment:
-
Good Luck!
Is the report based on the same query as the subform?
We just need to get the same criteria for the report as on the subform.
(I know that sounds easy :))...Leave a comment:
-
You will need to use the Max() aggregate function on your date field, in the SELECT clause.
You may have to split into two queries....Leave a comment:
-
If I am understanding you correctly, try
[CODE=sql]SELECT tProspects.CLEC Number, CompanyName, calldate,callre sult
FROM tProspects INNER JOIN tContactslog ON tProspects.CLEC Number = tContactslog.CL ECNumber
WHERE callresult <>"not interested” AND calldate>=[Date From];[/CODE]
The [Date From] will prompt for a user input and then show all records from that date where an interest was shown.
Welcome...Leave a comment:
-
You can use a parameter query. Access will prompt for an unrecognised field name.
[CODE=sql]SELECT *
FROM tblJob
WHERE CompanyName Like [Prompt for beginning of company name] & '*';[/CODE]...Leave a comment:
-
Have you tried [CODE=vb] DoCmd.OpenRepor t stDocName, acPreview, , strWhere[/CODE]...Leave a comment:
-
Try opening the report with a filter/criteriaLeave a comment:
-
The maximum number of records is defined by the size and number of fields.
I have successfully linked several databases in the past, but never to the size you are describing.
I only hit the 2GB limit once, and that was because I was inserting pictures, which Access converted to bitmaps.
A database that is very active, lots of records adding and deleting, will also grow quickly. Regular compacting is often necessary.Leave a comment:
-
The usual methods to increase what you can print include:- Page setup - landscape
- Page setup - reduce margins
- Text box Format - reduce font size
- Report Wizard - Adjust field width so all fields fit on a page
- Reduce space between fields
- Reduce field widths to show only data and no space
- Change number format
Alternatively, consider changing report format
StoreNo, Store Name, ...
P1,P2,P3,....
...Leave a comment:
-
Create your forms (AcReadonly) and reports as required.
Remove standard toolbars.
Backup your development database.
Create a .mde from your database and distribute.Leave a comment:
-
You could use a message box, to ask the user if the invoice printed correctly, before updating the invoice counter.Leave a comment:
-
Choosing an actual point makes sense.
In which case, do you want the point before, or after, or both when midway between known points?
qryNearestTime:
[CODE=sql]SELECT Missing.Hour AS MHour, Min(Abs([GPS].[Hour]-[mHour])) AS NearestTimeDiff ,
[mhour]-[nearestTimeDiff] AS Bef, [mhour]+[nearestTimeDiff] AS Aft
FROM GPS, Missing
GROUP BY Missing.Hour;
[/CODE]
qryNearestPoint :[CODE=sql]SELECT...Leave a comment:
-
I think you have misunderstood interpolation.
If we look at finding position at 10:10, then position at 10:11 would be better than at 10:07, using nearest known position.
Position at 10:11 would also be better than the average, which in this case would be position at 10:09. i.e. 2 minutes away from known!
Interpolation works out how far between start and end, required point is, and calculates for that position.
10:11-10:07...Leave a comment:
-
It's amazing what another pair of eyes can see!
Glad it's working.Leave a comment:
No activity results to display
Leave a comment: