Search results

the field is bound... here is the text that is in the field =[tbl_TempQuote]![spart] show this SHOULD be the part number (spart) from the data table (tbl_TempQuote) or am i missing something ??:(

hi hope you can help with this folks... i have a form which opens a subform. on the 1st form, the user puts in a Part Number when the subform opens, the PartNumber is prepopulated but a field next to the part number needs to go away and look at a list of BOM items and populate the child parts...

hi hope you can help with this folks... i have a form which opens a subform. on the 1st form, the user puts in a Part Number when the subform opens, the PartNumber is prepopulated :) but a field next to the part number needs to go away and look at a list of BOM items and populate the child...

Problem sorted thanks. Solution is that I had to close the update form first (which then saved the NEW data) and then run the Query that copies the revised data to the Original table here is the VB from the Update Button :- DoCmd.Close acDefault DoCmd.SetWarnings False DoCmd.OpenQuery...

ok i think i have kind of sussed whats happening here (or not) 1) there is a query that copies the requested (by the user) record no (only 1) from table a to table b 2) the edit form uses the contents of table b as its control source 3) the user updates the text in real time THEN clicks...

Hi Dave, here is the SQL View of the Update Query (although, suprisingly, it doesnt verify the syntax in SQL Query Analyser!) UPDATE tbl_SubmissionData INNER JOIN tbl_TempEdit ON tbl_SubmissionData.ID = tbl_TempEdit.ID SET tbl_SubmissionData.Application = [tbl_TempEdit.Application]...

OK guys thanks for the advice above BUT 1) i have NOW prooved that the Query Works on its own - independantly it just doesnt work when i invoke the query from the Button on the form 2) i have commented out the warnings bits and YES i DO get the warning and the " you are updating 1 row" -...

:( hi - no not sorted this yet, but looks like i MAY have the tables transposed, so i will TRY that, then i will let you all know cheers Paul

thanks Dave / Gemma-the-husky it looks like its SELECTING the data from the tbl_SubmissionData table rather than the tbl_TempEdit

this is a Screen Grab of the Update Query - can anyone see what is wrong it SHOULD take the data out of tbl_TempEdit and update the table tbl_SubmissionData thanks Paul

DC - thanks for the advice. think i had already tried that, but did it again! :rolleyes: I got the "you are about the run an update query" message and then the message saying "you are about to update 1 row" which was correct but when i closed the application down and go back into the dbase...

I have a Form with a Button on. The form is a text input form that updates data on a table. The data i have pulled in to view on the form is held in a temporary table and the query i am trying to run, takes the updated data and puts it into the original table. temp table name - tbl_TempEdit...

Hi I have a Listbox on a form, i want to select (user to highlight a row) one of the list items and then click on a Button called 'Edit' to take the user to a form where they can edit the contents of the row. can anybody help please? do i need a docmd.openform (formname) and then put the...

thats it !!! i was confusing myself as i was using 1 table for the source data for all three drop downs i have now copied the table and made 2 further tables the combo drop down boxes now reference the individual table relative to the combo box, NOT the same data table i have amended...

DCDrake sorry, not sure what you are asking me to look at 1) properties - for the Drop down boxes ??? or 2) properties - for the data table holding the data that the combo boxes look at can you explain further please :o

this is the code that runs when a button is pressed on the form. Set dbCurrent = CurrentDb() Set rs = CurrentDb.OpenRecordset("TBL_SubmissionData", dbOpenDynaset) With rs .AddNew !Project = Me![Combo7] !Valve = Me![Combo9] !Title = Me![Text13]...

Hi. I have a series of 3 drop down boxes on a form. each drop down has text data in such as tom, dick, harry etc. when you select, say 'tom' - the data table, when viewed after, is holding the value of the item on the list - ie 1 in the case of 'tom' or 2 inthe case of 'dick' - INSTEAD i NEED...

Hi. I have a series of 3 drop down boxes on a form. each drop down has text data in such as tom, dick, harry etc. when you select, say 'tom' - the data table, when viewed after, is holding the value of the item on the list - ie 1 in the case of 'tom' or 2 inthe case of 'dick' - INSTEAD i...

thanks Bob, will give that a blast, I am fairly new to VB ( recently moved from a PICK basic environment - multivalued database - so used to the that syntax, but your code looks easy enough to read)

thanks guys for your input. however, I have studied your code (both) and I dont understand enough bout VBA to alter either code portion for my needs. I have inserted your code into my VBA app, and looked at altering but cant find my way around. as a workaround, i have used a crosstab query...