Search results for query: *

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...

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...

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...

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, 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...

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...

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...

Hi, Sorry for the Title. I am adding a number of fields in a calclated field. The feilds that I am adding return an empty string sometimes. The tables that they are based on have default values of zero but this doesn't seem to be helping. Basically I have a time sheet query with three separate...

Hi, There exists a database which the powers that be have decide to make some changes to. There exists 52 entries which were appended to the database to create it. The old numbering is out by 2000 and there are 52 entries. What is the criteria or Update to syntax to take those existing numbers...

Is it possible to alter a fields property from a text field to a number field via an up date query. One database "JobNumber" has an autonumber field where the alpha prefix is added in the format ie JN3131. The other database a purchase order database has a refernce text field where numbers or...

Hi, There is a server in another country (Windows server 2003, office 2003)which has a number of databases. They reside on the "D" drive of the server. The computers using this database are mapped to a "J" drive to avoid drive letter conflicts (it was the way it was, and so I obeyed). Remote...

Hi, Private module attached to an access form called up by a control. All variables are global and the excel sheet does open and activates the activecell. I have taken a subroutine and dumped it back into the main body of the routine. The following gives me an error 1004 Application-defined or...

Hi, if i have some checkboxes on a spreadsheet (created by the controlbox wizard,15 of them) and the user selects them and inadvertently saves and then exits, how can I reset those checkboxes so that when the next user opens the sheet that all checkboxes are returned to zero. Example Check1 is...

Hi, I am using the following code to disable a worksheet so that people cannot tamper with data on it, as it is used in formulas else where on the sheet, but allows them to enter data in allocated cells which is then worked on to give a result. The trouble is It doesn’t seem to work. The cells...

Hi, Two questions. 1)When I automate excel I get the application window opening but not the worksheet, so advise please where am I going wrong? (please be kind). Private Sub Open_Excel() 'Find and open the Excel workbook with 'the pricing for the various Selector sizes. 'The Workbook...

Hi, Using Access 2003 service pack 1. This code is part of a private module attached to a form. Private Sub Open_Excel() 'Find and open the Excel workbook with 'the pricing for the variuos Selector sizes. 'The Workbook does not have to be visible. 'set up variables for...

Greetings, The thought of using backward compatible Access 2003 on an Access 2000 form made me try it.I have updated to 2003 to get the extra benifits and future proofing as older computre get updated. The original 2000 form has a find record control (established from the toolbox wizard)...