Search results
-
Payin' Cost for using Attachment
quiet morning so I had a chance to try it. I did put it in its own module so I had to change me. to point it to the control that has 'assigned vendor. There was a minor typo that is fixed, SuppFolder > SupFolder. Testing I found the 'assigned vendor' got added to the filename and the file... -
Payin' Cost for using Attachment
Thank you very much. I am going to try to try it out later today and I will let you know how it goes. -
Payin' Cost for using Attachment
Yes my Db is HUGE! because I used attachments in all the wrong ways. I retooled my Db so now it stores file paths instead of files. Now I need to migrate a LOT of attached files to their new proper location and store the paths in my newly retooled Db. One of the fields in the record is now... -
Filter on load not working correctly
Thank You for your contributions. -
Strange behaviour - filters are not remembered between loads
Yes, I know how to apply a filter that I create. I really wanted to be able to bring back the filter that was in place. I have a popup form that the user can push buttons to filter out big groups of data. For example the users create the records they are looking at so one button is for them... -
Strange behaviour - filters are not remembered between loads
No, I hadn't noticed it was old. Ooops!. but thanks for the response. It took a lot of 'trouble shooting' but yes, I have validated after several attempts that clicking the save icon works to have the filter settings 'take'. I tried SendKeys "^S" but that did NOT work. I have had some... -
Filter on load not working correctly
I tried SendKeys "^S" But it didn't work -
Strange behaviour - filters are not remembered between loads
SendKeys "^S" didn't work -
Strange behaviour - filters are not remembered between loads
found the info on replicating keys https://docs.microsoft.com/en-us/office/vba/Language/Reference/user-interface-help/sendkeys-statement -
Strange behaviour - filters are not remembered between loads
sounds like you are getting exactly what I did. Sorry no great solutions to offer. I was having luck clicking the Save Icon which is probably exactly the same as Ctrl+S you are doing. But, of course, that is not a serious solution to the problem. I had gotten a suggestion to just have the... -
Strange behaviour - filters are not remembered between loads
I can say, if it is the same thing I am experiencing, using DoCmd.close… acSaveYes does NOT work as I tried it. Somehow saving the form is not the answer. In my thread I mention that if I click the Save Icon (which looks like it might be the same as Ctl-S noted above) then the filter settings... -
Filter on load not working correctly
I think the 'filter left over' is whatever filters were on the form when the Save Icon got clicked. That was my experience. If I set the filters the way I liked them then Clicked the Save Icon and THEN closed the form, I could later reopen that same form and the filters I had set up were in... -
Filter on load not working correctly
Thank You for your comments. I had been hoping to take advantage of the Filter On Load so that I could avoid the extra code to do this. If I end up going this way, your code will be very helpful. I was wondering how I could save the filter and the idea of a table is helpful. One other... -
Filter on load not working correctly
Part of me wants to solve the original problem out of spite but I have to admit that just turning the form off visibly does achieve what I need to do as the only reason I was closing it was to keep blinders on the user. My controls pass the user form A to B and back again so instead of closing... -
Filter on load not working correctly
Thank you for your input. I had actually already read that one trying to figure this out. That last section where it talks about Filter on Load is what I am trying to do. But I am finding it doesn't really work that way in real life, or I am not understanding. I WANT it to just apply the... -
Filter on load not working correctly
I want to utilize the Filter On Load. I have a datasheet view form that a user will use to look up a record then click to launch a form that shows detail for that specific record. There is a field in the datasheet form that had a click event which opens the single record form. When the user... -
Next click the second radio button which says "Append a copy..." There is a drop down where you...
Next click the second radio button which says "Append a copy..." There is a drop down where you choose the destination table. Click OK then the magic happens.- gakiss2
- Profile post comment
-
After you get the excel 'table' matching the table you want to attach this data to then just use...
After you get the excel 'table' matching the table you want to attach this data to then just use the Access Import function which is in the External Data tab. after clicking Import from Excel you will browse to the excel file you made(its better if the excel file consists ONLY of the table you...- gakiss2
- Profile post comment
-
The main thing to worry about is that the columns you end up with in the Excel file match...
The main thing to worry about is that the columns you end up with in the Excel file match perfectly with the table you will append to. That means the name of the field/column in the first row, data type (text vs. date vs number etc.) and any restrictions you have put on your table such as field...- gakiss2
- Profile post comment
-
For me, a one time deal is more easily handled in Excel. I am more familiar with it and its...
For me, a one time deal is more easily handled in Excel. I am more familiar with it and its simpler. Export the two tables to Excel (External Data tab). Lemme know if you need detail on that but its pretty straightforward. Using Excel, join the two tables together. Again I am assuming this...- gakiss2
- Profile post comment