Search results for query: *

IT has moved our files to a new server. We currently have ALOT of excel tables and/or pivot tables linked to Access Database tables/queries. Is there a quick and easy way to change these links from J:\\..... to \\gad.intra.net\....... Appreciate any advice.

I've written an Excel macro to change the Access Query Excel is connected to. This worked perfected in Excel 2003, but in Excel 2010, Excel won't allow access to this macro. The file is a Macro-Enabled formatted file. I've looked at the Trust Center. Any thoughts on what could preventing...

Has anyone ever encountered this problem. I have a 2003 Excel spreadsheet linked to an Access 2003 select query, but after making changes to the database, the select query in Access is reflecting the changes, but the Excel spreadsheet is not. If I make the select query a table, and change the...

I'm coming from Excel 2003 where all my VBA macros that can be used by all workbooks are located in the PERSONAL.xls workbook that is hidden but opened when you start Excel 2003. I have been able to figure out if I manually open the PERSONAL.xls workbook a made copy of, then all of these macros...

I'm learning to use Power OLAP. Is there anyone out there familiar with this product? I have five cubes built: 2007 data, 2008 data, 2009, data, 2010, and projections which has budget, forecast and projection numbers. I've created a cube (using the formula function) that should combine...

I have a cube in Paris Technologies PowerOLAP that we update from MS Access. I change a field heading in the Measures table, but I also changed that members name in the Measures dimension. This may not be the cause. We also made changes in another dimension table, but only to the data. When...

Thank you for your help. Everything is working fine.

Not for email in outlook, but yes my husband will be using the laptop. once I switch it over, I was going to remove outlook from the old laptop.

I just bought a new laptop and need to setup outlook 2007 on the new computer. If I'm signed into my email account on the old computer, can I still setup the same email account on the new computer. If not, what do I need to do? Thanks for any help. I've done this before but it's been soooo...

I have an Access table imported(linked) to Excel where I can Refresh Data to update the data. But at month-end, I need to SaveAs the file with the data not capabable of changing when we start updating the Access table for the next month. Data is YTD to in Access. Is there an easy want to turn...

Thank you for your help. For the month, I want the abbreviation (Jan, Feb, Mar). Will this function (=Format(DateFieldExpression, "mmm") work if I'm trying to extract the month out of a date (1/1/2001) giving me Jan? Sorry for not being more specific. Leslie

I just started a new job and I'm hoping this is a simple adjustment that needs to be made to my Access software, but I'm trying to create two fields off of a date field. The first field should be the month in month abbreviation format and the second field should be the year in YYYY format. I'm...

I just found what you were talking about. Thank you very much for your help. In this way, I will not need the Next Question button at all. Thanks agains.

Thank you PHV for your response. Unfortunately, I'm still at a lose when you say Current event procedure. Is it possible for you to elaborate. Sorry in advance for the lack of understand.

I'm building an Access Form to use in helping me study for my quizzes at school. The text box with the answer I have hidden when the Form is first opened, and then when I hit the correct answer button, it displays the correct answer. Problem: When I navigate to the next question (record)...

Thank you so much. This worked perfectly. I knew it was fairly simply, just couldn't wrap my brain around it.

I have created a 2007 Access Database form in which I want to use to test myself in studying definitions. The form has the definition from "Table1" and a list box which pulls from a query with ALL the words in "table1". I have added a Click Event to the list box. When I click on the word in...

I have a contact form setup on my website that when a visitor fills in the form, I receive an email with the information. Recently, I started receiving these emails with bogus info filled in the contact form. (example below). Are there people intentionally filling this in and sending it or is...

I have a subdomain setup on my hosting account and I'm having trouble adding a PhotoGallery. I think it has something to do with where I have the photos saved on the server. First I had them under the subdomain, but the thumbnails were showing up on the web as Xs. Then I tried moving all the...

I have a gateway laptop that I have attached a full-size USB keyboard to. Now when I try to use the laptop keyboard, the "Fn" keys have reversed. These are the keys that when holding down the Fn key will serve as the numeric keypad on a full-size keyboard. But right now when I type without...