Hi I have a folder of text files (a few thousand) and I want to either take the relevant bits of them into Access (one per record, memo field) based on what's...

My database (Access 2007) keeps track of bids from FE colleges. These are made in an academic year (these span two 'calendar years e.g. 2009-10 for the...

I am having network traffic problems (backend sql 2008). If I use a passthrough to pull a lot of data, and then use local queries for subsets of that, will...

Hi I'm trying to sum three fields in a table in a fourth field, is this possible? I have figured out how to do it on a form i.e. calculating the nett, vat...

First, I would like to thank all of you who have shared your knowledge with me over the past year. I have gone from not knowing the difference between an...

Hi I work in the HR department of a large company, at present all of our disciplinary and grievance cases are stored on a very messy outdated excel...

Will this upgrade add Access seamlessly to Office Home and Student 2007?

Hello, We have a data base on the hospital web. what can be the reason that sudenly the data base is read only and i can't do append query ? thank you

How can I easily see who is using the backend database? I can tell from the presence of a ldb-file that it is in use - but I dont know by who... Any...

I tried posting this message once, and got an error, so forgive me if this is a duplicate... We've had an MS Access 2003 application for a few years that is...

I am sending letters to individuals who have an account balance using merge fields from an access database. Works well unless the last digit is a zero - then...

Recently when I look in this newsgroup I cant just search for my name "DianePDavies" and then find all my questions... I used to be able to do that. Is there...

I have a large amount of objects (queries, forms, macros and reports) that I want to move from one mdb to another. Is there a way I can export them in BULK,...

I have someone who says they entered data into a database, but the data isn't there. Others have entered data into the same database and that data is there....

Hello, I am adding two fields on my form but it only shows the result if a number is placed in both fields. Is there a way to show the sum if only one field...

I have an employee enter sales information for each day for my business. At the end of the month I get a report that shows just the total sales for the...

Am I correct in assuming I can make a primary key a number data type? When the user enters the number, it would be without the symbols, however when the...

Wasn't sure exactly where to post this so here goes: One of my employees is trying to utilize the functionality in Access 07 where she can create an email...

I am trying to create a column where a pin number can be entered by not seen. Was hoping to have asterisk show but can't figure it out.

OK, so I know a little bit about Access, which means, dangerous enough to really mess things up, but not good enough to fix anything at all. I created a form...