Recent content by ralphyehle

I am using Office 2010 Access and Excel software. And use the TransferSpreadsheet method in VBA to export data from an Access database into multiple spreadsheets located in workbook files. Can I autofit the columns of my spreadsheet as part of this VBA code? Or can I include a VBA module to...

thank you for pointing out the DMax function. Your database example opens for me missing tables, TBL_Client and TBL_Items.

I am appending different types of rows to a table. I want to create a number for each row that starts with one and then consecutively numbers each row after it. The issue is that there are four different types identfied by a field with a 1, 2, 3, or 4 number code and I want the numbering to...

Excel 2010 - Microsoft Access Driver question upgraded Excel to 2010 and Access to 2007 from 2003 and now this code produces error message: [Microsoft][ODBC Driver Manger] Data source name not found and no default driver specified - How do I fix this? Private Sub btnPageLoad_DblClick(ByVal...

We recently upgraded to Office 2010. I want to send an email to a list selected by a query. After highlighting the query I use menu "External Data" to merge with an existing word document. A window prompt opens that asks for the Mail format: If I select HTML and click OK, everything is fine...

thank you to both of you for help. Turned my head around how this works. And got it to work! Yah

At the music school students study violin, viola or cello. Based on their instrument they have three different piece lists. I would like to create a combo box to display the pieces. I can do that with a separate box for each instrument's piece list. What I need help with is how to create a...

Thanks much to both suggestions. I've got it working now. Ralph

Hi, I want to calculate student's current grade levels based on their birthday. If todays date is 04/11/2008 then calculate the most recent past September 1st as 09/01/2007, use that September date minus the students birthday, to find age as a whole number and from that, calculate the grade...

problem fixed thanks for the simple fix.

My calculated unbound field 'txtTotalCost' does not add the fields that people use to enter data, if the $0.00 in any one of the fields is deleted. The calculated field sums five bound fields, if one of them is null, then the calculated field does not add the other 4. The default value is set to...

help most appreciated The sample frame with date table we create each month is not used again, it is a record we are required to keep for three years. A quality control sample of cases is drawn from the sample frame each month. I like the idea of the button to create a copy with todays date. I...

Once at the beginning of each month I extract all new cases from last month into a table. The table has a generic name as I repeat this step monthly. I would like to save or archive the data each month without having to manually copy and paste the table and rename it, prior to the new...

The spreadsheet I want to import various ranges from is hidden, and titled 'Data.' Example: "Data!A7:AC7" I've successfully done this with another vary similar workbook which was originally designed in 2000 and saved as into the newer 2002 Excel format. Hows the Excel Object Model work? I'll...

I am trying to import an Excel2002 file into Access2002 using the import wizard. There is a hidden worksheet named 'Data' with 5 ranges defined (Page1-5), one of which I am trying to import: I am getting the following error message – “Import Spreadsheet Wizard -- The wizard is unable to...