Search results

Thanks, dcx. That did the trick. Actually, the child and master were already linked, but I deleted the subform instance on the form, and then recreated and relinked it, and for some reason it works now. Thanks, Steve Geller

This is probably a very simple question. I have a parent table and a child table. The parent table has a form, and the child table has a subform within the parent's form. The parent's PK is an autonumber. The child table has a field for the Foreign Key as a number. What I would like is when...

Pat: Sorry for the enormous delay on this. The problem was caused by the Foreign Key (not the PK) in the child table being an autonumber. Apparently, the original designer assumed that the autonumber of the parent's PK (Also an autonumber) would always be synchronized to the child's FK...

I'd say that it's not only OK, but necessary in some cases. (eg. a form where the person enters their name, home phone, work phone, and cell phone should go to two tables - Person and PersonPhone)

Thank you for your advice, Pat. I do have one question, though. I understand that I need the main form record before the subform. However, even if there were missing records, this shouldn't keep me from linking the child and master in Design view, should it? I guess what I'm asking is: Is...

I am doing maintenance on a database that has a subform that's inside a form. Before I made changes to the front and back end, the subform worked fine. A user could enter data in the first row, another row below it would be created, and there were no error messages. Now, however, if a user...

I have subforms that are fine when their record source is a table on my hard drive. However, if I change the record source to link tables on the server, the entire subform is blank. I don't mean the individual controls in the subform are blank, I mean the entire subform is one solid color with...

Never mind. I fixed the problem.

I have a subform that has fields linked from the database (total project hours), a text field for user entry (hours used), and a field that displays a calculation (hours remaining). This subform is in a form so the subform can show multiple values. The problem is that when a user types in a...

I was afraid of that. Thank you for giving me the information, Wayne.

I need to copy data from one set of tables (source) to another (destination). In the destination tables, some of the tables have less fields than the source tables (eg. Table2 (has Field1 and Field2) will be copied to Table1 (has only Field 1)). All of the fields in the destination tables are...

Wayne: Just to clarify, are you saying that table fields in an Oracle database can hold multiple values? The reason I'm asking is that this seems like such a bad idea. I mean, it seems to me that every field in every record should only have one value (different values from field to field and...

I'm doing normalization on an application that was given to me. The original designer has combo boxes (ie. multiple values) in some of the fields in the tables, and I want to change those to single values. The original designer said his reasoning was so his forms could have drop downs directly...

Rich: Genius. Absolute genius. Thank you so much for pointing me to a simple answer, especially when I was wasting my time trying to do it the complicated way. Steve Geller

I have a subform with two pertinent controls. One is a combo box that gets its values (an ID number) from the database. The other is a text box that uses DLookUp to compare the ID in the dropdown to the ID in a table, and then return the name associated with that ID. This DLookUp is in the...

Thanks, ghudson. I'll let you know how it works.

In my VBA, I need to refer to the file path (actually the .ldb file that goes with it) the database is currently in. Is there a way to get the code to generate the path instead of typing, for example: strLDB = "D:\DATA\My Documents\dbname.ldb"? Thank you, Steve Geller

WayneRyan: Thank you for the information. It'll be a while before I can implement, but now at least I have enough information to start! Thanks again, Steve Geller

I have an Access database on a server, and am trying to accomplish something similar to EndersG post "Limiting # of Open Databases", where I want to limit the number of people who can open the database at any one time to a set number. I don't care if they're in a form, report, or the central...

Thanks for the information. The difference between your setup and mine is that I have to deal with the subforms. I checked, and part of the Access environment requires that when you click on a subform, the BeforeUpdate event for the form is run. I can't stop it, but I'm looking for a...