Recent content by sig331

I have a macro that exports data from Access to Excel. Data is grouped into weeks and each week has five columns. Header information associated with the entire week is merged across the five columns. The users selects a range of weeks and the macro loops through the appropriate number of times...

I am trying to append an Excel file to a table. The append actually works, however, I get an error message. It says: "Microsoft Access was unable to append all the data to the table." Then it says "The contents of fields in 0 records were deleted, and 0 records were lost due to key violations."...

sSource = "C:\Gundog Training Databases\BackUp\" & me.BackUpName

Thanks, I like this approach. All the code is in one spot and easy to manage. Works great.

Something like this? Add reference to Microsoft Scripting Runtime Library Dim FSO As Scripting.FileSystemObject Dim SourceFolder As Scription.Folder Dim FileItem As Scripting.File Set FSO = New Scription.FileSystemObject Set SourceFolder = FSO.GetFolder("C:\Path\to\directory") For Each...

If the first form is still open, you can pull values from it into the second form. Me.MemberName.Value = FirstFormName.MemberName.Value

Hi everyone. Long time reader, first time poster. I have searched and searched for an answer to this question with no avail. So I thought I would ask. What I have is a form with 21 sets of textboxes, each set represents an item. The goal is to have the item information populate in the other...