1,597 Topics
 | |
| | Hi, I am trying to query a database to retrieve information about a product. Firstly the user must select a product from a Combo box, and what i want it to do is when they have selected a product for it to search for the items that are within the … |
| | Public Class Form1 Inherits System.Windows.Forms.Form Dim con As New OleDb.OleDbConnection Dim dbprovider As String Dim dbsource As String Dim ds As New DataSet Dim da As OleDb.OleDbDataAdapter Dim run = New OleDb.OleDbCommand Dim sql As String Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load dbprovider = … |
 | Hey guys I'ld really appreciate if u can help me with this. I'm building an application that has an access database for storing codes for voters. my problem is that after i update my database with the usual vb codes, i'll have to exit the application before the datagrid view … |
 | I have one Access Database and in one of the column I need to store image file, how can I do that? Can anyone help me. I know how to do this is MS SQL Server Database but not about Access Database. |
 | I just want to know about the new extension in Access 2010. I need to create a database with .mdb and I can't do it with Access 2010 'cause the new extension is .accdb or something like that (I don't remember :$) As you can see, I don't use it …  |
| | Hi, I want to make a report of several fields - however, rather than showing each record for each field I just want to display totals. Given this I think it would read a lot better if I had the field headings in one column down the page, so it …  |
| | I have 2 table [EMPLOYEE] Emp_ID Emp_Name [ATTENDANCE] Emp_ID Emp_Name Time_In Time_Out How do I display it like this. I hope I present this right [CODE] +--------++----------++---------++---------+ | Emp_ID || Emp_Name || Time_In ||Time_Out | <---- FROM ATTENDANCE +--------++----------++---------++---------+ | 1 || Josh || || | <---- FROM EMPLOYEE +--------++----------++---------++---------+ …  |
| | Hi I have an application that has an Ms Access 2007 DataBase which runns great if access is installed. Is there any code that I can use in vb that I would be able to run access with out installing it. Tanks in advance  |
| | Im trying to select data from a MS access database, i have done this for SQL server before with no problem, but now with a Access database i get a run time error for "No value given for one or more required parameters". Below is my code [CODE] Private Sub … |
| | guys can you please help me in displaying columns from my ms access table to a listview in vb.net.. i use oledb in connecting to ms access.. |
| | 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 <> … |
| | 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 |
| | 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 |
| | 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 … |
| | 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 … |
 | 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 … |
| | I want to give users full access to certain folders in the ProgramData folder. Can this be done with Delphi code?  |
| | 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 … |
| | 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 … |
| | 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 … |
| | 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 … |
| | 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 … |
| | 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 … |
| | 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 … |
| | 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 … |
| | 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 … |
 | 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] - …  |
| | 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 … |
| | [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, … |
| | 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 … |
 | 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 |
| | 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 … |
| | 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 … |
| | 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. … |
| | 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. |
| | 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 … |
 | 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.. |
| | 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() … |
| | 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 …  |
| | 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 … |
| | Hi, My Access database has one column named 'Term' and the Table name is 'ATG'. I require to populate my listbox with data in the 'Term' columns. I'm unable to do that using this code. Can anyone tell me what's wrong with this (it displays numbers from 1 to 10 … |
| | "Good Day.. Its my very first database project and I am really excited about it, trying to make for myself… I am an insurance manager and also learning access through free resources like training videos on youtube etc.. kindly help me on my problem Two Tables, tblContributionRegister & tblAgentDetails. tblContributionRegister … |
| | Don't know if this is right place for my question, but Does anyone know if it is possible to have multiple forms visible at the same time while developing an application with Access in "Form View" mode? If so, how does one tell Access to do this? This applies to … |
| | I am looking for a remote support solution. I've looked through the some discussions in the community and found most of them are about web-based solution, or software-based. Has anybody thought of remote support appliance? I personally would go with appliance, as it is more secure and reliable. But I … |
| | i want to know, what kind of addresses do pointers deal with? i mn logical or physical? and how can i access a particular memory area using pointers? PLEASE HELP.......  |
| | Hi All, As shown below, I have already managed to disable all menu items from the QAT. However I would also like the menu option to be completely removed! [code] <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <commands> <command idMso="ApplicationOptionsDialog" enabled="false"/> <command idMso="FileExit" enabled="false"/> <command idMso="Help" enabled = "false"/> </commands> <ribbon startFromScratch="true"> <officeMenu> <button idMso="FileCompactAndRepairDatabase" … |
| | Hello to everyone! I am an engineering student and we have this class wherein we use Microsoft Access. Our instructor gave as a hands on homework using the MS Access. As I do it at home and inputing numbers and etc all that I need to input, suddenly this [COLOR="Red"][B]ERROR[/B][/COLOR] … |
| | Hi, I have a table with 2 date fields startdate and enddate. A program have a start date and an end date like this 01/01/2011-25/03/2011 . Now I want to test any date and get the program it belongs to. Say for the above, 12/01/2011 would return the above program. … |
| | I'm still new to Microsoft Access so I don't have a great understanding of its workings but have spent the past couple of months working on a project to manage the company's telphone bills. I'm essentially compiling the usage from every company phone each month into a final table by … |
| | Hello everyone. I am working on my final project at university for C++, and I got stuck a little. I have an array inside an array. And I want to access that inner array's member and print it with cout. Here is the code: [code=c] void standings(userClub uc){ cout << … |
The End.