Search results

Hi vijugopal, The code below is run from an existing Access database (not from Excel). It opens an excel workbook, cycles through every worksheet and imports the worksheet data to it's own table (named the same as the worksheet). If you just want to import a single worksheet then just use the...

Hej Loranga, kan yag for en korv med brod tak? Is that right? Probably incorrect spelling?!... but I'm married to a Swede and I need to improve on my swedish. Just pointing a colleague to this website which I used many times over the years and saw your post. You will find most of what you need...

If ppl can see your values but can't change them, then how about changing your text to white on a white background and removing the formula bar... that way they won't be able to view it. You could also look at options related to hiding the worksheet. As for your report... think about...

Hey Uncle Gizmo... totally understand your point... that's why I asked. I have signed up to your website and included my link. If anyone is interested to know what I've have created I will gladly send you a link if you pm me. Cheers, James

Hey folks, I've just created my own website where I'm trying to promote something that I have concocted out of Microsoft Access, Excel and Outlook using VBA. Are we allowed to post our websites to obtain feedback about layout and content or is this a big "No No"... Thanks, James

Access Navigation Button images Thanks guys... I couldn't find them on my system, so I suspect that you are correct Mike. Nothing under Visual Studio on my system DCrake. In the end I downloaded a copy of Gimp and created them from scratch. I saved them as .gif and they look exactly the same...

Hi folks, I am wanting to track down the path for the files that Access uses for it's form navigation bitmap images (first, last, previous, next). I want to get copies of these images so that I can use them in an Excel Form. I was able to create some similar nice looking images in...

David... the previous code takes about 2 seconds to to run through over 25000 records... so although it looks ugly it still works... your suggestion would probably work, but I was after a "better solution"... not a solution that seems as protracted as my original!! :p The jpg image actually...

Yeah... conditional formatting would work to highlight these differences on a displayed worksheet but I want to retrieve the records to a different location. So I want to create a "find values between range" functionality that allows me to put the row numbers into an array and then allow the...

If you look outside now you may get to see the moon, jupiter and venus in an alignment that makes a happy face :) ... apparently this doesn't happen very often. Gives you a warm glow inside!! :D http://www.news.com.au/story/0,23599,24732092-421,00.html

Having just relocated to Australia after 12 years in the UK... everything about Melbourne is too American for my liking... roads that take up a city block, people wearing American clothing, caps, etc... fastfood... not quite got as far as the drive through coffee shops and banks... but having...

Hi everyone... it's been a while... Hope that you're all well. Using Excel 2002 on Windows XP... I'm Attempting to loop through 25000+ rows in a column and check if the cell value is between a given currency range. I will then save the row number of each matching record in an array and allow the...

You can use a union query. Select all fields from each table. Make sure that they all have the same fieldnames. Output '' for those tables that don't have that particular field. Select name as field1, surname as field2, addressline1 as field3 from table1 union Select fname as field1, surname as...

Bee, Suggest that you run a few tests just against the linked tables first. Check that data entered in the linked table of one f/e is shown on the back-end db. Check that the data entered on the linked table of one f/e is also shown on the linked table of another f/e. If these tests are ok then...

No problem... glad I could help. :)

Look at this website... http://www.platte.com/support/DOSInstructions.html It gives instructions for downloading from an ftp site using DOS command line. If you can get it to work this way then you should be able to translate the instructions and parameters to the technique that I have...

ftp Kinger create a file called parameters.txt with the following details in it ------------------------------------------------------------- <user> <password> Hash on binary cd <FTPdirectory> prompt off get <filename.txt> ------------------------------------------------------------- --...

A colleague found this website for me and it works a treat when you need to get around outlook security settings. No need for extra dll's, no need for Redemption or ClickYes... All you do is paste some code in Outlook and tailor your Access code slightly. I have just tested it on a 1000 emails...

After the ls, add another line that says "Bye" (or "exit"... but i think it is "bye"). This should close the window on completion of the ftp.

Looks like you may have it... if you want to be sure paste the following in a module and run it... you should end up with a query called qryTestQuery with the results that you want... then tailor it to suit your requirements. Public Function test() Dim strString As String Dim qdfTemp As...