[microsoft:access] Forum Topics

How to make the form size automatic setting the size equals to the screen. or Maximize the whole form including the form components.

Hi, I have made simple database in MS access. I want the front end for that database which can be easy to use the database for 3rd person. Can anyone help me. Saroj

Hello I am new to ASP and Access Databases really as well. I primarily use PHP and MySQL/Postgre.I work for my university in web admin department and due to rather sloppy coding in the past by workers have to rewrite an ASP form that writes to an Access DB. I …

Hello, I have just started using databases, but I am totally stuck. I made a database and table using MS Access. The table has three columns. ID, Code, and Letter. Basically, the Code column stores a number for each letter (eg. 1 = A, 2 = B, 3 = C, …

hi i use database access(2003) and i dont know how to search in my database i think about something like this : [CODE] ... a = Tclients.Rows[j][i].ToString() if(a == b) //ok ... [/CODE] but i dont know if this the true way because that very slow when i check 10000 …

create a Report of Customers and my database are MicroSoft Access 2000 Coding are Following Plz somebody hlp me in my project [code=java]import javax.swing.*; import java.awt.*; import java.awt.event.*; public class FrmCustomerReport extends JDialog{ public static JTable JTExpTable; //Start create variables JButton JBSearch = new JButton("Print",new ImageIcon("images/print.png")); JLabel JLPic1 = new …

Respected Friends.. I need help from your side.. Im using Visual Basic 6.0 with MS Access, I wish to create a automatic serial number for my program, It will show HITE001.. HITE002...HTTE003... same time it will show in form load stage it will automatically show in combo box( last record …

thanks a lot I need another code where once I enter a text into a text box i need the data to be transferred to MS access without erasing any data(a new record is to be created)

I want to have a running total in my net profit column. The formula is Amount paid - paypal fees - write fees. Can I do this with out using a query? Here is a screen shot of my table. [ATTACH]18861[/ATTACH]

I am getting 2 different compiler errors of the following: AoE2Wide.cpp(1089): error C2679: binary '=' : no operator found which takes a right-hand operand of type 'AoE2Wide::DrsItem' (or there is no acceptable conversion) 1> C:\Program Files (x86)\Microsoft Visual Studio 10.0\VC\include\vector(599): could be 'std::vector<_Ty> &std::vector<_Ty>::operator =(std::vector<_Ty> &&)' 1> with 1> [ …

Hi friends, after a long time. i am developing a small tool by using VB.Net. I want to display data in comboboxes from a table which is in an access database. I using SQL query. Its a simple problem , I think the problem is in my COMMAND. I want …

hi friends i m doing project in vb and database is microsoft access in my form i have 3 radiobuttons and 3 combobox when i select radio button then respective combobox enable and remainig disable i load all the data in combobox through data reader the problem is user can …

hi, i am trying to copy all the data from two columns from two different tables to another table. the problem is when i use insert statement for the second time it does not copy the data from the two columns. i was able to insert two columns from loanTable2 …

hello every body this is my second problem , please solve my problem i am designing a site in which customer can input credit card no, card expiry date etc. you can say a complete ecommerce site.i only know about merchant id. therefore we must contact with banks etc provide …

I use Docmd Open query to open one append query in the script that has another code in it. When I run the script, this option will opo out: "You are about to run an append query that will modify data in your table" "Yes/No" If I answered "Yes", the …

Hi all, I have a very annoying problem with adding new records to my Access Database, I'm not getting any syntax errors but there's obviously a symantic error of some kind causing this headache. I've been developing an RFID system for two months now and spent the last four weeks …

Hi I am new to VB.NET but for my final year project have started a system for childrens daycare center. I want to create user accounts which I think I should be able to do in acess. How do I link this to VB.NET? is it hard? what will vb.net …

Hi Everyone, I wonder if anyone out there has deployed a solution successfully like mine? I have created a vb.net 2005 winform solution that can be installed on a desktop. It uses an access 2003 database to hold data. The setup.msi was created using the vs.net deployment menus. The solution …

I need to link an access database to my visual vasic express 2008 class i have made (as been set an object orientated project) but am struggling to link the database and get it to show the information from the database through the class to the product form. I'll attach …

I am trying to use my textboxes and checkedlistboxes to insert data to a ms access database that is local just as a preliminary step to get my app running to show what it can do. I have connected to the database through the datasource connection in Visual studio 2008 …

So i have tried basically 30 different methods of going about this all with different errors in every form and fashion. Basically all im trying to do is write to my database in some form or fashon. Im having no problems reading from it but i need to change some …

Hi! I have a vb.net project on a jump drive that connects to an Access (2003) database (located on the jump drive). My problem is when I change computers, I have to change the drive letter the jump drive is located. Currently, I have the following code and have to …

hi frnds i m doing the project in vb.net in which i want 2 add data in database i took two lebel boxes and two textbox and i want data should add in database on button click so i tried it in to microsoft access just normal table which contens …

I have been trying to make images appear in a table from a database i have created in MS Access this code [CODE] <td><%=(Recordset1.Fields.Item("Image").Value)%></td>[/CODE] is the code that is original used that shows the path, i was told to replace the code with the one below the original but i …

Can you help us for our project in creating a daily record transaction? Do you have any codes out there or samples, and help us in connecting it to the database thru Microsoft Access. Your feedbacks are highly appreciated ASAP.

Greetings. I have a question regarding MS Access Me.Filter. In short, I am building a personal database for my CD and DVD collection and I have a few CD's that start will a number instead of a letter - such as the band, 3 Doors Down. On my form, I …

hey guys i really can't solve this problem, hope you can help me. the problem is, i use this codes to get the data type of a column from an access database Form12.ListView1.Items(j).SubItems.Add(myData.Rows(i)!DATA_TYPE) but what displays in my listview are numbers like (130 , 3 so on..). How can i …

hey guys i really can't solve this problem, hope you can help me. the problem is, i use this codes to get the data type of a column from an access database [code] Form12.ListView1.Items(j).SubItems.Add(myData.Rows(i)!DATA_TYPE) [/code] but what displays in my listview are numbers like (130 , 3 so on..). How …

This should be an easy one but I am missing something and have been working on this for two days now. I am trying to insert a date/time in a short date format (date/time mm/dd/yyyy) into an access database and I get the "Data type mismatch in criteria expression" every …

Hi Friends well i m developing an application into asp.net database is access now i want to show a particular record into 1 textbox names txtbox1 here is code plz give me code that i can show record into textbox [code] Imports System.Data.OleDb Partial Class Default123 Inherits System.Web.UI.Page Protected Sub …

Hi All I got lots of help from this site Here I am facing 1 simple problem but can't point it out, So I need urgent help from you all. I am using Windows 7, VS C# 2008, Access 2007 My Access database have 1 photo column of OLE Object. …

Hi, I've been having issues with this for the last 4 hours and I don't know what to do. Basically I'm using an MS Access database to store information on a movie collection, however I do NOT want to use the crappy controls microsoft has for populating and navigating databases, …

i trying to make a code to Delete and Update Access 2007 database after remove a selected item from a listbox in VB 2008. [using "Remove" button that i create] pervious i already make a button to View data from database and Remove from listbox. but i don't know how …

Hi there Another noob question from me...one of these days I'll get the hang of this VB! I am importing data from an Access table that has four columns/fields. I have set up the relevant headings etc on the list view control...but I have also set up a 5th column …

So I've been reading a lot about Access 2007, but all the books and tutorials don't talk about the stupidly easy questions. I have a SharePoint 2007 running on a server that my team has access to. From what I've read, SharePoint can easily display information and generate reports based …

Hi guys, I have designed a simple form in vb.net with MsAccess as the backend . The form is used to search for a data and diplay it. I need to create an .exe file of it and distribute it to many users without any errors . I have surfed …

Hi there I'm studying Visual Basic (using Visual Studio 2008) as part of an all-round IT foundation degree...I must confess that programming is becoming my weak spot! Unlike the C++ I was taught last year, I'm not finding VB too easy...probably becasue I've never programmed this way before and I've …

Hi, I am not sure if my problem belong to this forum. However I am using PHP and hence I will post it here. I have a secondary database that is MS Access.Curently I have managed to export it to another database of mine in which I can delete and …

search data in listview by using a textbox, this is my code sample cos i have been able to display data in access on listview so i want to perform a search function... Imports System.Data Imports System.Data.OleDb Public Class Form9 Dim Passport As String = "" Dim searching As Boolean …

Hi there, for a serious amount of time i've been struggling with this same issue, I did find some answers but non sufficiant. Maybe someone could lend me a hand? Allow me to illustrate my situation; I'm pretty new to VB.net, a whole lot is left for me to learn. …

Hi, I have this database based on this logic: There are projects in a company. In each project, different employees different roles. One employee could have different roles in a single project. Also, can work in different projects at the same time. Some projects could be added but role of …

Hello! At school we created a project and it works fine. I wanted to create my own project, it's practically identical to the school project, so i copy paste the code, and modify it to my needs. Everything works fine, i can add data in C-sharp DataSet, but when i …

Is there any ways to allow the text box in a report to show the lastest date from the database? For example: 24/2/2007 15/4/2009 21/6/2009 14/7/2010 13/10/2010 i want the text box to have 13/10/2010, which is the lastest date out of the 5 date(which I have more in my …

Hi, i have this main form that has several tab. In the tabs, there are several fields. I want to call/get/set the control/field inside this tab, how to do it? for example, in the main form there is a textbox control called "InvoiceNo", to call this one, i will use …

I have these few dates in my database and I would like to have the latest date to be shown at my report footer. 03 dec 2001 15 may 2010 08 mar 2007 14 jan 2004 29 sep 2009 can any kind soul plz help me?=) thx alot in advance=)

Hi all, I have designed an application in MS Access 2007 that will be used in some schools (over 60 schools). Each time I start the application, it shows an alert in the message bar that the VBA macros are disabled, and gives me the option to enable it for …

[B]how can i disable the save function. The database that I am making now is being shared by many users and i do not want them to mess up with my design and programming stuff that i had done. I have tried making the file into ACCDE format but it …

I have inherited an Access 97 database with a VBA front end. I know nothing about VBA front ends, but can work with Access The system is vital to our organisation. At some point I will look at re-writing the full thing in Access 2007 as the VBA does nothing …

Hi, I have this set of coding when i use it when i am in ms access 97 but not ms access 2007. this is a set of coding for login form of ms access. Whenever i log in with the correct userid and password, it always promt me "wrong …

Hi, I have a c# form in which I retrieve data from Access DB. I have Two DateTimePickers so I could choose data between dates. My problems is when I try to retreive data between 19/10/2010 and 12/12/2010 it gives me me data beyond 12/12/2010 but when I try to …