Recent content by VBOldTimer

Use Select @@Identity

For integers or booleans: =Val(Format$(TheField)) For Text: =Format$(TheField) Doubles and Singles can be handled like the integer example on a pc set to US standards, otherwise you will need to check for a Null using IsNull() or IsNumeric =IIf (IsNull(rs(0)),0, rs(0))

Use JRo to add a password, and compact the db at the same time. You can do this also with MS Access. Ado and Dao have no problems with this. Once set, you just supply the password in the connection string (plenty of examples here). The simple database password can be easily cracked with an...

Actually, you can get the new number after calling AddNew and prior to calling the Update, just to throw in. Make sure you use a server side cursor though. It is possible to still have some (seldom) clashes though so a good practice to do a quick count query (fastest) on the table using the...

You mean like myStr = "good morning to you" myStr =StrConv(myStr,vbProperCase) Debug.Print myStr = Good Morning To You

Check out the DataRepeater control (add a control reference to it)

"Data Control and bound controls cause more headaches than they are worth" Well, personally I think you are right about the Data Control. It just complicates matters, if the project is anything but small, and sooner or later somewhere down the road you end up changing to a recordset...

As discussed in thread222-510367

Try: Dim x As Long Dim y As Long Picture2.AutoSize = True Picture2.Picture = LoadPicture("MyPicture.jpg") Picture2.BorderStyle = 0 With Picture1 .ScaleMode = vbTwips For x = .ScaleLeft To .ScaleWidth Step Picture2.Width For y =...

Unfortunately, rorubin's posted link is for the TabStrip and not the SSTab. For the SSTab, under VB6, I haven't seen a method, API call, or whatever, to do what you want. You can only at best place a frame on the tab and dynamically resize it when the sstab resizes. But this is still a poor...

Another way (even thought the close button is still visible and not greyed out) would be to simply code: If UnloadMode = vbFormControlMenu Then Cancel = True Or, even more simple: Cancel = UnloadMode = vbFormControlMenu

You already asked this. thread709-524550

"Without value mont and year." I guess this is throwing some of us off. What do you mean? Give an example.

"I have the ADO objects on the app with no connection string" Have you also removed the RecordSource from the properties window?

RecordsRead is supported by CR. You said you were using CR and DIDN'T say that you were using the DataReport! The underlying recordset recordcount property will give you the total records