Recent content by twcaddell

Doc, I had just discovered your solution prior to receiving the email. I did indeed have a form activate where I set the tab index number based on the contract name. I forgot to include the elseif statement for the new contract. Again, thanks for taking the time to provide me the answer.

Hi All I have a "Main" form that has multiple pages to it. Three of those pages have the same functionality in managing our contracts. All three forms have main subform that lists all the jobs under that contract and a second subform that lists the specific data for the job that is selected...

I did place the rst.movefirst before the copyfromrecordset to no avail. I then saved, quit access and restarted with success. Guess too much junk in the buffer that it couldn't decide what to do. Thanks for the suggestion TC

I have a procedure that passes a subform and creates a recordset using the subform's recordset. I then use copyfromrecordset to write the recordset to an excel file, but it does not work; however it does not cause an error and the procedure continues. I put a debug.print to see if I can access...

Another option is to pre-process the Excel File, place into the proper format, save, close and then perform your transfer

Hi The remote data is the authoratative data and will not be updated by the local database calling for the data. The local data (read-only) is used for reviewing the data on line and compiling reports. Reports are always a month out (January's report created end of month uses Dec Data) Not...

I have a requirement to display in a subform data from remote tables in an access database (900 miles away). I do not want to link the tables because one table is quite large, the time to connect lengthens time my system is ready, I only need a subset of data (a month at a time) and I only...

Spike - Noted. Will be more descriptive in my title and will look up how to pass dates Gemma-the-Husky. Will follow your suggestions as well as look at collections vice an array

:banghead: As the title states, I have hit the wall. I have two class variables (both arrays) among about 10 other class variables, that are not returning any values but "" for the string or #12:00:00AM" for a date. Here are my class variables: 'UPSData Class Module Private p_LetterArray() As...

In reading further on in the forum, someone suggested that convert the column to text. I tried it and it worked. Not sure why the other way wouldn't work though, but it is solved for now.

My organization contracts out to a 3rd party for a service. They send a list of invoices during the month, listing their job number, our Purchase Order Number, a description, the cost and date completed. I have a file that contains 5 excel worksheets. My routine determines the names of the...

The reason I say that is because the data matches a spreadsheet that was submitted in 2012. Thanks for the info though TC

Namlian, Thanks for the suggestion. Opened the file and read it because I didn't know you could do what you suggested. Will read up on it. Again, thanks TC

Not sure whether to post to this forum or excel, so I posted to both. Background We receive from our vendor data in an excel file that lists PO number, Date and value. I have outlook (via a rule) save the file to a network drive. In access, I have a button that is to start a process that opens...

I have a complex database app that has a form called from the main form. It requires two inputs: BeginningDate and EndingDate and I use a calendar picker for date selection. Using data assigned to a variable, I build the SQL query in VBA. The result is: SELECT [1733_All Print...