Search results

Thanks for clarifying, you've been a great help :)

Thanks! That was really helpful--actually answered a lot of questions I hadn't even asked yet. You were right--patients can have multiple symptoms simultaneously. One clarification, since I'm trying to visualize the tables in my head. By 'sparsely populated' do you mean I should stick...

Trying to help someone else with designing a database for medical conditions. We're at the table design stage and we're trying to figure out the best way to handle yes/no data. I've totally confused myself by this point over what is probably a very simple problem. For instance, we have a...

Woohoo! Thanks

Actually, now I have another question, since I'll have to know eventually. If I want to create a many-to-many relationship, is that when i can use the junction table? For instance, multiple payment statements can have multiple invoices associated with them and vice-versus. So would I create a...

Ok, I think my brain is finally 'getting it'. The relationship definitely seems to work. Thanks!

Thanks for the response. I assumed I could use ContactID in the Account table and just add multiple ContactIDs as needed, but that wouldn't that be allowed, right? (it would cause duplication of the primary key, unless I made them shared PKs). Alternately, I could add Contact1 and Contact1...

Totally new to Access and databases in general. I am trying to set up a very simple database but when I'm trying to create relationships between my tables, they automatically set one-to-many in the wrong direction (for instance, I have an account names table that I want to link to a contacts...

Ah, never mind. I made the following adjustments and it works. woohoo Private Sub Command29_Click() On Error GoTo GET_RESIDENT_DATA_Err CurrentDb.Execute "Delete * from [Resident Nutritional Profile]" DoCmd.OpenTable "Resident Nutritional Profile", acViewNormal, acAdd...

Thanks wazz. I'm in the right place now. How can I add this function to the same module as OnClick? Making the function public and pasting the function name into the code doesn't seem to work. I just get a compile error looking for "=", so I guess it wants more. Below is what my edit of the...

Hi! I need to create a macro in Access 2000. I've never used access before, so sorry if this comes off as a stupid question. I've scrounged together some vb code that will allow me to delete a table's contents, then import new contents from an Excel spreadsheet but so far the only way I can...