I am trying to set up tables with a many to many relationship. I have 3 tables with one-to-many relationships and a junction table with 2 key fields, but I...

I have a subdatasheet(controlled by a query) I am using in a form. When I type in a person name(already in the database) into the form I want the subdatasheet...

I have a form with a subform on it. Unfortunately during data input not all the fields on the subform will require input. This in itself is not a problem,...

Good Day! i am trying to do what seems like the impossible. i have a crystal report that is linked to our main accounting software, and this is SQL database....

Dear All, Please could any one help me to resolve my problem in Data Access Page? I created Data Access Page successfully in MS Access 2002 and I save it...

My english is bad, sorry. I want to make query to show double entries in field "1" which have first 7 letters the same. I'm using this query: SELECT...

Thank you for your quick response but I would be grateful if you could give me more help on how I can do it, or let me know an internet site / address where I...

I have a very neat database that handles the billing and bill of materials for my cabinetry business. A colleague of mine wants to use it but he would like me...

How can I remove comma's and decimals from a certain value using a formula in a query? Example: 2,352.00 Result: 235200

I have a data base with numbers in to 1 decimal place. I wish to report these numbers to 2 significant figures. i.e. if the number is 10 or above then whole...

Hello My main form has a datasheet subform that is based on a query to a table. I have unbound text boxes on the main form, so that users can search...

Hello Straight forward question but I can't find it when searching. I have Currency £ and want to change to $. I can do this in reports but wondered if there...

Recently I have a problem with an error invalid argument box whilst using access. I have taken on a dbase, which has been written using visual basic rather...

i being having this problem for some time now. i have build a database in access 2002, and now it doesn't work well in access 2003 i have try take all...

Hello, I have a report on a form that is being run by a macro. On the WHERE CONDITION for the macro is the following statement: =!! When the user clicks on...

i need a wondows98 utilities disk drive disk

Is Winfix 2005 a microsoft suggested download ?

Hello, How can I transform columns into rows for a table in access 2000 ??

comment faire pour que l'assistant de gravure de windows xp recconnaisse les CD-R de 800 mo ? Merci pour la réponse

I have built a database and am trying to add a search facility to one of the forms. I have a form called 'Safe-Point Units & Customers' which contains several...