Hi, I am trying to figure out a process from queries to obtain correct data from a table. For example, I have 3 fields Apple Red Big Apple Green...

Hello, I'm new in .Net world and there is so many info that I'm lost. DataSet is creted by Visual Studio 2008 to handle a FireBird database. Where can I...

Hi, I'm brand new to MS ACCESS and I am using MS ACCESS 2007. I would like to make a drop down list of different animal species for an animal shelter database....

I have a database that tracks projects. One project may have several appointments related to it. I have a check box to mark a project as being complete. All...

I am working on a table with an autonumber field as primary key, now that is ready I need to set theinitial value of the field to zero, how can I do dat if I...

Hi, Should I make the field called ID in my second table a number or text type of field when that field relates to my first table's primary key field called...

How do I show different pictures in individual Access database records (forms view)?

I am trying to create a database for a book program that I run. I am currently using an excel spreadsheet to track all books in inventory and who they are...

I have designed a table. The numeric fields are defined as: fILED TYPE :NUMBER; FIELD SIZE : LONG INTEGER; DECIMAL PLACES:2 The problem, I am facing is,"The...

Hi, I created a new field and chose Data type number. It is Field Size Long Integer by default I noticed in table view, having typed 3.05 into it, it became...

ok i need a knew email address and i want to use windows because it is allready installed in my computer but i cant figure out how, can you help?

I need to split my db so that I can hire another person to work with me. The new person will probably stay in my office while I will travel. I currently just...

I have been working on an SOP for about 3month now and am getting frustrated at it. The problem is that when I need to change something, formating the page,...

Have a large Access table 3 million rows. I tried to add a row number field but get an error "File sharing lock count exceeded...". Should I be able to do...

I am starting to use Access 2007. I have used previous version of Access. How do I create a query without having to use the query wizard? I use to be able to...

I need to create a database to track convention attendees, their lodging arangements, Hotel info, if attendees need transportation to and from the airport...

I want to take advantage of the query abilities of a combo box within a form, but I do not wish to display the drop down arrow to the user. I also want the...

I would like to show a "Task" & "Sub-task" relationship in a table, and I would love to use something like Adobe's Advanced Data Grid...

Hey Aspiring Writer! ODC Adv I am John, writing this on behalf of Gabriel, the webmaster of the Internet's No.1 Love & Dating Articles Site -...

We are offering our Microsoft Access Library management & membership database 'LIBRARY SOLUTIONS' FREE of charge. To download, please visit our website...