1,597 Topics

Member Avatar for
Member Avatar for dini.kumar

DATA TYPE MISMATCH ERROR CRITERIA [CODE]Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click If TextBox1.Text <> " " And TextBox2.Text <> " " And TextBox3.Text <> " " And TextBox4.Text <> " " And TextBox5.Text <> " " And TextBox6.Text <> " " And TextBox7.Text <> …

Member Avatar for BitBlt
0
150
Member Avatar for anuradha2011

Please tell me that in Html website what is the code in javascript to connect to a MS Access database that is hosted on NIC Server. If not so possible in javascript then any other option what can added in HTML website

Member Avatar for gotboots
0
235
Member Avatar for anuradha2011

Please tell me how could i run .asp page on html website that is hosted on NIC's web server. Please reply at your earliest

0
109
Member Avatar for dwinn

Hi Everyone, I am writing a program in VBA (within Access 2010) that grabs a specific .txt file, split up the fields as per given specification and imports the values in to an Access table. So far, I can open the file and see what the program is seeing and …

Member Avatar for dwinn
0
3K
Member Avatar for ruba_cti

I need to update a column in access where I should be removing the 7 leading characters in a field.Example: Column value before: AB34567213. Colum value after: 213 So, I tried using VB in Access and this is what I got so far: [CODE]Private Sub delete_leading_chars() Update table_name Set col_name …

Member Avatar for ruba_cti
0
174
Member Avatar for nagatron

Hello to all java programmers I have a java database problem specifically the auto increment. In my MSAccess I have a table named "[B][COLOR="Red"]Confirm[/COLOR][/B]" and in that table I got two fields, the "[B][COLOR="Red"]confirm[/COLOR][/B]" which is set to text and the "[B][COLOR="Red"]id[/COLOR][/B]" which is set to auto number or auto …

Member Avatar for nagatron
0
965
Member Avatar for TerenceZ

I want to give users full access to certain folders in the ProgramData folder. Can this be done with Delphi code?

Member Avatar for pritaeas
0
92
Member Avatar for dwinn

Hello, I am currenrtly trying to write a query in Microsoft Access 2010. This query retreives a list of values from a table I have called tblTable Some of the values are numeric and some are alpha numeric. I am trying to do the query so that when it comes …

Member Avatar for dwinn
0
2K
Member Avatar for dlindner999

I'm still pretty new to this and I need some help. Here's the situation. First the user opens a form to select which database (one of 3) they are working in. Then they will be using several forms. The same set of forms are always used no matter which database …

Member Avatar for dlindner999
0
279
Member Avatar for Walahh

Hello, May be the there is a very simple solution for my problem, but I am stuck on this for 2 days already. May be I had been looking at the wrong places...I would really appreciate any kinds of helps....feeling really frustrated right now. You see, for my project at …

Member Avatar for adam_k
0
267
Member Avatar for JacoScheepers

The command FileSearch does not excits in ACCESS 2007, my code is as follow: How do I import this filein a different code? Public Sub Import_Labolink() Dim sourcefile, destinationfile, miscresults As String Dim i, N, m, o As Integer 'Dim mFileSearch As New myFileSearch ' New code for filesearch N …

Member Avatar for adam_k
0
209
Member Avatar for LnrdPJL

Hi I have an Access 2003 database and website that im trying to code using VB asp.net, it's basically a book and toy library website and what i want to do is have a webpage of items with pictures and when the user logs in to the site, they can …

0
94
Member Avatar for Walahh

Hello, May be the there is a very simple solution for my problem, but I am stuck on this for 2 days already. May be I had been looking at the wrong places...I would really appreciate any kinds of helps....feeling really frustrated right now. You see, for my project at …

Member Avatar for Walahh
0
307
Member Avatar for amanitali2010

hi dear i i have two columns in an access table, first column is of percentage and second is of result . i want that result should be automatically calculated as if the percentage is les than 33 then ruselt fail and if percentage is greater than 33 then result …

Member Avatar for BitBlt
0
91
Member Avatar for booksty

Hello, Please I need an efficient algorithm for ranking records in a database. I know sorting and grouping can produce record ranks, but I want a means of inserting the ranks beside each record as arranged in the table. For example: [CODE=text]This figures will rank 10 - 3 5 5 …

0
64
Member Avatar for kindofsudden

First time poster here... My VB.NET program compacts and repairs my DB, but somewhere in the process unsets the database password. No problem, just reset it through VB, right? Ummm... not sure how to go about that task. So I either need to know how to compact it without losing …

Member Avatar for kindofsudden
0
298
Member Avatar for whin_lopez

Hi guys! Any one have an idea of how to create a sub category in vb.net? well I'm thinking of building a sales and inventory system of computer parts and peripherals and here's the logic. I'll be assigning each of them category like for example: Componenets[INDENT]Peripherals[/INDENT][INDENT]Networking[/INDENT] - Processor[INDENT]- Chasis[/INDENT][INDENT] - …

Member Avatar for kvprajapati
0
537
Member Avatar for reeky_15

I'm a newbie in vb. My first project is a grading system for a certain school. In my login form, there's a [B]Forgot Password button[/B]. In the Forgot Password form, the user is asked to answer a secret question that he filled up upon registration, and if the answer is …

Member Avatar for MarkGia
0
3K
Member Avatar for ClimaxBeetle

[CODE] Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim ds As New DataSet Dim da As New OleDbDataAdapter Dim cb As New OleDb.OleDbCommandBuilder(da) Dim cn As New OleDbConnection Dim cmd As OleDbCommand Dim sql As String 'sql = "INSERT INTO Employees(GivenName, LastName, Gender, JobPosition, Month, …

Member Avatar for adam_k
0
321
Member Avatar for jbd

Hi, I want to use a Word table to collect responses which I'll then put into Access. I want to use drop down boxes in the table to limit the input options but when I convert the table to text so I can then get external data in Access, the …

Member Avatar for adam_k
0
140
Member Avatar for nohal.surya

Q--> i have a [U]employee[/U] table which cantain following field (eid,enm,salry,did) and i need a list which has employeies complete information whose get minimum saler in each department *** only single list cantain all employee info whose get minimum salry

Member Avatar for adam_k
0
154
Member Avatar for navybofus

Hello everyone! I have a problem trying to get a user to be able to query the database with only the fields and specifics they want. Basically... User logs in, browses through record entries and then wants to see how many of the entries are under the age of 21 …

Member Avatar for navybofus
0
265
Member Avatar for saifphp

Hi all, I have a Website developed by PHP4.3.2 and Microsoft Access2000 Database. The Site is running under IIS5 in Windows Server2000. Now I have changed the OS from Windows Server2000 to Server2008 and IIS is 7.5 here. I have configured PHP with FastCGI. But, When I run my site …

0
70
Member Avatar for Techyon

Hi guys, I'm finding myself in a little trouble. I've tried to google this problem, but without much success. Hopefully its something simple I'm missing and someone will be able to help me. I'm writing a little program that will synchronize two access database schema's. It works, to a point. …

Member Avatar for Techyon
0
2K
Member Avatar for tranquil

Hi, I am developing database in Access & VB. My question is how can forms be displayed so that they automatically size to any screen whether it be 15" or 21", for example. Many thanks.

Member Avatar for tranquil
0
231
Member Avatar for jlrafli

could you help me, please ! ... because i am newbie, sorry :) at form vb net 2005, i can browse file .mdb (C:\my documents\db1.mdb), I have created a table in sql server database, where table is the same as the access table that will be imported, after that when …

Member Avatar for debasisdas
0
116
Member Avatar for arjani10

Hello!Somebody can help me to restricted access only a part of my wordpress when asked to register to view it?I need something like this [CODE]<code for restrict view> content to hide </code for restrict view> [/CODE] Thank you..

Member Avatar for arjani10
0
89
Member Avatar for arsalanghouri

please tell me where am i wrong [CODE]try { OleDbCommand cmd = new OleDbCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "insert into purchase(pdate,bill id,ritem,suppname,smobno,qty,rate,amount,payment,balance) Values('" + dateTimePicker1.Text.ToString() + "','" + textBox15.Text.ToString() + "','" + textBox7.Text.ToString() + "','" + textBox12.Text.ToString() + "','" + comboBox2.Text.ToString() + "','" + textBox14.Text.ToString() + "','" + textBox13.Text.ToString() …

Member Avatar for kapojian
0
204
Member Avatar for ibakir

Hey :D , take a look [url]http://www.dalilack.com/marketList.php[/url] click edit on the orange button EX : [url]http://www.dalilack.com/marketFormUpdate.php?Id=11[/url] the id of that user is 11, you can use 'hoho33' as a user name & 'shityshit' as a pass now you notice there's info for each member , and in order when that …

Member Avatar for Stefano Mtangoo
0
1K
Member Avatar for knitex

So i have this problem with a database. Under a section Date of Birth there are about 110000 entries. There are some that just have the year, for example 1978, I'm wondering if there is a way where it can automatically put in /00/00 after the 1978? so it would …

Member Avatar for chuckc
0
273

The End.