Search results

I have just recently upgraded to office 2003, and have found no complaints with it so far. Like Pat says you can create the db still in 2000 or 97 format. Andy

On the double click/Onclick event of the textbox put the following code: Something like Application.FollowHyperlink me.textboxname Andy

Put the following code on the onopen event of your form: 'Set reference to DAO 3.5 or 3.6 Dim mydb As dao.Database Dim rst As dao.Recordset Dim numofrec As Long Set mydb = CurrentDb() Set rst = Me.Recordset numofrec = rst.RecordCount If numofrec = 0 Then MsgBox "Try a new search"...

Thanks Debased, Glad to Help. Good Luck Andy

Try this: DoCmd.RunCommand acCmdNewObjectQuery Andy

You could add the following code on the on Open Event of the form/report me.caption = " " Make sure you put a space between the quotes. Regards Andy

No Problem. Glad you sorted it. I can remember when I had these problems but as time goes on it gets easy, that's the learning curve. Good Luck in your project. Andy

I don't think so. You can set a textbox to flash different colours, or alternatively create the ticker in Flash/Java and link/embed that object into your form. Do a search on Google for "create text scroller in access" and you will find loads of Flash/Java examples. Andy

Carly, Have you fixed it yet? Follow ghudson's comments and you won't go far wrong. Andy

Hi Wayne, Hope you are keeping well. Thanks for the solution. Worked a treat. Take Care Andy

ALeb, Thanks for the help. I still can't get the sample to work. I even made sure the links to the files existed on my system, just incase. I have decided to use an OLE to view/edit the spreadsheet. It would have been nice to view the sample. If anyone has the same problem or solution please...

Hi Carly, Found the problem. Code is absolutely fine. There is no toolbar called Print Report or Print_Report. If you changed the toolbarname to print preview so the code looks like : Docmd.ShowToolbar "Print preview",actoolbaryes The Access Print preview toolbar appears. The toolbar you...

Carly, Any chance of a quick sample db? maybe we are missing something. Have you tried right clicking the report to see if a menu appears? Follow the menu path : Tools > Customise > Select the toolbar name and click on properties. What type does is say? is it Menu Bar/Toolbar or Popup Andy

Carly, I haven't played with toolbars for a while, so bear with me. Check that the hide all toolbars code is not cancelling out the open event. Where do you have this code? Have you set the toolbar property to Menu Bar/toolbar and not popup. If it's set to popup it will only show on right...

Firstly where are you putting the code. You may need to set the report properties toolbar property to Print report has opposed to using code. Post where you are putting the code and on what event. The showtoolbar = actoolbaryes is just to show that the actoolbaryes is the property to show the...

Use the following : DoCmd.ShowToolbar "Print_Report", acToolbarYes When using the code editor start to type in the command and when the controltip shows, includes commas where applicable and aprt from the variables that need to be defined, the rest of the code will appear automatically. Try...

You could link the data to an excel spreadsheet, then just refresh the data upon opening of the workbook which will display the data and you keep the formatting. Hope this Helps Andy

Pat, Thanks for the advice, however we have no control of the creation of the excel files as they are system generated from a third party contractor. Obviously the files could be renamed, but when the file is generated to the server , I want the user simply to click a button to set an OLE field...

Hi All, I need to change the format of a date in a unbound textbox. I want to change it from dd/mm/yy to dd.mm.yy, simply changing the / to . I used a input mask and set the format to dd.mm.yy but still returns the date has dd/mm/yy. Basically I am using the value from a calendar to open a...

Aleb, Thanks for the help. I open the db and I am presented with this screen: If I click Ok/Cancel or click the close button I receive the same response which is: Nothing then works because I receive the OLE error as above. The form then appears : I have checked the references and...