[microsoft:access] Forum Topics

Hello all I am a total newbee to access so please bear with me if this is a dumb one. I have an unbound main form : frmTest. With fields : [CustomerId](autonumber), [PhoneNum](str), [CustomerName](str), [CustomerSurName](str), [StreetName](str),[StreetNum](str), [aptNum](str), [floor](str), [Notes](str), [RegDate](date) and a subform field called [FrmQryCustomerSearch] which uses DataSheet view …

Hi everyone, I am using Access 2003. As I understand, there are things you can only do in the 'form' mode but not in the 'table'. Why is that? For example, let's suppose that I have the following fields in my table 'product': ID, Name, Code, Style Every time I …

All, Have a set of nested forms/subforms in this order: frmMain => sfmMain => ifmTABset => sfmUSR => sfmSETcfg where sfmMain & sfmUSR are the control fields containing the subforms being called and the TAB control TabCtl0 resides in the TABBED form of ifmTABset. I am trying to open the …

Hi Guys, I'm new to SQL and just know the basics. My boss has asked me to help him with a new system they are developing using MS. Access. In the form, the user enters their information as well as checks the applicable check boxes. When they have completed the …

When I try to view or run Visual Basic code in a form's class module then I receive the below error message: “ActiveX component can't create object.” Or “MSACCESS.exe has generated errors and will be closed by Windows. You will need to restart the program. An error log is being …

I'd really like some advice on a project I'm working on. I'm working on a school project where I'm supposed to build a system for a small dietitian clinic. One of the things I have to do is create a way for a receptionist to book, change and cancel appointments. …

I attach a file. In this file I make a querie. all the (data) field of both tabel show in the querie. I want all data will add up in querie. I mean a calculate field. like : (200,200,300) this amount was in both table. in querie it will show …

i have written a employee class .there are some properties i want to access database fields data through this property can anbody help me any help would be greately appreciated. Kindly find the attachment also. [code] Private m_sname As String 'local variable(s) to hold property value(s) Private m_iemployeeid As Long …

Hi, I am trying to insert into Access Database using following code [CODE]OleDbConnection empConnection = connection; string insertStatement = "INSERT INTO d " + "([Employee],[Deduction Type],[Number of Hours],[value],[Month],[Year],[Comment]) " + "VALUES (@Employee,@DeductionType,@NumberofHours,@value,@Month,@Year,@Comment)"; command = new OleDbCommand(insertStatement, empConnection); command.Parameters.Add("Employee", OleDbType.Numeric).Value = Convert.ToInt16(txtID.Text); command.Parameters.Add("DeductionType", OleDbType.Numeric).Value = Convert.ToInt16(cmbDedNum.Text); if (txtNoOfHours.Text == string.Empty) { …

Hi I need to have my c# code to update from microsoft access automatically. can i use the timer control? This is the code i found for timer control: public partial class Form1 : Form { Timer timer = new Timer(); Label label = new Label(); public Form1() { InitializeComponent(); …

sir, i m making a simple database in ms access 2003. i m using hindi krutidev fonts in labels & text box. please help me will any problems creat in futrur.

How to Check if Dynamic Form field exists in Access Table -------------------------------------------------------------------------------- I am trying to dynamically insert form field values into the database. The code has 3 parts to it 1) Check if field already exists and Alter table to add columns/fields 2) Insert the values in the column/fields …

Hi all It’s required from me to create a database for a company which have three branches; the company does repair and sale second hand cars. I have created the database with my tutor but I think there are things missing but I don’t know where they should go and …

When using Ms access 2007 What do you think are the advantages of creating a report design (as opposed to just designing the report as you go)? How could creating a report design actually save you time when you start developing the report? How could you determine which fields should …

Hi, this is the first time I have posted a question. I'm really hoping for somebody to help me. I have a text box in a report that I need to populate via a function. The data required (OPENING BALANCE) is already in another query titled: "qryEOD Report Query". I …

I've been working on this project that works with a MS Access database. What I need to do with this and what I am having trouble with is I need to select a team name from a listbox and then calculate their total points. I'm struggling to figure out how …

I want to retrieve a image stored in MS Access database as an OLE object. while using a OledbDatareader and getValue method, its returning me a byte array. how can i use this array to display my picture as it is in a picturebox on a form. private void pictureBox1_Click(object …

Hi, I have created a project using MS Access db its working fine except one. A dialogue box opens up when running its exe, saying [B]"Please enter MS JET OLE DB initialization information."[/B] But I have provided all the DB connection information and other related information at runtime during initialization …

Hi Is it possible for me to merge the data i had from microsoft access to my c# application? And also, i want my application in c# to say for every 5 mins, update the data i had from microsoft access. Is it possible? Thank you very much

I dont actaully know where to post my question below, so this looked like the best place next to a "generel web discussion" forum but none found. OK, basically i need some advice from you guys on excately what steps i should follow on how to create a browser based …

I use a database connection string as below and my program work fine. Public Function initdb() Set ws = DBEngine.Workspaces(0) Set db = ws.OpenDatabase(App.Path & "\Masterfile.mdb") Set rs = db.OpenRecordset("Detail", dbOpenTable) max = rs.RecordCount Exit Function End Function *********************************** But now I lock the msaccess table ie. Masterfile.mdb with password …

Hello, I am using OLEDBConnection and OLEDBDataAdapter and connected to the MS-Access database. how can i add the textbox value to the table in database on a button click and want to display it in datagridview??

I created a database within MS Access - no SQL code - and set a field to "Memo". When I go to my web app that inserts some form data into the database, if I type too much into that one field on the form, I get "Invalid Precision Value". …

Hi, In the VB projects that use Access Databases, its found that the user is able to access the database directly (manually) ie by reaching the file and double clicking it open. But, what all can i do to prevent the user from directly accessing and using the database? What …

Hello friends, I want to clear a table by clicking a button on a form. I have created the query to clear the table but I cannot make it the source for the command button on the form. Is this possible? Thanks for your time and help.

Hi All I have come to the end of my first large project and would really appreciate some guidance on how to go about getting it into a finished state. There are a few issues im worried about and having come this far and with a deadline looming im so …

I have an Access 2003 database to track employee call-outs. I have to run the report for the current day and for the last 7 days. I only want to show the employees who have call-out more than 1 time in this seven day period. The report must run automatically …

[code]Imports System.Data Imports System.Data.OleDb Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim conn As String = "Provider=Microsoft.Jet.OLEDB.12.0;Data Source=G:\Visual Studio Projects\test\dbtest.accdb;Persist Security Info=False" Dim cmd As String = "SELECT * FROM Table1" Dim adapter As New OleDbDataAdapter(cmd, conn) Dim topics As New DataSet("Table1") …

I can't figure out how to perform a calcuation in a query and have the result output for use in a chart within a report. Forgive me I'm a newbie

hi, i am useing the netbeans for the first time n i am trying to connect to a MS Access DB through the wizard but i am not able to. I entered for a DSNless connection: Name:JDBC-ODBC Bridge. Driver: sun.jdbc.odbc.JdbcOdbcDriver Database URL: jdbc:odbc: Driver={Microsoft Access Driver (.*mdb)};dbq=C:\Users\Vamsi\Documents\PIN.mdb; the issue its …

Should I be able to use VB6 to read/write an Access 2002 db, where the executable is running on Win98 SE?? I've resolved the oleaut32.dll version issue and reference DAO 3.6 but still get "unrecognized database format" if I reference a 2002 db.

Hi All.. I am angry cause its such a little thing but its a big part of my project so Here is the scenario.. I have an access database with a table called People and a Field called Names.. In the Names field I have five entries. A B C …

I'm teaching myself Database design, using MS Access (2007). This question may have a basic answer, but remember, I'm just a learner and it's not so obvious to me. I would like to select a Company either by 'Name' or 'ID' or 'Account Number' in a Form and have all …

I am using the following code to retrieve the last entered value from a table and insert it into a textbox called rf. The code below works but the DB remains open until I restart my computer. [code] Sub Page_Load() If Request.QueryString("VesselName") Is Nothing Then VesselName.Text = "Blank Name" 'some …

I'm in the planning stages of an inventory db. The part I can't figure out is how to design the database as far as changing costs go. If I have a cost associated with an item, how do I handle when the cost changes? I know I need to have …

Hello all, I was wondering if someone knew the syntax for getting the next record in a table for Access? I want to write an event procedure that will allow the users to get the next record, either up or down. I know where to put the code ( I …

I have made an application with access database using Adodc and it works fine. However, I have set the ConnectionString and RecordSource in the Properties window in VB6. But now I want to write it in the Code. I need some help. I have written the code and need someone …

Hi I have just uploaded an Access DB and an .aspx page that writes to the DB. It works fine locally ie IIS. The problem is that when on the host the db does not get written to. I think its to do with the Source to the DB on …

Ok, slight problem. I have a reservation with rooms. I need a query which will look at the "Arrival Date" and "Departure Date" So the query basically tells me which rooms are available from that. I would also like to no how to actually send emails from MS Access? Thanks

Hi, this is the first time I have posted a question. I'm really hoping for somebody to help me. I have a text box in a report that I need to populate via a function. The data required (OPENING BALANCE) is already in another query titled: "qryEOD Report Query". I …

Hi, I just got MS Access connected with Visual Basics 2008, so i am able to view my database in visual basics. Now i would like to be able to use the buttons i have created on visual basics to add, edit and create data relating to MS access 2007. …

Hi, I was having this problem with connecting my visual basics software to MS access. I wanted to connect the softwares so that the programe i am bulding on visual basics can use the tables i have created on MS access. Tables like customer details, account details, product details, etc... …

This is part of my login form. im trying to lock the account if there are to many failed login attempts. but im not sure if my sql statement is wrong or i my ExecuteNonQuery() is wrong. heres part of my code. I should note that my "account_lock" column is …

I have an issue wherein the number of fields(columns) in a table exceed 255 in MS Access.ie(370) So i decided to split the tables into 2 diferent table each containing 185 fields. Then before running the QTP script, I join the 2 tables and store them as a view. View …

Hello everyone I was failing, how to write an Access Database using Java J2SE 5 edition ? Could you guys help me out? Any help would be appreciated. Thanks

Hi Friends ! I want to create DSN automatically with common dialog to choose database. I don't want user have to go to control pannel \ Administrative tools \ ODBC Manager for create DSN. I am using MS Access as My Database. How can i do it ? Plz help …

Hi peeps. I would like to create a GUI tht will write / send the data to MS Access. Once the database is created I will also need it to interface with my website. Any suggestions on how I get started please. Thanks Wayne

Hi there, I'm new to java. And I would like to get data that I have in a Ms Access database and sending to a excel spreadsheet using java. I've search the web and I keep finding the ohter way around. Could anyone provide me with a sample java code …

Hi guys, got another question. I have a dialog with a series of dropdowns, textboxes and checkboxes for entering and saving data into an access database. There is a load data button on that dialog which loads a second dialog box. This one has a datagridview which is linked to …

Dear Friends, I am designing a database for a local garage where they repair and sale cars. I have come up with the attached normalisation. I would be very grateful if someone could have a look at it and give me some feedback on it. Kind Regards HB25