Search results

Form Names - main form name: XXXXX - form name XRoomInfo which is the subform - In design mode in the main form I click the subform, in the upperleft the name RoomInfo is dispalyed in the drop down. So based on this, how would I change the code you just sent. Since I tried it and it did not...

OnCurrent Event Code Private Sub Form_Current() With Me![RoomInfo].Form .Visible = (.RecordsetClone.RecordCount > 0) End With End Sub RoomInfo is the name of the subform

I have the code to make a subform disappear, but yet it does not when the text boxes in the subform are empty as you scroll through the records. Any one have any suggestions?

How do you hide a subform when there are no records in it. If it is linked to the main form and you are scrolling through records and nothing is in the subform, how do you make it disappear. I have done this before, but have forgot how to do it

Subform Disappearance How about making a subform disappear when there is no record on it. I have seen this and did it before but forgot how to.

Chris-eh Chris-Eh; You are the bomb!! What you said works great!! Is there any other tricks I can do with a subform?

I have two subforms within a main form. I want one of these suforms to just show the text boxes. How can I hide the scroll bar on the side and and the area that advances thru the records. Is it possible to have it look like just two text boxes are on the main form? If so what properties are...

Here is the delete code Hayley: Here is the code generated by the wizard to run the query. Do I substitute what you sent me? Private Sub cmdDCadets_Click() On Error GoTo Err_cmdDCadets_Click Dim stDocName As String stDocName = "DeleteCadetIdQuery" DoCmd.OpenQuery stDocName...

Dialog Box Hayley: What code could I put in the vb side that will give the user the option of yes proceed or no do not proceed. Thanks In Advance!

How would I make a command button that would run an update query. In the command button wizard I did not see anything that would do this. Can some one tell me the code to put in on the VB side to make this work. Query called: UpdateRiflesQuery

Query SQL SELECT [CADET_NO], [dbo_RifleInventory].[PEOPLE_ID], [SERIAL], [SLOT], [TROOP], [DRILL_TEAM], [JR_OR_SR], [DORM_ROOM], [DORM_PLAN], [PREVIOUS_ID], [FIRST_NAME], [MIDDLE_NAME], [LAST_NAME], [dbo_PEOPLE1].[PEOPLE_ID] FROM RifleInventoryQuery;

SELECT [CADET_NO], [dbo_RifleInventory].[PEOPLE_ID], [SERIAL], [SLOT], [TROOP], [DRILL_TEAM], [JR_OR_SR], [DORM_ROOM], [DORM_PLAN], [PREVIOUS_ID], [FIRST_NAME], [MIDDLE_NAME], [LAST_NAME], [dbo_PEOPLE1].[PEOPLE_ID] FROM RifleInventoryQuery;

I created a query where when I click on it to run a dialog box pops upa dn says "Enter Parameter Value" Can you some one tell me how to get this dialog box not to show up everytime I click on the query. I have created the same query in another DB and it works with out the annoying message...

I have a form and have set the properties to have a recordset type of Dynaset (Inconsistent Updates). I changed the data source and now the Dynaset (Inconsistent Updates) odes not work. WHat I mean is that before you could add and delete, but now if it is selected you can not add or delete. It...

Data comes back twice After reviewing the results of the query the data comes back two times for each record. I only need to it to come back once.

What should show up in query When you run the query the id,serial,slot,drillteam,jr or sr, first name, middle name, last name,dorm plan, dorm roomshould show up for each person. Currently I am getting all this information four times or two times rather than just one time for each person.

Table Link SELECT dbo_RifleInventory.PEOPLE_ID, dbo_RifleInventory.SERIAL, dbo_RifleInventory.SLOT, dbo_RifleInventory.DRILL_TEAM, dbo_RifleInventory.JR_OR_SR, dbo_PEOPLE.FIRST_NAME, dbo_PEOPLE.MIDDLE_NAME, dbo_PEOPLE.LAST_NAME, dbo_RESIDENCY.DORM_PLAN, dbo_RESIDENCY.DORM_ROOM FROM...

Table links I tried different scenarios as to they way they were linked and did not get an answer. Is there something I could put in the criteria of a field to bring back what I want?

I have a query that will eturn the same exact data multiple times(4x) rather than just once, is there a way such as a criteria etc. to have only once instance of a record come back when you run the query rahter than four instances of the same exact record?

Adding to existing record I have made it so you can add a new record and delete a record. What I want to do is add or delete fields from an existing record. I have another question in regards to bringing back more than one result of a record. I am bring a record back multiple times when I...