Hi, I have today completed my first ever program for a friend which displays total hours worked for each day then adds them up.Now I want to transfer this data to store in access. I did do a sample kind of thing last week with flexgrid which worked but i didn't write code! Itshowed me how...

I have a class that needs to work with either Access or SQLServer. Technically, I could have it work with any other, as well, but I don't have need of that at the moment.I believe I could remain in the OLEDB namespace for both, but I wanted to use the SQLClient namespace for SQLServer, and...

hello i'm jane and i'm here to ask for some ideas for my project. we were asked to make a system for a network solutions company. the company does deployment of employees to install networks and stuff. can you suggest what to do with my system? i'm assigned to deal with the employ...

Hello,I have an Excel Spreadsheet I am querying with VB6 and SQL. I am trying to run a report on how many individual products have sold, and what those total sales figures are by product. There are five columns dedicated to product price, so I need to be able to scan all five columns for the pri...

Hey all I have the following code in my .net that calls a stored procedure in SQL Server 2005:Public Module CurrentUser Private conn As New System.Data.SqlClient.SqlConnection Private cmd As System.Data.SqlClient.SqlCommand Public currentusername As String Public currentuserdepartmen...

I am adding a image to an SQL server, which works fine, however when I try to update the image in the database I get the following error:operand type clash: image is incompatable with varcharBy the looks of things it happens when trying to update the image in the database, however if I am insert...

What is the principal of index??<br/>Why it is faster when search and sort?

Hi,I am kind of new in this forum, so if there already was such a question, i am sorry for repeating it.The question is like that:I need to have a Log diary for my software. The problem is that i am using SQLServer in my software, so the most easiest way for me to create that Log diary is by cre...

!!?i have a form that I am trying to filter according to dropdowns.I coded it so if you press ESC it clears the combo and resets the filter.After it gives the error, I can hit F5 and it runs fine. its like it is going to fast?Private Sub SetFilter() Dim FLT As String Dim ctl As Control...

I have a couple of question regarding the Sql 2005 connection. First I would like to state that I am using visual basic 2005 professional, next here are my questions.1.) "What is the difference between Standard Security, trusted connection andprompt user name and password" ?2.) I want to create...

Hi all, I have written an SP in SQL server 2k5 to authenticate logins. At the moment, it runs a select statement to find rows that match both the username and password. Then I use a dataadapter to fill a ds and see whether the ds contains any rows. But I know that I can do this better.What I...

Hello, This is an extension to the thread about authors. To retrieve the buyer and seller for the book. Now, both buyer and seller are users. The table "books" has references to the users table in the fields "sellerid" and "buyerid".With a query like thisSELECT u1.email , u2.email from users a...

hi guys<br/>I am using the oledb and Microsoft.jet engine. i have a list of about 1000 customers in the database under a customer field. On form load i would like to imports all the customers into the combox. How will i go on about doing this.<br/>Regards<br/>Gerald

ok I have a select statement that works perfect...SELECT tbl_Import.*FROM tbl_Import INNER JOIN qry_Del_Complete ON (tbl_Import.ANI = qry_Del_Complete.ANI) AND (tbl_Import.AcctNo = qry_Del_Complete.AcctNo);gets the 3 rows that I want to delete from tbl_Importso I flip the query to a delete query...

I need to write a query with a WHERE clause that looks like:WHERE <Field>= <some value>Normally, this would be easy, but in this case I don't know what data type <Field> is, nor <some value>, though I can be certain that they are the same data type. They could be eit...

I have a project where I am developing a class that will fill a dataset for later use. There is one crucial column for display in the class, but the column, which will be submitted by the user when the class is instantiated, need not be unique. Therefore, the display column will not be of any us...

hello freinds i have a little problem exporting data from access to excel i wrote the code in access vba here is my following code :Function GetChanges()path = MakeFileName()'Create the Excel Object Dim FName As String Dim PArray() As String Dim appXL As Excel.Application Dim w...

I'm trying to call an Oracle function from a VB.NET app and it's returning the incorrect value. It always returns zero. When I run the query in TOAD it works fine. Try objCommand.Connection = objConTFP objCommand.CommandText = ("SELECT APPS.XXTFP_ACCT_GENE...

Hi,<br/>Microsoft says that SQL Server Express can only have local connections. Does this mean local as in the PC that it is on or the local network? I assume it means the PC that it is installed on but I want to make sure.<br/>Thanks!

I'm using the following code to call a function in Oracle. It's returning an err msg: "IS NOT A PROCEDURE OR IS UNDEFINED". Do I need to make a change in the COMMAND TYPE?Dim objCommand As New OleDbCommand() 'objCon.Open() Try objCommand.Connection = objCo...

Hi,a have tried a hole day, so seeking help now.i followed this code guide: http://www.homeandlearn.co.uk/NET/nets12p1.htmlI really like to learn,how to make a search button in the database.What i need is a database (i know how to read and write from/to it)But i need to search on a phone number w...

Some info that may help: this is Access 2000 db VBA that links to a table in an Access 97 db.In a query SELECT DISTINCT [Record Number], Comment FROM Table1Comment is a memo field, and so some records have several hundred characters, and could have more. I didn't write this query, just work...

Hello, I have a books table which apart from other fields has fields author1, author2, author3 which refer to the id in authors table. author2 and author3 may be 0, which means the book has only 1 author. Issue is how to retrieve author names for author2 and author3 only if they are not 0? F...

i tried this and it worked fine on my development PC http://www.vbforums.com/showthread.php?t=393457i compiled it and run it on a client PC that was installed with oracle instant client 10.2 http://www.oracle.com/technology/tech/oci/instantclient/index.htmli got an error:runtime error 3709Requeste...

I've created a program where i can input:Exercises performed,Time taken,Calories Burnt,Weights lifted,Comments about that workout.I also have a "Exercise list" which has all the exercises from Bench pressing, to push ups and pull ups which have the details (Calories burned per hour etc).So...

I need to Insert TableB from TableA with the records that doesnt exist in TableB<br/>INSERT INTO TableB<br/>(SELECT A,B,C,D<br/> FROM TableA<br/> WHERE NOT EXISTS<br/>(SELECT A,B,C,D<br/> FROM TableB ))<br/>Please help .. I am not able to work this out !

I am trying to import a text file into a table. This text file is tab delimited. I have an oracle function that I wish to use in my SQLLoader. This function returns a number. That number will be the value of the second column in the text file.<br/>How can I do this? The version of Oracle is 9i

Hi there<br/>I build an aplication that works with an mysql database and I want to make a periodically update of mysql database.<br/>How can I make an export from mysql to access?

Hi all,Hope you are all in fine tune.I have created a dynamic access database using Microsoft ADO Ext. 2.8 for DDL and security. The database contains tables. The tables are holding fields of both text and numeric datatype. The problem is I am able to make the text fields to hold zero length str...

hi all i have a SQL Query that is like thisselect p1.Property_ID,p1.Lis_key,p1.Func_key,p1.Attrib_codefrom sde.property p1where p1.func_key = 'PV000000'and exists (select 1from sde.property p2where p2.lis_key = p1.lis_keyand substring(p2.func_key,1,5)='GEOSS'and substring(p1....

I have a query that gies me the distice from a postalcode to a store. Itgives me the five closest stores:SELECT `store_id`FROM `distance`WHERE `postcode` =3000ORDER BY `distance` ASCLIMIT 0 , 4Output is here1080100811211073I also have a query that will give me the data from the store:SELECT `Sto...

Hello peopleusing MySQL server, I can type the following querrySELECT id, myfield1, myfield3 FROM table1 Where myfield1 ='test'and then I can access the field 'id' to know the position of the record in the tablebut now I am trying to get info from a Microsoft SQL 2000 server...

Hi!A colleague of mine asked me what a schema was. I explained how it worked in oracle, where you create a schema automatically when you create a database user, and that schema has a 1:1 ratio to the user.But then I stsarted to think about how it works in Sql Server 2005. There, you can inside a...

Hello masters thers a little problem with data grid...I cant fatch records in data grid using ADODB record set I have written code like thislblMasterTbl.Caption = "Table:" & masterTableDim tempConn As New ADODB.ConnectionDim tempMasterRec As New ADODB.RecordsettempConn.Open "Provider=Microsoft....

Hi, I know basic SQL... and I'm fairly knowledgeable in VB.NET. But I was wondering if I could get any help and enlightenment on how I would go about making my VB.NET(2003) application access a database somewhere online. It would just need to read the database and then do something based on...

Hi allPlease look the table query.SELECT [Post_ID] ,[Post_Category_ID] ,[Post_Title] ,[Post_Description] ,[Is_Email_Notification] ,[Attachment_URL] ,[User_ID] ,[Is_Delete] ,[Is_Move] ,[Is_Close] ,[Total_Views] FROM [Cfamla].[dbo].[Post_Detail]S...

Hello. What is wrong with this code:Dim lngRow As LongDim cmd As ADODB.CommandSet cmd = New ADODB.CommandWith cmdSet .ActiveConnection = cnn.CommandText = "update MAIN set SASIA = SASIA + ? Where [KODI]=?".Parameters.Append .CreateParameter("@SASIA", adInteger, adParamInput).Parameters.Append .C...

In this thread ( http://www.vbforums.com/showthread.php?t=450619&highlight=sql+sum) the following code was posted:"SELECT type, SUM(amount) AS totals FROM history GROUP BY date, type HAVING date = '" & Combo1.Text & "' ORDER BY date" My question is simply this:Where does the "..As total...

hi,<br/>is it possible to stop people from importing tables from your access database?

Does anyone know of a quick fix to this problem?I have a column in my table that contains various phone numbers. However to keep these unique any phone number that is a duplicate has been assigned a ~ and the number referring to the duplicate occurrence. So I am left with data as shown below0123...

Hi allI tried to insert a string including special characters like apostrophe s ('s) using a richboxtext in vb6 to sql server 2000 database. I cant insert this string and I always get an error message. if I remove that ('s) then I can insert. please help me to find a solution soon.t...

SELECT dbo.MWorkOrder.MWORefNo, dbo.MWorkOrder.PWORefNo, dbo.MWorkOrder.DateOfService, dbo.MWorkOrder.Remarks, dbo.WOList.Category, dbo.WOList.Dept, dbo.WOList.Mac_Code, dbo.WOList.Status, dbo.BreakDownReport.BRRefNoFROM dbo.WOList INNER JOIN...

The following is a simplification of what I want to do:> It is for my ham radio logging program> which you can freely download from my website> www(dot)wa0h(dot)com> the 0 in wa0h is the number zero.I have a very large database which contains 1 table.Each record in the table contains...

Hello, How can I perform full text search on two different fields for two different values. I mean search field1 for value 'value1' and field2 for 'value2'.Is it something likeSELECT title, author FROM books WHERE MATCH(title) AGAINST('art of war') AND MATCH(auth...

Hello guys;I am Turkish people. Why ? Because my question is not %100 english language ok?Now my question..i'm using VB6 and database is MSSQL my Stored Procedure is create procedure dbo.AracYuklemeProc @personel varchar(10),@guntarih datetimeASSELECT SUM(hesaptoplami) AS AracPerToplam,...

Hi All,I'm going to implement a standalone solution to my company's partners, which is a VB.NET application with some $$ calculations.Some rate data are sensitive and we choose to use sql server express 2005 as local database engine.My concern is that, how can I protect my id & passwor...

Hi,I'm using VB to create a front-end for an access database and I've set up some validation in Access but was wondering how to refer to these in my app to save writing my own duplicate error handling routines. For example, the primary key must be unique and when I try and save data th...

Hey guys.So I was doing some touching up on a program last night, and while I did not change how the database was manipulated, I found that 1, and only 1 field on a table I was working with was being corrupted on insert and/or update. This is a TEXT field.When I query the database in MySQL, the...

hello guys :bigyello: i just wanted to ask how can i create triggers from code using VB6 or anyother version of VBi made a command and assinged the trigger script to the command but i didnt work out ! it sounds the commands connot exexute T-SQL scripts cmd.ActiveConnection = conn cmd.Comma...

Ok. How about this one?I'd like to add a "Diary" feature to my app. The user would:1) click cmdAdd, which would create a textbox at runtime2) enter a note, comment into this new textbox3) click cmdSave, which would add a new record to TblComments in Access 2003--4) When app is reopened, cre...