Search results

Anyone can help?

Hi Galaxim, Thanks for your reply. Sorry for my poor english, I don't really get you. Is the Listbox you mentioned a kind of form in Access? Attached image is showing the queries i have done. I am wondering if i could create a form button only with VB Script that run all the Queries in the...

Hi THanks for your reply. Is it possible just to use a button instead of combo box?

Hi all the Access experts, As title tells, I would like to use a form to run multiple queries. It's just that I want the form to be "flexible" (sorry for my bad english, i couldn't think of another word to express). Here is my idea. I have created multiple queries saved in the queries list...

Oic, so since the i has become value 2, the loop stops?

Hi thanks for your reply, "do something" is a VBA command?

thanks, i wrote a for loop , Sub TransferData() Dim db As Database Dim rs As Recordset Dim strInputFields As String Dim strOutputFields As String Dim TableInput As String Dim strSQL As String For i = 1 To 2 TableInput = "INPUT" & i i = i + 1 Set db = CurrentDb Set rs =...

Hi guys , as title, I would like to ask you guys whether there is "FOR" loop in Access VBA codes. It's because currently I have been writing a code to build a loop. and the code is something like : Dim rs As Recordset Dim strTableFields As String Dim strOutputTableFields As String Dim...

Hi Shoji, What i meant was please ignore the email #12 as only that task my boss doesn't want me to do. but for the move the data to another table, he still needs it. it's just that now he wants multiple data to be transfered to 1 output table. Looking forward to hearing from you soon. THanks!

Hi expert shoji, sorry for my bad english and making you feel that way. My boss needs your codes. it's just that he wants to make it to be more mappings in the table "Mapping". He needs multiple input tables to be transformed to the output table according to the criteria set in the table...

Hi expert Shoji, Sorry for the late reply as i was quite busy during the weekend. Now my boss doesnt want me to take care of the transforming data part. But for the data reallocation like the first coding you wrote for me, He poped out some questions. Can I have several data input tables...

Hi Shoji expert , you know what? it works! thanks a lot , i dont know how to express my feeling but really, thanks a lot!! Regarding the coding above, i still cannot understand why you added the commas for each string and delete it after that. Another question pops out, is it possible to...

Hi thanks for your reply, expert shoji. here is the tables i created. as you can see in the images, the system showed Compile Error. Sub or Function not defined. Is anything wrong with my table setup?

Hi expert spikepl, It's because when we receive data (Excel or Notepad) from clients, the layouts and the headers for each column are different from one to another (Eg: client A's first column is policy number but Client B's first column is Name). So, my boss wants the data to be standardized...

Hi Shoji Expert. Thanks for your reply. But it seems like doesnt work. appreciate if you can explain the code for me , =)

Hi all Access Experts, First of all, I am not a native english speaker, so please forgive me for my poor english. My boss has assigned a task for me to move the details under a field name (eg:[Name]) in table 1 to table2 under another field name (eg:[InsuredName]). Previously, the software...