Search results

Alright, I did a search for this and came up blank, but I'm sure its been asked a million times, sorry for the inconvenience:D Is it possible to make a subform a popup form? I have a client table --1--to-many--> service table and want the service form to popup out of the client form. But I...

I see what you are saying. The Service Recieved is not just a list of services though, they are date/time specific. Here are some more specifics about the DB structure. I will post a pic of my relationship tree later this afternoon. Clients can have a Case Manager and/or Service Manager...

Ok I have a series of tables structured like this: --->=1 to many Service Managers----->Clients-------> Service Received-----> Service Log However, each client can also have a Case Manager. Usually I'd just make another table for them and create another 1-to-many for that field, but heres the...

That makes perfect sense. Thanks for the input. Any other arguments pro or con?

An easy question: When I create dbs, I usually have to create single field tables that contain data that will never be duplicated, such as race, gender, etc. In the past I have just made the single "gender" or "race" field the primary key rather than assigned autonumber PKs to all the data. Is...

Alright, but that puts us back to square 1: populating the linking table, establishing the connection between the CM table and the Child table.

Would you mind looking at the DB if I uploaded it? I can put in some fake data so I don't break federal law :D I think if you saw it it might make more sense that what I am saying.

The spreadsheet I am importing contains every field you see in tblChild except anything with an 'ID' after it. Plus the Unit field is also in the spreadsheet and is imported. Each child can have 3 CM of 3 different types. I have sorted all the case managers into 3 separate tables based on type...

No, its an autonumber. What about an append query putting the CMID and ChildID into those fields? Edit: Ok, tried this, I cannot append both fields at the same time for some reason. The comp locks up, the DB goes to roughly 250 MB of space and I get weird data back. If I append one at a time I...

If I am importing data, how do I populate those fields in the linking table? In other words, how do I tell Access which CMs go with which Children?

I am importing some data from an excel spreadsheet into tables and attempting to set the relationships so that I can run reports on it. As you can see, each unit can contain a number of case managers, no sweat. However, it sems as though I need to create a many to many relationship between my...

Side Note: Oddly enough, I cannot enter data into those forms when they get opened by the subform control. Any reason this might be happening? When I open them normally, outside the subform control, it gives me the option to input data.

The subform control only has the OnEnter and OnExit events. I keep getting an error when I try to fill the actual switchboard OnLoad event with: With Forms!frmCM .Data Entry = True End With Weird, it says it can't find the form.

Yes sir, I wish for the form to open with none of the previously entered records visible or the 'acAdd, acNewRec' mode. To clarify, I will want to open the form in the 'AddNew Record' mode as well as the 'acAdd' mode in different instances, so information on how to do both (not at the same...

I am looking to open a form in a subform control, but in "Add" mode. Here is my code to date: Case conCmdOpenFormAdd With Me.chiSwitch .SourceObject = rs![Argument] .Visible = True End With How do I let the subform control know that I want...

Here is what I tried with no success: Case conCmdOpenFormAdd With Me.chiSwitch .SourceObject = rs![Argument] .Visible = True End With With Forms!frmCM .DataEntry = True End With I even tried setting...

Can I specify how I want the form to open format wise? Here is what I have: Case conCmdOpenFormAdd With Me.chiSwitch .SourceObject = rs![Argument] .Visible = True End With How can I get the form to open in "acAdd" mode through this code...

In setting up my DB I was thinking it might be convienient to open my data entry forms within the switchboard interface, i.e. you click Enter Client Data and frmClientData opens up in the switchboard form. I know there has to be a way to specify which control the form shows up in, but I am...

Ok, I used your code and and also a hint from a previous poster and it wrked like a charm, I thank you. As I am a VBA novice, (knowing but a little code and some obvious functions), could you please inform me why Age is a string and not an integer? Is it because you have added "BETWEEN" and...

I am looking to develop a form that shows records in a report based upon criteria defined in said form. So far I have had success in filtering city names, state, and whether or not the client is a medicaid recipient. Unfortunately, my knowledge does not include how to search a range, such as...