Search results

MajP, it worked! I have several continuous forms and will use this method. Thank you.

I have a continuous form with an edit button. On the continuous form, there’s an edit button for every row. I want to be able to highlight the row of the continuous form, store the row ID in a string, and then click the edit button to edit just that row only with the other rows locked. Is this...

You were right. I didn't need the insert. It's writing to the subform and saving to the table. I moved the focus to the subform, then me.dirty = false, goto next record is working. but sometimes it says it can't go to the next record. Sometimes it works then it stops working with the error...

Thank you everyone for your help.

I have a popup form that has data entry input for the fields Trail_Code and Trail_Desc. The form has a “+” sign button to add the data to my continuous subform, which it does. The problem I’m having is that it only writes to one row of my subform. When I do another manual entry and click on the...

Thanks for the attachment. I think this is what they are looking for. I'll give it a try. Ben.

Wow. Thanks!

Thank you.

Thank you.

Thank you. Yes, you are correct. But I've been given an existing database and told to map out what it does. I'm looking for the best way to do it. In Excel, I started with "This button updates tbl_green based on type code. " But it's just words. Should I create a flow chart? Just wondering how...

Thank you.

Thank you. I'll take a look.

I have been given a legacy database and need to map what the VBA does and what tables are affected when a button on a form is clicked. I used the object dependencies, but it doesn't get down to what happens when buttons are clicked to show when tables are updated. Is there a way to map this? I...

Just one row in Access. Ben

Ah, I see where I need to explain more. Yes, Gasman, the data in ExcelCVS looks like your column 2. I would like to import it into Access so that it looks like Column1 Column2 JPWestfield 8/1/2019 Ben

Hello the DBguy, I was thinking about that. But the Excel CSV data is in rows. The append in Access inserts into columns. I'm trying to get the row data from Excel into columns in Access. Like: "JPWestfield" is in row 1 column (B1) in Excel CSV "8/1/2019" is in row 2 column (B2) Excel CSV I...

I have a CSV delimited file with row data that I want to transfer to MS Access columns. MS Access is already open; I have a button on Access form to import Excel to the table. For instance, In the CSV file cell b1 and b2 have this data: JPWestfield 8/1/2019 Customer and date are columns in...

I have created an Excel Template. In Access I export data from a query to the Excel Template which works fine and it opens the Excel template so I can see the data that it exported. With the Excel template still open, how do I, with VBA, insert a blank row when column A date changes? Example in...

You are right. The Parts table is not normalized. I'm trying to create a temp table but need to split the customer and PN and then write to the temp table. The splitting is where I am stopped. In the meantime I am creating a normalized CPN table that has the splits but it's very manual. Then...

Thanks. I'm looking up the split() function. Ben