SCBWV

Maybe look at the Mod function... interesting, 1462 Mod 365 = 2. Wonder when DateDiff starts?

Sounds to me like you want to sunchronize the toolbar on all the mdi forms. Try looping through the forms collection: If you can identify each mdi form by name then you can use: For Each frm In Forms If frm.Name = "mdiform" Then frm.Toolbar1.Buttons(5).Value = tbrPressed End If Next …

Its hard for me to follow which forms are which in your example. However, you can use Use fmticket.Text1.Text = fmpay1.Text1.Text to have one form's text box use the value of the other.

Copy protection usually brings its own set up problems, which I don't care to support in my commercial applications. I imagine that could be a nightmare. I use a key code, that I build into the installation routine and the program. The code is based on the user and company …

Why convert to ADO? I successfully sell a DAO database that runs on everything from 98 to Vista. I'm not sure about 95, but feel confident it would. I've used Access 98, 2000, and 2002-2003 formats. The Visual Studio Installer, or the Package and Deployment Wizard, should identify and include …

Why not use InStr? If InStr(Email$, "@") > 0 Then 'Valid Email Format If UCase$(Left$(Website$, 4))="WWW." then 'valid web format If UCase$(Left$(Website$, 11))="HTTP://WWW." then 'valid web format

Private Function GetColor(DefaultColor) On Local Error GoTo GetColorError CommonDialog1.CancelError = True CommonDialog1.Flags = cdlCCRGBInit CommonDialog1.Color = DefaultColor CommonDialog1.ShowColor GetColor = CommonDialog1.Color Exit Function GetColorError: 'User clicked the Cancel button GetColor = DefaultColor End Function

Since it seems the Excel data is populating a text box control, why not use the Change event for the text box to trigger your code?

Send me your email and I'll send you one I wrote.

App.Path is Read Only and is set to the path of the executable file. You shouldn't define this anyway, as a user may chose a different path when installing the program. You can use like App.Path$ & "\Data\MyFile.MDB" and your program will the data directory no matter when the user …

I don't use Global. I put all my public declarations in a Module: Public ErrorStatus as Long

Why not just copy the file PTSTEST over PTSPROD?

You can use frmsummary.lblfname0.Caption = frmWage.lblfirstname.Caption or you can put the captions / text in public variables which are accessible to any form.

File$ = Dir("*.DAT") Do While File$ > "" 'Open and process file here 'Close File File$ = Dir Loop

Are you using VB.Net? Cos I'm using VB6 SP6 and I don't see a Protection option.

The toolbar should be in a CoolBar. In the CoolBar Property Pages, on the Band tab, there's a settign for New Row. Add more then one Band and set the second Band to NewRow.

What database version format are you using? What version of DAO are you using? Also, if you're working strictly with strings, you should use the specific versions of Left$(), Mid$(), Right$(), Chr$(), ChrW$(), UCase$(), LCase$(), LTrim$(), RTrim$(), Trim$(), Space$(), String$(), Format$(), Hex$(), Oct$(), and Str$(). Otherwise, VB uses the Variant …

I have a VB6 application that uses DAO to read and write MS Access files. Since the program uses Access files exclusives, it was written in DAO instead of ADO. The recordsets within the program are based on queries in the database. I need to add a field to the …

If the database is on a LAN, you can use Access format quite easily... I do it all the time.

Try mydb.requery as well

I ran into this on a commercial application I sell. It seems some of the new screens, particularly wide screen flat panels, return a different TwipsPerPixel. I was able to work around the issue by comparing the design resolution with the screen resolution being used (Screen.Width / Screen.TwipsPerPixelX) and adjusting …

Congrats, fellow West Virginian!

Why not you Microsoft Visual Studio Installer? The intallation can be uninstalled through the Control Panel.

I'm not exactly sure what you're trying to do, but if you need the dimensions of a picture, why not load it in an autosiing picture box and read the dimensions?