Search results

Aleb, Thanks for the sample but I can't view it. Keep on receiving activectl error after a parameter box is asking the value of pole1 field in frmpuctures. Can you help so that I can view the sample? My russian isn't that good. I'm afraid. Cheers Andy

Hi All, I know there are several different ways and editing/viewing excel data through access. I was wondering if anyone has a preference or best practice. I could use : DAO Link the worksheet etc etc Basically I want to view and edit the spreadsheet in an access form, rather than the user...

RyanB, If you don't have licenses or access to activex control you can substitue the commondialog control with windows api. Do a search for win api and/or commondialog and I think there are some posts with sample code. Post back if you have no joy. Andy

Welcome to the forum, Post your db structure currently and what you want from access. Be prepared to take constructive criticism... and I'm sure everyone will help you in your quest. Andy

Just simply change the file paths in the the form or the table to images that exist on your pc, and it will show different images. On the form there is a image control, all the code does is to change the filepath to the recorded path in the table. If you go into design view on the form and...

Just duplicate the line and change the help file.

Carly, No Problem. I had a quick look on MS KB and microsoft state that Access isn't capable of disabling the mousewheel. However there has been code posted by ghudson called mousetrap, and I think the only other option is the dll file or a drastic measure is I heard somewhere that you can...

Quantum, Try the following : Application.CodeProject.Path Application.CurrentProject.Path If you do a search on Google for 'Application.path in VBA' there are some other solutions. Andy

Carly, Unfortunately the DLL needs to be on the pc that operates the program. The DLL can be placed into the Windows/System folder or the same folder as the mdb file. I suppose there could be away to set access to check if the DLL is there and if not copy it say from a network or other means...

Try this : http://www.lebans.com/mousewheelonoff.htm You could set the code on your startup form. Andy

You could store the relative path in the table and You could code it something like : Dim AppPath as String AppPath = C:\Program Files\.... Image path - code something like Imagepath = AppPath & Me.Textboxname Hope this helps Andy

QC, I have had a quick look. If you go in design view on your form and click on the next to the Oncurrent and Onload events , which opens the VBA Editor and copy the code in the class module to the relevant events and that should do the trick. Let me know if it works. Andy

QC, Try deleting everything that doesn't apply to the problem, then compact and repair and then zip it up. Let me know if the filesize is reduced. Andy

Do a search of the forum, you will find loads of posts regarding networks. Ideally for performance you should split the db into front/backend. Put the backend on the network and the frontend on the users pc. There are different opinions on what should you do, but it determines on what your...

No you misundertand, I am talking about Access. You can do it table level and form level by setting the Input Mask Property to PASSWORD. This will encrypt the data to ******* for example. Regards Andy

Have you tried Compact and Repair from the Tools Menu. Otherwise email me the db to access@spaceprogram.co.uk. Andy

If you are talking about masking the actual values for all passwords in the db like they would appear on a web form, then just simply set the fields Input mask to PASSWORD. Sorry can't help with encryption. Good Luck Andy

Embedding your images is not a good idea, as per The Doc Man's comments. It would be quite easy to have a specific folder, thats holds the images that could be packaged with the db when you install it in your environment, otherwise you will have problems with your db later on. I have attached a...

Woknick, It sounds like you need to revisit your db design and look at the tables. For the information you want can all be done in access. There is no need to use an external database. If you need specific help on how to implement please post you current table structure and I sure we can help...

Never done this, and there might be better methods. You could try. Store all the filepaths in a table. So a textbox bound to that field in a form which displays the filepath. Make the visible property to No. Add an image which links to a image. Then on the onCurrent Event out the following...