Search results

hi thanks for your reply now im 10 steps ahead, however i dont have a table named quoteTbl, must i create 1?

please advise me how to go about using Dcount, the web is very confusing ive spent 1full day trying to make it work but to no success, and time is against me Combo553 is the column that should display the Dcount Values. RegistrationNumber would display the main quotation. the form name is...

Good Morning all how do i turn clipboard messages off, or choose not to save data on to the clipboard without the pop-up box.

easy peasy. thanks speakers.

thanks i deleted the control and started over, it wasnt much of a mission.

hi John Thanks Man, the first code you gave me was a perfect fit, what does your last reply refer to.

thanks Bob, but now i get the error: the record source '~sq_cQuotation~sq_cAdditionals' specified on this form or report does onot exist. Quotation is my form name Additionals is my ComboBox Fields name

Thanks for the code Vila Thanks for the Insight Eugin much apreciated.

Hi VilaRestal, thanks for your Response. the TrackID is an Autonumber Field so what i done is i created a ComboBox with its record source set to display all TrackID's the database currently contains and ive hyperlinked them so if im in a entry and the TrackID has generated this number 10009 It...

Great Morning Experts. In my form I have a ComboBox Field. The Row Source Currently Tells the ComboBox to display all the current entries in the database, however, i only want records related to the entry im in to be displayed in the combobox. So using code, how do i tell the ComboBox to...

DoCmd.GoToRecord , , acGoTo = [TrackID] i have a hypelinked ComboBox Field and when i select the TrackID (Contents in field) i would like the form that belongs to the TrackID to open, my code returns an error that says "you cannot go to the specified record" and sometimes opens forms with a...

DoCmd.GoToRecord , , acGoTo = [TrackID] i have a hypelinked ComboBox Field and when i select the TrackID (Contents in field) i would like the form that belongs to the TrackID to open, my code returns an error that says "yo cannot go to the specified record" and sometimes opens forms with a...

Populate RELATIONSHIPS (tblClient : tblDocument, 1: more) please elaborate on the above Mstef

Magnificent. Thanks A Million.

Hi All this one is abit of a challenge i have a field named RepairStartdate (date format is short date eg: 00/00/000) 2nd field is named WorkingRepairDays (Format is Interger eg: 10) 3rd field is my desired calculated Field Named EstimatedRepairEndDate (Format is short date) now i want...

thanks, i was complicating things.:o

hi all after including the BELOW code in my OnFormat Event in the detail bar this is what my report looks like (see attached image). my back colour is set to white. Const shadedColor = 16777215 ' Const shadedColor = 12632256 ' alternative shade colors ' Const shadedColor = 12632256 ' Const...

it has an id field named ProductID and the ProductID field is generating this error, but its one of the fields that ussually gets edited so id like to copy the origional data (OnDirty) so the origional data isnt lost when edited sorry i had to edit my reply

It is in Continious form view, any guidelines?

im tryng to copy from a subform, and the field i'd like to copy from is based on a query. im trying to copy so that i dont loose information upon editing the records using the code Eugin gave me a few days ago: Private Sub Form_Dirty(Cancel As Integer) DoCmd.RunCommand acCmdSelectRecord...