Search results for query: *

When we import reports from one ADP to another, the report in the new ADP seems to loose its Input Parameters. Anyone else come across this? Or have any idea what we're doing wrong? Regards, James Hardiman JamesH@Sunsail.com

I'm trying to do something which shouldn't be rocket science! I'm working in an Access Project (.ADP) with a SQL Server database. I have a table with a compound key (two columns). I need to find a record. I'm using ADO. cn.ConnectionString = "etc" cn.Open Set rs =...

Yesterday I got help with iterating through the Reports collection (whether or not closed or open)... for which thanks! Now I'm trying to iterate through the properties of a report, but can't get my head round the object model. This is what I have: Private Sub cmdDoit_Click() Dim obj As...

Access (bless its heart) has corrupted my database, and none of my (100s of) reports now have any input parameters. I want to do something like this: Private Sub cmdDoIt_Click() Dim r As Report For Each r In Reports If r.InputParameters <> &quot;&quot; Then Debug.Print...

Access (bless its heart) has corrupted my database, and none of my (100s of) reports now have any input parameters. I want to do something like this: Private Sub cmdDoIt_Click() Dim r As Report For Each r In Reports If r.InputParameters <> &quot;&quot; Then Debug.Print...

Morning, everyone. I'm confused about how to mix setting variables and using them in the middle of my select statement, and don't even know what questions to look up in the online books. In the following code (which works fine), I keep getting the SQL engine to work out the same stuff over and...

I have a bunch of records in a table. First column called ValueDate, created thus: INSERT INTO tblStockValues SELECT getdate() as ValueDate, blah blah... If I run this from Query Analyser: SELECT CONVERT(varchar(30), ValueDate, 113) AS blob, ProductId FROM tblStockValues I get this: blob...

I have a DB that allocates guest numbers. Don't want to use AutoNumber, because I need sequential numbers. Also, I want to re-use deleted numbers. At present I do this: intRangeLower = DLookup(&quot;RangeStart&quot;, &quot;tblAvailableNumbersRanges&quot;, &quot;TableName='&quot; & t &...