3,459 Topics
I need and interface sample for supermarket inventory that work with access data base. I am sorry i am new to vb and i got assignemnt which i have to complet real soon..help out
I have a database that has a simple search form where you enter the 'Search Text' and then mouse click the 'Search' button and the results are displayed. Alternatively if the Enter key is pressed twice, first time to enter the text and tab to the 'Search' button, and the …
I'm successfully importing a .dbf table into access using the get external data wizard. The issue is the data structure of the imported table. For instance, a filed with num(5) in .dbf will appear as double (without any field length) in the imported table in access. This limits onward use …
hi i have a question in getting values from two table i ave two tables Table1 and Table2. table 1 have data and table 2 may have the same data as table 1 and more. and also table 1 may have the same data and some which is not in …
Hi I'm currently using vb6 and ms access for my database. So far the application runs good, but the rumor (or fact) that access are not powerful enough with multiple access and also it has low data limitation (around 2 Gb), it scares me. I don't want my clients to …
In my proj i'm using ms-access DB.. i have two fields namely sms_date,sms_time.. i myself enter the records to the DB.. I need to populate the gridview with the records within the given range of date.. i hav a calendar control to select the date(mm/dd/yyyy) and user should type the …
> Is it possible to convert older > version of FileMaker Pro > to Microsoft Access 2000 I suspect FileMaker can save its tables as .DBF; Access can use .DBF tables directly or can import them. Alas, I don't think you can convert any part of your application EXCEPT the …
I hope you could help me with my documentation. Please help me to compare and give advantages and disadvanatges of the following based on your experience: MS ACCESS FORMS versus VB.NET STANDALONE APPLICATION versus WEB APPLICATION (intranet) for example : __________________________________________________________________________ 1.CATEGORY|2.ACCESS FORMS|3.VB.NET(WINFORM)|4.VB.net(WEB)|5.comments ___________________________________________________________________________ 1.DEPLOYMENT|2.fail|3.fail|4.pass|5.when deploying standalone applications,you need to …
Hi Every Body I am just trying to insert a record in Access 2003 table by code of C#2008 Here is the code - [CODE]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; using System.Data.Sql; using System.Globalization; using System.IO; using Microsoft.VisualBasic; …
I have searched and cannot find out why my code will not update the database. The program stops at the mDA.Update(mDS, "temp_data") line with the following error: System.Data.OleDb.OleDbException was unhandled ErrorCode=-2147217904 Message=No value given for one or more required parameters. Source=Microsoft Office Access Database Engine StackTrace: at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors(RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] …
i try to make the running sum of quantity using query with a expected output [CODE]ID | Date_in | Date_out | Quantity_in | Quantity_out | Quantity_Run_Sum in01 |17/2/2011| | 300 | 0 | 300 in02 |17/2/2011| | 400 | 0 | 700 Out01 | |20/2/2011 | 0 | 100 | …
Good day Sir/Maam.. im new here. i have a project in MS Access 2003 that will tanslate numbers into words... is there a code using Asc? to this program... im sorry im newbie in programming.. thanks a lot..
Hi, Please help we with the code with Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) to find the location for access database in windows7 and vista. thanks
Hello I am trying to connect to an access database, i have tried using the[CODE]Class.forName("sun.jdbc.odbc.JdbcOdbcDriver")[/CODE] but this does not work. I am using Eclipse IDE and running windows 7 64bit. Does anyone know how to make it work? Thanks
I think the title says most of it. How do I, in MS Access using VBA, get information from a workbook which I can then put in as a recordset in a table? I know that excel has an easy workaround for other excel workbooks, and I've read somewhere how …
Hi all, I am not sure about method to publish my program. But basically when I publish it no errors at all... I have database name usurfdb.mdb. I have set it build action to content and copy to outputdirectory = copy if newer. Should I amend anything on my usurfdbdataset1.xsd …
Hello all, I'm using MS Access as my DB for a very simple web site. Everything was running nicely till all of a sudden I can't inset rows into any table in my MS Access database. In my tests I even created a fresh and clean table1 with one number …
Dear friends... I need a urgent HELP... I applied for a job... They asked me to do a PROJECT, vb with access... In that they asked me to create INSTALLER file with 32bit & 64 bit support. I don't know how to do this... i have to finish it and …
on Microsoft Access database i create tables named John , Philip and William. on Form1, i have datagridview1 which show those tables on database. when i click one of them,i pass it into a textbox1 on Form2. for example i pass John into textbox1 and here is my code (i …
I want my Access form to return a result based on data entered in a text box and combo box. I have 4 queries: qryA, qryB, qryC, qry D I want the user to be able to select A, B, C, or D from a combo box and then enter …
Hey guys I’m trying to export data from a access form into an excel sheet when it is clicked by a particular button... but the VB code I’m using for the button will not work. Here is my current code: Private Sub Command12_Click() DoCmd.OutputTo acOutputForm, "frmExport", acFormatXLSX, "h:\mydocu~1\exports\F_assignments.xlsx", True End …
can any one help me about my project.... how to code data from excel export to access..
Can anybody advise on the way to set up an ODBC connector for a desktop MS Access MDB Front End to connect to an MS Access MDB Backend on a remote (internet) location? Thanks Max
Hi, i have a problem in my database. how to sum the value of row into another value of row?.. i want to compute the total of Hoursworked.... this is my example table for the sum of row by row.. DTR Table EmpID TimeIn TimeOut HoursWorked Date 1 08:30 05:30 …
Hi, I have ms access as front end software to be used for employees in my company. Every user will have different access to the contents inside based on their role. For example, manager will have different access from the others. First attachment is the image for limiting user access …
After deploying my project, I tried to install it on other pc , it installs well but whenever i run the .exe application my database file which is MS Access cannot be found. Well obviously the path is the problem. How would i make my path flexible and so that …
Good evening everyone! I am working on a documentary and I have 10 000 short videos to sort! I am looking for a database/software program which will help me. In brief I want to attribute several categories to files, in order to find later (when I will make the documentary) …
Hi I want to convert Sql Server Database to Access Database , I have one database and it has different tables and view also. please help me how to do this ?
Hi all, I've got a small problem with a database I'm working on, the project was given to me by college kids & their Teacher to complete. They created the database using Access 2007 and I'm left building a Windows App user interface in Visual Basic. Anyway I can't figure …
SOFTWARE USED: MVS 2008 DATABASE: MS ACCESS 2003 LANGUAGE: VB can anyone help me regarding on how I can ADD new record on a gridview :( I'm working several weeks but I can't find the solutions :( please.please. I found some answers but I can't transfer the code into vb …
im doing my project pls help me !
Hi everyone, novice here. I'm having some major issues trying to figure out what's going wrong with my code. The general problem is that I can't get the foreign key in one of my child tables to populate the primary key from the parent table. I have a parent table …
i m using two list box one(check style list box) is for food item another(simple list box) is for cost.when i selects any fooditem then a input will occour for entry of food quantity.and after selecting all items and entry of their quantity they will store in ms access databse. …
Hi I am using C# 2008 with Access 2007. I am using MDI on MDI a added a menu now that Menu have a Login MenuItem which is enable and other menu items are disabled at form load. Now I am try to implement this if login is successful then …
Hello Hope you guys can help me. I have created a system that stores information using php and my dbase is MS Access.Currently im on the debugging phase since i finished all major development a while ago.Now im stuck because i need an incrementing 4 digit number.Can anyone assist me …
Hey Guys, I am trying to create a little project for my college course. I have been trying in vain over the past few days to sort out some errors i have and alot of google pages have brought me here where i have gained alot of knowledge so i …
HI guys, I have finish my project in vb.net and publish it without errors. The problem is this: As my project finished installing in the pc, an error occurred saying that the path where should be my DB Access is not there. Although I manage this problem by manually copy …
honestly, could someone come up with a simple method on how to link vs.net 2002 and ms access 2003
I've been scouring the Net trying to get my head around using VB.NET to save information entered through text boxes on my form into an Access database. Most of what I see so far shows me how to display records already entered into the database and update the table, but …
Hey I have attached my program to the thread. I have an access database called "Database". I have 3 textboxes. "name" "age" and "language" as an example. When the accept button is clicked, i want that information to update to the database. I can only do it with a datagridview, …
I have a small company Database that tracks our repair orders. I have a query that I would like to execute based on criteria that the user inputs. I am new to VBA so most of my code is based on google research. I took a technique of wrapping my …
[B]SELECT staff.StaffNo, semester.SemesterID, teach.SubjectID, teach.Sub2, teach.Sub3, teach.Sub4, teach.Sub5, teach.Sub6, teach.TeachLoad, (IIf(IsNull( teach.SubjectID),0,1) + IIf(IsNull(teach.Sub2),0,1) + IIf(IsNull(teach.Sub3),0,1) + IIf(IsNull(teach.Sub4),0,1) + IIf(IsNull(teach.Sub5),0,1) + IIf(IsNull(teach.Sub6),0,1)) * 3 As teach.TeachLoad, FROM (subject INNER JOIN (staff INNER JOIN teach ON staff.StaffNo = teach.StaffNo) ON subject.SubjectID = teach.SubjectID) INNER JOIN semester ON staff.StaffNo = semester.Staff[/B] i …
How to make or set this as autonumber in msaccess-vb database? from 00-00-00 up to 9999-9999-9999 how to make that code to become autonumber? and what code can i use in my database when the new entry is equal to existing ?(The same primary key)
Why my code in my VB-access database is not working. my add code is not displaying the inputted data it only displays the gridline in datagridview. I already connect the database access file. What's wrong? Can anybody help me? thankz.
hello, im using vb6 with access 2007 (.mdb) im using adodc connection. my question, how to prevent if the data existed in my database. i've put primary key in my database and i need an example like it's giving msgbox "data existed!" anyone can help me? thanks.
Hi. so i'm using ms access 2007 as a database, i have here a table of TRANSACT IP which has the following columns of Transact_ID, IP_ID, Date, Time, Average, Min, Max. i have to produce a report in which i have to query from this table with the follwing format: …
Hey there, im stuck now with the datagridview not being able to discard the old headings in it and load another table in access. this is how the test program works i have 2 buttons. start the program, and press one button - the datatable loads close the program, and …
guys How do you Create Database in MS Access Using Oledb in vb.net?
*THIS IS THE CODE WHERE I CLICK A BUTTON TO SIGN UP FOR AN ACCOUNT* Set db = New ADODB.Connection db.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0; Data Source=" & App.Path & "\useraccount.mdb" Set rs = New ADODB.Recordset rs.Open "Select*from useraccounts", db, adOpenStatic, adLockOptimistic rs.AddNew rs!Lastname = Text1.Text rs!Firstname = Text2.Text rs!Contact = Text3.Text rs!UserName …
Hi, There is something wrong with my code. I can't seem to access the database anymore not can I add new data information. I am suppose to create a registration form with username and password. Then save it to a database on MS Access. Then login using the login form. …
The End.