Search results for query: *

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

Hi, Basically what is needed when a Requisition is printed is an email sent with purchasing departments address and the Requisition number in the subject line. The question is I can open the email hyperlink to the send to with the email address but what method do I need to add the...

Thanks, Warm regards Bill

Cheers, Regards Bill

Hi, Any free access repair tools I can down load? Using access 2000. I have a front and back end database. Unfortunatly there is no backup of the back end of the database as the back up system never worked on the server. What caused the problem - a report was run and it has become corrupt but...

Hi, Due to lack of system resources (the system will allow result of 11 queries but not the full 15 to be joined) I have had to create two union queries (one of 9 and the other of 6 ) to generate the information I require. The two unions can be run separately but a one off proved to be too...