Sample Db thread (1 Viewer)

[ChrisO]

Draw on Reports with Class Shapes.

G’day all.

Well, that’s what it’s about.
(Not much in the way of ‘green gravy’ with this one.)

The last one in the list begs much more math, which I would not understand.
Ultimately it would require the passing of torsibillity and torque to the report.
(OK, there may be only two ‘i’’s but I like three. )

Anyway, here it is…warts and all.

Regards,
Chris.

 

[MStef]

Hello Cris!

I have tryd "AutoCompact.mdb", thanks for that.
I found it very useful, but I had to change two lines in
"GetProgramVerison" function.

Dim strVersionNumber As String I changed ...As Integer

strVersionNumber = CStr(Nz(DMax("VersionNumber","tblVersions"),0))
I changed
strVersionNumber = Nz(DMax("VersionNumber","tblVersions"),0)

Because, when the forms ("frmSplash" and "frmFileList") where opend,
there was an error number 3075
Syntax error (comma) in query expression 'VersionNumber = 7,1'

MStef alias Štef

 

[ChrisO]

Thank you Stef for the feedback.

I can reproduce the bug if I switch regional settings to German, it’s the Decimal symbol in the Numbers section of Regional Options in Control Panel.

I don’t want to change the variable type to Integer because I would like to maintain a floating-point number and also learn how to handle different regional settings.

Can you please confirm your regional settings if not German?

Thank you for your feedback because this is exactly the way to make the product better.

Kindest of regards,
Chris.

 

[MStef]

My regional settings is CROATIAN.

 

[ChrisO]

G’day Stef.

Croatian does not seem to be in the list of regional settings in Win2000 but I think I’ve fixed it anyway.

Post # 15 in this thread has the new attachment.

Thanks again for the feedback and regards,
Chris.

 

[Kraj]

I just realized I have a handful of sample databases saved. This first one has some examples of button customization.

 

[Kraj]

This is an example of a switchboard front-end to a database.

 

[Kraj]

This database shows examples of working with subreports.

 

[Kraj]

These samples interact with Word. The first has a dialogue box for selecting and opening a Word document to work with, the second performs a Word template merge.

 

[Kraj]

This nifty one shows how to use a calendar to select and pass a date into a field.

 

[Kraj]

This has a form that uses cascading combo boxes.