Recent content by mr.donaldson

Hope this easier to follow. Private Sub cmdCopyFiles_Click() Dim CheckFile, FileFound As String, AllOk As Boolean, i As Integer, ErrMsg As String Dim sDest As String, strFileTemp As String, FileExist As String Dim ctlList As Control, varItem As Variant, posn As Integer...

You are both correct. I'm getting the files that do not exist as opposed to the files that do exist that share a common filename.

I am hoping to get some help to get me through this issue. I am trying to copy files from a listbox to a directory. I need to check if a file exist and if it does, append to the existing file. The filenames are similar in that the source file is "TESTMAIN60" and the destination file is...

I have a form built with multiple buttons. Once the user clicks the button and enters their parameter, I am using VBA to export the data to an excel pivot table. I would like to turn the subtotals to false so as the user clicks the check boxes in the pivot there are not any totals...

I have a form built with multiple buttons. Once the user clicks the button and enters their parameter, I am using VBA to export the data to an excel pivot table. I would like to turn the subtotals to false so as the user clicks the check boxes in the pivot there are not any totals, subtotals, or...

Is it possible to set multiple conditions across multiple tables using OR in a where clause? For instance, can you run where......(table1 = 'test') or (table2 = pass) or (table2 = "fail) AND (class = 'SQL');

I have a table called workorder_data with a field called workorder. A user enters their workorder number followed by a respective code (123456789-AD, 123456789-BC, 123456789-CD, 123456789-TC, and 123456789-PTC). I want to pull all the AD and BC workorders into their own separate columns. So I...

I have 1 table that I duplicated to make 3 tables total. I did this b/c I am trying to create separate columns from the same field and table. The field is Workorder. Each workorder list the workorder number followed by a dash and then code. I am wanting to put all of the workorders with the same...

I will try what you suggested. Im very new to all this so I am trying to figure out how to put that in my query. Thank you for the help.

Thanks to anyone taking the time to read this post. I am fairly new to Access and SQL so I am doing my best to work through roadblocks on my own before seeking help. However, I am at a stand still. I have a table called Coded_Data with one particular field called Codes. This field list a...