[microsoft:access] Forum Topics

I am having a problem wit searching my database when i click search it says syntax error with FROM Clause. Here is my code n screen shot! Its the code for the find button!! [code]Option Explicit On Public Class Form1 Private Sub DisplaySearchResults(ByVal objectname As String, ByVal FieldName As String, …

I really don't have a clue on how to even start this, making a login form. So i've been searching around trying to find others doing the same thing but i haven't found much and what i have found they are using different databases. But here's what i have so …

Hi everyone! is there anyone has an idea on how to incorporate the biometrics scanner (time in/time out) with visual basic. For example, what would I need (devices, component, software, etc.etc..) such that I can manipulate the data in the biometrics device with visual basic programming and ms access as …

Hi there, i m not a very advanced programmer so i have now come up against a brick wall. i need to use a VB code preferably on a command button, whereby the user enters a keyword into a text box, clicks the 'Search' command button, and then a procedure …

hi , I need to know how can I connect Microsoft access with VB,I need to have wide space in programming in MS access...regards

Hello there, I am in the need of some serious guidance/advice/direction. I am comfortable and familiar with creating DB's, however my knowledge/skills/abilities simply revolve around MS Access. I have been approached by someone that wants their existing web based DB to be overhauled. They have provided me with a very …

Hello, I spent hours wondering why this statement doesn`t work. I would like to insert record in a table if it doesn`t exist already.If record exists then a message will come out saying record exists. The values for the record to be inserted are current selection in combos on a …

Hi, I am trying write a program to input and output data from a microsoft access file with java.sql class and the swing class. basically i am on the first stage, trying to figure out different parts. the first thing i would like to know is: (assume it is already …

All, Have a form with over 189 controls on it and trying to automate the save. I currently use the following script to init the fields: [code] On Error GoTo Err_Msg For Each ctl In Targetform.Controls ' 100 = Label, 106 = CheckBox, 109 = TextBox, 111 = ComboBox Select …

Dear Sir, Let me know how to connect a access database in Visual basic 6.

please can anyone give me more information on how to solve this problem i have. im writing a php code to create a form for a ms access database, i want customers to be able to select or tick various things they want in our services either from a dropdown …

Hi, I would like to query from you people if its possible to change back color either row wise or CELL wise in List box. Also I would like to know any other ways of listing record in forms other than in List box, Flex Grid and Data grid. Regards, …

just wanted to know how i can input a search facility to my webpage, which is on short courses. i want it to retrieve information from my database to display on my web page. my webpage is linked to an MS Access database. if anyone could help me u would …

I've an application running on my local system with local sql server database. I've an other application running on internet (like on [url]www.abc.com[/url]) and it has Microsoft Access database. I just want to insert some records from local sql server to online MS Access databas. Problem is this I can't …

I been searching for days for a sulotion but can't seem to find one. The coed that I have does not give me an error but it does not save anything on the table either ' Can someone help me find what I'm missing? this is my coed [CODE] Dim …

Sir, I am using front end as a VB.net 2005 and I am a beginner in this language. I am creating Desktop application and using controls TAB controls 1st tab control is Contact in contact I am using one text box, two button and one datagrid while I am using …

I can't retrieve the data from my "file.mdb" file. Below is the code I created: code = m_Code.Mid(beginIndex, endIndex); CDaoDatabase database; CDaoRecordset recordset(&database); CString lpszFile = "C:/file.mdb"; database.Open(lpszFile, FALSE, TRUE, _T("")); recordset.Open(AFX_DAO_USE_DEFAULT_TYPE,"SELECT * FROM KeyID", 0); COleVariant olevar; while(!recordset.IsEOF()); { olevar.ChangeType(VT_BSTR, NULL); recordset.GetFieldValue("ID", olevar); CString fieldValue = (LPCSTR)olevar.pbstrVal; if(code == …

Assuming it can be done (as I've been told): How do I import ".mdb" (MS Access / OleDb) files (specifically, Northwind sample database files) into SQL Server 2008 (Express with Advanced Features)?

Hi, I was wondering if someone out there could help me out with this issue. I have an id card software application written in MS Access (currently running in Access 2003). I need to figure out how to capture pictures via a digital camera attached to my Win Xp PC …

I'm not a developer so I won't even pretend to know what I'm talking about. I just loaded CF 8.0 & DWCS3 and i'm trying to load an existing website that uses CF. I'm trying to set a data source and was sucessful with one of the sites that uses …

Please help, I have copied some code to connect to a MSAccess database. However when I try to run it I get a Security Exception message. Weird thing is, in the IDE I can use database explorer to find, open and test the connection to the database. The database is …

Hello, I have a form where I have to say two dropdown lists. Firts dropdown list is populated based on query from a table in access database. I have another dropdown list .I woud like in that second dropdown to show only values that are relevant to the selection in …

I need some help about how to connect MS Access database in NetBeans.I visited [url]www.netbeans.org[/url] but didnt got much help related to MS Access. What I did is I start from Net Beans Desktop Application ....But when i select the option of database in it ....It asks Database URL....I have …

* [B]Edit:[/B] Sorry about double negative on the title, I don't know how to edit it back First of all, I am fairly new to Microsoft Access VBA. I created a form with 2 textbox (txtUsername and txtPassword) and one label act as button (I use label instead of button …

I'm working through the lessons at Programmer’s Heaven's "C# School" tutorial ([url]http://www.programmersheaven.com/2/Les_CSharp_0)[/url], and I'm currently on lesson 13, "Data Access in .Net using ADO.Net", so of course I've been trying to connect to Programmer’s Heaven's SQL and MS Access / OleDb databases. Unfortunately, they're now offline. Can anyone please tell …

Hello there! I developing a database simple enough for my friends to use using ACCESS. I wanted it to be only one Table only. The fields I want to play with are: TrackID, Member_Lastname, Member_Firstname, IDcolor, IDnumber, ReferredPerson_Lastname, ReferredPerson_Firstname, RPIDcolor, RPIDNumber. I created a dropdown combo for each on the …

Hi, How can use MsAccess database on Linux machine? I use PHP to connect to mdb and work with it. Thanks

Hi there. I am writing a program for work and for one of the parts I need to open up an outlook email account and parse through the new message bodies for specific information. After I get the information I need, I need to put it in a datbase. I …

I make two table in ms access. both of two table has like 'student name' column. when I enter a name it save in table1. Now I want this name will save in table2 automatically. I mean I don't enter this name in table2, but it will store this name …

I want to connect the access database to the c++ project. What are the requirements of this? How to connect that? Give the example.

Hi, I have a report that generates personalized letters. How can I attach these personalized letters (in PDF format) to their corresponding e-mails using MS Access 2003? Please help. Thanks. ilokana

hey, im an allright programmer, but im stuck with something, which is probably very simple, i have a database, with all my movies, that is linked to a data set in vb 2008, that all works perfectly fine. above this i have a label and on form load it creates …

This seems like it should be an easy one to answer, but I remain clueless after many days of searching and trying different fixes. Basically I have a report with many sub reports, such as a form that shows family information and insurance beneficiaries, which all have their own subreport …

Basically I have made a database that does all of my company's human resources needs. Now I have no training and everything has been learned from trial and error and/or looking up on the internet, but try as I might, I cannot find the answer to this question. Basically on …

hi...! i want to create the crytal report for my project in which i am using VB.NET language with the database of access...! i have now idea how to create the reports. i was just try to create the reprots it just shows only one record. kindly solve my problem …

Hi all - just getting my feet wet in some light programming after spending 14 years in Quality Assurance. Have already put together some exel based utilities, with a lot of help from generous users on the internet, and am now moving on to MS Access. I'm sure I'll be …

Hello all, I am having a bit of an issue with a report / query I'm running through a form. Thanks to your wonderful forums I have figured out how to take a value from a combo-box in a form, and run it to a report, however, when it does …

Hello, I am trying to get the currently selected values from dropdown lists and textboxes from a web page and write them to an access database. I am using MS Web Developer 2005 Express. To do that I have created data Source , for the InsertQuery Property of the DataSource …

Respected, There is problem in making the shopping cart.But only by using the jsp not other languages. And database is designed by using M.S.Access

Hi Guys , Have been reading the forum`s posts for a while.Found it really cool . So I joined. I have a really silly problem. I am trying to insert a record to a table in an access database on a click of a button . I use web developer …

Hi, I am creating a survey where 2000 people people will attend. I use Ms Access 2003 as a database. Do you think, Access is capable to do this? I am wondering, if more than one person use Ms Access, will it be still safe. Thanks

Hi, I am developing an Inventory Management System using VB 6.0, and MS Access Database. I am getting an error: "data type mismatch in criteria expression" which sounds like a variable type mismatch. But i have checked and double checked my datatypes and they seem to match up. Here is …

Hi, I have problem to change table design in access. I have imported data and table is like: Product; Name1; Name2; Name3...etc And i should change it be like: Product; Name; qty ..and all data.. Any good ideas how i will change this ir right shape..?

Hi, I have 2 questions for concurrent access to a TXT file and Ms Access. I have a TXT file to store user entries (Name and Surname). I also use Ms Access Database to do same thing, storing user entries. If more than 1 user uses my service, will it …

I need urgent help please!!!! This is my problem: I want to connect to a Access database with VB.Net. Here is my imports: [code] Imports System.IO Imports System Imports System.Data Imports System.Data.OleDb Imports System.Collections Imports System.ComponentModel [/code] Here is my connection string: [code] Public pDB As New OleDbConnection("Jet OLEDB:Global Partial …

Hi, I need to create a multi user VB.Net application that connects to Access 2007 and has 2 forms. How do I go about it? Please give me a start up. Thanks

I am wrking on a VB6 project,and I m new to this,I need to save the inputs values from the text boxes from the VB form,and using the command button,i need to save the data into the access database which i had created named Dtldb.mdb How do I use Data …

Hi guys, I'm trying to import an Excel Spreadsheet to Microsoft Access Database but this Error Message always show up [COLOR="red"]"NOT A VALID FILE NAME"[/COLOR] Can you please guys help me out. ^_^ Thanks a lot! :) [code] Try Dim acc As String = "C:\ffsclines.accdb" Dim exx As String = …

I am developin a project in VB6,i need to save the data inputs in form to the Access Database,using the save button......... Plz help me Thnks in advance:)

Hello everyone! Would like to seek help from experts. How can I make a "command button" in MS Access 2003 that will automatically convert "a record" (in a form view) to a PDF file? Will it be done using a code builder? Please help me..tried many times but it all …