I know this might seem technically wrong and therefore, I haven’t found advice on how to do it on these postings. I have an Access 03 table...

I am trying to design a budget database and I want to have consistent categories and expense. I have a table with Category and Expense It looks something like...

I have an Access data base that has acumulated 7 years of HR info. We plan to moving this info to HR Application. The new application has a field called field...

I recently viewed a post that said "autonumber is fine as long as you dont display it to the user..." Everything in my database references autonumbers!! ...

Hi all, I want to enforce referential integrity between two fields in two separate tables: tbl FishTaxonomy (includes the full name, common name, and...

Hi I have a database that was set up very quickly a few years ago, it is for recording the booking out of equipment to staff at a college. The database now...

I am trying to design a budget database and I want to have consistent categories and expense. I have a table with Category and Expense It looks something like...

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

Dear, Can anyone help me to make good database structure? What i have are some locations where I have some machines. Every machines have 2 counters (IN and...

Hi, I have a RESPONSE field on my table. This field is set up as a text field (I do not want to change it due to specific requirements)- however, I'd like to...

I have a few tables in my database, all 1 to 1 with the master table. I have a query that gather much of the data into one large datasheet.The problem is I...

Hello Everyone, I know I have seen this problem before and that I have corrected it in the past, but for some reason I can't figure it out this time or...

Hello, Not sure how to approach this: We have an inventory database that has a variety of item types. Workstations and printers have quite a difference...

Date 5/4/2010 Starting in early summer 2010, Microsoft will begin progressively closing down the Microsoft public newsgroups to enrich conversations in the...

This is probably a crazy question, but will ask it anyway. Is there a way to share an Access database via the web? Off the top of my head I am thinking of a...

I am trying to create a membership database for a church. I need to have all members entered into the database, then for the members I need to have their...

i have a form based on a crosstab query that sums on threee possible types A, B or C. on the form the field for B shows #Name?, if B does not exist. this...

I am trying to design a very simple database for tracking attendance of my church's youth group. We meet weekly and for various events and fundraisers. I want...

Is it Possible to change a common relationship between two tables to Force Referential Integrity after the data has been entered. I have two tables joined...

I am working with an access database that I did not create and I am looking for pointers that will help me analyze and understand what is happening with the...