Recent content by justagrunt

Thanks Bill

Cheers The AceMan1, immmmmmmmmmm. I'll have a look into that and give it a go. Warm Regards Bill

Hi, A basic question but then again I've missed out on some of the basics. Main form has two subforms in a parent child relationship. Can a subform be made a compulsary object to be filled out? My understanding is that normally a subform only becomes active when it is highlighted and a feild...

Thanks Herman, Name selection was one of those things that happened right at the start when trial and error and know knowledge were in abundance and ignorance was bliss. Thanks Bill

Hi, Using select statement as suggested in a previous post I was able to format an auto fields prefix, but find the format would not stay when the form was reopened as the base tables feild format held nothing. Select Case Me!Frame20 Case 1 Forms![Works Card Form]![Works...

Cheers. Great thanks. Beaut. And all other ways to say thanks. Warm Regards Bill

Hi, Is it possible to automate the selection of a prefix for an Auto numbering field. On the form the text box format is >"BO" which does nicely and adds a prefix to create 'BO6953" etc and this appears in the table. If I have say 6 prefixes that are required, can the choice be automated to...

Hi, I'm on a steep vertical exponential learning curve right now, the progress database discovered yesterday and MySQL wednesday last week. Reports are required which the vantage merant progress database cannot give and in the format that is required - ie automated spit out at one button push...

Cheers. In for a penny in for a pound. Warm Regards Bill

Hi, I have databases with front back splits. If I use SQL Server or MSDE (more like MSDE 2000 Release A because its free)and I'll put it on the server, the wizard upsizes the back ends as a copy, keeping the originals? I then relink the front ends to the copies in the SQL Server or MSDE which...

Hi, Simple question. Err_messageError: MsgBox "Error No: " & Err.Number & "; Description: " & Err.Description Gives the message Error 438 etc. How do I use Debug to also show the line that the code stopped at? Ta Bill

Hi, Good question. At this stage I would guess at something after 'Sets up error handler for the rest of the procedure On Error GoTo Err_messageError Haven't set a line trap as yet. Warm Regards Bill

Sorry error is 438 - typo.

Hi, Automating an email but found that .quit etc closed the already running session, so tried the following only to get an error 48 - Object doesn't support this property or method. Is it possible to check for a already running instance use it but not destroy it or if not, create and then close...

Thanks Cheers Regards Bill