Search results

I have the following code for my form: Private Sub Label2_AfterUpdate() If Me.prod1 = True Then Me.Label2 = "PCD/PCX" End If End Sub I have a text box called Label2 on the form, why don't this work? thanks in advance Mike [This message has been edited by Xenix (edited...

Open form in design view, select form properties, under the Format tab you will see a title: Navigation Buttons set to No Regards Mike [This message has been edited by Xenix (edited 02-07-2002).]

I have a table with interest groups. They have labels Prod1 to prod68 they are tick boxes. now I want to do a search form on say prod1 and view how many customers are interested in prod1 I would like a combo box where I can select this but how can I give them meaning full names in the combo...

Thank you Pat ) that worked fine Regards Mike

Thank you, If I do that is shows no records, I think this is due to the table Business sector, it only has the company name in it if there is a Business sector any other advice?

I have two tables, One Company details and another which is Business Sector, there can be multiple Business sectors for a company so I use this method and link with company name. I want to generate a report with only the companies that have no business sector filled in?? Can anyone help me...

Hello I want to filter my form from two table sources, I have two fields on my main form called "Total Employees" & "Company type". I also have another "business sector" this is a multiple field and so I made another form for it called "ComBusSecFilter". I am trying to find the records that...

I would like to filter fields in a record that are left blank, how can I make this command do this: Me.Filter = "TotEmployees = ' '" seems not to work for me thank you in advance Mike

Thank you pat that worked fine 1000 thank you's that was really doing my head in Kind regards Mike

No MarketCompanyQuery is the main form. I still can't get it to work, the form is open and a small form appears when they select a link between two companies, but then the error message appears saying : Microsoft Access can't find the Form MarketInterConnectQuery If I run just the...

I have a tab box on my main form within each tab control is a form. I have another form which appears when a certain box is clicked on my tab form "Company Inter Connects". How can I call a value from the main form into my new form which appears: I reference the form by: cache1 =...

Ok sorry guys, found it: =[Forms]![FormName]![FieldName] & " is a " & etc. for anyone else that wants to do it Mike

Seperate dbs just for security on the server, nobody can open the tables and have a good look at confidential data

Can anyone show me how to put table names within a text string on my form? I want: "[Company] is a [Relationship] to [Company2], What is [Company2] to [Company]?" Thank you for any advice Mike

I would like to transfer multiple table data into another database. But multiple tables within the next database, I have one Database called Marketing and another called Quotations. So Companies from the Marketing Database as they become a customer I would like to click a button and transfer...

Anyone know how I can select a different printer than my default when I print?

Anauz: Please can I have a copy of ur code? Thank you Mike Email address 2: mikenorge@yahoo.co.uk [This message has been edited by Xenix (edited 01-16-2002).]

Is there a way to make the little pulldown arrow bigger? I want to use font size 24 in my record lookup pulldown combo box but the little pulldown arrow stays the same size thanks in advance Mike P.S. one more thing, How can I clear the combo box when I select a new record with a...

Yes they are the same Number, Single, 3 decimals. also if I place the value at the end of the code end e.g: Forms!Quotation!quotecurrency = 1.345 it works fine? [This message has been edited by Xenix (edited 01-14-2002).]

I have a problem with copying data from one field from a table into a field on my form. I have declared them with the same format but get the error: "The value you entered isn't valid for this field" I use the code: Forms!Quotation!quotecurrency = Me.GBP Anyone help me? Thank you Mike