I've been looking for a template for Access 2007, that will organize my MSDS collection. My binders are getting too big to search when a new MSDS comes in. ...

We mustly buy and sell with European Companies utside the UK, is it possible to be able to enter stock prices and purchases in euros only by default.

Hello, I am using a form that you input search criteria. You then hit a button and it runs my query off of the information in the form. Problem is, when I...

I have a form that contains 1 main form about 6 subforms within it. The main form exists in a one-to-many with the sub-form. The issue is that the subforms...

Hi All I have a small query : I'm running Access 2003 on an XP pro machine. I use icons on a customized toolbar to run my various macros , and choose these...

How many combined records can Access hold. I have a table that has 120k records. I'm about to split my data, so now, it's about to double. When do I want...

Hello, I have created a form that I would like to do several things for an inventory database I am creating (I have used Access for about 4 days). The form...

How do I make changes in access?

I am using the Studnet template for Access 2007. I have added several drop down menus to the template, but the information selected will not save.

I have the following code on the Open event of a report rptInvoice which opens from a button on a form frmOrders, but when I try to open the invoice report I...

Occasionally, when the user edits a record, an error message 3020 is received as follows: "Update or CancelUpdate Without Addnew or Edit" It does not matter...

I have a bunch of tables each one a question. In each table two fields. Field 1 is the answer field 2 is the points for that answer. How can I set it up...

Has anybody come up with a way to have users access formatted attachments (either snapshot or rich format)? I have everything in the access report just the...

hello, I have a query that I want to count how many days its been since "Excused Absence" was entered. each time its entered I use the InputDate for the date...

I am creating a LAB report for my studies and found a thread one of the same questions regarding a combo box, I followed the instructions, however is not...

I am brand-new to Access. I am using it at work for the first time and am learning on the go. In the long term, I have the opportunity for formal training,...

I have set up a field, data type number, format= percent, but when I enter the number 5, it comes up as 500% in the field on the table? if I try 0.05 =...

I have a database I want to update with information from excel automatically but only if I choose to per record. So as I type a field in a form I want it to...

I have two tables: Master is Projects with ProjectID as the primary key Subform is Communications with NoteID as the primary key Each table has a Project ID...

I have not gotten a good answer for the below. Can someone pls help? This is actually a post from earlier that I'm reposting. Can you let me know if I'm...