I'm using Access 2003 with the perl DBI interface. Perform the following steps: (1) Search for a record using "SELECT ... WHERE...". (2) If I cannot find it,...

I am shocked that I can't seem to find the redo command and command in office 2007? This is ridiculous. Could you please say where it is

I am trying to clarify where the prefered location is for relationships. I am working as a contract employee to "cleanup" a database created by someone...

Why should I use the JOIN ON syntax instead of the WHERE syntax? In my antique book Jet Database Engine Programmer's guide Page it says (page 119) "This is...

I have a table tblDaily_Attendance for calculating the Check In-Time for the day and Check Out-Time for the day , Breaks, Food break,Gross Hours worked, Net...

Where is it best to define database Relationships. I have an old split database that has some relationships in the Back End but also others in the Front End....

I have a need to find information on the column names and properties from within the objects in the dbase. I have unhidden the system objects (am using...

I am a student in IT, and am interested in finding a template for high school academic transcripts. Is there such a thing or do I try to create onemyself?

I am developing a clinical database which includes listings of Patients Providers Staff Sites Medical events. Patients, Providers and Staff may have multiple...

If I need to design a form that will allow the simultaneous display of all the items a person will assign a rating to, do I need to set up fields for all of...

I am trying to figure out how to run a report that shows certificates earned by associates that have completed training. Problem is that there are different...

I am making a new database and need a little help on the design... Im going to need to see what type of rig (Drilling, Swab, and WorkOver) on a form that shows...

Looking at creating a asset register, all data is on paper so unable to do massive dump into tables. want to create a form that will do the following but need...

I'm making an Income and Expenses database where the transaction (income or expenditure) dates need to be sorted by the Fiscal (financial) Year and month ie...

Hi Could anybody please give me some information? I am creating a database that contains sales orders, purchase orders, invoices etc. Is it best to use...

I have a form with a few drop dows and a command button. Each command button has an on-click event, as below: Button_A: this works DoCmd.OpenReport...

I'm not sure where to put a couple fields in my database. The database is for info on our company items. I have 3 tables tblItems itemID itemPartNumber...

i have an Unbound form with two text boxes and many command buttons on form header i would like the following ones (1)as soon as the form opens an small...

Hi, I need to store the web visitor's IP in a field. I thought of creating a numeric field but I've been told that because the IP has numbers and dots should...

I can't figure out what the rules are for foreign keys in tables. For example, M:M is easy -- the table includes the PKs of the two related tables. In a 1:M...