Recent content by abenitez77

It is working for me with 1 issue. The first time I type a value it works fine. On the second attempt on a new row, I type a value and nothing comes up (it is blank) but when i scroll up and down with my mouse it refreshes the dropdown and I can see the values. How can i get it to refresh? I...

Thanks! this worked and helped me a lot.

I have a form in ms access 2016 with a subform in datagrid view. In that datagrid, I have a column that is a combobox and I am filtering the values as you type. It works for the first selection, but when I make my selection and I want to either go to the next record and make another selection...

I have 4 sheets in my workbook and I want to rename the existing 4 sheets and then make a copy of the 4 existing sheets. I want to have 8 sheets: 2020 2020Rx 2019 2019Rx 2018 2018Rx 2017 2017Rx This is the code I have so far and it creates the 8 sheets, but I want to create the new ones from...

This is close ...but I need the address of where the Thanks! close and got me where I needed to be. this is what works for me below. I am putting the values in cells E12 thru E15. I now need to copy those values to columns F thru P. But I need to change the Letters accordingly...ie in...

My search below only finds 1 value. It does not stop at the other value it should be finding. The value in the cell is identical to the one it does find. What am I doing wrong? for vrow = 12 to 15 fDesc = loWorkSheet.Range("A" & cstr(vrow()).value) If fDesc = "" then goto NextvRow...

Ok, so let's say I just wanted to export all the records that are filtered on the form? not the selected rows....

My guess is, the user thinks he's selecting all rows by selecting the column, instead of going down and selecting the record selector where it selects the entire row. But I see your point...that does not select the actual record. I just need to educate the user on the correct way.

The user may select the records how you are showing it as well. If he wants to select all, he may select the column, but I can require them to select it the way you are doing it, if it helps. I expect it will be contiguous 95% of the time, but there may be an occasion where it won't be.

I agree with you on the approach, but the "SelectedField" is basically just the user highlighting the rows or the column which then hightlights the rows (in this case only the filtered records on the form). So there's no way for me to identify them and add it to the query.

You can see the column is selected on a filtered set of records:

I have a form that has a grid and in that grid, rows are being selected.

I have a table with a column named VendType and it has 3 values ("FS", "EXP, "DSD"). I want to export the records into 3 separate spreadsheets by VendType. I also only want to export the rows that I select from a grid on the form I am on. The form could be filtered and possibly have rows...

This worked! I just had to add a missing comma and parens: Format(Abs([CreditMemoAmount]), "- $#,###.00") Thanks!