Search results

I have a subform that has its Default View set to Continuous. In one of the events in the subform, I'd like to add code that will switch the view of the subform to Single. I tried Me.DefaultView = 0, but I get an error message saying, "To set this property, open the form or report in design...

Here is a sample of some of the code that illustrates why I need to use the Form object: Call MyProcedure(Forms!MainForm.Form!Subform1.Form!Subform2) Procedure MyProcedure(frm as Form) If frm.NewRecord = True Then For Each ctl In frm.Controls rst.AddNew rst!NewValue = ctl.Value rst.Update Next...

I know this has got to be a simple reference problem, but I just can't figure it out. I am trying to pass a nested subform to a procedure, but I keep getting a type mismatch error. Here's an example: Call MyProcedure(Forms!MainForm.Form!Subform1.Form!Subform2) Public Sub MyProcedure(frm as...

Thank you very much!

Thanks to you both. I'll take a look.

I'll try that. Thanks.

I'm thinking about trying to do some freelance work in Access. I know a while ago, I ran across a couple of websites where people post database jobs they want done and then others bid to try to get the job, but now I can't find any. Does anyone know of any of these sites? Has anyone used them...

Do you have any idea where and exactly how I would put echo off? I'd like to try it.

Any ideas?

Can anyone tell me how to suppress the little message called "Printing" that says something like "Now Printing..."? I have tried the following, and it didn't work. The little message still pops up. DoCmd.SetWarnings False DoCmd.OutputTo acReport, "rptCommentsPrevValue"...

That did the trick. Thanks so much!

I have the same problem Does anyone know how to suppress this error (actually it's not really an error, because after it pops up, the data entry screen comes up)? I've tried error trapping and turning off system warnings, and nothing is working.

I will try that. Thank you very much!

I see what you're saying except that the relationship between 1 and 3 really is independent of the relationship between 1 and 2, and the relationship between 2 and 3 really is independent of the other two relationships. The data is actually as follows: fac1 - way1 fac2 - way1 fac3 - way1 fac4...

Here's an example: Table1 contains waypoints. Table2 contains facilities. Table3 contains companies. Each waypoint can have more than one facility, but each facility can have only one waypoint. They have a one to many relationship. Each waypoint can have more than one company, but each...

They really are related as follows: 1->2 1->3 Yes, these are two indpendent relationships. But there is another relationship: 2<->3. This relationship is independent of 1.

I have some tables that are set up as follows (these are not the actual names of the tables and fields, I'm using generic names so that I don't get a bunch of questions about the setup to begin with; I believe they are set up in the best possible way): Table1 has a one to many relationship with...

Robert88 - Thanks, but I do know for sure that Table1 has a one to many relationship with Table2 Table1 has a one to many relationship with Table3 Table2 has a many to many relationship with Table3 That's not the part I needed help with. Wazz - Thanks! Table4 will give me the many to many...

I've got some tables, and I want to make sure I relate them in the best possible way. Table1 has a one to many relationship with Table2 Table1 has a one to many relationship with Table3 Table2 has a many to many relationship with Table3 Would it be best to set them up this way or is there...

Inserting a "dummy" record at the end worked perfectly. Thank you very much!