Recent content by DDONNI

Hi All, I'm hoping someone can help me on this one. I'm currently trying to code a Module that will automatically send emails to people using Lotus Notes. I've got the code to send an email via Lotus Notes but I'm wanting to add Tab Table and then have tables on each tab. I've looked anywhere...

Hi All, Can someone please help me with something. I'm currently trying to link a table in Access to an Excel Sheet, so that when the Access table is updated it is reflected in Excel. I'm looking at it and i don't see how i can do it as when i've linked the tables I can only delete information...

When i enter entries into Access, and then they are deleted, for some reason the size of the Access Database doesn't reduce in size. I've only just noticed this as i accidently entered over 65000 entries in and then had to delete them now the database is twice it's usual size. Can someone...

Ok, this is getting stupid i deleted the link and created a new one, making sure the formats were the same on both sides, but when the link table is created it reverts all the columns to text. I'm now wondering if this is to do with the fact i have the heading already setup in the excel table...

Thanx loads i what your saying makes sense i'll give it a shot i know i didn't format the spreadsheet to accounting first so thats probably where i went wrong. Cheers again.

Ok here's the update, i've run all the append queries that append linked tables, and none of the formatting is working its all set to text now. I have no idea whats going i didn't change anything as far as i know. Can anyone help with this one please. It's so frustrating. :mad: Is there...

Cheers mate thats great its working now i don't know what i was doing wrong before i think i had it set to edit. but i am running an append query.

I've tried this but it only allows you to read, edit or add. the query is appending an existing table i don't want to be able to see the query i just want to make it run at the click of a button. Any other ideas?

Hi Guys i'm now trying to create a form as a menu where i can execute Macros at the click of a button and also to generate reports. The problem i've got is i'm trying to setup a command button to run a set of queries but i can't seem to find a way of doing this. I've tried to add the query to a...

Ok it only worked for a couple of the tables but not for others. I think its because the ones that it works for have a blank entry in when the tables are empty and the ones that it doesn't work for have no entries in at all when blank. I don't know why this is, i've tried creating the other...

Ok i've just changed the formatting again, and updated all the tables and its now working, i think the problem was because i was formating the cells as currency instead of accounting. Cheers, i knew it would be simple. :)

Hi I'm stuck again with Access i obviosly don't know how to use it at all. I've setup a link between a sheet and a table and the table is updated using an append query. All this works fine, what doesn't work is the formatting. I have 1 column in particular that needs to be formatted as a...

Cheers mate i'll have a look and give it ago. I think i'm finally getting the hang of Access. Though it taken ages. :) .

OK i've managed to link a table up in excel, but i can't seem to delete records in Access as its telling me "Deleting data in a linked table is not supported by this ISAM" Can anyone help me on this please i'm totally lost. Effectively what i'm trying to do is load up 3 tables from excel use...

Ok its slightly more complex than that i've got 15 tables in Access and i need to link them to 15 tables in an Excel workbook. How do i do that?