[microsoft:access] Forum Topics

I'm trying to make a log in page in Dreamweaver that can pull and store information to/from an Access database that I have in the web folder. [I]If someone could walk me through this that would be the best thing ever![/I] I've tried using ASP/Javascript as the Document Type (not …

I want if user click on save button all productname,item_code, and unit of MSHFLEXGRID name as grd in my project should be store in MS access MR Table . i have wriiten a code in a procedure like : If DataPath = "" Then Exit Sub End If Dim con …

I have designed an interface of a form using vb.net . How to connect that with my ms access database. please help me

I have an old application written en VB5 .. and need to access an Access Database. It seems that VB5 is not compatible with Access 2000 ... What can I do???? besides moving all the programs to a newer VB ?? And in that case, which VB will be the …

Hello All: I made a simple form in VC#, inside it there is textBox I want when I write the value inside this textBox it's must check it with one rows of the table inside dataBase if it's exist it print a message box else exit.....Any one can help ??? …

Hi All, Please Help me with this issue as i m very new to VB.NET. I have Created a vb.net Application with MS ACCESS DATABASE, everything is working fine, But, There is a small problem that i am facing . Everytime i ADD a new record it saves succesfully but …

I have created many sites using Coldfusion so I know the syntax and I know how to use the product, what I don’t know is how to setup the server, (That was always done by others in the company) my problem is I am trying to create a site on …

hey guys I'm new here but direct to the point can i ask how to create a monthly report? its very important for me to know this because it will be part of my system which i will create for the final project in my course so please anybody care …

how to convert the file format of access .mdb to .dll system? can anyone know?

need help! i am using vb.net 2003 as front end and MsAccess 2003 as back end or data base.i create a simple program on how to add,delete and view records, [COLOR="Red"]but i dont know how to print these records.(example list of USERNAME and PASSWORD) .[/COLOR] check the program that i …

HI all, Very urgent. I am building a Access DB and i would like to autipopulate a specific Outlook Form that resides in : tools/forms/choose form: " name of the form". Is there a way to autopopulate this outlook forms ? thanks M.

i am developing a project in vb 6 which deals with printing lots of forms and invoices - all containing user-filled details. The invoices have different structures - some are tabular (with irregularly placed columns, however) while some are plain text (letter-like). i am going to use MS Access for …

Hallo friends, need help for following problem. i have a form where i get the details of particular Combobox. Pic 2.jpg attached. here on right side i got few textboxes say txt1..txt2 .... txt7. on left side of this jpg i got the details of a particular project number. when …

[I]I do apologise if this thread has been started in the wrong section. - Wasn’t sure where to put it...[/I] ________________________________________________________________ I am using Microsoft Access with a select query to combine 4 separate fields into 1 field for each record using the following expression:.. [B]Expr1: ([prod_group_name] & " - …

Try to do 3 things. The 1st see if a database exists in a certain location: if it dose then connect. else show error message. The 2nd see if the database is open: if open the display a message to the users that they are going to get disconnected. pause …

is there a way to disconnect a user/s from a database and/or display a msgbox to the users telling them that there are about to be disconnected? ms access 2003

I am trying to write a script (which i have done) that sends a meeting request out from Access to users outlook. When they accept it adds that meeting to their outlook. But if a user declines it deletes that meeting out of everybodys outlook. e.g. if I send a …

Hello Again, Again being a novice at MS Acces 2003 this is definitely outside my ability. I was told that using visual basic it is possible to show a month calender in a form instead of just entering the date in a field. The user should be able to have …

Hi, I have a big problem interacting with the MS Access database. I have read again and again all the topics related to the error [B]"The number of query values and destination field are not the same"[/B] on this forum but still I can not fix. Here is my story: …

I have to delete the records in a ms access table using vb.net when i click on a button.

I'm receiving error message "ExecuteReader got No value given for one or more required parameters", any help with this is appreciated. (using Access 2003) Public Class frmDisplayJV Private Sub DisplayJV_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load cbJVDate.Items.Clear() Dim ADate, SQLStmt As String Dim ACounter As Integer Dim …

I wan't to make a page that "if i enter a value in the textbox and i press submit button in the jsp page will link the data to the jsp page by getting the data in the data base using the odbc in ms access? someone can help me

hi, I would like to generate ppt where data from my back end MS ACCESS dynamicall changes with record.I coded for connectin to back end. I want the code to generate Power point using VB 6.0 where i can dynamically change data.Please help me developing the code. Regards, Dinil

Dear frens, from your help I succeeded in creating data grid . Thank you for it. Now i need to generate report from data grid. my data grid code is as follows; Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Db1DataSet1.Clear() Dim conStr As String = …

hi guys! | -----------------------|---------------------|------------------------------| | validation_period |-----sys_date-----|-------exp_date-----------| |------------------------|---------------------|------------------------------| |-----------6-----------|---26/11/2008---|-(add validation_period-| |------------------------|---------------------|field value into------------| |------------------------|---------------------|sys_date)...?--------------| |-----------------------------------------------------------------------------| using ms access 2003 i got the system date by using date() function but the real job is to pass the validation_period (which is basically a number of month(s)) field value as a parameter into …

hallo...this is my first post.. i want to validation my registration.. if there are anyone to regis but the username is already(in database), there are message " sorry, choose the different name please" i have no idea, i have tried but always failed... o..yeah i use ms.accsess for my database..and …

Good afternoon and Jose and Murdo here with our MS Access database fun for Christmas! What we'd like to know is there an easy way to find out which of our employees are here for the 25th December and the only data we have is linked to our Leave Status …

Good day everyone and are there any Access geniuses out there who can help Jose and myself with some links, dates and logic for our HR database that we are stuck with? Cheers, Murdo PS My ady is <EMAIL SNIPPE>

Hi, Please help me with Expression builder for my FOrm. Weight_likely - back end DB Column I want an expression, where if Weight_likely is blank then in form 0 should be populated or if Weight_likely has a value then the value itself should be populated. =IIf([Weight_likely]="",0,[Weight_likely]) Please help me on …

Hi all, I have this sql line (below) and where it works fine at the moment. But I have columns with 2 words i.e. opened by. I would like to add this colum to the statement below but everytime i try it errors. Do I have to reword the statement …

I have a busted five table design for a food item guest ticket . Here are the names(Actual) of those tables: GuestTicketType, GuestTicket, GuestTicketOrderCategory, GuestTicketOrder & GuestTicketPayment. The incomplete(busted) design looks like this: guesttickettype has a field named guesttype, which is one of three guest types: dinein, takeout, delivery. The …

Hi, anyone can help me convert or set my .mdb with form in ms access file to an application? i mean an application open the interface(form) without open microsoft access.

I am writing my first database app (windows form in c#) and I am using an access database. I have 2 tables with the following fields: payroll --Store --lastName --PayFreq --SSN (PK) --HireDate --EffectiveDate --TermDate --DeductionCode --Deduction --NAD CHAR hrconnection --Store --lastName --CoTime --Plan --Dependants --HireDate --EffectiveDate --TermDate --SSN (PK) …

Hallo Friends, I need some help from you. i am hereby attaching some files of my project. in 1.jpeg after clicking add button the data will be automatically written in access table shown in 2.jpeg. this is the code for add button. ----------------------------------------------------------------------------------------- [I]Private Sub cmdadd_Click() Dim db As New …

I have given below a code snippet where i am able to generate a ppt with one slide. In a loop the followig code snippet will be passed with new "dbId" and for each "dbId" new slide has to be added in the already existing PPT as extra slides. Please …

How To Get Data From Intranet ? I Want To Get An Access File

Hi friends, I am Ramesh. I am a B.E. Graduate. Currently i am doing "ATTENDANCE AUTOMATION SYSTEM ", mini project in VB. I am supposed to generate a new access sheet(i am using MS ACCESS as my back end tool). I tried my level best, but i can't. FRIEND IF …

I'll start off saying I am not a programmer. I am making a database that imports data from Word forms. It requires code and I found some that works almost perfectly for me at [url]http://msdn.microsoft.com/en-us/library/aa155434(office.10).aspx[/url] It does exactly what I need. The only thing that would make this code better …

/ I'm using Microsoft Visual Web Developer 2008 to make a website and I have an access data source on the page linked to a table with a bunch of cities listed. There is a Grid View on the page linked to the data source. Also on the page I …

Hello friends, I want to update the record in my database in MS-Access.What code should I write to update it?? What is the syntax for update statement?? plzz suggest me if u hv any idea...

Hello everybody... I'have bound a database to my form, and it displays the record of some fields from my database. I want to make the displayed record so that it can be searched by clicking the "find" button by the related searching categories. Below are coding that i've used.. [Private …

Dear Sir, I have developed the database program for storing the Company bills. it has two table COMPANY & COMPANYBILL. It has 1-Many relationship. In the COMPANYBILL table i am storing the BillAmount and PaidAmount. Also i have create a form for the COMPANYBILL. The Report shows the BillAmount, PaidAmount …

Hallo everyone, Iam using C# to insert a row into access table. Iam getting the values to insert from textbox. I got the error "cannot open action query". Here is my code [code] private void button1_Click(object sender, EventArgs e) { txt1 = textBox1.Text; txt2 = textBox2.Text; String connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data …

I made a querie with 2 table. both of 2 table have date fields. the querie also have this both of date fields with other fields. so all data show in a each line. like name | address | date this 3 fields in table1 Roll | Class | date …

On not filling a text box of a field that is madatory in the database i want to throw a error message to user and set the focus to that particular Text box Please help me in setting focus to that particulat text box. [code]Private Sub Form_Error(DataErr As Integer, Response …

hi, in my MS ACCESS front end, when i press TAB to jump to next text box or button focus is shifting in a disorderly way with no proper pattern. What might be the reason. Please help me. Regards Jagadeep

Hi.. I have a table: PROFESSOR in ms access, that has 2 fields: "Name" and "Location". The table has 10 records. And i have made a vb form with a combo box that will show a list of available locations from the database table, when it is dropped down. So, …

All, I have an issues form in a database (MS Daily log) and when you fill in the form it save the data into an issues table. Everytime you do this it gives each issue an ID number (auto number). Basically I want to fill in the form then before …

I'm trying to write a questionnaire that gathers info of the user and then updates a database in Access. I've managed to write the program and everything works up to the point where it updates the database, at which point it displays the error message below: OleDbException was unhandled Syntax …

I have a combo box on a sub form. Based on the choice, I want another combo box on the sub-sub form to have a selected choice. I've tried to have the choice change the Row Source on the 2nd combo box but I've been unsuccessful. Both of the combo …