5,053 Topics

Member Avatar for
Member Avatar for ninjaimp

HI I am trying to write data to an access table from vb.net. The code all seems to run fine but no data is being sent to the db though! the code i have got is [code] Dim itemcount As Integer Dim MyCn As OleDbConnection Dim sql As String 'Dim …

Member Avatar for happy@usa
0
241
Member Avatar for Sunshineserene

Hi, I have a java program with quite a lot of classes. I'm facing a problem with accessing some variables from another class. May I know how to I access it? Is it possible?

Member Avatar for tong1
0
14K
Member Avatar for miweiser

Can I get some assistance with the T SQL syntax required to use the contents of this combo box in a pass thru query in order to improve performance response time over the LAN [CODE] [Forms]![WELCOME]![FILTER_BUILDER].[Form]![Combo28] [/CODE] Apparently TSQL doesn't like the "!" from Access: [CODE] SELECT dbo_A_VIEW_LOWEST_LEVEL.contract, dbo_A_VIEW_LOWEST_LEVEL.[Profit Center …

Member Avatar for miweiser
0
195
Member Avatar for keeda

Hi, I have a table Employee that has a coloumn EmployeeID, SupervisorID, and Active(values Yes or No).. I need to find the number of Active Employees(with Active as Yes) under each supervisor.. how can I write the query? I am using Access 2007. Thanks!

0
72
Member Avatar for keeda

Hi I have 2 tables say A and B. Table A has EmpID, First Name and Last Name. Table has Award Recipient, Award Presenter ID(EmpID format). I want to write a select query where I want to fetch First and Last name of the Award Presenter from table A based …

Member Avatar for keeda
0
102
Member Avatar for ryan311

i have a problem in connecting in access 2003 here is my code Module Module1 Public cn As New ADODB.Connection Public rs As New ADODB.Recordset Public Sub connection() cn.Open("[B]Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Project Management\pm.mdb;Persist Security Info=false[/B];") cn.Open() End Sub Public Sub OpenRecordset(ByVal sRecordset As ADODB.Recordset, ByVal sString As String) sRecordset.CursorLocation = ADODB.CursorLocationEnum.adUseClient sRecordset.Open(sString, …

Member Avatar for lolafuertes
0
76
Member Avatar for kerek2

Hi all...need help from u all...i already develop system using VB.net with Microsoft Access 2003 as my database. when i running in Windows XP it's working great but when running in Windows 7, i can't insert into it...can anyone help me plz

Member Avatar for kerek2
0
141
Member Avatar for kashy!

I am having a small problem with dataset problem defination is: _____________________________________________________________ System.Data.OleDb.OleDbException was unhandled ErrorCode=-2147217843 Message="Not a valid password." Source="Microsoft JET Database Engine" ________________________________________________________________ and My connecting string is: _______________________________________________________________________________ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="D:\Shop Inventory\database\DATABASE.mdb";Persist Security Info=True;Jet OLEDB:Database Password=123456789" ________________________________________________________________________________ WHERE the password I added is right but whenever I try …

Member Avatar for tarikraza143
0
200
Member Avatar for bluerdanblue08

Anyone please help me! I would like to learn and create a crystal report with ms access database and view it with crystal report viewer for our special project in school, I have no idea and I tried to look for some tutorials in web but I didn't saw a …

0
81
Member Avatar for techie1991

I have just started writing C code in dev-c++. The programs are running fine, but each C program shows me the following warning: [QUOTE] [Warning] command line option "-fno-access-control" is valid for C++/ObjC++ but not for C[/QUOTE] The test program I used was: [CODE] #include<stdio.h> int main(){ system("pause"); return 0; …

Member Avatar for Kanoisa
0
573
Member Avatar for mrshowrules

Here is the copy of the log file from hijack this. I can access exe files, task manager etc. IE opens but the searches open up spam sites and other search sites. I ran malware bytes and cc cleaner. please advise: Logfile of Trend Micro HijackThis v2.0.4 Scan saved at …

Member Avatar for crunchie
0
82
Member Avatar for seldridge

My name is Steve and I am a GIS freak and geek from the days of actually using a pencil and paper but have graduated to the digital age. Look forward to getting and giving some help. My strong points are ArcGIS Models, MS Access, and other Microsoft stuff, my …

Member Avatar for mackone
0
223
Member Avatar for gangaloves7

hi i wanna combine all three column values in column... i want some thing lik this PartNo Stock Obsolute Replaced order part no 12345 10 12345 12346 10 12346 12347 11001 11001 12348 11002 11002 12349 12349 Empty 12350 12350 HELP ITS URGENT!!!!!!!!!!!!!!!!!

Member Avatar for kinwang2009
0
125
Member Avatar for lgriess

How do I configure the PasswordRecovery object so that I can pull the password from the webservice rather than allowing direct access to the sql server database? Where does PasswordRecovery even do the sql for getting the users password from the database? All the examples I've found show the PasswordRecovery …

Member Avatar for Momerath
0
163
Member Avatar for ticktock

Hey all, I am currently fiddling around with SQL/Access statements in C# and created a very simple dictionary program that will search for the words depending on the length of each text entered in one text box. So when the user presses the search button it the program will search …

Member Avatar for Fezzer
0
463
Member Avatar for tycomps

Hi all, Win xp pro sp3, ie8. Firefox connects and is functional, internet explorer will not connect. Malwarebytes connects and updates no errors found in safe mode scan. Mcafee update fails with connection error and windows update will not connect. Below are associated logs, any help is greatly appreciated. Thanks …

Member Avatar for crunchie
0
274
Member Avatar for apachex

I need help for connecting my 'Access' database to asp.net website. Coding is in C# . I was working on making a registration page, but since i was unable to connect, I tried a test code for login and it ain't working :icon_cry: I am using the following code for …

Member Avatar for dnanetwork
0
232
Member Avatar for qiera

i am new with vb and this is my code that i work with.. there are errors in my code to view data from ms access into data grid.. can anyone help me to solve this problem? thanks... Imports System.Data.OleDb Public Class frmView Inherits System.Windows.Forms.Form Dim DB As OleDb.OleDbConnection Dim …

0
33
Member Avatar for gdsbt1

I am on a trip away from home and have my Toshiba laptop with me. The past week or so I have been getting redirected to random sites when I do a search and click on a search result. I am assuming I have picked up a Trojan or something, …

Member Avatar for jholland1964
0
135
Member Avatar for elanch

hi all! I need to make a form in Ms-Access as EXE file. So that the file can be runned without opening Ms-Access. I know that, it is possible in Vbasic but whether it is possible to do in Ms-Access. Thanks

Member Avatar for Petre
0
3K
Member Avatar for jigen7

Hi to all, I currently need help ,we have a case study assignment , so far i need some information on how to implement this kind of network plan, for example what hardware and equipment would be necessary to satisfy the network needs.any info would be helpful thanks So far …

0
72
Member Avatar for slingingshot15

hi there, my name is brian. i am doing a final year project for school and i need to come up with a school databse using microsoft access. can u al give some ideas as to what should be included in the database. eg. what it should be used for...eg …

Member Avatar for MoZo1
-1
93
Member Avatar for wenjaun

Hi all: I am working with MS Access and developing a form to let user to enter the caller's info into the database. Let say: Bob first time called in and the user entered all his personal information into the database, let say, next day, Bob called again; for time …

0
69
Member Avatar for rowdyrode

Hi, I don not know how to properly code with VB but I did write scropt with winbatch. I have a MS 2003 Word app that I want to add seven drop down list box's into it that will populate the main list box from the database then once a …

0
78
Member Avatar for revolution3396

I need a vb code as below This is my login page [ATTACH]16718[/ATTACH] This is my login page code Private Sub StudentLoginButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles StudentLoginButton.Click Dim connection As New OleDbConnection("Provider = Microsoft.ACE.OLEDB.12.0;Data Source = ../Data/Student.accdb;") Dim command As New OleDbCommand("SELECT * FROM Student WHERE …

Member Avatar for Animal Mother
0
158
Member Avatar for Animal Mother

Hi everyone Could someone please help me, I need to loop through all the records in a column in my access database, Currently my program only views the first record in the column and does not go any further, I tried a While loop but I get a NullException error …

Member Avatar for Animal Mother
0
1K
Member Avatar for zack_falcon

I am doing a Quiz Generator / Viewer project, which requries the use of a database for the numerous questions the teacher has to put in, as well as the user names, passwords, etc. I used Microsoft Access (2000, I think) because I found it easier to use. For the …

Member Avatar for zack_falcon
0
143
Member Avatar for sophisticated19

Hello everyone.. I desperately need your help to tell me how can i retrieve the data that i've stored in an access db column and display it in a combo box in a vb2008 project? thank u in advance..

Member Avatar for AndreRet
0
90
Member Avatar for rhonda2010

Hi! I am having a problem with the project I am working on. The project will have more than one query; however, I cannot get the simple one to work yet. I have a form with two text boxes and a button. I also have an Access database that I …

Member Avatar for JSS at MSSU
0
861
Member Avatar for kckrns

Hello all, I am currently working on a project that requires an update within an Access Database. There are photo folders, and the user defines the path name via a dialog box. That path name is stored to a string value, and through OleDBReader, the actual name of the photo …

Member Avatar for Niranjan003
0
109
Member Avatar for Loadstone

(This is a repeat post from C# section since I just found this section and thought it might apply.) Hi guys, First I want to apologize for such a lengthy post. I'm attempting to give as much information as I can, and I'm sure I'm leaving something important out anyway. …

Member Avatar for Loadstone
0
326
Member Avatar for Loadstone

/edit: I found the Windows Servers forum section and posted there as well, but if you have any input I'd appreciate any help I can get. I'll be checking both threads for replies. Hi guys, First I want to apologize for such a lengthy post. I'm attempting to give as …

Member Avatar for Loadstone
0
251
Member Avatar for Coder Smurf

I am trying to develop a subroutine that will send an IM to a user. The idea being if the user is online, the code sends an IM to the user via communicator. If the user is offline, it sends an email. The code does work, in that it does …

0
103
Member Avatar for nv136

Hello, everyone. I have a small program, and i want that program to show how much RAM the whole system is using, and i want it to show how much R.A.M my program is using, any ideas on how to do that? is it hard?

Member Avatar for nv136
0
143
Member Avatar for Sidicus

Hello Everyone, I am trying to find a good way to get information from a website into a access 2007 database. Im thinking I should have the website write a text or xml file with the data on it and then have some program (or access itself if it can) …

Member Avatar for leo002000
0
97
Member Avatar for SacredFootball

Confusing question? The only way I can explain it best is to show it: [CODE] Table1 --------------------------- Name Num1 Num2 Num3 Devin 224 18 845 Scott 322 32 652 Jim 179 46 929 Tim 202 41 562 [/CODE] [CODE] Query Getting Max Value --------------------------- Num1 Num2 Num3 322 46 929 …

0
78
Member Avatar for jackcuso

Hi there I have been having a hard time with the rediction of pages, I got the Antivir Pro solutions a few days back , I go t rid of it but after that everytime i open a browser page another one opens, and every link i click on a …

Member Avatar for crunchie
0
354
Member Avatar for johanb

I am running Win7 pro and the Microsoft Virtual XP. The virtual machine uses a separate VHD for it's user generated data, a small 1 Gig fixed size virtual harddisk. I attach this VHD in read-only mode to the host [B]while the Virtual XP is running[/B] for backup purposes. This …

Member Avatar for johanb
0
228
Member Avatar for Heyzaneretro

This problem all started when I bought, installed, and then tried to get Starcraft 2 to work with my video card. Suddenly I am being plagued by a multitude of problems. The first, and possibly most annoying, is everytime I launch internet explorer I get a runtime 217 error, and …

Member Avatar for Heyzaneretro
0
331
Member Avatar for gunbuster363

I am using the newest version of ubuntu the network is ok, I can google, I can facebook. But when I try to check my company webmail (internal), it said cannot resolve hostname what is happening? My window vista is doing ok with the webmail. The webmail is microsoft online …

Member Avatar for gunbuster363
0
203
Member Avatar for DreamscapeEagle

I'm trying to create a Web Form Application for my class final. I downloaded the zipped file and extracted it of course. When I go to Data/Add New Data Source and follow the prompts in the Wizard I get to the screen that you choose your Database Objects, I get …

Member Avatar for DreamscapeEagle
0
111
Member Avatar for vali3878

I was using AVG and Avast simultaneously until I was advised that it was a no-no. I uninstalled AVG and kept Avast. Google searches are redirected to Searchlight and others. Some webpages won't display showing a MGINX error page. I'm blessed with Audio of Obama playing randomly. And Outlook opens …

Member Avatar for crunchie
0
349
Member Avatar for cgcgames

I am Working on Conecting to a database in windos forms C++. I use MVC++. here is a link to my DB file so people can see what i have tried to do in the DB. [URL="http://www.mediafire.com/?yfr52oqcknakk9g"]http://www.mediafire.com/?yfr52oqcknakk9g[/URL] you need access to see this. i have finaly figured out how to …

Member Avatar for cgcgames
0
201
Member Avatar for selicon.valley

i am developing website which on asp.net n backend is microsoft access now i have the grid into it with show 3 colums my questions are if i want to add2 more colums which i want to 5 how do i do now i want to add records into grid …

Member Avatar for plusplus
0
141
Member Avatar for undergroundx64

Could you please answer these questions? 1. Name, job title and place of employment -- 2. Do you use Microsoft access, excel, power point or word? & how long have you been using it? -- 3. Did you have any formal training? Or did you teach yourself how to use …

Member Avatar for devLady
0
139
Member Avatar for OsheRono

Greetings, I have been cracking my skull all weekend trying to find a solution to this, and I have no idea how to search as I'm not sure what to search for (I have performed a search, but it didn't show what I was looking for, hence, the post). I …

0
89
Member Avatar for cgcgames

Hello Everyone I have been looking on the net and I found a few things but I am a bit think :P. I need more of a walkthrough kind of things. I am currently making a programe for a game and I need to access a database that has information. …

0
84
Member Avatar for mayasmom20

The virus name comes up in AVG as adwaregeneric.BBO It is in the myway search assistant that I can't delete from my computer. I hope someone can help because I have had a problem with this virus for forever. Even after restoring my computer to factory settings it still hangs …

Member Avatar for jholland1964
0
140
Member Avatar for Andy_Parr

Hi, I have a database linked to my VB.NET project using the data source wizard. I've created a log in form using a table in access that has the details required to log in. The code is: [CODE]Imports System.Data Public Class Form1 Dim conn As OleDb.OleDbConnection Dim strSQL As String …

Member Avatar for NoOneSpecial
0
458
Member Avatar for selicon.valley

i m developing website using asp.net with microsoft access 2003 i have product details along with the images now i want to add this images into database but how i add this pictures what code is use if there are 100 products with 100 images i want to show 10 …

Member Avatar for selicon.valley
0
115

The End.