Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ghcrazy8

    Files Moved Need to relink everything

    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.
  2. ghcrazy8

    Excel 2010 VBA--Excel Connection to Access query

    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...
  3. ghcrazy8

    Excel 2003 Query connection to Access 2003 DB query

    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...
  4. ghcrazy8

    Excel 2010 and my VBA Macros from Excel 2003

    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...
  5. ghcrazy8

    Paris Technologies Power OLAP

    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...
  6. ghcrazy8

    Error when processing Cube from MS Access

    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...
  7. ghcrazy8

    Transferring Outlook from one laptop to another

    Thank you for your help. Everything is working fine.
  8. ghcrazy8

    Transferring Outlook from one laptop to another

    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.
  9. ghcrazy8

    Transferring Outlook from one laptop to another

    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...
  10. ghcrazy8

    Unlinking an Access table to Excel

    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...
  11. ghcrazy8

    Access Query--Call Procedure Invalid

    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
  12. ghcrazy8

    Access Query--Call Procedure Invalid

    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...
  13. ghcrazy8

    Access Form -- Make Text Not Visible

    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.
  14. ghcrazy8

    Access Form -- Make Text Not Visible

    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.
  15. ghcrazy8

    Access Form -- Make Text Not Visible

    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)...
  16. ghcrazy8

    Access form for Word & Definition Testing

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

    Access form for Word & Definition Testing

    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...
  18. ghcrazy8

    Contact Forms--receiving cryptic info

    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...
  19. ghcrazy8

    FP PhotoGallery on a SubDomain

    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...
  20. ghcrazy8

    USB Keyboard attached to Laptop Question

    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...

Part and Inventory Search

Back
Top