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...

Thanks a lot for the reply Rich, I'll check out all the things you mentioned. At least I know it's now possible! (This forum really is a life-saver!)

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

Thanks again to the people who helped me with this, I've only just got round to finishing it off, but it works OK I just like to have a couple of enhancements to it:- 1. If a user does not select any criteria then I'd like a msgbox to appear saying 'no criteria entered..' At the moment I get...

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...

Thanks for your help Doug (and the charitable G person)!

Thinking about the advice given...... Would I only be able to link one field? How do I go about covering all the possibilites that a user might select-for example if you have 6 combo boxes/text boxes and want to be able to bring up filtered records based on any combination of combo boxes/text...

Thanks for all your help people, Just a quick query-could you explain why the left function is needed at the end?

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...

Thanks Pat, As a newcomer to Access, this appears to be a major weakness of the application, although I guess there's some very intelligent reasoning behind it which I havn't figured out yet!-I'll have a look at the white paper, thanks for the info!

Thanks KevinM, Sorry, but I'm still a little unclear as to why it's a better way. The only reason I ask is that I have quite a few forms like this where I need to do a calculation with currencies-the local currency being a field in the 'one' side table and prices of products on the many side...

Can anyone hrlp with this? Thanks, SteveD

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'...

Hi, thanks for reply.. I have a form where the record source is a query with two tables. There is a one to many relationship between the tables. On the 'one' side there is information on a particular country such as currency, population etc. On the 'many' side there are records relating to...

Hi, thanks for reply.. I have a form where the record source is a query with two tables. There is a one to many relationship between the tables. On the 'one' side there is information on a particular country such as currency, population etc. On the 'many' side there are records relating to...

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)

Thanks for the reply, for clarification I don't have a field for e-mail addresses in the database,-I've simply got a list of names, I've put a simple bit of code on the 'onclick' event which opens microsoft outlook and as long as the name is in our internal address book it will work (apart from...