Search results for query: *

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

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.

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

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

Thanks Rob. What are the steps in order setup another subscriber/distributor in another location that replicate with the publisher?

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

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

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

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

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

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

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

Hi All, I decided to create a distributed group. Thanks for your help.

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

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.

I got my problem resolved. The aboce code is ok, but I forgot to make the same changes elsewhere in the form. Thanks

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

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

Yes, its a network issue and the problem is resolved Thanks for all your help.

I'm pretty new to SQL replication Where can I locate the event viewer?