I have a hperlink field that I want users to be able to Add, Open ect on my form. It works until I uncheck the "Allow Full Menu" in the Access Options area....

I haven't use the attachement data type before. I set up a field in my BE tables as an attachment data type. I placed this field in my FE form, but when I...

Hi i want to change a filed called salary range property settings so that the currency does not show £ or $ in my reports but a local currency which will ...

I have been reading all about the evils of lookups in tables, however could someone please explain how you avoid using them - is the answer to have many tiny...

Is it still 1Gb for the latest version of Access?

I'm designing an access 2003 DB for a small Newspaper. It will monitor the deadlines of the newspaper. Each record is a day. There are 5 people that could...

I have a table that populates specific data from a SQL view when I manually run an append query - works fine. What I really need to do is have that table...

I am having trouble understanding a design concept. I am setting up an employee database for the first time. At issue is how to handle the actions entered...

I am setting up a job number database for my company. As of now the "database" is kept in a binder. It will soon be housed on our server. Yay! The most...

Win 7, access 2007 , tables: device and ip, relation (device.ipIP, foreign)one-to-one(ip.ID, primary) when I delete an device from device table using form it...

I am trying to find the easiest method to write code which would allow me to open a report from a form linking up to five fields. For example: I have a...

I am currently designing a database that will be used on a LAN and a number of remote laptops that may or may not have access to the internet. I would like to...

Ok after reading some of the feedback, I went back and redesigned my tables. In addition, here is an overview of what I want this database to do. 1. Tel me...

Hi, i am having some trouble decided how to design this database. I have attached an excel spreadsheet with all the requirements. So far this is what i have...

Existing I have the following table structure (in Excel) and now want to have better control by using ACCESS. SC no Buyer PC no Supplier...

Does anyone have a good petty cash template? -- Lady Chalkley

Hi, I am trying to create an access database that has historical data and new data is imported in monthly. I need it to be able to check each time if it's a...

project number in my data table will be truncated. I know that it will be impossible to establish referential integrity Use an Autonumber field as primary...

I have a yes/no field that I tag if I want to send a bill to various people. After I have sent the bill I want to clear the field so I can use the field at...

We have created a new project use SQL. When I create tables in import data we get a Message that says "Recordset is not updatable". What are we...