Search results

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

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

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

Hi Huys i'm really having problems with macros as i've never used them in Access. I'm used to recording a marco in Excel but i can't seem to do that here. What i'm trying to do is create a marco that will upload 3 spreadsheets into 3 tables which i've already created in access. The tables are...

Hi Guys i'm to run a query to sort unique data between 2 tables. The SQL command i'm using is SELECT [EBAN].[BANFN] FROM EBAN2 INNER JOIN EBAN ON [EBAN2].[ID]=[EBAN].[ID] WHERE ((([EBAN2]![BANFN])<>[EBAN]![BANFN])); This works fine as it filters out the unique values but, it filters out all...

Hey Guys, I'm having some problems as i'm kind of a beginner to using access i'm used to using MySQL, but this one has me stumped. I have a table that i update weekly, and theres around 100 or 200 hundred new entries, I download the data into an excel sheet format it and import it into Access...