Search results

Hi there I have a form with a text field bounded to a memo field. When i try to edit the contents in this field, the deletion of characters or editing get messed up. I have to extra careful to use backspace or delete and have to recheck after exit to see whether the changes are what i wanted...

June the Replace works out but VALUES part flag syntax error, any reason

Thank you June, i feel it will work. I will try it. i learn something new about VALUES, thanks for that. Cheer!

Hi gals / guys I use the following to append in a table, Tbl1 "INSERT INTO Tbl1 ( Txt ) SELECT '" & Var1$ & "' AS Cs;" As you can see the Var1$ as a string. In the query there it is quoted with a single quote before a double quote. The issue: if var1$ also contain a single quote eg House's...

Thank you folks. I have just used the .fields associate with recordset.

Hi guys Another quick shot - i want to loop through all the fields in a table and list out the names. So i am thinking of the field collection with all the Dim & Set and want a sure quick job done. I think we can also do it with an recordset. Will appreciate a quick comparison. Thanks...

Got you mate

June Thanks I thought i got the it spot on but i was wrong. I have fair experience to use JOIN (INNER & OUTER) and that is editable. In my UNION ALL query this message pops up "Union number of columns don't match". Is this a condition? And again, if the UNION ALL is a recordsource of a...

How to UNION ALL? How does it go with JOINS? BTW does a UNION whatever allows select of fields, i think it do, right? Friend a bit more singing from Down Under! Thanks always. PS: If you are busy, i just look up at W3School. Cheerio!

Guys and Gal, That's it, a big Thank you to all. Cheerio

Thanks Ladies & Gentleman, all feedback much appreciated. Pat I am waiting for the avalanche in the US midterm elections on your 435 seats in the House of Representatives and 35 in Senate; a little politics in this forum that our world really need and to be thankful for. :) .. Counting down.

Hi Folks A quickie i hope :). I have 2 tables eg Tbl1 & Tbl2, both having a similar / same LinkIDFld. I would like to UNION them to be the recordsource of FormTarget. How should the recordsource string be? I have a few scattered fields in this FormTarget that is from another Table eg...

It is a form. Anyway thank you both of you. Sorry s or no s

June thanks but the snapshot of the aggregate is static & still want to update the 2nd table. I can use Adodb record recordset to do it

Hi there again I have form which can be toggled to visible or hidden. How to check it's status using VBA; what is the right collection to check this. I only know of Forms.Count or Reports.Count I am sure it is just a step away, with a little help i will get there :(

Hi I have a select query with Sum of a numeric field, let say we name Query as QTot: SELECT ID1, Sum(Num) AS SNum FROM TB1 GROUP BY ID; Then i wanted to use these Sum ie SNum to update a table Tb2, i use UPDATE Tb2 INNER JOIN ON TB1.ID1 = TB2.ID2 SET Tb2.Val = [QTot].[SNum] WHERE...

Miss communication I can put the codes in the on exit event, that is not my issue s

Sorry Again how to fire the exit event of the subform?

GG & others in the forum that keeping track. This is what i found If i want changes eg filter or record.rowsource, all target forms must be sub forms with the switching form as main. That's it.

Thank you Bro. ..BUT.. I have no chance to get to the Exit Event of the subform; it just move to a new Record in the SubFrm. You codes will come in handy if user move cursor to the main form, thus firing the Exit Event; until tht is done we are not given a chance to open new record in the...