Search results for query: *

I believe that this maybe something to do with Column G. On the Colours sheet, this value is numeric (right alignment of cell) and on the array returned it looks to text even though the column is formatted as a number. If that is the case then how would I fix this? UPDATE!! In case anyone...

Hi Folks. Just trying to get a bit Excel happening, not my forte, but can't work out why I'm having this issue So 3 sheets. Entries/Breeds/Colours I'm using the Unqiue/Filter combination to get the base of the data I want. With the Finction below in F1, I get the following What I'm trying...

Thanks Software RT, that was it. It seems strange that code pause on the error and debug returned the correct value, which to me says that the object was there. Wierd... Oh well on to finishing this up. Thanks for the responses guys and have a great day.

I have used this process many times before but I'm can't get this to work main form: (button click event) ... strSexVal = 2 DoCmd.RunCommand acCmdSaveRecord DoCmd.OpenForm "frmPetDetails2", acNormal, , , acFormAdd, , Me!PetID & "|" & strSexVal frmPetDetails2 form: Private Sub...

YES!!!! That was it Duane. Thank you so much. Removed the Link Master/Child fields for the subform. One headache out of the way :)

Ok I'm back. Reading through the much appreciated replies the following applies. Affectively the prefixes on the left are just the filter for the subform. Every time a prefix is clicked on, the subform is requeried (i.e. Me!sfrmBreedersCats.requery) I have removed the BreederID from the query...

Sorry guys, have to do other things for the next few days will check your responses later and get back to you thanks so far

The user doesn't enter or edit data on this form. The form opens with the BreedersID from their details form. All I want them to do is select a prefix on the side to see which cats belong to that prefix. They can double click on the cat to open that record if they want. It works for one...

I have a form that has a subform attached that has some weird behavioural problem basically when I click on a Prefix field and using onclick and a requery it should update the subform. This works in one instance but not for others. When I open the subform on it's own it shows the correct data...

Can you share the SQL behind the report?

Thanks Duane. You got me thinking that I was heading in the wrong direction

YES! got it to work. Not sure how elegant it is but it works for me. So... first off I created a public variable called TransID (integer) On the income field in the Balance form on any field I put this This takes me to correct form. On that form in the On Current Event I put the following...

Ahhh... it seems you refer to them as tabs (with the tab property) anyway. I will keep playing

It called a Navigation Control. Different from a tab control

Looks like the video didn't go through

Hi Duane. My understanding of the sourceobject tag is that it is more like parent. Correct me if I'm wrong. The Club Balance in on one navigation tab subform and the insert (or edit) is on another navigation tab and subform Example in attached video

Have combed the net and have not found an answer to the following. Basically a books program for a club. Backend tables are based upon the TransactionsID in the Transactions table. I wish to be able to double click on a record on a continuous form to open a record on a navigation tab subform...

Hi folks because of changes at Google Maps API I'm making some changes to a maps page I have. The data creates the array from MySQL using PHP. Cutting out of the un-neccessary stuff I end up with this. The code below shows the map but it doesn't show the markers. Getting no errors so I...

Thanks Combo. I'll have a look at this later. the filename function just returns the full path. I use it a few times so created it as a function. Public Function Filename(ByVal strPath As String, sPath) As String sPath = Left(strPath, InStrRev(strPath, "\")) Filename = strPath...

Hi Folks. I couldn't find an answer to my specific problem so came to the gurus I export data from several qureis to the same Excel sheet using DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "qryTS_Shows", strFileName, True DoCmd.TransferSpreadsheet acExport...