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

That's it. It worked. Thanks, all. I went with the filter option in the end. If anyone wants the full code to record all properties of all reports from two ADPs into one table, print them, and list the differences, let me know! JamesH@sunsail.com

It definitely doesn't like AND ... and the help agrees. You get error 3001: Arguments are of wrong type, in conflict, don't agree. Filter seems to work OK; I think this code is working OK: Private Sub cmdDoit_Click() Dim obj As AccessObject, dbs As Object Dim rs As ADODB.Recordset Dim cn As...

Thanks for those two replies: I tried the FIND like you suggested, but it whinged, and I thought that was because it doesn't like AND. I'll try that, and the filter: trouble is I'm working my way through 99% of all the records in a 10,500 record recordset... likely to be a bit slow! I'll give...

This is in Access. Create a form, place on it a text box (txtMyString), a list box (lstMyList), and a command button (cmdSplit). Go to the properties of the list box, and set RowSourceType to Value List. Stick this code behind the button: Private Sub cmdSplit_Click() Dim myArray() As String...

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

I regularly make it part of our development process to rebuild our ADP: create a new ADP, import everything, reset the references, recompile, compact. Saves several squigabytes, but within minutes of starting work on the new ADP, it's big and slow again. It only seems to be forms that are slow...

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

That did it. Thanks. If anyone is interested, I have expanded on that so that I can go through any property of all objects in one ADP, and write the results to a table, and then do the same in another ADP, writing the results to a different column of the same table (keyed on the object name)...

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

... so it would make sense for me to append this question to the ADP forum! doh! James

I got really excited there, for a few moments... but the thing I ommitted to mention is that I'm working with an ADP, not an MDB. Whoops! Is there an ADP equivalent? Or, how do you get to msysobjects from an ADP? Ta James

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

Hmm! JHall's reply looks like the one that leaves me feeling best, and doing the least work! So thanks for that! I started to try JayKusch's approach, but it felt like I was headed in the general direction indicated by JHall, and would need separate SPs or views. If anyone knows anything we...

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

Mm. As usual, I'm getting an education here! Thanks; with your help I got there: Alter Procedure &quot;aaSP&quot; as DECLARE @date1 varchar (35) DECLARE @moomoo varchar (435) SELECT @date1 = '2003-08-20 16:25:40' set @moomoo = 'select * from tblStockValues where ValueDate >=...

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

Wow! That hurt my brain! But I think I got there in the end. This is what I've ended up with: SELECT IDENTITY(int, 1,1) AS ID_Num, GuestId into #gapper from tblGuests select top 1 ID_Num from #gapper where ID_Num < GuestId if @@ROWCOUNT = 0 select max(ID_Num) + 1 as ID_Num from #gapper...

I haven't tried Snag56's code yet, but I've got this SP that deals with the case that James Lean said he hadn't. Not stunningly elegant, but it works: Alter Procedure spNextNoReuse @Num1 int=0, @Num2 int=0 As SELECT @num1=ISNULL(MIN(t1.GuestId) - 1, 1) FROM tblG t1 LEFT OUTER JOIN tblG...

Guess so. You're into playing with it and trying it out now. Append your code here for others when you get it to work!