Search results

I tried the INNER JOIN and got a "Type mismatch in expression." error. and the computer was on fire. any help with the error message?

tbl_A has column "ID" with duplicates. tbl_B has column "ID" with distinct values. i want to find all the distinct IDs in tbl_A that are present in tbl_B. I've tried the following with no luck: SELECT DISTINCT tbl_A.ID FROM tbl_A LEFT JOIN tbl_B ON tbl_A.ID = tbl_B.ID WHERE tbl_A.ID IN...

Mihail: I'm new to access 2007. Where and how would i use that piece of code? What exactly does it do? Thanks. -ed

I use the first record of my table as a blank when the form is opened. Users are supposed to use a drop down to navigate to a record for updating. Some users have populated fields into my blank that i've had to go in and delete. I'm wondering if there is a way to prevent that first record from...

awesome! thanks guys! i'm still new at this. thanks again for all the help. Happy holidays! -ed

how do i link them?

I split a database (without first making a copy of it) on my local machine and put the front end on a shared network drive. now no one can open any of the forms since the back end is on my machine. is there a way to undo this or to split the database on the network drive so that users can get...

I have a form that uses a multi select combo boxes. When more than one person is in the database, if a user is updating any of the multi select combo boxes, it locks out other users from making changes to those fields on different records. Can anyone explain why this is happneing? Can anyone...

I have developed a master record table in an Access 2007 database. I have a form that is used to populate the fields of the table. The database was developed to merge data that currently resides in three different spreadsheets. I'm looking for the simplest way to bring in all that data into...

how do i prevent users from entering design/layout views in my database?

i developed a database for a group and i want to be able to prevent anyone from mucking things up. is there a way to give myself developer rights amd to lock everyone else out? thanks! -ed

I have a form that opens blank with a combo box that has different customers listed. I'm trying to have the other fields display associated data when a customer is chosen and to be able to save the record if any changes are made. when i have the "Data Entry" form field set to "No", the...

given a subform that lists items: a b c d e f g given a table that contains a coverage field customer coverage smith a, b, d, g how would i create a relationship bewteen a subform and a coverage field such that when i multi select items in the subform, it will show what items...

CJ_London: how would a user choose the items for a customer? would they use a list box and select everything that applies? -ed

I have a list of customers in a table (tblCUSTOMERS) and a list of hundreds of items in another table (tblITEMS). The relations ship between customers and items are many to many. The form i'm using needs to have a coverage panel showing what parts are associated to the customer when updating...

I'm trying to build a form that does multiple things. Whenever i test it and it doesn't work (example: synchronized combo boxes), i would like to receive a message (or at least be able to find or generate a message) that tells me the error that is occurring. My hope is that this will allow me...

Hello World! I'm working on a database that will be used by two different groups. Group A provides a list of items to be investigated by Group B. I'm wondering if it is possible to: i) have Group A create an excel file of items to be investigated (let's call the file tblNEW) ii) open...

Hi everyone! I'm a new Access user (currently on Access 2007) and have been dabbling in it for about a month. I have some SQL experience and am working on expanding my development/IT skills. A little about me, I was born and raised in New York City nearly my entire life. I'm the youngest of...