Search results for query: *

Hello folks, From what I have read, on this forum and elsewhere, the Shape statement in ADO can be used to create recursive recordsets, where values extracted from a table are used to extract further values from the same table, and so on, for as many nested statements the user has programmed...

Hello folks, I've got a ton of BO reports to schedule in Broadcast Agent (I'm using BO 5.1.4), and I'd like to so by using a bit of VBA. Below is what I have so far, put together from various sources. It fails on the .ExportAsText line. I know this isn't the correct method to use, and I've...

Hi Folks, I hope someone can help, this has had me going in circles since Friday. I'm trying to emulate the conditional formatting of Excel 2007 in 2003. I've been given a workbook that another has created. At the top of its only worksheet is a small table, (C4:C8), that holds 5 possible...

Hello! I'll get straight to the point, and waffle on later... Can I retrieve a value from a recordset and use that value as the function it describes? e.g. If the value in rsSource!BookmarkVariable was "Date", can I parse the word "Date" to give me the date, without writing my function to...

Hi, I'm updating a raft of policy documents with new logos, etc. I've got one word document(Template) open with the new items, and I open each policy document in turn to read and paste into as necessary. I've written a macro that will save the file I'm working on with a new filename if hasn't...

Hi folks, I hope someone can help. I keep getting caught out by things that seem evidently logical, but then aren't! I've rewritten this question several times to get it as clear as possible, but please let me know if you'd like any more information. In a nutshell: I have two linked...

hiya folks! okay, I'm not sure how to articulate this problem but it should be straightforward if I just tell you what I'm trying to do. In vba, I can do this... Dim stDocName As String stDocName = "frmTestForm" DoCmd.OpenForm stDocName ...that is, refer to "frmTestForm" as...

Hi, firstly, thanks to all you folk on tek-tips. I've learnt more useful techniques from these forums than from any book or course! Sycophancy aside :) I have a question about table normalisation the answer to which I've never been quite sure of. I have a table that stores case details -...