I wonder Who is This STEVE... Many question for learning purpose I go His name Pops up.... and I always see.. "Help .. with $$$$$$".... We...

I have several combo boxes which hold data from 1 table. Some fields in the table are empty but they show up in the combo boxes as blank rows. Is there any way...

This happened while designing a form. I finally noticed I was using too many tables, now it is happening while designing a report. I would like to know...

Hi! I need to create a new database, where some fields are common. Ex: Date, Hour, Type... I thought about making: - 5 different and specifics tables, and; -...

Can someone help me with where certain fields should go (I am self-taught so please bear with me!) I am creating a database to store information regarding...

Hi, Any help on clarifying the following would be much appreciated. Given an unlimited number of categories with each category containing the data {ID, NAME,...

This one is driving me mad! I'm going round and round in circles and I think it all hinges on my relationships between my tables. I can't seem to make my...

The general situation: the law office that I'm working for is converting their Lotus DB to access. It already has approx. 200k records that are several...

I am trying to decide how to "normalize" a large database. There are about 25 fields with many common values like State, County, Street Address, MapID, etc. ...

Which is better to use prefix - pk or suffix -pk or none. I honestly like using suffix of _pk, but if I had a reason to use the prefix version I would. I...

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

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

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

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

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

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