Search results

Hi all, I am struggling with this. I have a seached but not found the answer anywhere. I have a simple excel sheet with a macro that emails cell values to named recipients. I wanted to glam up the email a bit by adding a header image, but I can't figure out how to do this. I figured that I...

Hi, I;m not holding my breath with this one as it seems fairly complicated. OS: Win XP SP2 Laptop: Dell Latitude C400 Problem Device: Wireless LAN PCI Card (realtek 8180) This laptop is fairly old, which I happily use for web browsing and not much else. Due to it's age, I use the Wireless...

Hi, I've been playing with "activeworkbook.fullname" which gives me the file path, however, if the file is opened via a mapped network drive, a drive letter is displayed rather than the full UNC. Is there a way to force the UNC to be displayed no matter what method it was opened by? Many...

Hi, I have some code that sends an email, then should display an excel message, however, once the email has been sent, the focus no longer is on excel and the taskbar application display flashes. I have to click back onto the spreadsheet to display the message and continue. Is there a way to...

Hi all, I've had a quick look around but couldn't find the answer. My VB code starts with application.displayalerts = false then, further down the code application.quit finishing with application.displayalerts = true However, It still asks me if I want to save the spreadsheet, even...

Hi all. Access 97. I know that holding shift will take you directly to the db window. However, If opening through a batch file, is there a switch I can use to tell it to open as if I was holding down shift? (ie, the autoexec macro is ignored and it goes directly to the db window). Many thanks...

Hi all, I currently have a batch script that opens an access 97 db, runs a macro, then closes. The user currently sees the app open up and close. Is there a way to hide the access application when running the batch script? Many thanks Kempes

acc97. I have a db which uses a secure file to access it. (usernames, passwords,etc). How can I link to a non secure db without having to set up this db with the same security? Is this possible? Thanks in advance. Kempes

Hi all, Not sure if this is possible in access but I currently have a continuous form showing all records from a table. when the records exceed the page space vertically, you can scroll up and down using the scroll bar, or scroll wheel on the mouse. However, I don't want to use this as there...

Hi all, My spreadsheet has 2 activex text boxes. When a user enters information into a normal cell outside of these boxes, then clicks on a text box to input more information, it doesn't allow this. You have to click off this cell, then you can select the text box. is there any way around...

I'm back again. I can't quite find the solution to this issue. I am using saveasUI to disable the save option, but I do have a scenerio where I would like the user to be able to save. It is all locked down in the code, so the user basically doesn't have to do anything different. I have a...

Hi all, Is there a way to tell excel not to prompt for "Do you want to save changes, blah blah blah"). I just want to spreadsheet to be closed without prompting. Many thanks Kempes

Hi all, I have a listbox set to multiselect. When users select one or more options and saves the spreadsheet, they are no longer selected when re-opening the spreadsheet. How do I get excel to remember what options were chosen when saving and re-opening? Many thanks Kempes

I have created a UDF that works a treat. However, the values are not automatically calculating. I don't use excel much and can't figure out a way to re-calculate this formula when the sheet has been updated. I have found a manual method of ( ctrl, alt, shift + F9) but this needs to be...

Hi all, I'm attempting to create a batch file which I have successfully managed with databases that does not contain user security. What the script does is compacts the db and saves a copy to a named location. I can get it to open the db with my work group file but how do I pass it the...

Hi, Is it possible to create a rule that is exclusive to a subfolder without it running for the whole inbox, and without having to manually change the (run rule in this folder) option each time. If a mail comes in from a certain person, I want a rule to run for only 1 subfolder, and that's it...

Hi all, I've searched this forum and not found the answer to this so far. Is it possible from access vb to open a large PDF, save as optimized and close the PDF. I need to automate this optimization, which I believe is only availble using adobe professional. At a guess, I am thinking I will...

Hi all, I am using PDF Splitter that splits a master document by the bookmarks. The issue I have is that the main doc contains many images, and when it splits, each individual document created is a similar size to the master document even though it is a fraction of the information. I believe...

Does anyone know if this is possible? What I want to achieve is this. When you have a group header that is displayed at the bottom of the report, the header shows but the detail is naturally pushed to the next page because there isn't room. Is it possible to tie the header and detail together...

Hello all, Has anybody ever encountered this before. I can't seem to get rid of it. When logging in to my Acc 2003 db I get a message along the lines of... "Access failed to start correctly last time. Starting access in safe mode will help isolate a startup problem. Do you want to open in...