Search results

first you do not need the relationship as it is just a table to populate a combo box. if you dont want to store the code then change the properties of the combo to bound field 2 assuming that the code is 1 and detail is 2.

go to the properties of the combo box on the after_update event me.subform.requery or use me.subform.refresh

Cheers

Dear all, I have a form with some text boxes on with the properties as gen number and dec places set to 2 but i still get data such as 1.22223333 or 1.7766335 What is going on?

Dear all, All I am looking to put a database together that lets a user create a contract using the db forms and I was wondering if anyone had any examples of contracts or questionnaire table design/example db? One other main thing I need to do is store calculated vales and then write them to a...

zip up the db and it will be looked at!

References were missing and a form named wrong. Attached is repaired copy.

try to compact the db via the tool bar then zip it to here else send me the db mark_curtis_69@yahoo.com

Create a combo box and either populate it direct or via a table. in the query refrer to the combo box!

In a nutshell No! My advice is use the best and ditch the other. Users will moan a little but will get over it!!

if u develop the db as a runtime with Office developer then distribute as a runtime there are no licencing issues as the developer edition covers this.

why dont you do the following: Send the users straight to a form with the two unbound text boxes and then use a subform based on the query results. You can then either clear the sub form with code or use requerycos the table will be refreshed as opposed to refresh that only refreshes the form.

This could be your machine set up and not the applications, get into control panel!!

Thanks all. I have written it in vba instead!

another zip another

Dear all, I have a cross tab query that returns monthly data by year. There is also a field where users place a one off project cost. What I want to do is only show the one off cost once in the query basicall if the report runs more than 1 year i only want to show the one off cost in the last...

Dear all, I have a cross tab query that returns monthly data by year. There is also a field where users place a one off project cost. What I want to do is only show the one off cost once in the query basicall if the report runs more than 1 year i only want to show the one off cost in the last...

How can I alias: PIVOT tblFinancials.FY In ("1","2","3","4","5","6","7","8","9","10","11","12"); where 1=jan, 2=feb...........

search here for bookmark

put this in a new text box control source: ="*" & [ProductID] & "*"