Search results

I have tried what you suggested but I have no such fields as Parking 1 or Parking 2 There are 2 fields: Name and ID I would like to write the values of ID grouped by Name next to each other separated with a semicolon, like 1;3 So based on the above example end result should look like this: Name...

Dear All, I have a table that looks like the following: Name ID Parking 1 Eating 2 Parking 3 I would like to get the below, if possible with SQL, if not then with VBA: Name ID Eating 2 Parking 1;3 Your help would be very much...

Thank you very much!

Dear All, How can I create a form (based on a table) that has certain fields in the header and certain others in the body and at first I fill in the fields in the header then if I insert new records in the body, the fields in the header will not be null, but keep the ones I used when I started...

Dear All, I have a form that I want to print In the print preview window I do not get any error messages, stating that the width or height is too big and still if I want to print it, it starts printing 105 pages instead of 1!! (as the form fits perfectly on 1 page I have no idea why Access...

Hello! Thank you for the replies! The Inputbox method works fine! However, when trying to use the command button wizard, I cannot see the option mentioned by Uncle Gizmo, after choosing Open Form, the wizard only asks me which form I want to open, then which records I want to display, then the...

Dear All, I have a form that shows records of a table At one field, if the word "petrol" is entered through a combo box, a new form pops-up, asking for a number (how many litres) The problem is that whenever this latter form is filled in with a litre, that number goes into a new record and not...

Hello, I managed to get another code for this problem: Sub splitter() Dim dbCurr As DAO.Database Dim rsOld As DAO.Recordset Dim intLoop As Integer Dim strSQL As String Dim varReps As Variant Set dbCurr = CurrentDb() Set rsOld = dbCurr.OpenRecordset("TableOld") Do While Not rsOld.EOF varReps =...

This looks really great! My only problem is that unfortunately I am not an expert enough to know how to finish the code, I tried the following: Sub split() Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs = db.OpenRecordset("input") StrItem = rs!Entname 'Step 1: Where...

I would need to use all 4, but, for example I am not interested in CASHCOLLECTION, KEYACCT, etc For me those ones are important where all 4 arguments are filled in So I still need to get this field apart somehow to be able to work with it

Hello, It is not a problem if we dont know which field is which The aim is to get them separated and put them into those fields as shown in the screenshot Many thanks in advance

Hello, I checked the above code and basically what it does is that it creates a new file, parsing the first column In fact I would like to add as many new fields to the input table as many output Split makes and fill them in with the output of Split Here is a code I was trying without...

Thank you very much for the solution!! :)

Thank you very much for the solution!!! :)

No problem, thank you for trying! ;)

Hi David, I tried your solution but it still does not work, the data was imported the same way, the first field contains the string and was not parsed to separate columns Maybe I did something incorrectly? (screenshot attached) Many thanks

No I am saying that the first field (EntName) has values in this format: text1_text2_text3_text4 which I would like to parse to separate columns

let's try this one then (I renamed the csv file to txt)

Of course, sample attached below

Dear All, I have a csv file that is separated with comma values so I can import it easily into Access But the imported table's first field contains a text string which is delimited with _ characters, eg: text1_text2_text3_text4 Could you please advise on how I could parse that field to...