Sample Db thread (1 Viewer)

Status
Not open for further replies.

ChrisO

Registered User.
Local time
Today, 23:07
Joined
Apr 30, 2003
Messages
3,202
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.
 

Attachments

  • Classes_With_Shapes_A97_V1.zip
    37 KB · Views: 706

MStef

Registered User.
Local time
Today, 12:07
Joined
Oct 28, 2004
Messages
2,251
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

Registered User.
Local time
Today, 23:07
Joined
Apr 30, 2003
Messages
3,202
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.
 

ChrisO

Registered User.
Local time
Today, 23:07
Joined
Apr 30, 2003
Messages
3,202
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

Registered User.
Local time
Today, 12:07
Joined
Aug 20, 2001
Messages
1,470
I just realized I have a handful of sample databases saved. This first one has some examples of button customization.
 

Attachments

  • funwithbuttons.zip
    42 KB · Views: 1,005

Kraj

Registered User.
Local time
Today, 12:07
Joined
Aug 20, 2001
Messages
1,470
This is an example of a switchboard front-end to a database.
 

Attachments

  • swbrd.zip
    48 KB · Views: 1,133

Kraj

Registered User.
Local time
Today, 12:07
Joined
Aug 20, 2001
Messages
1,470
This database shows examples of working with subreports.
 

Attachments

  • subreport97.zip
    34.2 KB · Views: 799

Kraj

Registered User.
Local time
Today, 12:07
Joined
Aug 20, 2001
Messages
1,470
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.
 

Attachments

  • Word Dialog Box.zip
    34.9 KB · Views: 814
  • wordmergetemplatechoice.zip
    88.7 KB · Views: 850

Kraj

Registered User.
Local time
Today, 12:07
Joined
Aug 20, 2001
Messages
1,470
This nifty one shows how to use a calendar to select and pass a date into a field.
 

Attachments

  • calendar date to field.zip
    17.4 KB · Views: 836

Kraj

Registered User.
Local time
Today, 12:07
Joined
Aug 20, 2001
Messages
1,470
This has a form that uses cascading combo boxes.
 

Attachments

  • combo2 sample.zip
    64 KB · Views: 1,646
Status
Not open for further replies.

Users who are viewing this thread

Top Bottom