Search results for query: *

There is a Word template that we use that was developed over the last 4 years. It is protected as there are only certain items that need to be added for that particular customer. It gets printed then never saved. It was designed in Word 2003 and has been included on machines that use Word...

Looking at the “Ads by Google” shown on this page I noticed one listed as “Boot Disc for all Windows” its for a product called Power Suite (2010 by Spotmau. Has anyone had experience using this product? I have 2 desktops at home, one for my wife (taking classes online) and one for myself...

We are currently working on migrating from Office 2003 to Office 2007. In our Excel workbooks there are buttons that reference the Personal.xls file like Run("Personal.xls!DoSomething"). I can change the reference in the templates that these files were created from so that in the future it...

This my next step that was started with thread68-1582801. This I felt warranted a new thread. Links in Word are updating automatically, even though with selecting the Office Button>Word Options>Advanced. Then under General, the Update Automatic Links at Open IS NOT checked. Also, viewing...

I have been tasked with updating our programs from Office 2003 to Office 2007. I have noticed on the machine provided that when the "X" is selected in the upper right corner the workbook closes but an instance of Excel stays open. This does not happen with either Word or Access. This causing...

I am currently updating from Office 2003(Excel) to Office 2007 (Excel). With some of our templates I receive a message when trying to convert that "This workbook contains one or more of Line Print Settings". I can save the file without these features. But what am I losing? Can anyone tell...

I have the task of upgrading out programs from Word 2003 to 2007. In one of the programs we copy a pre-existing Word document, rename it open set the page numbers to X of Y using automation from Excel. We then further add to that document ranges from the Excel workbook. With Word 07 it...

I have been asked to upgrade our programs to Office 2007 from 03. I noticed that on footers in Word where I insert page numbering what used to say "1 of -4-" now says "of-4-". In Word Tools>AutoCorrect>AutoText would allow me to see what was available. Now OfficeButton>Word...

SkipVought fumei PHV While researching my latest group of questions your response to someone else helped me. Thanks

Looking for advise in replacing a power supply. I have an older eMachine T3990. I added a second 80gig hard drive and CD drive. Currently it has 512meg of RAM. Use it mostly to covert my vinyl records to CD and to copy the iPod. Or convert 35mm slides to digital images. Have experienced...

We have a database that is rounding and not sure why. Entering a number directly into the field of the table anything less than 100,000 is recorded correctly(99,999.99 is recorded that way). While anything greater than 100,000 is rounded to the first decimal place (100,000.01 is recorded as...

The following code works in Excel and I am trying to change the syntax so that from Access I can control Excel but have had not luck. Thanks for any help. Dim rngcell As Range Dim ActiveSht As String ActiveSht = ActiveSheet.Name intLstRow = Range("E" &...

We have been using the following line for years ExFile.Application.ActiveWorkbook.Close savechanges:=True (from Access97) without any problems. Starting this week we are get the Excel SaveAs box to open. When we open an Excel file from Access the Excel file name is changing (noted at the top...

Hi all. I am using faq702-777 as a guide. My form has 2 combo boxes and 2 subforms. There is a button that opens another form that will have several checkboxes that will allow the user to select 1 filtering critera. There is one unbound textbox for them to enter the critera. The following...

Hi all-- Have a form bound to a table. The form has one text box. I am trying to have the info in the text box appear in order and the following code in the OnOpen event of the form asks for "Enter Parameter Value" of txtTypes. What have I overlooked? Me.OrderBy = "[txtTypes]" Me.OrderByOn =...

The following give me "couldn't find installable ISAM" error message on a new machine. Docmd.TransferSpreadsheet acImport, 8, "GapImport", Mypath1, True, "A1:L2000" The previous machines originally had Office 2000, then upgraded to Office XP (10) now they have 2003 (11). Our new machines...

I am tying to add a second critera to the following insert query but can't get the syntax correct. This works: DBS.Execute "INSERT INTO SLIC_Trips " _ & "Select * " _ & "From [SLIC_Trips_All] " _ & "Where SLIC_Trips_All.District='" & [Forms]![SLIC_Miles]![TxtDistrict] _ & "'"...

I have imported an Excel spreadsheet where each row is one record. There is an ID number for the record, several fields with unique information and various states that may or may not have a numeric entry. I can extract the record and place specific parts in listboxes/or textboxes. My problem...

I have been given an excel workbook with one column that "should be" numeric only but.. It has A100, A5000, 1 and 400. They should be 100, 5000,1 and 400. According to the Microsoft online help the formula "should" convert to all numeric...

I am trying to figure how to update a linked SQL table with information in a local table. Until yesterday I had no experience with pass through queries so the learning curve is vertical. The following Access query shows the records that need to updated but I can't seem to be able to write the...