Search results

I have a simple, well working form and subform created with the form wizard. On the form is shown student data and in the subform grade level data, related by a key field, many grade levels for one student. The wizard put the student data (name) in text boxes with record locater controls at...

Thank you for taking your time to help me. It looks like it working well now. John

I have a subform based on a query where the criteria for the query fields is set to combo boxes on the form. The form works well, but when it is initially opened, the query runs and prompts the user for the criteria data. I need the form to open without the query running so the user can input...

I'm really greatful for the coaching. Thanks a million. John

Thanks so much for the help, this one was confusing. I am correct though, that if I want to add a field I have to "unsplit" - right? Or is there a trick that will allow me to modify the structure of a split (linked) table?

Thanks for your help. No my confusion turns out to be that a SPLIT table is treated as a LINKED table. My table structure does not contain data or links to other databases, but I split it to reside on a server. This has had the same effect as linking. Reading the manual on linking or...

Thanks for your help. BTW, I am fully backed up (including off site). That's why when I tried to split again and had a problem I easily went back to the state before that operation. I don't have archived generations of my development however that would allow me to restore to a specific point...

I have a prior thread regarding a message about "Linked" tables, which I don't believe I have. Digging around only finds references to importing or sharing data with other databases, which I am not doing. However, I have split the database so I can have the data reside on a server and...

Thanks to everyone. My confusion is that I do not have a table that is the source of data for another table. I only have tables with distinct data that are related. I don't know where to go to change the "source" table - my data is only in the table that pertains to its use.

But here is the quandry - what is the "source table"? I have table A with a primary key, like client number and a related table B with client number. I use the relationship to format forms or reports, but the data on table B does not come from A. How does it effect the relationship for me to...

I have a nice application built with several tables related to each other. This is an application with a split database which resides on a server and an installable application that I put on individual workstations. I encounter a problem when I want to update a table format, say add a new...

Thank you so much for your very on-point help. I have two manuals, but frankly getting right to the answer of some of these fundemential questions is not very straight forward. My form looks and works great and I am in your debt.

Actually if you saw my golf, the distinction might blur a bit.

Thank you very much. Please go back to puttering (I guess that is not "putting"). John

Can someone tell me how to test a Requery to see if it returned any records to the recordset? I want to add a user message explaining the the parameters choosen found no records. Thanks for any help

Thank you very much, that worked well. I have another question - Can I get rid the labels on bound objects. I want to use different lables that the field names. All help is greatly appreciated. John

I have designed a query driven by parameters in a form with combo boxes. The query is working (I'm running it on a control button) and the dynaset is showing in datasheet view, which is OK, but I want to have the results populate a subform of the form where I have the combo boxed query...

Thank you very much, that is working well. Now my quandry is the output of the dynaset. I am getting it in datasheet view, which is OK, but I want to have the results populate a subform of the form where I have the combo boxed query parameters. I can drag the query into my form and it creates a...

How can I get a query criteria selected from a table value unrelated to the query? In this case my query is of a table of school classes that details the Teacher, Classroom, period, etc. I also have tables that specify teacher's names and class names so they are all entered uniformly. I want to...

Please help me figure put why I am getting a compile error on the following: DoCmd.FindRecord Me.UserName, , , , , , I am getting "Compile Error: expected:expression" I have tried every variation I can think of. Thanks.