Search results for query: *

Hi..Could anyone please share from experience code samples that can synchronize an Access 2000 database to a SQL server 2000 database. Access 2000 runs on a client PC and the sql server 2000 is on a server PC on a LAN. Help is greatly appreciated. Thanks!! Mur

HI!! is it possible to Synchronize an Access Database with SQL Server. I want to use a VB interface and is it possible to use MS Jet Replication engine to do that. My requirement is as belows. I have my Main Database on SQL server. I want my users to enter data while their offline (on an Access...

Hi i found the following code in MSDN where Jet Replication is used to sysnchronize between two Access databases. I want to use ODBC connection for the second database (FY96.mdb).i want to know how can i use this code with a ODBC connection. Sub JROTwoWayDirectSync() Dim repMaster As New...

Specify custom HTTP Referrer URL Hi!.My downloader program requires the above functionality. In other words, when selected a file from a site the users have the option of specifying a Custom referrer URL. (useful on some sites that provides you access to certain files only if you clicked from a...

hi!..well my problem is that whenever i work on winXp suddenly the system restarts. and when booted again the system screen displays strage colors across the monitor (like a motif) and freezes. I checked my VGA cards & re-installed the driver too. But i dont think the problem is an hardware...

Hi!, i've been experiencing strange red patches around my monitor recently. sometimes When i start my PC the desktop icon borders gradually start to turn red & the whole screen goes red and then greenish. sometimes it doesn't happen but i see 4 or 5 red bars around my monitor. is the fault with...

Hi!, i'm searching for some script that would send a bogus/false HTTP-referer when linked from one page to another. in other words lets say. i want to go to, http://www.xxx.com/pg2.asp from, http://www.xxx.com/pg1.asp so here the HTTp-referrer value will be 'pg1.asp'. what i want to do is to...

send Datagrid items to a recordset Hi! i want to print datagrid items to a crystal report. So i hav to send the datagrid datasource (in form1) to a public recordset2, which i can use to retrieve when loading the form2 (reportform) so i would really appreciate if someone could make a suggestion...

Hi i use RDC (CR8.5) to display reports. I'm finding it very difficult on how to use unbound fields in a report. i use the following code on Report form, Dim cn As Connection Dim rs As Recordset Dim Report As New CrystalReport1 Private Sub Form_Load() 'report form Set cn = New Connection...

How to use sum in SQL Update query. Hi i want to achieve the following, which is, the paidamt field in Student table shud be equal to Sum of installment field (in table payments). I wrote the following SQL but why it doesn't work.. cn.Execute "update students as s,payment as p set...

Hi i'd like to use a methodology that prevents new data being added to an existing record with the same field data. ex: if record with mno=9 and bno=4 exists in the table, The system shud prevent any new entry with mno=9 and bno=4.. i used the following dummy code but it doesn't prompt me...

Hi! i use a Listbox to populate Name field. So with that i want to store the particular ID & Description attached to that name. i tried, Do While i < rs2.RecordCount lstModules.AddItem rs2(&quot;name&quot;) lstModules.ItemData(lstModules.NewIndex) = rs2.Fields(&quot;ID&quot;) 'stores...

Hi!!, As i'm new to CR i wud be really appreciate if someone cud sort this out. What i want to do is print all the data from a Recordset(SQL) to a Crystal report. I use CR8.5 Infact to make things simple i have the below code which can print from recordset to 'VB DataReport'.. Private Sub...

Hi! i use a recordset to set datagrid datasource. as below, rs.open &quot;select ID,name,Desc from table&quot; 'rs recordset set dg1.datasource=rs 'datagrid dg1 My problem is how to hide 'ID' field from the datagrid. I dont want to display that column. I know there's a property named...

Hi!!, I wud really appreciate any help for the problem below. well i use a datagrid to input multiple fields of data, for example, col1(module name) | col2(hrs) ---------------------------------------- mod1 | 12 mod2 | 8 mod3 | 6 I dont want to use Datagrids...