Search results

Hi everyone. I need your help to the following issue. I used this example : http://www.access-programmers.co.uk/forums/showthread.php?t=165549 and more specific the last one "Using multi select moving". Now I want to put the selected values to a new table and add new rows each time I have a new...

lol !!! Thanks for supporting me on this till the end! Now I have a hard work to do all the weekend to make this work with my real database. As for the xls format it is also a very strange error. Never happend before and I've exported so many files with no problem. I'll try to run the code...

OMG!!!! Can't believe my eyes!! It is WORKING! YESSSSS!!!! I'm so so happy! Thank u so much!!!! But now seems I have an issue with the xls file formatting. When I try to open a file I got the following message: This file you are trying to open, 2224.xls is in a different format that...

Unfortunately nothing changed this time. Well, if u don't mind and have a little time I attach a small sample of my tables. Maybe this will help u find out if i'm doing something wrong.

Hi again! Thanks for u still supporting me on this. The code now looks like this: Private Sub xL_Click() Dim rst As DAO.Recordset Dim db As DAO.Database Dim tdf As DAO.TableDef Dim strSQL As String Dim strField As String Dim fld As DAO.Field Dim objXL As Object Set db = CurrentDb strSQL...

Thanks for your reply! I hope u did well with the dentist. :o Here is the situation now. I did a step further but i'm totally confused. So... I noticed that after running the code an xls file opened and only the header was written in this. And then again this run time error at the module in the...

first sorry for this late response, but we had a electric power cut off due to bad weather I guess. Anyway. The code in the module was a copy-paste so I'm sure it says movefirst. I changed it to movenext but things didn't change at all. Again se same error. Then I changed the SQL lines as...

Well, here is the situation now. I run the code and it opens the xls file and only puts the header. Then it stops and I get a run time error 3021 No current record. When I press debug it leads me to the module at rst.MoveFirst line. I've checked before running the code and excel was not...

Well, I'm not sure I can describe what happened now. It oppened many many workbooks only wrote the header but in some of them added some row data and at the end I got an error message : Unable to get the Open property of the Workbooks class. Seems to get close to a result but still something...

The actual name of the field of the branchholding table is: BRANCH. no queries here. It's name is t_inputBranchList and code is as : Set db = CurrentDb strSQL = "Select BRANCH FROM t_inputBranchList " & _ "ORDER BY BRANCH" Silly me by mistake I had added a branch twice, so I...

Again the same error as before : Ambiguous name detected: SendTQ2ExcelSheets right after the path and highlights the rst!Branch.

There is an error at If Inst error : sub or function not defined

As u said, here we go with the errors...:confused: Well, let me tell u what I've done. I moved some tables into a new db and I checked that all their names ending with _SEND. I created a basExport module that looks as below: --------------- Option Compare Database Option Explicit Private...

I indeed have a table with all the branch numbers and emails. For your other question I work both ways. I have 13 tables as imported from excel and a field named Action where I change to SEND for those I want to email and when finish I send all rows with "SEND". Then I go from table to table...

:( please someone help on this.

Well, I think that this is pretty close to what I'm looking for. Let me describe you in a few words the design of my tables so not to be any misunderstanding. In real I have 13 tables. t_InactiveSEND t_Overrides_SEND t_EMRE_SEND etc each one of them has various fields but the one and only...

up! I would really appreciate if I could have someones' reply on this. Please respond even if it is something hard or imposible to be done. I just need to know so to find another solution. Many thanks in advance.

I could never make it without your assistance. I'm reading this forum since 2005 even though I don't participate that much and I would like to say a BIG thanks to all this support you offer to people all over the world.

and YES !! It is working!! Thank you very very much. Very precious help :)

Thanks for ur reply! After some changes I think I'm close to the miracle. Going a step further and I've managed to create the excel files properly formatted but at the end the whold DB freezes and I have to close and reopen. Any suggestions? Here is the code as it is now. DoCmd.Echo False...