Search results

Thanks for the suggestions. Apologies for not responding before now been on a holiday to bonny Scotland!. I will try the above links. Cheers Andy

Hi All, I want to use the mousewheel to scroll through the list in a combo when the combo has focus. Can this be done? Any help is appreciated. Thanks Andy

Welcome to the forum! There are several ways, Use the validation rule on each field or alternatively put code on the beforeupdate/insert events something like: If IsNull(me.text1) then 'do something here End if I would use validation though, use the search function of the forum and you...

Have you tried this : Forms!CheckPoint!network_object!SourceName = "test" Removing the Me from the code. Andy

Hi Dereck, Have you tried this : Right([streetname],Len([streetname])-InStr([streetname]," ")) Hope this Helps Regards Andy

Have a look at this thread : http://www.access-programmers.co.uk/forums/showthread.php?t=34942&highlight=seperate+address+field or do a search for 'seperate address' Andy

Is this what you are after? Andy

This is what the help file says to reset toolbars and menus: Show default toolbar buttons and menu commands On the View menu, point to Toolbars, and then click Customize. Click the Options tab. Click Reset my usage data. Notes The Reset my usage data button affects the buttons shown on a...

Is there a reason why you want to develop you application in Viscual C++ and not Access or Visual Basic. Do a search of the forum for 'access runtime'. There are lots of posts that will explain that to package access in pc's without access you will need the developer's edition and licenses. Andy

Just use the following code and it will open the browse dialog and you can select the database as if you used the menus. Enter on the onclick event of a cmd button or wherever you want to trigger it. Docmd.Runcommand acCmdImport Andy

try posting to the thread I pointed you to, as Oldsoftboss created it he might able help you. It just sounds like you need to set the references for the function. Post the actual action you did for it to cause the error, with a little bit more detail and we should be able to pinpoint the...

Try This Andy

You could populate a lsitbox or something to display the file system then have a read of drag and drop capabilities in access Here Hope this Helps Andy

Do a search or look in the sample database forum and you will find examples that have been posted for disabling the shift key and if you do a search for the user ghudson, who posted code to hide all of the toolbars. Do a search for the following keywords : toolbar,disable shift key,hide...

Glad to have Helped! Andy

Thanks Malcy, you have a good easter as well. Andy

Hi Malcy, Replace your excel code with this : Dim xlapp As Object Dim xlwkb As Object Set xlapp = CreateObject("Excel.Application") xlapp.Application.Visible = False xlapp.workbooks.Open "c:\mgmshp\export\mgmshpexp.xls" Set xlwkb =...

Sounds like excel is still open after the code has completed. I am not too hot with excel code from access myself. To set a breakpoint, go into the vba editor and in the column to the left of the code using your mouse click in the column where the code is and a red spot will appear. Exit VBA...

When you get the error message, and press debug which line is highlighted? Have you tried setting breakpoints on the code and stepping through it and also set the xlapp.application.visible to true for testing purposes? Andy

Have you seen the quote of the day sample db that Mile-o posted. Maybe you could use this as a basis to start what you require your db to do. The link is below: http://www.access-programmers.co.uk/forums/showthread.php?t=64303 Hope this helps Andy