1,557 Topics
 | |
 | 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 +--------++----------++---------++---------+ …  |
| | 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 … |
| | [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 |
| | 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() … |
The End.