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 Rhinorhino 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: cfbeginner
  • Content: Threads
  • Order by date
  1. cfbeginner

    Type Mismatch on Format$ Date

    Hi, I'm getting Run time error 13: Type mistmatch' on the below code: If (Me.Date = "") Or IsNull(Me.Date) Then Forms! frmContact!contactdate = Null Else Forms!frmContact!contactdate = Format$(DateValue(Me.Date), "yyyy-mm-dd") End If My debugger points the problem line is...
  2. cfbeginner

    Recommend Book

    Hi All, I need you to recommend some books for: 1.Microsoft Access and SQL Server programming 2. SQL and replication 3. ColdFusion programming Thanks
  3. cfbeginner

    INSERT record to database error

    Hi All, I'm trying to insert a record into the database in production and received the below error. Runtime error '-2147217900': The identity range managed by replication is full andm must be updated by replication agent. The INSERT conflict occurred in database 'sales', table 'company'...
  4. cfbeginner

    Replication agent

    Hi All, I have a replication agent that is setup so that publisher that replicates with the 5 subscribers every 20 minutes. What are the conquences if I change the to every 10 minutes?? Would there be any perfromance hit?? Thanks
  5. cfbeginner

    help on writing a Query to delete records

    Hi All, I have a 3 related tables, ContactTable: (PK)COntactID, (FK)CompanyRepID, ContactName, CompanyRepID, Address etc... CompanyRepTable: (PK)CompanyRepID, (FK)CompanyID, Location, etc.. CompanyTable: (PK)CompanyID, account, companyname, etc I need to do two things 1. remove from all...
  6. cfbeginner

    Delete from Multiple tables

    Hi There, I would like to turn the below SELECT query in SQL into Access VBA using the DBConnection.Execute(.....) SELECT tblCust, tblOrder, tblreserve, tblpayment FROM tblUsers INNER JOIN tblOrder ON tblcust.ID = tblOrder.custID INNER JOIN...
  7. cfbeginner

    Assign one email address to multiple users

    Hi There, I'm petty new to active directory users and computers. can I assign he email address of Itstaff@rj.com to two users so that when someone email to that email address those two users will received the email. I hoped this is clear. Thanks
  8. cfbeginner

    dateFormat and DateAdd

    Hi All, Right now the below code gives me below colmuns 2006-Q2, 2006-Q3,2006-Q4,2007-Q1 <td class="table_form_header" width="10%">#DateFormat(DateAdd("q", 0, Now()), "yyyy-Q")##Quarter(DateAdd("q", 0, Now()))#</td> <td class="table_form_header" width="10%">#DateFormat(DateAdd("q", 1...
  9. cfbeginner

    Replication and merge issues

    Hi All, Our Publisher replication servers received the error: The merge process was unable to update last synchronization information at the Subscriber.(source: merge replication Provider(agent); Error numer:-2147199481) The log fiel for database 'sales' is full. Backup the tranasaction log...
  10. cfbeginner

    The Process could not connect to Subscriber

    Hi All, We had a power outage in our office at another location and when we boot up the SQL subscriber server, it's not having a problem replicating to the Publisher in another location. We are using the PUSH subscription method. There is an agent to replicate every 20 minutes. The error is...
  11. cfbeginner

    INSERT AND SELECT and assign new value

    Hi All, How do I insert a multiple row an existing table and assign a new value to one of the fields?? Below is my SQL query Insert INTO tblCompany(CompanyID, Type, SoftwareID, LocationID) SELECT CompanyID, Type, SoftwareID, LocationID FROM tblcompany Where LocationID=7 This works great...
  12. cfbeginner

    Re-establishing shared linked files

    Hi Everyone, I’m in the process of creating a new database by getting the latest version of all the files in the existing database(keeping no history), my question is how do I go about re-establishing the shared linked files in the new database? Since our database is large and there are many...
  13. cfbeginner

    Get the lastest version of a file including shared links

    HI All, I need to know how to go about writing a VSS autmation application in VB 6 to get the lastest version of all files in a VSS database and keeping it's shared links as well. Doe anyone have some source code to do that? I appreciate any help. Thanks G
  14. cfbeginner

    Delete duplicate line of data in a text file

    Hi Everyone, Does anyone have a sample code in VB 6 to delete duplicate line of data in a text file. For example, my text file contains: this is a dog this is a cat this is a mouse this is a dog I want to delete duplicate line 'this is a dog. Thanks everyone. VBNewbie
  15. cfbeginner

    Migrating ASP app to .NET

    Is there a third party tool or methods available to make migrating .ASP file to .ASPX files easier? Any suggestions is appreciated. Fong
  16. cfbeginner

    XSL Newbie: XSLT do not display specific item from XML

    HI Everyone, I'm trying not to display one category item from the table, specifically 'News' category. How do I go about coding this in my XSL file. Here is the XML code(partial): <category catid=&quot;4&quot; selected=&quot;0&quot; name=&quot;News &quot...
  17. cfbeginner

    Registering/Unregistering dll

    Hi All, I'm running windows 95 and I can't seems to register/unregister any dll on my registry entry. When I used COM Explorer or using the command method to register the dll, I'm getting the following error message &quot; Failed to load name.dll in order to register&quot;. Any advise as to why...
  18. cfbeginner

    Why is my frame not showing up???? What's wrong with my code?

    Here is the code: <%@ Language=VBScript %> <HTML> <HEAD> <script LANGUAGE=&quot;JavaScript&quot; src=&quot;Navigation.js&quot;></script> <script LANGUAGE=&quot;javascript&quot; src=&quot;Selects.js&quot;></script> <META NAME=&quot;GENERATOR&quot; Content=&quot;Microsoft Visual Studio...
  19. cfbeginner

    VSS Directoy Listing

    We have a large VSS that runs on a server and it is used company wide. I want to know how I do create a agent or some sort where we can dump the the VSS database in a text file. This test file will list all the projects and subprojects in the VSS database. That way people can just do a search on...
  20. cfbeginner

    Runtime error in code

    I'm using MS Interdev, once I select the Quick View, a runtime error has occurred on lIne: 60 Error: Expected ';'. The code on line 60 is: <script language=&quot;javascript&quot;> var tempDesc<%=i%> tempDesc<%=i%> = &quot;<%=arrCategories(2,i)%>&quot; </script> The second error is a syntax...

Part and Inventory Search

Back
Top