Replies

Thanks Ted

I did set the correct time upon booting the pc up and that’s the problem because doing that cleared the whole browser history.

I’ve tried Undo changes to my computer with System Restore but it still doesn’t get the browswer history back.

Hi Willie,
Can you post the code of the LinkTables procedure? Interested to see how you go about reading the ini file and check all linked tables connection strings – and reconnect if necessary.
What’s the url of the Puget Sound Microsoft Access User Group?

Hi Mark, can you please explain the procedure(s) you use to store the path to the backend in the registry?

Thank you Hans

1. Literal dates in VBA use US date format m/d/yyyy, so #1/12/2007# is interpreted as January 12, 2007.

2. The result of Format is a string, so you are performing a string comparison, not a date comparison:

If “09-07-2009” < "12-01-2007" Then

Since 0 comes before 1, the condition is True.

There is no need to use Format. VBA is very well able to compare dates.

If your intention was to test whether CGior is before January 12, 2007, use

If Me!CGior < #1/12/2007# Then

and if you wanted to test whether it is before December 1, 2007, use

If Me!CGior < #12/1/2007# Then

I used Me instead of Forms!GioRep – if you ever decide to rename the form, Me will still work.

Thank you Hans

This converts dates to a text string, why dont you convert them to real dates then do the comparison.

Thank you Pat

Hi Steve, could you explain the meaning of TableFieldSetToVarchar(Max)?

i know this discussion has moved to another thread, but in case anyone is wondering how to do it, here’s a way:

1. setup an ODBC connection to SQL Server
2. create a pass-thru query
3. before writing the query, access Properties to specify the ODBC file, which is basically a connection string. You can opt not to store the password in the query (it will be stored in plaintext…). If you don’t want a response (that is, a recordset), set Return Records to “No”.
4. write something like this:

INSERT into dbo.()
SELECT * FROM OPENROWSET(BULK N’\<path’, SINGLE_BLOB) as Document;

NOTE: if SQL Server is not running on the same machine as the target file, you must use UNC.

Alternatively, you can tick the check box “Linked to source” in the Number tab of the Format Data Series dialog – this will make the data labels use the same number format as the source data.

Is that a feature of Excel 2007? I don’t see the number tab in the Format Data Series dialog.

Change the formula in E2 to

=ROUND(B2/SUM($B2:$D2)*100,0)

and similar for the other cells.

Apply the custom number format 0;; to E2:G21. This will hide 0 values.

Thank you so much Hans
I had to format the series data labels with 0;; as well otherwise the zeroes would still show on the chart.

I think you would have to actually calculate the percentages in the base data and then plot those instead.

Hi Rory :-), thanks. How do you dispense with the zeros in the chart? I’ve tried using zero-length strings in the cells’ IF condition to no avail.

Thanks Mark

The only tool that I am familiar with that does that sort of thing exhaustively is Total Access Analyzer – there are other utilities that you can use to rename objects that might do the trick – Rick Fisher’s “Find and Replace” comes to mind.

Thanks Wendell, I had just posted a new thread about the same topic; how do I delete it?

Is your CollateReports function used anywhere in the mdb? Which actually makes me think…are there any utilities around that allow one to find where a certain function is used anywhere in an Access file, be it VBA code, queries, macros, control/record sources on forms or reports and so on?