Search results

Don't think so, maybe I am asking to much but I want to ensure that e.g. address1 and address 2 abd address 3 appear as seperate lines like CompName Address1 Address2 Address3 City Postcode However when lines (eg address3) are left blank I want it to print as follows CompName Address1 Address2...

I have got a database with a table called Company details. I am using the following fields (CompName, Address1, Address2, Address3, City, PostCode) Based on this table I have a report which has a block showing the company details. The problem is that sometimes one of the address fields (2 and/or...

How would I trap the error code? I would use it in a runtime application and as soon as you get an error message it will close down the application.

I have distributed an Access Application using Access Runtime (2002). The problem is when an error occurs or a required entry is not entered the system automatically created a runtime error message in a VBOKonly message format and will close the application as soon as you click on OK. Now I...

Why not use a Dlookup function as an afterupdate event when you have entered the code. Eg With CodeContextObject .[Description] = DLookup("[descriptionField]", "[TblDescriptions]", "[TblDescriptions].[Code]=[Code]") DoCmd.GoToControl "Description" Forms!FrmNAME![description].SelStart = 255 End with

A quick fix would be to print the report as a print peview report. Use Control P to open the print dialog and select the PDF printer. Once PFD file is created use file send. Pfd writer (Adobe or any other pdf creating software is required on each PC).

Tks works like a treat

I have a main form FrmQuote that has 2 Subforms. The 2nd subform FrmCalculateQuote is based on a calculation query. In order to save a calculated value I have another Table/Form (FrmSCQuoteOverviewUpdate) that records the quote value calculated in the subform FrmCalculateQuote (text34) The...

thanks looked at some of them but I am still none the wiser and need some more help. On the partquoteform I have a button to open the partsform with the following onclick event and open args Private Sub Command28_Click() Dim stDocName As String Dim stLinkCriteria As String...

I have a main data entry form (frmpartquote). From this form I would like to open a new form (products) to create a sub set of records. When I open the new form to add products to a main quote I would like to transfer the quotenumber on the quote form to the quotenumberfield in the products...

Do you have both forms open at the same time? If so you can use the IsOpen function You can add this to any button or close event If IsOpen("SubFormname") Then Forms![SubFormname].Refresh End If -------- Public Function IsOpen(ByVal strFormName As String) As Boolean Const conDesignView = 0...

I am using the same code but want to protect my backends with the default access password security. Hwr when you set passwords it won't be able to relink as it is not able to open the backends because of the password(s). Is there a code you can use here to open the backends with the password and...

thanks it all works apart from a minor detail.. I have secured my backend database with a password using the default security settings in Access. With this password in place your program will not open and relink the tables. When I remove the passowrd settings there is no problem. Is there a...

thanks I know that a databse is easy to crack but using work groups is difficult if you are not a system administrator. The program is also distributed to different sister company's each operating different operating systems etc. I fear that distributing would be a more cumbersome process.

I am using a database with a front end with tables linked to 2 back end tables. The front end database is protected by a password, however I also want to protect the backend databases using the standart password protection in MS Access. I want to protect the backend from being opened, unless...

encountered a problem as I am using 2000/2002 and yr examples are 97 in declaruing the function I encounter a poblem in 2000/2 in declaring Dim dbsTemp as databse. the system give me the error : compile error - user defined type not defined. How do I declare this in 2000/2? Public Function...

not really, the data and structure are different and besides as they are send in xls format, they are being imported/appended again in the same tables in the controllers database for him to have a complete view of what is happening.

My database requires remote users to send 4 tables by e-mail to 1 controller. Using the sendobject method I can only send a table at the time, i.e. 4 different e-mails each with 1 attachment. Is there a code to attach 4 tables to the 1 e-mail? I am using access 2000/2 and outlook. :confused:

Can anyone help me with an DB example where after installation and opening a database it searches for a backend and link the tables from that back end. I have an program that has 2 backends. I would like the users to choose the location of the files (network or hard drive) but that has...

Seems to have worked. Just hope it doesn't get temperamental. thanks :D