Search results

One way of doing it is to set the Control Panel in the Form Properties to No or Off, that will remove the icon to the left of the screen and also remove the min, max and close buttons on the right too.

Im really using a lot of unbound forms right now due the fantastic versatility of them final form. Is there a way of replicating the tabular form in an unbound form without using the table as the recordset? I want to be able to completely design this database using only unbound forms and the...

Thanks Mile for that.

Can you change the background colour of the Tree View control like you can witht the other controls?

Thanks Rich Sometimes Access is such hard work!

I have a tabular form which displays records from the table. How can I have a sum for each line of the form (basically a sum for each record?) I have tried =sum([field1] + [field2] + [field3]) which works correctly if there is only one record showing on the form, but when there are more than...

The thing you are looking for is cascading combo boxes. Never bneeded to use them before so not sure how to do it, but have a search for them on here. loads of posts for them

Thats because windows in its infinate wisdom changes the attributes to Read Only when copying files from CD. You need to re-set the attibutes of the files once they are copied from the CD. Right click each file and take the tick out of the Read only box then press OK That should do it for you

Can you zip up your database small enough to post here and Ill have a look at it if you want

Have a look at this rather por screen shot, (taken over remote desktop on a pc which has no graphics apps whatsoever.) It might show you where need to put the proprty etc.

Works a treat. Sorry but was called away for some urget IT assistance and never got round to looking at the help files in access. But thanks for that

Rich here is the code =Forms!tbl_Customers1!List35.Column(2) The first form (tbl_Customers1) remains open, the second form is populated by the details from the listbox35. Everything else works fine with the exception of column 2. The data in it is £

No i haven't. Have done a search on the forum for details about it but there is nothing here. Can you explain a little about what it does whilst I look elsewhere for information on it

No one else had this problem?

in the On Click event of your button for printing the report you need to put this code: Dim strDocName As String 'Sets the report to print the current record on the screen Dim strWhere As String strDocName = "Invoice" 'Report Title strWhere = "[CustomerID]= " & Me!CustomerID...

Ceejay Just set the properties of the text box to Password Format. That will give you the ******** that you are looking for

Hi I have a form with several list boxes on, all working fine. One of list boxes contains Quotation Data, when I highlight one of the quotes in this list box, I have a command button which when clicked, brings up a second form and populates the fields from the data contained in thie list box...

I must admit, that happened to me too, never used to though so not sure what that means. I guess if you are making MDE files it might be a good idea not to show the database window

Mmm ok try this What format is your current database in (it will tell you on top of of the database window) My guess is that it says 2000 format. That being the case, close access completely, then just open up access from the access icon, not by the database. Click tools, then convert...

Before you can convert an MDB into an MDE you need to compile your code and remove all the unwanted code. Open any form and then open the VBA window and remove all the code that doesn't belong there, for example any command buttons that you have deleted will leave their code behind. Then from...