Recent content by kweitzel

Hi MinusM, all i tried was using Excel VBA, but obviously, the reference is not on my maschine ... I don't get the runtime error with this ... and it works fine! Thanks a lot ... Klaus

Hi All, i am having a little challenge here (you know there are no Problems, just ...). Anyway: I am having a form in Outlook 98 where I contact a technical helpdesk. In the form I have 2 comboboxes. I want to restrict the choices of the second box depending on the choice made in the first...

hmm ... xlExcel7 gives the same error ...

Hi, thanks for the suggestion. I tried the xlExcel9795 already. Result is the same error. I have yet to try the xlExcel7. I'll get back to work on monday and test. thanks

Hi Gents, first of all a happy new year to all. Now, here is my question: I am importing a Excel Table (Excel 2) into Access 97. Unfortunatly Access 97 wants as a minimum Excel3 for direct import (via the transferSpreadSheet). I generated a piece of code, which should convert the Excel 2...

Hi Lookup13, I have never heard of using Excel Workbooks as templates for this, but why don't you design a report in Access as a fax template? regards Klaus

Hi MePenguin, if I understand everything right, you declare the strings "OldFieldName" and "NewFiledName" in the onClick event (or maybe onLoad or so) as a private variable. You should maybe try to declare them as public. hope this helps Klaus

Is the DLL on your machine? If yes, take care, that it's in the Access folder (If I remember right ...)

I managed now, but I am not really happy with the result, since I open 2 hidden forms based on 2 tables where I compare the fields. Is there anything else I can do to achieve comparing 2 fields directly? Here ist the code: Private Sub bttn_Import_NL_Click() bttn_Import_NL_Click: On Error...

Hmmm ... I read in an earlier post something similar ... but sorry, cant actually remember where, exept that it was in a forum here ... It had to do with select row and column ... maybe try to search for tha. Sorry of not beeing of better help ...

Hi BigMrC, why don't you import the data in a complete table, then run a query where you select the required fields, store the data in a temp-table and the run an appen query? This is sort of what i do in the previous post where i need help. Hope it helps getting you started ... Klaus

Hi Folks, after extensive searching this helpful DB here I have to post a question: I have a Customer Details Tabel which i import from excel. The file selection for the import is done via a module called "fgetfilename". Then I add 2 fields to the table ("timestamp" and...