Activity Stream

Colin, I'm pretty happy with my progress, but Faster Is Better. I hope the OP responds. If he needed more speed it's here in aces.

Hi Guys / Ladies Thanks for all the help and suggestions, The database is a gigantic one which is originally in a text file (of all terrible...

Added the suggested code, but the second form does not close normally. When I 'hard' close it (CLOSE ALL) it finally returns to the first form with...

Only way I know to force the zeros is to save the CROSSTAB as query object with column headers specified. Then the chart RowSource will be a SELECT...

Private Sub test01() Dim s$ s = CurrentProject.Name ' = "TestDB_v004.accdb" s = Mid(s, 9, 3) ' = "004" 'Debug.Print "Version...

You will need to define your fields and ensure that you have zeros when there is no other data. See specify column headings here...

I don't think what's needed here is an event so much as a property. You can define custom properties by either adding your own to the CurrentProject...

UPDATE SET Commodity = "Electrical " & Mid(,InStr(," ")+1) WHERE Commodity Like "Elec*";

Tim, Is this a home grown classification system or is it from some general commodity system? Hopefully any usage of these codes in your...

If you use the replace function be precise. if you have: Elec utility Elec. Appliances Electric Appliances Electr comps and do a replace...

No there is only one function in the entire Module - it is a call to an API to find out who the current user is - it has been in use for years and...

Access per se does not have any events that you can run, only events on forms/reports - but these won't run if you save a form from design view, and...

answer removed

Try an update query with the Replace() function.

@OP The behaviour you describe is nothing to do with the code I supplied. Check the properties such as Default value for your End Date field to...

A date value and a time value can be added to have a full date/time value that can be used in DateDiff() function to calculate elapsed time for any...

Hi! What i tried to explain was this: In my form, let's say I type in 12:00 in "Start time" field. The next field (in tab order) is the "End...

Hi No luck with converting to XLSX as the file is over the 1,000,000 lines Looks like I have to down the path of SQL Server. :(

Hi. The file has always been greater than 2GB. normally sits between 2.2GB and 2.8GB and it works with no issues on WIN7. We are just been forced...

?format(#12/8/2019 10:35:39 AM#,"mm/dd/yyyy") 12/08/2019

just use Date() instead of Now() ?

Table and field names in query object cannot be dynamic (well, CROSSTAB column headers are exception). Requires VBA and QueryDefs collection to...

The output destination is defaulting to acViewNormal which is direct to printer. If you want to view on screen then specify acViewPreview. And if you...

I don't find that link particularly useful for your situation. Either try writing your version (whether or not you actually attempt to run it) and...

Sure. Here's the context. For the past 19 years, the federal government has required certain entitles to file "reports" each year. The government...

Thanks again! I believe I am following the code in the example. The one thing I'm struggling with is what you mean by concatenate in this context,...

Hi Dave That's quite an impressive speed improvement In case you're not aware, you can measure elapsed time to millisecond precision using a number...