Search results

Hello all, it looks like i have an issue. I wanted to avoid a kind of temporary table as the DB I'm creating is quite heavy and complex already. Before: 1 Append Query to Table 1 Update Query to fill a new table from the previously created table It worked like a charm but was way to heavy and...

Well, I had some difficulties to choose the right forum zone. Because it is most probably a VBA solution attached to that form problem. Here we go: I have a form (jpg attached) with checkboxes, When clicking these, it runs automatically a VBA function in order to update the value of the...

... I have a few friends there I met during a trip last year. And I hope they are doing well. No news yet (it is the night for them so I'll have to be patient).

Hello, I'm trying to extract information from a query and create a XML file. No problem with that. My script is working perfectly (and thanks to helpers here on this forum). There is a bunch of fields that I don't want to show as there are empty of value. Fields are (0) or (1) or (2), (0)...

Hello all, I found this on this forum but it is a DAO version and my employer desactivated the DAO (they want now the very last version). And moreover I'm not sure how to convert it into ADO. Function ReplaceAccents(strTextToReplace As String, strTextToUse As String) Dim qdf As DAO.QueryDefs...

I thought it was easier... I'm trying to: 1/ Count the number of records in the Query "FR_LOAN_TYPE_1" (field "REFPMT") 2/ use that count value into a condition 3/ if countvalue > 0 then ...**do the stuff ** else ** do nothing ** end if It must be something wrong, maybe a Dim statement, maybe...

For...each .value on selected columns SOLVED Good morning/afternoon, ... everyone, and happy Australia day to Australian people Trying to make a self-made XML export looks like I must amend this code without touching my database this is just an extract of course, you don't need everything I...

dlookup in a form, must display a table value SOLVED hello, just joined this forum as it sounds to be the most efficient today :) I found a lot of solutions just surfing your posts. But this new problem is annoying me. I do have, among others: 1 table "LastPrintDate" where I'm looking for...