[microsoft:access] Forum Topics

I'm getting the following error when I try to save a query. I have security set and I have FULL permission for my login including admin permissions. Can some one help? I'm using ACCESS 2003. Thanks. You do not have the necessary permissions to use the 'MSysTables' object. Have your …

i am a beginner and working in vb 6.0 as frontend and ms access as backend hello ! i have following tables party:- partyid,lastname,firstname,address,areaid,profid profession:-profid,profname area:-areaid,areaname route:-routeid,routeno,routename routearealink:-routeid,areaid i am using msflexgrid control to enter/modify/delete party details which includes area and profession also.For that i want to use a moveable …

i have a form which i have to protect with a password. this form is called from a user form which does not have any passwords on it. which means anyone can access it. in order to accomplish the security i placed a password in an access database but the …

Hiz people ....after a day i m having pracitcal exma....n they have said me to make a database....so i decided to make student database of my school.....very simple so that sir wont ask me hard questions....so plz i think i donno some steps in completing my database....can anyone help.... for …

Im working on a project in access and my partner and i are making a who wants to be a millionare kind of thing. the problem is that we want to do an if statement involing an option button but we keep getting an error message saying value not valid …

I have code that opens and closes the connection to the [URL="http://www.daniweb.com/forums/thread80947.html#"]database[/URL] via table adapters every time I update because it was throwing concurrency and other database exceptions left and right. Now, if I try to navigate through the records it throws concurrency exceptions? I can add, edit, delete records …

Hello All, i want to add a word/text file in database(MS-Access), for this i am using datatype ole object for that particular column. i am using a text box to catch the file name and the complete path of the file and putting the value of textbox in that table …

[B]hello all please help me out,I have designed a database in access having two fields(1.Regno 2.Smartid).I hav also kept some dummy values in RegNo,But the Smartid is empty. Now what code should I write to retrive the RegNo for which the Smartid is empty. I hav used only these three …

Hi there, I'm a newbie in .net. Can somebody show me a complete working code on how to make this getschema work. I am planning to use it in getting all the tablenames/querries inside an MS Access database and put them in a combo box. thnx in advance.... Newvbguy

[COLOR=#191970]hello Can any one please help me in the following..... I making a database with Access and ASP. I have created a search option where I have a text box and a submit button. the result to this search is displayed in the same page. all i want is a …

[COLOR="Green"]i use acess 97 database , i'm not want to use datacontrol and iwant to use DBGrid how can i tie DBGrid with database by code thank you[/COLOR]

I have a form on our Web site where visitors enter data. I use cfinsert to insert this data into an MS access table. Most of the time, this form works. However, I occassionally get the following error: Error Executing Database Query. Application uses a value of the wrong type …

I am working in ms access database2000 and my frontend is vb 6.0. I have three tables namely:- AREA:- areaid,areaname ROUTE:-routeid,routeno,routename,areaids PARTY:-partyid,lastname,firstname,address,areaid The field areaids in ROUTE table consists of chain of areaids belonging to that particular route in this format '12,23,65,67,' The problem is that i want to derive …

[B]Hello Guys,[/B] I Hope everybody is going well.... I am making a database with ms access and asp for my project work... when the search output is going beyond 10 result.. for eg: 15 records, then how can i display first 10 result at first page and balance 5 result …

can anyone plz help me out by giving the lines of code which will hwlp me establisg a connection with my access database usin ADO ......

Hi, I'm creating a customer database in MS ACCESS with the following 3 tables: Customer (with unique customer_id) Products (with unique product_id) Customer_Order(contains both customer_id and product_id). I want to be able to use a form to enter new information into both the customer table and the customer_order table. The …

pliz assist in linking visual basic 6.0 with access step by step

pliz assist in showing how to link visual basic 6.0 and ms access following all the correct procedures. i have used data 1 for linking but still not working.tell me how to link vb with access

I'm trying to create a database for an operator to choose values from a dropdown list. However, the source of these values are calculated (in a different query) in different columns (long story). I need to be able to choose any single value from multiple columns. I have tried to …

Let, i have a database in ms access with two field named-"name" & "roll". I also have a combo box or list box in vb containing those names. I have to select a name from that list and appear the corresponding "roll" from that database in a text box in …

I have a stand-alone 2k machine that I loaded the IIS from the 2k cd. Basically I have a htlm program run which displays the exploded view of an assembly on the screen with hot spots. When you click on a part of the assembly it runs an ASP program …

I am supposed to create a hotel reservation system that allows you to make a reservation either with a hotel package or without and calculate billing. However I am at lost for where to begin. I have made a couple of sorry attempts but I am having problems identifyind the …

Hi, I have used the following code to add a new field to a database. Is there a way to stop this field having a Null value but still keep it empty? [CODE] strSQL = "SELECT * FROM cells ORDER BY cell, Proof;" Set db = OpenDatabase(lblDatabase.Caption, False, False) Set …

Hi people, I need an urgent help in this. I have a form where I have created a textbox(disabled) in order to show the Number ID from the access database Auto ID but have a problem here. The newly created table in the database doesn't show any number example like …

Hi guys, I need to put the results of a query to an acces database onto a word document. now the query is driven by user choices so it might return one record or it might return over 300 records or then again, nothing at all. but if there is …

I have a simple form that I want to have generate a random password, I just need it to generate the password, The database user will then copy the password and paste it where she needs it. The main issue I don't want her to have go to a web …

[B][COLOR=red]I am totally new to vb.net programming.[/COLOR][/B] [B][COLOR=red][/COLOR][/B] [B][COLOR=red]Can anyone help me regarding the process to retrieve and update data from MS Acess using window forms in VB.NET...[/COLOR][/B] [B][COLOR=red][/COLOR][/B] [B][COLOR=red]Would be very thankful for your kind replies....[/COLOR][/B] [B][COLOR=red][/COLOR][/B] [B][COLOR=red]Please reply at your earliest...URGENT!!![/COLOR][/B] [B][COLOR=red]Thankyou.[/COLOR][/B]

i would like to query a date which only showing work week and year... i try in FORMAT([MYDATE], 'WW YYYY', 1, 2)... it work but when goes to 31/12/2006 it showing "01 2006"... but suppose it should show "01 2007" how can i overcome this?

Hello!! I have a working login/password form which reads the stored login/passwords from Access, but I am trying to make it so the login and password is case sensative? :) Thanks!

Hello all! In my VB6 program I am extrating data from an database Access 2000, which I just made as password protected (now that the code is complete) But when I try to run the program (login/password screen) and I enter the login/password I get an error... "Could not Find …

hi i am designing a database using Ms Access and ASP. i have 3 tables in access namely [COLOR=red]'PERSONAL'[/COLOR], other as '[COLOR=red]POLICY'[/COLOR] and 3rd one is named as [COLOR=red]'STAFF'[/COLOR]. in the contact table i have ID, Name, Children as fields. Also in policy table the firlds are:- ID, date_of_policy, no_policy, …

I really need some help here and hope there are some Access database whizzes out there...and i know...there are.... my friend and I are doing a database project for a health care service... and we are trying to use the expression builder to perform calculations But for our fields, we …

right MS Access is balls compared to other DB's i know but im working on a project which already uses an Access DB. Now after writing the following eclipse gives me a lovely error which im yet to figure out. Googling has thrown up people with similiar problems but no …

Hi, I am having difficult time to make this run. Can anyone help me please?. I have test form with 3 command buttons & one Richedit.Im using access database to test. It have just one table with two fields ID (Integer), sMemo (memo). I am trying to save richedit text …

I have a database (myDB1.mdb) that contains related data in seven tables. Using vb6 existing in a separate application, I would like to find a way to archive this data into a new database (myArchive1.mdb) located in the same location as the main database. I understand how to use the …

I am using an MSAccess 2007 database file to retrive some info The tables look like this tblIncome Date | Takings 12/05/2007 | 10 12/05/2007 | 20 13/05/2007 | 10 16/05/2007 | 40 tblExpence Date | Takings 12/05/2007 | 10 13/05/2007 | 20 14/05/2007 | 50 When running the code …

hi i am designing a database using Ms Access and ASP. i have 3 tables in access namely [COLOR=red]'PERSONAL'[/COLOR], other as '[COLOR=red]POLICY'[/COLOR] and 3rd one is named as [COLOR=red]'STAFF'[/COLOR]. in the contact table i have ID, Name, Children as fields. Also in policy table the firlds are:- ID, date_of_policy, no_policy, …

hello im preparing a chemical database where i need to store chemical structures. ASP as front end i want that when the user draw a structure(user will manually draw the structure) in frontend there should be a search in the database for similar structures and all the similar structures should …

Hi there, i'm working on a project in which i'm creating, editing and deleting customer records from a MS access db. I'm using vb.net 2003. As with creating and deleting records i dont have any probelms. the problems arise when i come to update the data base if i edit …

I am done wracking my brain on this one, so if anyone has an answer I would be most grateful! I am trying to format a form in Access where users could check off a box and have the home address (already enetered on another subform) auto-filled in the fields …

Hi - I am using Access 2002 (Office XP) I am trying to design a database to use in my business. I have created the following tables: Suppliers, Products, Salespersons, Locations(where the products are sold). I now want to input sales info. I need to input Daily Sales for each …

Im creating a Databased; based program to of course send and recieve data from/to the database but never have I use MS Access before. can anyone recommend a simple tutorial for me?

[B][COLOR=blue]Good evening to all:[/COLOR][/B] [B][COLOR=blue]I want urgent help in my graduation project which is on-line shop for selling astronomical tools [telescopes, binoculars, books and so on]. I planned to make the interface by ASP.net and the database using Access but till now and to be honest, I don’t know any …

hi every1.. i have a form with a register butoon...when the button is pressed, the registration form (which is connected to ms access) opens...but the problem is that the form displays the data stored in table..although i need a blank form, which allows users to insert data... any emergency reply …

hi i have another problem with my DB... until yesterday everthing worked fine but suddenly the entire project stoped working. i use this method to connect to the data base: [INLINECODE]Imports System.Data.OleDb[/INLINECODE] ... [INLINECODE]Public Class func Public Shared Function seleccionar(ByVal comando As String) Dim DBliga As OleDbConnection Dim DBcomando As …

Hi there, I have a form that adds a Customer to a database. I had set the cust_id in the Ms Access as an Autonumber. and when I open the vb form, i wrote a code that will set the textbox of the cust_id as the count of the records …

Could not create; no modify design permission for table or query. I recently added user and group accounts to my database. I set my account with admin priviledges. I have full permissions on all tables, queries, forms and reports. I get the above stated error when I try to create …

hi there.... i created a new database using MS access which has a column that needs pictures so as the picture path for this column i have for example: "nejmeh/antarf.jpg"--> as the picture anyways i dragged and dropped this database to an asp.net new website where i have a datagrid …

Hi All, I have built a section for my site which is to be used by administrators, In which I have a page where I can update records within my Access DB. All of the fields work fine apart from..... The radio buttons. Currently when updating a record and selecting …

hi i don`t know if this is the right forum for this but its an emergency.... does anyone know how to add pictures to MS Access database!! like, to add a column called pictures and under that column we have all the pictures displayed!!! plz HELP