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!

  • Congratulations bkrike 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: *

  • Users: Shamous
  • Content: Threads
  • Order by date
  1. Shamous

    turn of sync logs.

    How do I turn off the sync logs. I want to run in cache mode, but I don't want to have 42 items a day in the sync issues folder. Thanks Rusty
  2. Shamous

    Find a nth item in a list.

    How would I.... I have a query which produces a list like so: REP Customer Date sold -------------------------------- John S Ajax 1/1/05 John S Comet 1/5/05 John S Hotel 1/17/05 John s Miami 1/29/05 ..... John s San jose 3/14/05 John...
  3. Shamous

    upgrade a hard drive by a perfect copy.

    I am stumped. I need to upgrade my 40gig to 100gig using a 2.5 laptop drive. I have a PCIMCIA device that allows me to access a second drive on the system. In the past I have been able to use this (and its software) to make a perfect image or bit copy to the new larger drive which then boots...
  4. Shamous

    On W2k setup. Error on finding Domain

    After setting up W2k pro, I can't seem to get the machine to see the Domain. There is one and I can ping all of the dhcp addresses and the gateway, plus I can get to msn.com. I just can add the new system to the domain and then see the domain. This has happened before, though it is rare. Any...
  5. Shamous

    mp10, can hear sound, no display

    Media player 10 runs, have a tool bar icon and sound, but no display. Any ideas. Just happened today. thanks
  6. Shamous

    Query return result is uncompletely

    Hi, We have a wired problem here. There are two tables A and B, the primary key (see CID) of table A is the foreign key of table B. Table A is in SQL 2000, table B is in Access 97. When two table join in Access 97, the records will not be returned in the result if CID > 999. We didn't have...
  7. Shamous

    insert query problem when upgrade Access 97 to Access 2000

    I have a system which Access 97 is front end, and SQL server 2000 is back end. Currently, I am upgrading my Access 97 front end to Access 2000 front end. Some query don't work after the upgrade. There is an example: Table Name: TestTable (in SQL Server 2000) Fields: Name (varchar)...
  8. Shamous

    Error 430 Can't automate between Access and Excel

    This doesn't work and it should. Any idea why? xlApp.Range("A2").CopyFromRecordset (rs) It tells me that the object is not automatable? Thanks Rusty PS: here is all of the code Public Sub ExportToExcel(strSQL As String) On Error GoTo HandleErrors Dim response As String...
  9. Shamous

    Slide Orientation in Power Point

    Is it possible to have a Slide in the portrait setting and all others in the Landscape setting? Thanks Rusty
  10. Shamous

    Displaying Group Footers Conditionally

    I have a report with two groups. Group0 Header Group1 Header Detail Group1 Footer Group0 Footer All groups(0 and 1) contain "Totals" for the report. Each Group Footer is the same, and I do need both. What I would like to do is suppress the Group1 footer if there is actually no...
  11. Shamous

    Blocking out whole days in Outlook

    I am going on vacation for 10 days. How do I block all 10 days so nothing happens? Thanks Rusty
  12. Shamous

    IIS slow talking to SQL Serv was working before.

    Prior to 3 days ago, IIS/ASP was talking fine with SQL 2000. Now it takes an eternity to talk and get any data, or time out. Any ideas? I have check pretty much everything. Thanks
  13. Shamous

    IIS acessing SQL Serv slow or times out.

    Prior to 3 days ago, IIS/ASP was talking fine with SQL 2000. Now it takes an eternity to talk and get any data, or time out. Any ideas? I have check pretty much everything. Thanks
  14. Shamous

    Weird Query behavior

    Has anyone seen this before, or am I really out of it? :) Why on some '97 systems (not all?) does this happen from a QBE in the criteria section why are the two statements different. 1.) <>4 or Is null (produces 51 lines) 2.) <>4 or IsNull([FieldName]) (produces 26) Conversely, why...
  15. Shamous

    How do you turn off date auto formating in Access 97

    Same applications, two different systems. Both running Access 97 with SR2 On both systems/Applications , a combo box with dates created by code using the Date() function turns out different results. On the first computer - the data is as designed. Date() = todays date, date()-1, yesterday...
  16. Shamous

    USB Controller won't install

    While attempting to install drivers for a USB camera, my USB controller was wipe out. I can't seem to get the Hardware wizzard to install the correct drivers, even when using the proper .inf file(for the chipset of my laptop). W2k always wants to install the generic driver, which then causes...
  17. Shamous

    While attempting to install

    While attempting to install drivers for a USB camera, my USB controller was wipe out. I can't seem to get the Hardware wizzard to install the correct drivers, even when using the proper .inf file(for the chipset of my laptop). W2k always wants to install the generic driver, which then causes...
  18. Shamous

    Outlook programing help

    How do you.... I have a letter.htm file. I want send this as an email but have the HTML file open up and not be an attachment. I have to do this in code using an Outlook Object. I am currently using the following snippit: Const olMailItem = 0 Set objOutlook =...
  19. Shamous

    Auto insert page breaks.

    How can I do a Find and insert a page break? Thanks in advance. Rusty
  20. Shamous

    Address Bar Lag

    Does anyone know why the address bar would lag. I open IE and click the arrow on the Address combo box. It sits there for minutes. What is it try to do? Why doesn't the list just pop down right away? thanks, \Rusty

Part and Inventory Search

Back
Top