1,557 Topics
| |
Hi there, I'm trying to create a math quiz that reads a series of questions from a sequential access flat file. The file should contain a series of numbers, separated by commas. The first field(value) should be the first number for the problem, the second should be the second number … | |
Being somewhat new to VB.NET, I built a data solution by using wizards and drag-and-drop on forms. My data is in an Access DB and I opened up those tables with Server Explorer and dragged them into my dataset. I connected the tables to datagridviews. Worked like a charm. Then … | |
how to get null field value from access in vb6 in my 2 record field the value is empty but i'm not able to get that empty field in vb6 ... .... set rs = new adodb.recordset rs.open ("select * from table1 where id = '2'") text1.text = rs!name please … | |
trying to create table in Access2007. CREATE TABLE user (id Text(8), last Text(25), first Text(20), class Text(10), dob DateTime); but table is not being created. ERROR: query must have at least one destination field. | |
Hello! I've got a question here that has me scratching my head - I've got a table of IP addresses. Each octet has its own field (OCT1,OCT2,OCT3,OCT4). The first two octets are fixed, and will never change (so, the IP addresses on my table are between X.Y.0.0 and X.Y.255.255). As … | |
Hello, I have been given a class diagram where a variable called light_years must be a const int and stored in the space class, but later on that value must be used in the main file. Below is the space class class space { private: static const int LIGHT_YEARS; public: … | |
Hello everyone. I am building a small database that will hold information about volunteers and their talents. I have created a search form, in which the user can enter a keyword and it will search the tables for any match. Currently I am using a criteria of: Like "*" & … | |
Hello everyone. I have build a simple MS Access database to keep track of volunteer info (contact, address, phone etc). I have a report that displays each record in a list: record1. Last Name, First Name, phone, email record2. Last Name, First Name, phone, email etc... What I want to … | |
Hello , I'm trying to make an Update query but keep getting the following exception : "Data type mismatch in criteria expression" Here is the query : UPDATE PatientData SET PatientData.[Transaction Stop Time]='6/26/2010 1:07:12 PM' WHERE PatientData.[Patient ID]=6 AND PatientData.[Parameter name]= 'Temperature' AND PatientData.[Valid start time]='9/7/1999 12:00:00 AM' additionally, when … | |
Pros: HARDCORE COVERAGE! Easy installation Lots of options dual band USB sharing 4 guest networks per band fast nice setup menus that look good and easy to navigate lots of security support connections are solid Cons: only thing is lack of print server, other than that it's perfect. Other Thoughts: … | |
Hi every one I'm trying to retrieve UserID (which is autonumber in ms access database) using C# and assign it to string u.I'm totally new to C# and trying to get more skills.... here goes.. string connStr, selectCmd; connStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=..\\library.accdb"; selectCmd = "SELECT * FROM users WHERE First_Name … | |
hi all, i am not able to redirect/login to my owa page. when i run my code below commandd windoe comes and disappears nothing happens. please seemy code below: Sub main() Dim strServerName As String = "12.345.56.789" ' my owa ip Dim strPassword As String = "password" 'my password Dim … | |
I have recently been working on a job with a client who gets their data from county data. The county data is contained in .dbf files. Every year the data is updated and my client will get a CD/DVD from someone containing the county data in .dbf format. Now the … | |
I have a wireless access point. I can connect to it just fine. I can go to Google and I can type in a search, however I cannot GO to the searches result links at all. I've tried IE and Firefox and both the same. I can search for something … | |
I am trying to insert new records into an Access DB and getting some weird stuff. I get the data from a DBF table and load that into a dataset table and DataGridView with no problems. Then I loop through the ds.table and insert it into the DB with this … | |
In MS Access2007, I want to query ([I]q_Notes[/I]) a table ([I]t_Notes[/I]) in which one of the fields ([I]t_Notes.Topic[/I]) is populated from a Combo Box based on a field in another table ([I]t_Topics.Topic[/I]). I will have a table of several hundred records. I want to use the q_Notes query as the … | |
I am having a problem with the configuration setup, I am working in a organization in which 192.198.1.1 ( DHCP) 192.168.1.3 (DNS) 192.168.1.6 (ISA server)- Gateway Ip to wireless Router i.e. Static Ip ( 192.168.1.23) 2. I have configured the router by dhcp configuration , but not working. can anyone … | |
Hi all, I have a form on my program, and I have two comboboxes that I want to fill with data from columns in my database. I've tried three or four different ways that I've found searching around the web, but none of them seem to be working. They don't … | |
Hey guys, I am working on an application for my school and work. I work for the It team that maintains and checks the AV equipment we have around campus and solve the problems associated with them. We usually just mark them down with pen and paper etc. Im trying … | |
Hi Guys.. I've found a little tutorial which seems to show exactly what I have been trying to do which seems to work upto a certian extent. The code I am using is the following: **Code:** using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; … | |
how do i link ms access 2007 with microsoft visual basic 6.0 | |
In my program, I have a section to insert information about a customer into an Access database. I get the error below at the .ExecuteNonQuery. Message: System.Data.OleDb.OleDbException (0x80004005): Field 'Customer.Business_Phone' cannot be a zero-length string. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& … | |
Hi Guys, **<-- Newbie Here!** I seem to have an issue with an INSERT INTO statement when trying to add some textbox data into a DataSet and then update the backend table called 'cashOrders' in a Access Databse. The Following code is being run from the 'Save Button' private void … | |
A Example for OLE DB I Compiled. Put back together for fun maybe. # Someone convert this to ASP.Net plz with a splash screen. # # Required Materials # 1. a vb.net compiler(visual studio vb.net express perhaps?) 2. Libzplay dll(your search engine will help) Imports System.Data Imports ESO.libZPlay Imports System.Data.OleDb … | |
so i have a form with 4 textbox; idnum, lname, fname, dept 1 button i need help about when I type in the idnum.Text there will be results based on the database table (ms access)and auto fill lname.Text... and if it doesn't exist there'll be a prompt. | |
Hi, I am having a couple of different issues. Here's my situation... if anyone has any input, it would be greatly appreciated. 1) A couple of days ago, while I was working on the wi-fi at Panera, I lost internet access. 2) When I went home thereafter, I was able … | |
hi friends i am new in vb coding. i have two tables in ms access table 1 containing location column and id and table 2 containing id, name and date1, date 2...date 30 i have made form design in visual basic with "name" label with combo1 that selecting data from … | |
Hey All! I have created a database application which read and write data in Ms Access. It works well on my computer but when i try to install the same application via installer package to another computer, and run it, it gives me error that i dont have the database. … | |
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace Database { public partial class Form2 : Form { public Form2() { InitializeComponent(); } int baseExp = 200,currentExp,lvl=1,str,intel,dex,armr,min=10,max=25,minimum=2,maximum=3; public void levelUp() { min += minimum; max += maximum; str = int.Parse(strength.Text); … | |
Hello guys, I made a simple program that Add, Saves, Edit & Retrieves Data from a MS Access DB... Dim arrImage() As Byte Dim strImage As String If Not IsNothing(Me.ImageBox.Image) Then Me.ImageBox.Image.Save(myMs, Me.ImageBox.Image.RawFormat) arrImage = myMs.GetBuffer strImage = "?" Else arrImage = Nothing strImage = "NULL" End If myqry = … |
The End.