Search results

That's right. As you can see, I simply copied and pasted your code, input my object names, and it didn't work. Maybe it's something with the form or subform I'm using. The form name is OncListing with the subform named OncListingSub. I created the subform by using the subform tool in the...

Snuggles Unfortunately that code doesn't work. I'll give more detail. The primary key of the main table(tblOncReg) is [MEDRECNO] which is a number. The form OncListing contains the 2 buttons: Open and Delete. It also contains a subform, OncListingSub, which gets data from tblOncReg. It...

Clarification: I don't need to display the most current date that a weight was taken....I need to display the weight associated with the most current date for that particular patient.

Bob Your help and effort is greatly appreciated. I was able to get it working another way. Not sure if it's the right way, but it works. Here's what I did in case it helps anyone else(and maybe you can let me know if this is the "proper" way of doing it): I have one main form with 6 tabs...

The buttons are on form frmListing, which has a subform which gets its data from my main table, tblOncReg. When I click and highlight a record in the subform, I want to be able to click either "Open" or "Delete" and have those actions performed on the highlighted record.

I have a form called frmListing. In this form I have 2 buttons: View and Delete. There's also a subform that shows all records from my main table[tblOncReg] and displays only the 4 most important identifying fields. When I click a record in the subform(table), I want to then be able to click...

shudini I figured it out. On the button I use to open the form, I had the action set to "OpenReport". What I needed to do was set the "Where clause" so it opened the form with only the data for the current record being viewed. Here's what I had for the "Where Condition"...

Right now, the report works just like I want it aside from this one issue, so I don't want to change anything in the report other than this field. The control source for the 'Gender' field in the report is the data in the GENDER field from my main table(this stores a 1 for male and 2 for...

bob Not sure if I know how to do that. How would I create the query if the field in my main table is PrimaryPhysician, and fields in table[tblPhysician] being PhysicianID and PhysicianName?

Bob I've run into another problem. After applying a "Where Condition" for what my form should display, that code no longer works because the report isn't generated from the form, but rather the table that the form enters data into. So now it's getting the ID#'s from the main table. It seems...

Moniker I'm still very new to MS Access, so I'll explain how I have it now. The main table[tblOncReg] is linked to [tblWeightDate] by a key[MEDRECNO]. I'm not sure if I did it using a query though. Somehow I think I did it by making the WeightDate form a subform of OncRegMain and then...

So I got the report almost working. Right now, when I click to view the patients report, it brings up the appropriate demographic info, but then for the regimens and subsequent cycles, it outputs data from other patients in the order they were entered. A more detailed explanation in the...

I figured it out. Not sure if it's the same in all versions of Access, but in 2007's "Access Options" there's a tab for Current Database. In there I just changed the "Document Window Options" to "Overlapping Windows" instead of "Tabbed Documents"

That works, but then each form takes up the whole screen. I'd like it to look like it does in pop up mode, but not always on top. Should I be looking into modifying the format?

What setting controls whether a form is always on top of other windows that are open? When I click to view a report from a form I created, the report opens in the background and I have to close or minimize the form to view the report. I don't always want it on top.

I have a form[OncRegMain] that contains a subform[WeightDate]. The subform enters a weight[Weight] and date[DateTaken] to track patient weight gain/loss. The way I have it is that when the main form[OncRegMain] is opened to view a patient, the Weight and Date fields in the subform are...

I have 2 questions. The first is regarding splitting a database into 2 files, one for tables, and one for forms and queries. I have a database whose data will be accessed from about 4 computers, and almost never will this data be accessed concurrently. In that kind of situation, is it easier...

This should be a simple enough question for you pro's out there: What are the advantages/disadvantages of using the switchboard manager to create a "main menu" as opposed to creating a form with buttons that perform the same functions as switchboard items?

Bob That worked great. Thanks

I understand what you're saying, but not sure how to do it. I have a combo box in my main form, OncRegMain, that gets its values from a table called tblPhysicians. The [PrimaryPhysician] field in my main table, tblOncReg, is storing the ID# from tblPhysicians when the appropriate one is...