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!

Recent content by cfbeginner

  1. cfbeginner

    Type Mismatch on Format$ Date

    Hi There, I'm now getting the error: Wrong number of arugments or invalid peoperty assignment. Thanks
  2. cfbeginner

    Type Mismatch on Format$ Date

    I used Format$(Me.Date, "yyyy-mm-dd") but it gave me the below error: Runtime error '2113': The value you entered isn't valid for this field. ContactDate field is in 'Datetime' in my SQL table. Any ideas?? JerryKlmns, Leap year is in 2008.
  3. 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...
  4. 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
  5. cfbeginner

    Replication agent

    Thanks Rob. What are the steps in order setup another subscriber/distributor in another location that replicate with the publisher?
  6. 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'...
  7. 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
  8. 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...
  9. cfbeginner

    Delete from Multiple tables

    Doh! Sorry! I got it! Thanks for all your help.
  10. cfbeginner

    Delete from Multiple tables

    But the tblorders.personID is not used in the form. Only the tblcust.custID. What I need to do is to delete related records in all tables mentioned. Thanks
  11. cfbeginner

    Delete from Multiple tables

    Hi Royvidar, Actually, I found out that tblOrders used a different name in he primary key to join the tables. SELECT tblCust, tblOrder, tblreserve, tblpayment FROM tblUsers INNER JOIN tblOrder ON tblcust.ID = tblOrder.personID INNER JOIN...
  12. 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...
  13. cfbeginner

    Assign one email address to multiple users

    Hi All, I decided to create a distributed group. Thanks for your help.
  14. 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
  15. cfbeginner

    Replication and merge issues

    John, Thanks for your reply. My problem is that I don't have any hard disk space for the log file. So, I have to delete some files on the server to create more space and now is working.
See more

Part and Inventory Search

Back
Top