Search results

thank you sir, you were a big help, as always

Hi, I would like to know if it's possible to open/close a subform in a form using a command button? jlabre01

Hi, I'm trying to make a query based form, so i start at one form that just has a combo box with all the company names, then i push a command button to open the next form, which contains the results of the query. at the bottom of the page i put a button to go back to the previous page in order...

hey thanks man, that definately helped

Hi, I'm creating a form that will serve as a search for information on various jobs my company does. what I would like to do is have a form open with multiple information fields after i select a specific value from the form i am currently on. for example, if i select a the projectID i would like...

Hi, I'm having problems with the syntax on a query for a text box, i want it to check a couple values from the same table then output a 3rd value from that table, but access keeps saying there is a syntax error, please help, query is listed below: =SELECT [Price List].Price, [Price...

hey, Thanks

Hi, I wanted to know how to add a subform to a form. I'm trying to setup a form so that a quoted price can be listed for certain services, so I'd like to be able to fill out the information for one service then have the fields appear again so that i can enter the values for the next service...

thanx a bunch

Hi, I wanted to know if it would be possible to have a textbox where I put in a percentage (discount) and then the values (prices) in the other textboxes would be adjusted? jlabre01

Hi, I would like to know if it's possible to set a command button's event procedure, in on click, to make data entry fields become visible? jlabre01

Thanks to all, I got it to work jlabre01

Hi, I'm having problems with the join operation in the following statement, SELECT Projects.InvoiceNumber FROM Projects INNER JOIN projects ON (Str(Companies.CompanyName)) = (Str(Projects.CompanyID)) WHERE (Str(Companies.CompanyName)) = (Str([Forms]![Invoice]![CompanyID])); Any help would...

Hi, I just need to know how to parse to string/text format? jlabre01

Hi, I just wanted to know how to parse to string/text format? jlabre01

thanx that helped

Hi, I just looked in the design view at the projects table, companyID is defined as a number (long integer) but somehow in the table there are just names. not sure how to fix that.

Hi, ok I think I figured it out, in the projects table companyID is names, but in the companies table it's numbers. So how would i use the where statement to do the same thing as before?if i have to get the invoice number to output from the projects table and the company id from the companies...

Hi, I tried to add the square brackets around the names at the end as suggested but when i save it the square brackets are gone and it doesn't work, what should I do? jlabre01

Hi, I've created a form that uses a drop down menu for the user to select the company they're looking for and a secondary drop down menu that shows the invoice reference number for the company's invoices. The problem is with the secondary drop down menu, the statement I used to define what I...