Search results

Hmmm. Don't know what's happened by I closed Access and went to lunch. Now I've opened it up again it's working with acSpreadsheetTypeExcel12xml and .xlsx extension Weird!!

Hi Ranman. I need the output to be Excel 2010 with .xlsx extension. I can use acSpreadsheetTypeExcel9 and .xls but for various reasons we need to be using 2010 with .xlsx

Hi All, I'm working with Access 2010 and am trying to use the transferspreadsheet command to output data in a query to an Excel 2010 format file. Here is the line of code: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "q_calldetails_tmp", "c:\temp\testoutput.xlsx" It...

I've made a small step forward where I read that there is an issue with a calculated control on a main form that references a control on the sub form. This recommended that you first create the calculated total in a control in the footer of the sub form, then on the main form have a control...

Hi JHB. I've worked out the differences and got my form working as required now. Just tried to do something that I assumed would be very simple and it hasn't worked. I've had a price column to the products table and included that on the sub form. I've then added a text box to the main form so...

That's exactly what I was trying to do :) I'll have a look at exactly where the differences are. Thank you!! Cheers, David

OK, thanks. I'll have a play with that. The form was created using the form wizard so I sort of hoped it would end up giving me a form that could be fully interacted with!! Thanks, David

Hi All. Grateful for any help here. I've attached a simple database where I have two main tables - Products and Packages. A package is a selection of products. I think the database structure is correctly normalised with a link table that joins a single package ID to multiple product IDs...

OK thanks. I'll give that a try later.

Thanks CJ_London. The SQL side of it all makes sense. Now the next challenge, how to actually put it in to the VBA code!! I thought this would do the trick to just get a message box popping up to see if it had found the correct value. But this errors with runtime error 3065 saying I can't...

Hi All, I've imported some historic user data from some spreadsheets and I have a field which is a unique PIN code for each user. This is set as the primary key on my new table. Duplicates are not allowed. It's a text field with values ranging from 0005 through to 9576. The maximum allowed...

Hi All, I've found a couple of old posts about this but nothing seems to work correctly. I've succesfully linked an Outlook Contacts database to my Access application and created a form that lists contacts. But I now want to open the Outlook Contact form with a specific contact selected. It's...

That's it!! Yes, that's working great. Thank you for your help.

Hi Spikepl 1 - I know that from a DB practice it's best not to store calculated values in the DB but for various reasons this is what I need to do. 2 - Which brings me back to where I started. I can't find an event that fires correctly to update the pupiltotalhours with the current value of...

The text field on the main form is updating. But that is only there as a method that I found to transfer the total from the sub form. But what I'm trying to do is to update the actual database field called PupilTotalHours which is in the table Pupil_Details. All I'm actually trying to do from...

Hi Spikepl. Yes, the two text fields are updating correctly. But I'm trying to get that value in to the bound field on the main form - PupilTotalHours and save it to the main Pupil record. Haven't found any way of getting that to work properly yet. Thanks for your help.

Thanks both for further help. I've tried renaming the bound field and prefixing it with txt but that still didn't work. Copy of database attached. I've removed the various code attempts.

Hi and thanks for that document. It's really useful (why don't you find this stuff in the actual software documentation !?!). I'm still not having any luck. At the moment I have the following: Private Sub Lesson_Length_AfterUpdate() Me.Parent!PupilTotalHours = Me.SumOfHours...

Hi. At the moment there is nothing that is actually assigning the value in the TempSumOfHours field to the actual bound database field. So are you suggesting that I need something like the following in the AfterUpdate event of the Lesson_Length field and/or AfterUpdate event of the whole...

Hi and thanks for the quick reply. Not quite sure I've followed what you suggest. I always thought a requery was to refresh data from the database itself. Here's more info on the data and forms. Master table name - Pupil_Details Field name to hold total hours - PupilTotalHours Child table...