Search results

John Where exactly do I insert this code

What i am trying to do is have 1 combo box populate the second combo box which would then open a table based on the selection. Can someone help me achieve this Combo box 1 has a selection of job numbers in it, combo box 2 would have a selection of tables which can be open to show records in...

Hi can someone tell me how I can Link 1 combo box to another to open a table. I have got 1 combobox that has project numbers in it. What I would like to happen is once you select a project number you can then go to the next combo box and select which table you would like to open in dataview so...

It won't even let me zip it up it still shows 6.88mb when zipped same as unzipped

No it's not on a network it is just a stand alone database that I bult on my laptop

Hi There Can someone tell me why when I enter data into textboxes on a form it saves to table ok. If I change 1 textbox to a combobox so I don't have to keep entering the suppliers name it won't save the suppliers name to the table.

Ok I have got a bit further I can now insert password in popup box that says Enter database Password it then comes up with the following message (See attachment)

Ok i have re joined system.ndw as you suggested but now I get the message as per the attachment. What do I need to do now. I can't even get access to open when I select new database as you suggested as it asks for the password

Its part of a standard Microsoft Office packwhich I have had for several years. After opening Access you have the option to open a blank database or select an existing database, once I click on one of these this is when it asks for the password. After searching Access with a password retriever...

I don't know if I am breaking any rules posting here but I don't know where to go to get advice. My problem is that everytime I open Access 2003 and try to create a new data file Access is asking for a password. It doesn't matter if I am trying to open existing data files that don't have...

My frmCVO is a stand alone form not a subform so how do I link frmProjectDetails and frmCVO. Where do I do this. I know how to link a subform to the main form but the frmCVO is a stand alone form. ThefrmCVO is opened by a command button on the frmProjectDetails

Hi I have a form called frmProjectDetails, on this form i have textboxes which are populated with data from the tblProjectDetails after ProjectNumber is selected from a combo box. Also on the frmProjectDetails is a command button that opens another form called frmCVO. On the frmCVO are...

I am having a mental blank can some one help with the following. I have a second form with multiple text boxes that populate multiple fields in several tables but I can't remember the function I need to put in the properties of each box to get the data to the table fields

Hi I have a curly one here that is driving me in sane. I have a form with a combo box that looks up job numbers and inserts all the relevant information into the text boxes and a subform on the same form, this all works fine. However when I select one particular job number it inserts all the...

Missingling I managed to sort the problem with trial & error. I i didn't select the subform control which wasn't letting me link the form and subform. Its all coming together now. The only problem I have now is that when I select project number and data in the subform that is associated with...

Missingling Thanks for the help with linking the subforms to the main form. The subforms now show the column headings but no data. The top half of the form is still working fine showing the projects static data in the textboxes and changes when I change project numbers in the combobox. But no...

The data from the query is a total $ Amount

Hi Can someone point me in the right direction. I have a main form with a combo box for selecting a project number, when the project number is selected it shows the projects number, projects name and $ value in text boxes at the top of the main form this all works fine. Below this data i...

Hi Can someone tell me how to get the result of a query into a text box on the main form. The textbox is in the main form footer. Can you please give me a step by step directions as I am not very experienced in Access 2003. Any help would be appreciated

Thanks for that Missingling One other problem I have is when I select the Project number to add additional data how do I get it to generate another row in the tblProjectDetails and save it as that Project Number