I am trying to write an IIf statement to use in a calculation where if PT1 is zero it will use PC1 to determine the value. Here is the state I have tired but...

Someone has asked me to create a database and include what they call a "push" function that will automatically create an email to warn that a contract renewal...

Hi, What if you have two organizations and you plan to design a database to do the same task but within that task, the defined tables will vary because of...

I am a VERY novice Access user and attempting to build my company's first database. I've created three tables to track our consultants: Consultant Contact...

I'm creating a database of text fields. I expect some data to exceed 255 characters. What is the maximum field size of a text field? Can I increase the text...

Ok i'm going to try to explain this as simply as possible. database purpose: I sell italian charms and makeup on ebay and other auction sites. I am making a...

i have a form with a subform and on the main form i have a toggle button that locks the subform.. with this code !!.Locked = bLock this worked fine until i...

I've been trying to find this answer in the Help and in the forums, but must be using the wrong terminology. My form has a drop down field called "1." and a...

I want to allow for default shortcut menu's. But when that is enabled it allows the user to right click on the form and go to design view - which I obviously...

Hi there, hopefully somebody will be able to offer me some words of advice. I am creating a database for a firm that deals with property insurance claims....

Hi, I'm trying to create a engineering database whereby there will be hyperlinks to engineering documents. I'm trying to create a query whereby I can search...

Hi, I am looking for a way to convert a column on my table in Access that is Raw HTML to Rich Text. Thanks!

Hello, I have two tables I wish to link together. The first table contains records for multiple devices, i.e., two clocks, five radios. I need it to...

I am using Access 2007. I have a database for my Products/Services industry. I have a table containing my products/services, as well as a Work Order Form...

I split my database recently and now I am experience terrible performance when designing my forms. It can take 10 seconds just to select a field and delete it....

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

### How can I use relationships to auto-create records in my subform? ### Please Help! Using Access 2007, I am trying to create a "Classroom Database" where I...

Hi, I have a database which links to another database on the network. I have linked 5 tables from database1 into database2. Users do not have access to...

Here is my challenge. My work has a wretched almost unsearchable "database". I am trying to cobble together my own relational database from that...

I have a split Access Database on a network. I need to add a new table to the database. Do I export it to both the front end and the back-end or do I run a...