Search results

Hi JHB I have attached screen shots of before and after With your great knowledge you must know what i mean.

Private Sub cmd_Details_Click() On Error GoTo cmd_Details_Click_Error Dim rs As DAO.Recordset Dim strSQL As String If Not IsNull(Me.RingNo) Then If DCount("[f_Variable]", "tblsys", "[f_Variable] = 'LastRingNumber'") = 0 Then strSQL = "Insert INTO tblSys...

[Solved] In design view subform appears as a blank white rectangle I was closing the form first. now every thing is ok:eek:

this is from right click on access objects

DoCmd.Close acForm, Me.Name DoCmd.OpenForm Me.Name, acDesign still no different. Only way it works is if i close the form and right click on the Access Object and choose design view

I have tried design view with both, with and with out. this is a pop up form. Access 2010 with no add in's

No, all forms just Dynaset

frm_Breeding_Cocks subform qry_Breeding_Cocks frm_Breeding_Hens subform qry_Breeding_Hens frm_PartnershipDetails_subform qry_PartnershipDetails_subform

Yes, I have 3 sub forms

Hi I don't have any other form open. It is the frm_PartnershipDetails form

I have a button on my form to go to design view. When I change from form view to design view on a form with a subform, the subform usually appears as a blank white rectangle.:confused:

Is the program (of the screen pic's you show ) available. Can it search the whole DB

This question is about an old program called "Find and Replace 9.0" by Rick Fisher I used to use it when I had Office 2003 now I am using 2010 and it want work anymore. The program provides a "Find and Replace" function for Tables (searching design elements such as field names, not the data in...

I have been doing work on it, but just mainly tidy up code etc. I only did it in Excel to start to find out how much work their is. I will use your DB and import mine. Thanks.

I Have sorted it. I was doing a rst.MoveLast with no records:rolleyes:

Would it be very hard to add your tree control. Still working on a couple of problems. One is when i add a new egg when the pair don't have any, i get no current record error.

I do something similar to this manually in Excel and takes a lot off work. This working with 2097, 1 (4) of the first Glosters we got. At the moment only working on children, grand children and great grand children. She has 99 off spring.

Yes that would be great. Especially when selecting birds for the next breeding season. I have written another database to run bird shows in NZ. A lot of bird clubs in NZ use it to run there shows. I have run 2 Nationals show with it. If you would like to have a look at it let me know. It uses...

Hi. I have just got home. Been away so only just read this. Will have a good look in the morning. But what i have seen in the data base it is exactly what i what. Thanks so much.

Do you mean create a new query or use one that i already have.