Search results

Journey of life gets it. This is exactly what I'm doing. I avoid canned fruit in heavy syrup, and any veggies in a sauce. I eat canned fruit in juice only, and plain frozen veggies. I make all my meals except lucnh (where I eat frozen low-fat meals). My goal for each meal is less than 8g of fat...

Win XP I upgraded from Office 2003 (Outlook 2003) to Office 2010 (Outlook 2010). I went from a local PST file, to using Google mail. When O2010 starts, it asks for a profile name, and it shows my proper Google account. Under the Options button, there is one checkbox that says "Set this profile...

Before the Iphone came out, I bought a Archose Jukebox 6000 (audio only). It was the best price per GB that was on the market, and they still make great products too. At the time, 6GB cost me $300, which was a great deal. And it could act as another computer hard drive (it contained a mini hard...

Is this a one time deal with one file? Or a repeating problem with many files? Are you writing software to read and process this file? If so, have your software ignore the last line.

Just a general idea here. But write a DOS batch file which runs forever in a DOS window. Have it do these steps: 1. Check a directory for a TIF file. If there is one, send it to a predefined email address. You will have to find a DOS email program to do this. 2. Wait 500 seconds. (I think the...

I use the Firefox add-in called Leechblock to block sites from my son. I can also allow him 15 minutes every 2 hours to be on those social sites, so he can take a break from homework, but still limit his wasted time online. I also run the Leechblock support forum. With LB you can type in...

Under Code Window, Tools, References, if you have the same DLL name checked (under different directories) you will have a lot of problems. Your screen shot shows you have the same DLL (msjet40.dll) but in 2 different directories, so I wonder if that is a list of references that are checked.

Well, here's my workaround. Apparently E2010 doesn't like the wb variable defined as a Workbook. 'Dim wb As Workbook Dim s As String 'Set wb = Application.ActiveWorkbook ' No longer valid in E2010. s = Application.ActiveWorkbook.FullName s = Replace(s, ".xlsx", ".dat") s = Replace(s, ".xls"...

Nope. The open worksheet is actually .xls. I must have edited my question after you posted. The error I get is in the below line: "Object not set" I think was the error. s=wb.Fullname ' <== Error here Also, I may be opening .XLS or .XLSX workbooks. In either case, that is not my problem. The...

This is a macro which saves the current spreadsheet tab as a tab delimited file with an extension of ".dat". It does not work in 2010. How can I convert it to work in 2010? Dim wb As Workbook Dim s As String Set wb = Application.ActiveWorkbook s = wb.FullName ' <== Error is here s =...

Thank you. I installed A2003, and it also linked the MDB files to A2003, which is what i wanted. Then I started Outlook 2010, and it did not ask me to install Office 2010 again. At which point do you think Office 2010 will try to reinstall? Because the reinstall will link the MDB files to the...

So, I have to use A2003 for all my Access development, as Access 2007 and 2010 are both unusable to a programmer. So I upgraded Outlook by installing Office 2010, but it deleted all files related to A2003. So, my question is, now that I have Office 2010, can I now reinstall A2003? My...

Are you sure you closed your recordset when the model form gets closed? If the recordset is still open, it might disable the print button. Just a guess.

1. This report does complex calculations, so it would be a bad idea for me to duplicate this code somewhere else. Because if I duplicated the calculation code, the chance of having a difference is about 100%. 2. This report prints details on salesman commissions, with a subtotal for a product...

A2003 on WinXP I'm in a situation where I need to open a recordset named "summset" when a report opens, in a Group1_Print event I need to save records with summary totals to an existing table "CommSumm", then when the report closes I need to close my recordset. I need this opened recordset...

"Error 2465: Access cannot find the field 'Field1' referred to in your expression."

I made Report1, and in the report's VBA code I can read a field from the query in the recordsouce by doing: If (Me!Field1="03") then ... I created a second report from scratch, and copied all code from Report1 to Report2. Report2 has the same appearance except the query is different. But now...

Hello, First I used to work in a school as a computer programmer and I wanted to tell you that posting student names and student IDs violates school rules for sure, and may also violate state or federal laws. You could lose your job for this. Plus you have posted the school name, which are all...

A2003 on Win XP I have a report organized with a group called "CommGrp": CommGrpHeader Detail CommGrpFooter My CommGrpFooter contains sums of numbers from the Detail section, but the CommGrpFooter sometimes prints on the following page if all the details fill up the page. How do I get the...

Thank you!