Recent content by ProgramRasta

I clearly didn't explain the problem too well! The output is the following: Field1 Field2 Field3... I want the output to be Field1 Field2 Field3 As above more horizontal spacing but using a single space. Is there any way to increase the width of the space to say a tab? It's...

Hello All, I was wondering is it possible to adjust the horizontal spacing in a newly created text file. Each of the table columns is separated by a space - what I am trying to achieve is to increase the length of the space. Importantly, the format has to remain unchanged i.e. it needs to...

I see the question has already been answered previously in the following post and the solution worked for me. Import text file with Unicode characters? | Access World Forums (access-programmers.co.uk) Have a good day.

Hi All, I hope everyone is keeping well. I am importing a text file using the DoCMD.TransferText method. My problem is some of the characters in the text file have accents so the characters in the table look different. For example: ú is being entered into the table as +¦ Is there any way I...

Good morning. First of all, thank you to all who contributed, your time and knowledge was appreciated. The above solution made the import almost instantaneous. Have a great day.

Hi All I am attempting to import certain columns from Excel into an Access table. However, I'm getting severe delays in updating the table using the below code. I was wondering if my code is inefficient, Access is just slow at these type of updates or if I'm missing a trick somewhere. For...

Thank you for your time this morning. Have a nice day.

Thanks for replying to the thread. I have found the issue (but not a fix) ImportFileName = FilePath & Dir("FileName*") The ImportFileName is only recognising the FilePath and not the Dir("FileName*") unless I do the manual import. The reason I use Dir("*") is I'm unsure of the full file name...

Hi All I have a very frustrating issue and I am unable to understand why it's happening. I have the following code that imports a .csv file into a database table with the format I want. DoCmd.TransferText TransferType:=acImportDelim, _ SpecificationName:="ImportSpecification"...

Thank you very much. I hope you all have a great Easter weekend. Cat

Thank you for taking the time to reply. Would an auto number column make any difference?

Hi All, I have tried unsuccessfully to create an update query that updates the blank cells with the last non-null cell. In the attached database, the 'Description' field is what I am attempting to update and the 'Required After Update' is the desired result. Many Thanks for your time. Cat.

Thank you for replying. The problem was with a different extract of code. Apologies for wasting your time.

Hi All, I have a problem with a piece of code I'm using that I was hoping someone could provide some wisdom on. The problem is the code falls over when there is nothing to add in rsSource which can often be the case. I can cheat with a resume next command but I was hoping for something a...

Hello, The DateSerial() was the answer! This forum truly has the best contributors. Many Thanks. Cat.