Search results

Very valuable information. I'll take a look when time permits. The problem is we are getting these files from a large organisational customer and they are not well structured with lots of long text fields containing many blanks between textual info and the structure of the text file may change...

It works. Thanks. What is the other tip?

If I run the code Dim Forname As String, OriginTbl As String, CSVInput As String, Proc As String CSVInput = "OrInput.csv" OriginTbl = "OriginalTbl" Proc = "ImpBank" If fExistTable(OriginTbl) = True Then DoCmd.DeleteObject acTable, OriginTbl End If...

Hi Folks, The docmd.transfertext command is promising probably it will do what is requested from me. But to have a clear answer I have to sort out some details. This Import Specification file is stored where. Can somebody tell me please. Thanks a lot to all those contributing to the solution.

Thank you for the quite useful tip. I tried the command and it brings up the wizard. Now it is necessary to create a task which is probably a batch file where the initial parameters are stored so that the user can simply run it. However due to whatever reason I get the error message " The...

Hello Experts, Is it possible to have a command button on a form to run the Text File Import Into a Table Wizard? Thanks.

Well I think we are going out of the limits of this thread. This can be the subject of a separate discussion.

Well this is a matter of terminology. Essentially there are two environments: 1. Where you do your design, testing, development, etc ie everything in the IT shop hidden from the user, if I may call it that way. 2. Where the actual users and live data are, that is the operational...

The first commandment when developing an application is to keep the development and operational environments separate. When you do that you never have such problems. The second commandment is to keep the programs ie modules, forms. macros, queries, reports separate from tables. This is why we...

Good, but I believe there are much more politer ways of saying that. Well now enough of that back to work.

It worked Cotty42. Thanks a lot. Oh Plog, please stop being aggressive. What does that have to do with my or your father. We are trying to solve problems here.

Hello Experts, I have an application where the programs and data are split. Now I have to add two more tables to the application. These tables are sitting in the frontend. How can I move them to backend and make them linked tables. I moved them to backend. Then tried with the link table manager...

Sorry Folks, I had to work on an urgent problem where there was a crush in real time system. Now that I am back I looked at the case and this last suggestion paves the way to the solution. Thanks a lot folks.

Hi All, I have a string where alphabetical and numerical characters are mixed up. I need a string function where I can find the index of the first non-numerical character. I tried with the mid function but could not get it to work. Help please.

Both links are very useful. Many thanks. Now I have to do some work on the code. In case I have further related issues I'll come back.

Hi All, Due to form initialization I have lost a lot of time. I have been looking at the forums and tutorials trying to understand the obvious and implied differences between load, open, activate, gotfocus and current commands for a form. From what I understand when the form is loaded for the...

I have replaced the sub Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) by the code given below which is based on your code Private Sub Report_Load() 'Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Dim rpt As Report_AROLAB01 Set rpt = Me...

Yes the hint looks promising. Shall I put them inside the sub? Stupid question. Of course there to be able to change them. But how do I access the properties of the controls on the report. Could you please give me a few examples. Many thanks.

OK. I understand that perhaps the subject is not clear. I shall reword it and hopefully and will get an experts attention. This is what I am printing on the label:=(ConCarte([CARTE])+Chr(13) & Chr(10)+ConLab([MR],[NOM],[PRENOM])+Chr(13) & Chr(10)+[RUE]+Chr(13) & Chr(10)+[RUEBIS]+Chr(13) &...

Hi All, I have a form which gets information from the user and upon pressing a button I produce address labels for the user. The form calls a report which does the job. This works. Now the user would like to have parameters like fonttype, fontsize and fontcolour together with margins, row and...