Search results

I have downloaded the file and tried to change the query but the file is a read-only file and doesn't let me save changes. It is read only. I do not know how to change it from read only.

When I go to save the query2 after changing it it doesn't let me save it. Also I do not understand the form based on query 2. My form lets me enter minimum information about companies to retrieve full data in the subform. I do not understand how the form based on query 2 works. Gurdip.

There is nothing attached. Gurdip.

Actually I have not ried that before, should I? Gurdip.

The attachment sent back. The attachment that you have sent back to me is the same as before, their subforms are based on qryNew. Do you mean that I should change the subform to be based on query2 and then recode the criterias to the original formula? I have tried this before but it doesn't...

I have made a form that works fine called frmNz. However each time, the query qryNew keeps on changing, either becoming blank or too complex. This keeps on happening. I keep changing it to the SQL coding that I wish but when I save it, after, I go back into it and it has changed and the form...

How can I make 2 exact copies of the frmNz form that I have with the exact same coding working for the copies. I have tried to make copies but have been unsuccessful. It is attached. Gurdip.

Here is the working attachment. Here is the attachment, but the website and email address comboboxes don't do the same when enabled. How can I make them work? Gurdip.

It works. It works now except for the Website and Email Address comboboxes when enabled. How can I make them work? Gurdip.

Data Source When you say Data Source do you mean Control Source?

I have a form called frmNz in which I would like already existing data to appear in the comboboxes. For example, in the Business Name combobox I begin to type Can... and "Canalside Ltd" appears, ready to be selected. Or, in the Country combobox I begin to type Unite... and "United Kingdom"...

How can I get this to work on my form? Selecting some companies from the subform and then clicking on a "Mail Merge" command button to run the Microsoft Word application with mail merge, including these companies' information? There is an attachment. Gurdip.

I don't understand. You have written that on the form properties (current) "you need name of control (which is your tick box ) if true then fieldname.enable=true if false then fieldname.enable=false end if refresh and a save option or closeto this if you wish it to be greyed out then alter...

On the frmNz form I have added 2 checkboxes, Website? and Email? (i.e. is there a website and/or email?) I would like it so that if these are selected with ticks then website and email addresses can be entered into the below textboxes, otherwise the website and email address textboxes go grey...

RE: Fields On the View Directory form and in the UK Table, there are the fields: Business Name Business Type Address City Country Telephone Number Website Address Email Address I would like it to be that at least one can be input to find relevant information from the UK Table to be displayed...

RE:Company like... Where do I type the "Company like ..." etc??

On the "View Directory" form of my database I would like to allow the user to be able to fill in AT LEAST one piece of information on the company so that when he or she clicks on the "Submit Information for Search" command button, the table below shows the results that have been searched for...