Getting Started

combine two or more fields in access
I am trying to combine two or more fields in access query to display (Smith, J. K.) in one field. I have all three fields in my tables but the first and last names are spelled out. How can display only the first character in each name? ... 13 Jul 2008 08:58

Which database program is best suited to lots of images?
Mike Barnard <m.barnard.trousers(a)thunderin.co.uk> wrote in news:i7fu6497j9uno16rsualh7b53sj2i9jqr5(a)4ax.com: Mike, I am NOT an Access expert, but I program in several other DB languages. I have built a system like the one you mention and in the end decided that I would simply store the paths to the various pi... 6 Jul 2008 11:57

Test if folder exists prior to creating it - VBA
I am trying to output a file from Access - I use the following code to make a folder if it does not already exist; DestFile2="C:\Copy" If Dir(DestFile2) = " " Then ' CHECK IF PATH EXISTS MkDir (DestFile2) ' If NOT - Make IT End If ' End Check Fold... 6 Jul 2008 14:00

New member, can any one help?
Hi I am only used to working with widows XPPro, and my new notebook has preloaded Vista. I find all of the icons confusing. I have an email account with Virgin media, and when displaying a composed message, it appears as one single long string accross the page. How to I display the message as a top to bottom d... 5 Jul 2008 17:38

Finding records with same criteria
I want to bring up all records for a certain client. For instance, all clients named "Smith". I'm used to working with Microsoft Works database. That allowed me to bring up a group of records, and then choose "all records" to get back where I started. Can anyone help do that with Access? ... 5 Jul 2008 16:36

Back-up Bob Larson
Bob, Something does not work. I have now DoCmd.RunCommand acCmdBackup But the result is Error 2046 Not available Any suggestions? Eef Houniet "boblarson" <boblarson(a)discussions.microsoft.com> schreef in bericht news:2CBA933B-63AA-4E35-BEAA-B535269A4B31(a)microsoft.com... Eef: ... 5 Jul 2008 08:26

Page (tabbesturingselement)
Access 2003 has an option to make (on a form) pages with tabs. In Dutch called "Tabbesturingselement") I am looking for a way, to start procedures, depending on which tab has been activated. If active tab = A, do this, If active tab = B, do that. Thanks in advance Eef Houniet ... 5 Jul 2008 09:27

Crosstab Date Range Problem
Hi hope someone can help with an annoying crosstab problem. I have set up a crosstab query to show sales qty to each customer, by month, over a consecutive period January 2006-July 2008. I use the DatePart function to look at the sales date and get the month number. The problem is when I run my query it sums A... 4 Jul 2008 10:00

Back-up
Question A Access 2003 has an option under File (Bestand): Back-up from the database. (or some such translation from Dutch) What would this be as MenuItem? (As the following instruction for Save would be: DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70) Question B Is there a list of... 5 Jul 2008 09:27

Database template
hi i menage acounts for an isp and i was wondering is there a simple template that would allow me to see the users of the isp in a way that it would be easier to menage payments from those users. i am simply looking for payments made and over due payments highlighted ... please help . ... 4 Jul 2008 01:50