Search results

I got it figured out before I saw your code but you had the right idea. This is my first dance with Recordset so I didn't understand them. Although I don't claim to fully understand them now, my understanding was at least expanded this time around. I learned how to pull the SupplierFolder and...

I guess I don't understand where to put .MoveNext. I tried it but the procedure behaves the same. Private Sub transfer() ' Code to Save Attachment files in designated folder and save path in new Db ' Instantiate the parent recordset. ' sFolder = "C:\Users\gakis\Desktop\Attachments\" &...

1 to 3 is just a cautious beginning. After I am confident its working right I'll go through the entire table. The idea is to get rid of all the attachments so I can shrink the size. walking through with F8, I can see the next record getting 'selected' then the next, then the next. but the...

I've made a lot of progress with pulling attachments out and saving them in the newly revised database that uses the 'old fashioned' method of saving the files in a folder on the server then saving the file path in the database so users can still easily get to the files but the files don't live...

saving the paths in the back end table is working well now. I'm still working on a procedure to transfer the existing attached files to the folders with the file paths saved in the retooled Db. Ill need to work on it some more before I can formulate a specific question. At least now I can...

Thank You Loads. I never would have guessed that one.

sorry for late reply. After getting that irritating issue fixed I was of to the races making up for lost time. Yes, just making it not last helped a lot.

Sorry, I totally forgot that I had it password protected. Also I need to make a smaller version of the BackEnd so I can upload that as well. Thanks for your patience.

I looked around and ididn't see where to edit the default date format. do you know where? The only other thing I could think of would be to recreate the wheel and make your own. Create a table to hold the individual entries, add a column attaching it to the record, in my case there is a...

I could get a zipped version to fit. You won't be able to run it because it uses a backend which is very large.

Sorry that I wasn't clear but it seems you were getting close to what I am looking for. in the article it showed the table and it showed the date and time column. I'd like to change the format to a shorter one. say "12/12/20 16:47". I want to make it shorter so more fits in the control.

I found this answer by DBGuy from a few years ago: Works great. Now I would like to remove the time stamp and/or change the date/time format so that it is shortened up. I love the feature, just don't want to use up all that real estate. I had tried doing surgery on it with Mid text string...

Sorry, getting used to using code tags Private Sub cbonewEmail_GotFocus() Me.cbonewEmail.Requery End Sub Private Sub cbonewEmail_NotInList(NewData As String, Response As Integer) Response = AddNewToList(NewData, "tblcontacts", "Other", "Email List") End Sub Private Sub...

I also threw in code to requery on GotFocus event. Private Sub cbonewEmail_GotFocus() Me.cbonewEmail.Requery End Sub Private Sub cbonewEmail_NotInList(NewData As String, Response As Integer) Response = AddNewToList(NewData, "tblcontacts", "Other", "Email List") End Sub

I already have that part. I can successfully add the new item to the rowsource table. The issue is the behavior after that occurs. The form goes into new record mode rather than adding the new item to another text box.

Its like you knew.... Yes you are correct. I am using the after update to accomplish the task of adding the selected email to the text box(collection of emails) Also, I want the newly added email to go there as well. I haven't coded it yet as I wanted to get past this speedbump first...

Its the simple things that are most frustrating. Trying to use a dropdown for a user to add an email to a list of recipients. It works mostly, user clicks the arrow on the combo then clicks on one of the emails listed then the email gets added to a text box which is a collection of emails...

Yeah, that totally didn't work. So pretty much like I was doing it except the new table lives in the back end? I'll try that and see how it goes

It was basically a mistake on my part. I got some of that code from online which launches the file picker, saves the file and the path. So I stitched it into my existing database. the code to do that should be in the front end. I just made a new table in the front end and had the code put...

Sorry, I'm not clear. I mean that I don't know at what point the scope of the original 'issue / problem / challenge' ceases to be the original and becomes a candidate to be a fresh new thread rather than just a continuation. Your help has definitely moved me past the place I was stuck. So now...