Search results for query: *

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...

Hi Combo Funny how the dd/mm/yyyy format works on 99.999% of the 1000+ records but just not on a few. Anyway I tried your suggestion and it still didn't work (hmmmm...). I have just created DAO solution and that seems to work with either the dd/mm/yyyy or the mm/dd/yyyy format. Go figure...

I have a bit code that checks to see if a client has two or more records in a query and shows a different form based on the result. Simple enough. It works most of the time fine. However, occasionally it doesn't work and returns zero count even through there are records in the query. Example...

Hi Duane Feeling really dumb at the moment. Looking through my code I noticed a reference to the report's name to fill values. Of course I was playing with a copy all the time. Once I changed this it worked (used the label idea). Thanks for you patience and thoughts. I will crawl into a...

Ahhh... didn't think of that (Duh!). Will give it a go and let you know. Thanks

Basically. I use a query to generate the 5 generations and put the ID of each animal into a table (this table is emptied before each append} It then gets read via SQL and I then build each unbound field via code. It's maybe a bit inefficient but it's actually very quick on 150K records. The...

Hi Duane Using Ver 365Ent. And yes the text fields are unbound and filled via a DAO SQL sequence set in the Detail Format statement

Hi folks Got a weird problem. I have a report that prints fine until I put a watermark on it. Then the text fields stop showing. This is before adding And this after adding a background image I've tried gif jpg png all with web colours. the image is only about 2.5cm wide. I have...

Cool! Worked perfectly the first time. Thank you so much for spending the time and helping out. Cheers Howard

That's exactly what I'm after. Thank you! I will have a play and see where I get to.