Search results

well, i started this one myself about 3 months ago... when i knew nothing of access. most things i've been able to update to hopefully be normalized and documented enough to be understandable. the problem is less with me, and more with the fact that the database started as a small enquiry...

I know. this project is a lot bigger than what you've seen. it's slowly expanding, and already in use, which makes structure changes more difficult. fortunately it's only being used by one person, and he knows i'm making changes, so it could be a lot worse. i'm just drowning in some updates...

well, not entirely. still problems, but not sure where to start with them. once i know what the problem is, i'll be posting more.

found it... here

I've set up the tables, and now have no idea how to use them.... i'd like it to look the same as before... on one form (frmOverall) i have a combo to select the person for position1 and on another 2 combos to select the person for position2 and position3. i have no idea what to bind my combos...

I knew something didn't seem quite right. i'll be making those changes now. thanks for the input. pat, as always, full of great info. sorry, neileg, i guess i didn't understand your first post well enough to be convinced. i'm still not sure how to make these changes... the tables would be...

so, in conclusion, this is not a many-to-many relationship. thanks for the reinforcement.

Ok, i'l be leaving it as is, then. my tables are fully normalized, and i'm trying to continue that with these relationships. i could have had 3 separate lookup tables all containing the same list of people, but that's triplicating information, so i want just the one table that all three...

here's a simpler way, assuming each contact can only be associated with one company. tblContacts ContactID (Pkey) Name CompanyID (Foreign Key) tblCompanies CompanyID (Pkey) Company Name Then if you know the contact name, you can fill in all the details for both contact and company on a form...

more detail than i need. each record pertains to a project, so for each project, i need each position filled. doesn't matter if one person is in more than one position even within a project. there are only about 7 or 8 people who can fill the positions, and their info is in a separate table, i...

note: all following table/field names have been changed to protect the sanity of the reader. I have a main table, which includes 3 potential positions for a person to hold: pos1, pos2, pos3. each field is linked to the same table, which holds a list of people. in my back end relationship...

i'm not sure, but it seems to me you have too many roomid relationships.... what is the purpose of the roomid field in the facility table? assuming facilityid is the primary key for the table, why would you want to associate each facility with a roomid? aren't there many rooms for one facility...

i'm importing data from a spreadsheet. i've imported data from excel into a new table (tblImport), and need to distribute it across my existing tables, taking the relationships into account. i populated my main table with an append query, and that worked fine. now i need to populate...

if you've split the database, and each user has their own copy of the front end on their computer, you could use a temp table in the front end, and then an append query to move the data to the back end when necessary. that way, each person has their own temp table, so no multi user use. if it's...

I did until now... didn't seem to create any problems, but i changed it anyway. it works now, i put in the code you recommended, and changed strvalue's data type to string. thanks for the help.

I'm trying to send a currency value to a word document using bookmarks, but can't get my variable to format as currency. i have a field in a table, value, that's formatted as currency, data type currency. i have a control on my form (referenced as me.value) that's formatted as currency. in the...

how about comparing years, and adding 12 to one if the years are different? more detail.... if you're looking at december 04 and jan 05, the month function will give you 12 and 1. if you can determine that jan's year is one greater than dec's year, you can add 12 to jan's, and get 12 and 13 as...

It's returning a string because its output is used as a criterion for a query. i got it to work by making the second output "**". i have no idea why it works, but it does. your code doesn't do what i need. if the checkbox is true, i want all records. if it's false, i want only the ones that are...

I'm running a search query, and depending on the state of a check box. the check indicates wether or not a user wants 'lost jobs' (meaning bid not accepted) to be included in the search. fLstSrch is in the criteria for the 'order lost' column in the search. it passes the value fine, and if it's...

I'm pretty sure me.name returns the name of the current form.