Search results

Hi, I'm in the process of distributing my database to different offices. One problem I'm having is that when somedody previews a report it looks for my printer set up and displays a big ugly message. Is there a way I can simply get the report to use the default printer without dislaying this...

Hi, I've created a search form with a number of combo boxes on it for the user to select. The rowsource for some of the combo boxes are filtered based on selections in other combo boxes-for example a products combo box row source is filtered dependent on the country selected in the country...

Hello People, This is really frustrating.... I have a form based on one table which will be used as an input form to enter new records and edit records. While they are entering new records to this table I also want, on the same form, a way for them to enter image refs associated with the...

Hi, I've got a report based on a parameter query. I want the title of the report to reflect what the user enters as a parameter-is this possible? Thanks, SteveD

Hi, I have a form which has two particular text boxes on it- I want to enabled or disable them depending on the value selected in a combo box on the form. In the after update event of the combo box I have put an 'if then else' statement, it works the first time you use it on the form but if you...

Hello everybody, I am a little stuck on how to go about a particular task.. I have a form with several combo boxes and text boxes for user entry. What I would like to do is have a user go in and select the different values from the different combo boxes + enter values in text boxes, then press...

Hi help needed; I've started work on a form with multiple combo boxes which I would like users to be able to search. I've got tables as row sources for the combo boxes to limit users' choices, however I want the users to be able to leave some combo boxes blank if they so wish, so searches can...

Hi everyone, I'm new to Access & VBA and I would appreciate some help! I've put a little bit of code in the 'on load' event of a subform so that when the form is opened and there are no records to show a message box appears to say something along the lines of 'sorry no information to display'...

Does anyone know if it is possible to have a form that enables user's to update and amend records-the record source for the form is a query with calculations in it. (I need to have calculation's in it to show the values in different currencies)

Hi, I've got a subform with a list of managers on it. When a particular manager's name is clicked I have a simple procedure (using the docmd.sendobject) to open up a blank e-mail in microsoft outlook addressed to the relevant manager. It works fine except that the egg-timer appears when the...

Hi, Does anybody have experience of creating graphs in Access? I have a table which I want to be able to put on a graph in a report, but access doesn't seem to let me graph more than 6 fields at a time. The table has a 'Products' field with around 100 different products. It then has 12...

Hi People, I've created a number of forms on my database where users select items from a combo box, then if they wish they can view more detailed records by pressing a command button. The command button uses the Me! property of the combo box to show related records. My problem is that if there...

Does anyone know if you can change the format of command buttons on forms-not just resize them or change text apperance, but also change the colour of the buttons, add special effects to the buttons. I have forms with quite a few buttons on them and they doon't look very appealing! If anyone...

Does anyone know if you can change the format of command buttons on forms-not just resize them or change text apperance, but also change the colour of the buttons, add special effects to the buttons. I have forms with quite a few buttons on them and they doon't look very appealing! If anyone...

Hi, I have a switchboard start-up form for my database which is set to pop-up so that users cannot see the toolbars. The form also has a command button on it which opens a report. My problem is that when the button is pressed the report is hidden to the user behind the start-up form. Does...