Search results for query: save attachments

I am not sure what you mean by to save all the attachments before moving them? I would need help to modify the above code. Thanks

Since your code is moving the attachment as you save them, you end up skipping every other one. Try saving all the attachments without moving them first, then do another loop to move them.

Hi, I am having issues with the criteria for the query. The instructions are as follows Display all fields for all products with a selling price greater than $10.00 and the number on hand is fewer than 10 Sort the query in ascending order according to the Cost field. Save this query as...

Can you try just saving or displaying the attachment names somehow first to make sure your iteration is correct. Then include code to manipulate the attachments. That's what I would do I think.

This is where i made the key! I have 3 buttons in my form. 1. Is for the new record 2. Is for save the record that i created now 3. is for printing the report

i need code vba to save any attachment to folder outside my database "Behind DB File" called "Attachments" i have 4 fields on my Form "FrmWeeklyRep" and i need to save the attachments to folder outside my database and i have 1 field on my Form "FrmOrder" and i need to save the attachments to...

as i was expecte it, it doesnt work this way. thats why i wanted to save calculated date to a main table, cause and i quite understand why it asks me to input parameter, cause it doesnt know which one record it should get from Qddall query

Hi there. When I run my application the data entered appears in my FORM but not all fields are saved in my TABLE. The field in that are not saved is my BookTitle field which is derived from the combox StudentBookIssue_ID. [BookTitle] Control Source : = StudentBookIssue_ID .Column(1) . The...

Was able to open using Access for 365. Saved in 2000 Format attached

thanks a lot !!!! i appriciate your help. saved me tons of time

Not anything I can make head or tail of?

I have tried this....The record gets saved into MSysResources but is doesn't get and Extension and when double clicking the attachment field the file is not recognized. Any ideas? Thanks for your help

wierd. i removed current combo box and created a new one where i dont even drag locationID anywhere so now i have combo box row source SELECT [Tlocations].[LocationID], [Tlocations].[Location] FROM Tlocations ORDER BY [Location]; form record source SELECT Tmain.[RiskID]...

When I select Max, it gives the same error, as seen below: However, Access changes this to Expression itself when I save and close it. If I change it back to Max, I am getting following error:

Heres this trace. Heres me clicking Save on the form and heres the trace. Note the login user switch to someone else for the save transaction.

Hi all I am trying to import some forms from a previous db to a new one, to save me from formatting and referencing, but I get the following error: I have tried to close and reopen the db, as well as compact & repair without any luck. Thanks for the help.

i am attaching my database file , check the WRITE_DATA( ) function in module "dateSetter", after saving the data in this function i immediately open a form "RegSlip_form" and set the record source "SELECT dataTbl.* FROM dataTbl WHERE (((dataTbl.rollint_fld)=[TempVars]![rollint])); " some time...

That is because you are not saving the report yourself. You are forcing Access to save it and Access is using the only name it knows which is the query name. 1. No need to open the report first. Use a query with criteria instead. We'll tell you how if you can't figure it out. Opening and...

Hello Everyone, I am halfway there following this suggestion https://www.tek-tips.com/viewthread.cfm?qid=1602602 I have an unbounded textbox that calculated the totals between the Parent Form and it's Subform. My form has no buttons to cycle or save, I am using Access's navigation controls...

I do not know what your problem is, it continues to work for me. Did you follow what I said to do? Also this is a stupid way to save Hierarchical data. You really should reconsider your data structure. This does not make any sense and is overly complicated. Again see my thread in my first post.