Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JamesHardiman

    Importing Reports loses Input Parameters

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

    Using SEEK with ADO and SQL Server engine

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

    Using SEEK with ADO and SQL Server engine

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

    Using SEEK with ADO and SQL Server engine

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

    Split function

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

    Using SEEK with ADO and SQL Server engine

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

    Slow saving form changes

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

    Using Access Object Model

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

    How do I iterate through closed reports in an ADP?

    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)...
  10. JamesHardiman

    How do I iterate through closed reports in an ADP?

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

    Anyone know how to iterate through closed forms and reports?

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

    Anyone know how to iterate through closed forms and reports?

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

    Anyone know how to iterate through closed forms and reports?

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

    Help with some (probably) basic TSQL, please

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

    Help with some (probably) basic TSQL, please

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

    Another Date Problem!

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

    Another Date Problem!

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

    I need an SQL set generation function...I think!

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

    I need an SQL set generation function...I think!

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

    my forms automaticaly return to default settings, how can I stop this?

    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!

Part and Inventory Search

Back
Top