5,053 Topics

Member Avatar for
Member Avatar for end3r

Hi, I am not sure what is the best solution for my problem so I really need your advice. Here it goes... I have an intranet setup at work and I am acessing a web app from let's say IP 192.168.0.40. The intranet computer from which I am accessing it …

Member Avatar for JorgeM
0
7K
Member Avatar for slymdjay.gunshot

Hi geeks!! im working on a project (in visual studio 2008) where i need to create a reminder which will prompt every month for showing the actual state of fees a number of customers have left to pay. the project uses access as database and will have a fixed amount …

Member Avatar for phorce
0
583
Member Avatar for Obike

I'm having a problem updating records from my VB.Net application to the database (Access Database). I've tried all sorts of update technique and i keep getting either "syntax error in update statement" or "data mismatch in criteria expression". heres the code i'm using: Public Function save1stsemester() 'this code updates 1st …

Member Avatar for Obike
0
558
Member Avatar for krunal1986

hi all, i am sending mail through exchange server version Exchange2010. below is my code: static void Main() { try { string owausername = string.Empty; string owapassword = string.Empty; string mailFrom; string mailTo; string mailSub; string mailBody; ServicePointManager.ServerCertificateValidationCallback = CertificateValidationCallBack; ExchangeService service = new ExchangeService(ExchangeVersion.Exchange2010); EmailMessage email = new EmailMessage(service); …

Member Avatar for krunal1986
0
660
Member Avatar for anmolvatsa

FOR FOLLOWING CODE <%@language=VBScript%> <%Option Explicit%> <html> <body bgcolor="aqua"> <% Dim myConn Set myConn = Server.CreateObject("ADODB.Connection") myConn.Open = ("DRIVER={Microsoft Access"&" Driver (*.mdb)};DBQ="&"C:\Inetpub\wwwroot\tizagASP\razor.mdb;") myConn.Close() Set myConn = nothing %> </body> </html> I GOT FOLLOWING ERROR The page cannot be displayed There is a problem with the page you are trying to …

Member Avatar for ptduran
0
151
Member Avatar for rkodsi

I have one of our servers Win2003 EE SP2 out of sudden the following services stop: automatic updates, computer browser, cryptographic services, distributed link tracking client, logical disk manager, secondary logon, server ,wireless configuration , workstation. when I try to start server service it give me error 5 access denied, …

Member Avatar for rkodsi
0
335
Member Avatar for casheltown

I'm trying to use Microsoft Access to produce a contacts database for a local charity. Unfortunately I can't get my head completely round relational databases. I understand the basics but can't solve a particular problem. Can anyone help? I currently have four tables (Contact, Organisation, Children, SpecialNeeds) that need the …

Member Avatar for casheltown
0
154
Member Avatar for maurice91

Hi, I have a Vb.Net solution that contains several forms that read/write to an MS Access database. My problem: When I copy my Vb.Net solution and Access database to a new computer, the data source connection string needs to be changed. Currently the data sources wizard sets the connection string. …

Member Avatar for Lethugs
0
207
Member Avatar for ahmed_one

I need some help to make a order form in C#. My development environment is: Microsoft Visual Studio 2010 Ultimate SQL Server Express Edition 2005 Programming Language C# Sample Database = NorthWind (Tables Orders and OrderDetails) I've create a form for order entry, which contain a textbox for OrderID, a …

Member Avatar for ahmed_one
0
2K
Member Avatar for vijaycare

Hi All, I would like to thank this community for the enormous help to develop my skills. Thanks. I have 2 databases and a single report form and a crystal reportviewer. The User can select the database which he want to work (Each of them belongs to different warehouse) So …

Member Avatar for john.knapp
0
477
Member Avatar for holidaydarin

Explorer is running in the background and I can't stop it. This has been going on for a week or so. Explorer sometimes runs as two processes simultaneously, one under "New User" and one under "System". I use Firefox 99.9% of the time. Any advice will be much appreciated. Below …

Member Avatar for holidaydarin
0
377
Member Avatar for kinbo

I wrote a C# code called parent. When i run the program and try to add parent details to the database( microsoft access 2010), it gives me this error: Exception in DBHandlerSystem.Data.OleDb.OleDbException (0x80040E14): Syntax error in INSERT INTO statement. 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) …

Member Avatar for deceptikon
0
2K
Member Avatar for beginner_emman

hi, can anyone please check why im getting dataype mismatch error... im using combobox and msaccess db which consist of formNo(autonumber) LastName FirstName MiddleName Address (text) ... if i use address as valuemember there is no error,, but if i use FormNo as valuemember then there this datatype mismatch error.. …

Member Avatar for Reverend Jim
0
656
Member Avatar for joshl_1995

Hello Community, I was wondering if there is a way to restrict sub directories from accessing the parent directory (the main directory where all my website file are stored) and from having any interaction with the previous folders (so once there in the child folder they can't leave it eg. …

Member Avatar for pritaeas
0
293
Member Avatar for diode2012

Greetings Techies, My access to Youtube via IE 9 has become intermittent. However, it's fine with Google Chrome and Mozilla Firefox. I have tried disabling the ActiveX Filtering and tried the Compatibility thing too. The JavaScript is enabled and working (I checked it on javatester.org). I have Googled for the …

Member Avatar for diode2012
0
148
Member Avatar for kikiey

can anybody help me how to make a LAN connection for messenger such as yahoo in a big connection like in hostel? i use microsoft visual basic 6 and microsoft access as a database. pls help me :(

Member Avatar for AndreRet
0
290
Member Avatar for andrew_dvw_usr

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 …

Member Avatar for Reverend Jim
0
229
Member Avatar for kindofsudden

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 …

Member Avatar for john.knapp
0
416
Member Avatar for sachins1986

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 …

Member Avatar for AndreRet
0
2K
Member Avatar for hwoarang69

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.

Member Avatar for BitBlt
0
146
Member Avatar for jay.barnes

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 …

Member Avatar for jay.barnes
0
312
Member Avatar for nathaniscool99

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: …

Member Avatar for deceptikon
0
269
Member Avatar for tricket_7

I am having trouble getting the codebehind to execute properly. I am new to c#.net, what I have is a web-based log in form that when the user enters their username and Id it will check against ms access to verify the username and password. I am getting this error …

Member Avatar for Mike Askew
0
162
Member Avatar for Tobyjug2222

Hey Guys, I'm an A level student studdying Computer science, and hence using VB.NET for my coursework. Therefore I'm very novice at VB! While trying to update Data in a Microsoft Office, Access table (Office 2010) - I get this error. (In VB) Bare in mind, I've read all this …

Member Avatar for Tobyjug2222
0
610
Member Avatar for Geli19

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 "*" & …

Member Avatar for Geli19
0
830
Member Avatar for Geli19

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 …

Member Avatar for Geli19
0
191
Member Avatar for 404notfound

I found a tutorial online that so far has been aswesome. I downloaded the access db and so far can read and browse through it. However, when I try to write back to it (btnSubmit_Click), nothing happens. All other buttons work fine, I can still browse, and I get absolutely …

Member Avatar for XEN0
0
181
Member Avatar for pilesos

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 …

Member Avatar for Nijil
0
270
Member Avatar for remixedcat

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: …

Member Avatar for remixedcat
0
293
Member Avatar for vindom

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 …

Member Avatar for vindom
0
331
Member Avatar for krunal1986

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 …

0
166
Member Avatar for vindom

Hi! I'm writing little software just to get some practice in c#. I have listview in form 1 where program displays first name and last name form access database. When admin selects name/surname in listvioew and press show usercard(form2) I have a label in form2 and I want it to …

Member Avatar for vindom
-1
1K
Member Avatar for gosweetten

Hi everyone, Im newbie...I have comp problem...Pls kindly help me... T_T I dont know what happened... usually I can install new font ... **Local Disk (C)_Windows_Font** ... and open the WINDOWS EXPLORER to view the font that I already installed or copy paste the font to this folder... Then suddenly …

Member Avatar for Djmann1013
0
368
Member Avatar for khair.ullah

Creating a Report in Visual Studio 2008 In this section, you create a report that draws its information from the sample Microsoft Access database that ships with Crystal Reports. To create a report with secure data from the Your database follow these steps . 1. In Solution Explorer, right- click …

Member Avatar for khair.ullah
0
423
Member Avatar for hemalatha.nambisan

# # Based upon the NCSA server configuration files originally by Rob McCool. # # This is the main Apache server configuration file. It contains the # configuration directives that give the server its instructions. # See <URL:http://httpd.apache.org/docs/2.0/> for detailed information about # the directives. # # Do NOT simply …

Member Avatar for hemalatha.nambisan
0
371
Member Avatar for kumar.gaurav.7771

Hi All, I have Code on PC1. and Access DB on PC2 . I have shared Folder on PC . And very much able to access from PC1 with full ownership. Now I was trying to connect Msaccess from PC1 using below code. cnn.Provider = "Microsoft.ACe.OLEDB.12.0" cnn.Open "Data Source=\\192.168.0.1\Public\tels.accdb;Persist Security …

Member Avatar for kumar.gaurav.7771
0
248
Member Avatar for Gerbiler

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 …

Member Avatar for Ujube
0
342
Member Avatar for dansonyun

Here is a very tiny program(3 files) has embedded with Smarty template engine. Anyone knows how to remove Smarty completely? I konw the procedure to remove Smarty but failed to rewrite the code into pure PHP. Complete source files as in attachment. **CLICK HERE!!**~~~ http://www6.mimima.com/link.php?ref=FGHkNoDtmB *****************index.php <?php require("comm/Smarty.class.php"); require_once("get_data.php"); require_once("books.php"); …

Member Avatar for dansonyun
0
229
Member Avatar for jonnahealey

Hi All, Sorry if this isn't the appropriate place to put this question, but I'm new to the forums. My issue relates to ASP and a DSN-less connection. I have a website, which was built quite a while ago using DSN connections to an Access database, which ran on a …

Member Avatar for hielo
0
172
Member Avatar for yvrej17

Hi, I need a little help here. I'm Using vs 2005 with ms access 2003 database and finding myself how to get rid of this error "Syntax Error on UPDATE Statement" can you take a look at my codes below and tell me what's wrong? Thank you. Public Class Transactions …

Member Avatar for Icone
0
5K
Member Avatar for beckele

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 …

Member Avatar for beckele
0
199
Member Avatar for mahemaa.iyer

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); try { int c=0; String u1=request.getParameter("u1"); String e1=request.getParameter("e1"); String user=request.getParameter("user1"); request.setAttribute("u1",u1); request.setAttribute("e1",e1); request.setAttribute("user", user); out.println("welcOme"); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con =DriverManager.getConnection("Jdbc:Odbc:db5"); String str = "select * from Table1 where email=?"; out.println("welcOme"); PreparedStatement statement = con.prepareStatement(str); statement.setString(1,user); ResultSet …

0
152
Member Avatar for themaj

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 …

Member Avatar for Reverend Jim
0
206
Member Avatar for DaveD3

Hello, My name is Dave and I am a C# developer who is having trouble getting into web development. I am trying to develop an application that users can access from the web, enter search parameters, and the application will search text files stored on the server and return the …

Member Avatar for JorgeM
0
336
Member Avatar for qajaq49

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 …

Member Avatar for wafs
0
511
Member Avatar for UV1995

Hi all! I need help with Visual Basic I am trying to build a program in which the user types a question into a text box. Then the program looks for that question in a database (access database to be specific) and returns the appropriate answer from the database. I …

Member Avatar for dimara
0
1K
Member Avatar for jeffcogswell

IE9 is on the horizon, and there has been plenty said about it. But what about its web development aspects? In this article I look at its web developer tools, and decide whether I'll start using it in my own web development. Like most web developers, I abandoned IE several …

Member Avatar for fiascolabs
2
1K
Member Avatar for abhishek20

Hi i am using java code to connect to MS access using following url jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/login.mdb Now if I need to connect to the run this java code from some other machine in network then how will I write the path "DBQ=C:/login.mdb"

Member Avatar for Pradeeps206
0
344
Member Avatar for mmcdonald

Not sure if this is the right place, so forgive me if it isn't. There's a few of us building a huge online portal that contains IT training courses in Cisco, CompTIA, Microsoft and ITIL certifications. We're offering it at the small cost of £5.00/month full access to IT professionals …

Member Avatar for mmcdonald
0
231
Member Avatar for consc197

Hello everyone, I have a problem, i am unsure how to read the data from my Access Database into my vb.net form. I did some searching but i didn't manage to find anything useful so i would appreciate any pointers. Here is the code from frmAddNewCandidate i am using that …

Member Avatar for consc197
0
3K

The End.