Problem In a multi-use database, how do I restrict a user from having access to certain records and allow it for others. The scenario is as follows: The...

Not sure what happened. Was set to go right to new record entry with autonumber when opening form. Now it opens to the very first record in database and you...

I have many records that have a field in common (SBL) but different owners names. I would like to have one record with SBL and all the owners names listed.

My database used to be built on a single table. I recently split it because I needed to use one of the fields as a lookup for another field, and I got error...

i'm trying to convert a currency field ie £125.00 to a word field ie one hundred and twenty five pounds, anyone know how to do this please. found something...

Hi, I have a student database and wish to generate a report based on a query that contains: Student Last Name (from Family Info table) Student First Name...

Hi I hope someone can help.... I have a "BookingPayments" Table that I wish to redesign to be "normalized". Each booking has it's own reference by autonumber...

I all I am quite new to all this database designing. I have 3 tables: Suppliers_table, Call_table, Transaction_table. The Relationships are as follows:...

Good morning, Does anyone know of an app that I can use to go through my tables and make the Field Names, Formats, Data Types, etc. all the same? I have a...

Hello all, I've run into this issue before, and am just curious as to your opinion as to how best to handle. I have these tables: tblProjects ProjectID...

I need to create a field that will contain Notes up to 2500 Characters. Is this possible. Please help.

i would like to have a number required in a field, but only when a specific text is present in another field of the same table using Access

I'm using access 2002 and I'm trying to automate a procedure using a macro. The macro essentially exports a query as html, but asks me everytime if I want to...

Do field names have to be unique even if they are in different tables? I have 10 tables and the first field in each table is ID; while it makes sense that is...

I have created a query and want to print the entire query window on 11x17 paper? I am trying to show the joins involved with this query so I can take this to...

I have a table with two columns, one with a number and one with text. Some numbers are repeated owing to the text line being too long. I want the text to...

I have value to add two values from two tables and publish results to a third table. ie: (v1 in table A) + (v2 in table B) = (v3 in table C) Is there a...

I want to create a combo box with, in order, Detached, Semi-detached, Bungalow, Flat, Other but the choices KEEP appearing alphabetically. I would be...

-- KarenLouise

Access 2002 - I have several tables which contain null values. The fields are text, numbers, memos and dates. I am using Access as a server side db. Is it a...