I have a db that will eventually be split. tblChild has PK ChildID and is a linked table tblNote has FK ChildID (long). Relationship window will allow me to...

I want to change the data type of certain fields in certain tables using VB6 code. I currently use code like this to modify some of the field attributes: ...

I work for the YMCA and we run a quilt project for kids with deployed parents. I'm tryin to make the system much simpler and put all parts in one place. I...

This is my first time working with Microsoft access; I am using the 2007 version. I need to make a validation rule that only allows me to input the number...

I have a table with way too many fields, and I am trying to use the table analyzer to split it. I'm not sure how to approach this, and I'd appreciate some...

I have been given the task of replacing our old program for report writing. Unfortunatly my knowledge in Access is limted to none. If anyone is willing to...

Hi, I am using Access 2007 and have completed my database. Can anyone tell me how I get rid of the ribbon and side navigation bar that has the tables, forms...

I have a large db in production for a couple years. I recently converted it to A2007, and the app keeps getting "out of memory" errors. I'd guess there is...

Hello, everyone! I'm starting on a great quest here. I'll start by explaining the big picture, then break it down to baby steps. Big Picture- First, I work...

Hi, I'm trying to find out if there is a way of creating an autonumber like feature on related records in a table, but there can be multiple instances of the...

I am creating a database that lists all furniture in a building. Several reports are run based on the information entered on each item of furniture input by...

Just Curious... Does anyone know what 'Row level tracking' means in the table Properties dialogue box? (Right Click a Table in the Database Window). I can;t...

Hello, As far as a Primary Key is concerned (for an Employee Table) I have read numerous times on the boards NOT to use the Auto Number feature, I'm not sure...

How can I print the properties of a table that include the fields descriotipn value. The built in documenter does not give an option to include Description of...

I am working on a DB to store mileage and fuel records for a trucking company. The data would come from trip sheets turned in by drivers with OD entries for...

Anyone designed a db for this purpose? At the moment I have in my mind the following logic: For the first two tables in this list, each employee can attend...

I made a database to track hearings of an administrative tribunal. I have two main tables (people and decisions). All other tables are lookup tables. In the...

I have what seems two pretty basic questions, but they're driving me nuts. I have created a simple bank account database, with 3 basic activities--deposits,...

Microsoft has an "Access 97 Relationship Print Wizard"...

I need to set up a simple table in which I am keeping track of height and weight out to 2 decimal places. What do I fill in design view after selecting number...