Search results

That worked (I think the other should have). Now let's see if it will keep on working :)

On the main form. The excel file opens correctly but won't load the fields.

Now this doesn't work again.

Finally got this to work by importing the form with a working version from another copy of the db. I spent several hours on other aspects of the design and functionality of the form, so I was reluctant to do it this way. However the above code works the way I want it to. Now the question is...

Something really weird is going on. This is Access 2003. I have a procedure that uploads from Access to Excel. The button is on the main form frmTransactions, but the information being uploaded is on a subform frmTransactionsQe. The subform control is ctlQeSites. I have a number of text...

Thanks again Bob - works perfectly!

I seem to recall somewhere that Microsoft forgot that 1900 wasn't a leap year. This meant that all calculations after 1900 are out by one day (unless they've fixed that): http://en.wikipedia.org/wiki/List_of_leap_years

I have a form frmTowerLog with a text box called txtFILENUMBER. When I double click on it this code fires (thanks to Paul's site): Private Sub txtFILENUMBER_DblClick(Cancel As Integer) DoCmd.OpenForm "frmTransactionsMain", , , "txtFILENUMBER = '" & Me.txtFILENUMBER & "'" End Sub However it...

Thanks for the interest - it was the Visible property that was the culprit.

Doh! and double doh! Boy do I feel dumb. Thanks for looking. That was supposed to be on the tab control. That explains why a new form worked too. I'm glad I posted the stripped version. Go Red Sox (if it can't be the Jays)

:mad:A new problem has cropped up. My form is opening blank. I have tried compact and repair. I imported everything into a new database. I have checked the query to make sure it has data. I have checked the form's properties to make sure Data Entry is set to No on the main form AND the...

Thanks for this ..

Eureka! :D:D:D:D:D:D:D:D:D I had a .Value that I didn't need on one of the fields being uploaded. I remembered from an earlier post of mine that you answered that it wasn't necessary. I took that out and it works like a charm. I can even download from Excel now thanks to the info from...

I did that. And for good measure I did a restart.

Anytime you're in Toronto pm me and we can get a coffee. Can I impose on you for one more question? I copied over the changes to the code, but Excel doesn't open now. I made sure the file is in the C:\I don't think anything has changed, but your eyes are better than mine: Private Sub...

Thank you Bob. That was it. I should send you over to my relatives in Oregon for your favourite brew - tea, coffee, ale whatever. (Are you near Portland? - they are in Beaverton.) If you're ever in Toronto, I could treat you to a Tim Horton's coffee.

Maybe you can spot something. I have stripped out the db, but left the code intact. I have commented out the fields that I eventually went to load (once I get this right).

Yes - it is selected.

I have also tried creating a new db and importing the objects as well as compact and repair db. WRT determining what line that is the problem, I am assuming it is the control reference, since Excel opens the way I expect it to. It's just that the data is not getting across to it. The error...

Yes - the control name is ctlQeSites and the subform name is frmQeSites. After reading the example on your site and the other references in the forum I made sure the control and the subform had two different names. I did lie about the subform name - it is frmTransactionsQe. 2. If not using a...