[microsoft:access] Forum Topics

Greetings. I work for a university and have just changed jobs from a place where I was surrounded by seriously excellent computer folk to the Police Department, where I'm about the most accomplished person here software-wise :-O I do a lot of web pages with a lot of Photoshop goodies …

I have been developing a few applications, one is a user database which allows users to log into other software using an email address and password. I have created an administration application which allows me to add users and edit accounts. In this application I have included a DataGridView control, …

Hi, I have created an Access 2003 database for about 20 users over a network. I am currently weighing options as to just have the database on the network or to split it. The one main question I have is how to distribute design changes and possibly table design changes …

Hi all, I have a problem with a query in access that I cant seem to figure out. I have a form named frmRecruitment with a subform named sfrmParticipant. At the moment I am using an append query to append records from 'sfrmParticipant' to 'frmIntervention' using a button on a …

Hi, All Need a little help. I have a client that is getting this error while working in MS Access. There is a database that is housed on a network drive. There are 3-4 users at a time working on 1 table. The database was created about 5 years ago …

I would like to have a form where it automaticlly filled with reports as I build each report. Is there a way to do this? Thanks for any help.

I have a VB6 app that uses access 2007 for the database tables. I packaged it with the package and deployment wizard and installed it on a Windows XP home edition machine that does not have any MS Office apps. My program could not open and read the database. What …

Hi everyone, I have written an application to communicate with an Access database. Everything works fine when i compile it. I can run the compiled .exe file on the pc which has VB 6 installed but when i transfer to a pc that does not have a copy of VB …

Hi All, I got a question regarding sql. I got some data in a ms access. There's 3 columns, namely id, name and address. Here's an example. [CODE]id name address 1 a c 2 c d 3 d e . . . . 100[/CODE] And, I need to insert a …

I was wondering if anyone out could help me with a problem I'm having. I have been asked at my job to set up a purchase order database and one of hte things they want is when a purchase order form is filled out, instead of the data going into …

Hi All, I am novice in VB 6.0. I have to search data from access table using Employee no field which is unique and populate it on the form. But, I am encountering an error whenever I try to run the source code. I am getting runtime error as "No …

Hi All, I am making a tool in VB using MS access database. When I run the query in access it returns me the data but in VB it shows 0 recordcount. Any idea what could be the reason for this? One nore thing to ask. As multiple people can …

Hi All, I am inserting data in access database using Vb6. Data is getting inserted but when I try to fetch it again, it returns an empty row.I have an idea that I have to use update/refresh statement but not getting where to use it. Please help!!! Below is the …

I am trying to develop a website for a babe ruth baseball team. I want to include a page that displays team and player statistics. I have created Excel files for data from each game. I have also created an Excel file that collects data from each game and adds …

Hi, I would like to know if there is a way to link to a sql table, but not be able to edit it, the table is part of another program data and I just want to look at data, maybe copy to spreadsheet. I figured out how to get …

can any1 help me to connect my project to ms access database. i'm a newbie in vb.net. this is my code in vb6 to connect to the database can any1 help me to do it vb.net..hope sumbody can help me.. this is how i do it in vb 6 1. …

hi to all, pleas bear with me co'z I am a newbie with this environment. I have a microsoft access database and I already have tableadapter. I have already a forms that the operator input the name with the text box then searh with my database. After it successfully searched …

[COLOR="Red"][/COLOR][HI all, I have made a commercial software using vb6.0 and MSACCESS. My problem is even if I protect my .mdb file with a password, the password can be very easily found out by one or the other cracks. I want to further protect my MSACCESS datafile. Is there a …

dear friends, i want to update the table2 field which is same as table 1 field in ms accessdatabase. when ever i enter data in table1, table2 field which is same as table1 field should updated.table1 and table2 are connected to form1, form2 seperately. i request any body, please let …

[B]Question ONE[/B] I have on and off been using Basic, now VB since “the stone age” long before Microsoft and Windows. However it is only now I enter the issue of using [B]VB6 [/B]and a database. I use VB6-ADO-ACCESS plus using DataGrid as the main view to see the database. …

Dear Friend I am trying to perform the flowing tasks using the following SQL statement in Microsoft Access but they don’t work. I wonder if someone could help and tell me what is wrong with my Statements. Whenever I run these statements it will not create the query. [B]Task 1: …

Dear Friends I am relatively new to Microsoft Access and I have to create a report to perform below task, any suggestion, comment and advice will be really appreciated. Task 1: Prepare an order as a report (similar to the attached order form) to show an order for a customer …

The current state of my Mom's computer is horrible. I had an AV and Spyware software in place, but it failed to protect the computer. I've followed the instructions outlined before posting. However, I believe that the instructions are outlined for an older version of AVG. The current state of …

Hi, I was new to c# and asp.net .I want to create a simple login page using ASP.net with c# code behind.I had 2 textboxs(username and id) and 1 button control.I stored all the username and id in MS ACCESS database.Database name "user.mdb" and table name "table1" (only 2 fields …

Hi i really need code to back up an access database. Am using visual studio 2005. i have to submit my project next week.. please help me. I want to place the code in a button back up..

I am quite comfortable with MS Access and have developed a complex relational database for my company. However, we have decided to use FileMaker 9 as our database development software, so I have been asked to re-create this same databse in Filemaker. I am finding it difficult, as the simple …

I am new to FileMaker Pro 9 and have used MS Access a little. I am wondering if it is possible to transfer files from FileMaker Pro 9 (many files) to a web MS ACCESS database where another company where we send our data?

Ok so i have an interesting problem i need some help with. I am a beginner/intermediate user of FileMaker Pro 9 and i maintain a database that contains scanned in files. I am trying to automate the scanning/record making process but to do this i need FileMaker to pull the …

[code=ASP]<html> <title>CodeAve.com(Create Excel on Server)</title> <body bgcolor="#FFFFFF"> <% accessdb="a" cn="DRIVER=Microsoft Access Driver (*.mdb)};" cn=cn & "DBQ=" & server.mappath(accessdb) Set rs = Server.CreateObject("ADODB.Recordset") sql = "select id,empname,phone from empp" rs.Open sql,cn rs.MoveFirst file_being_created= "states.xls" set fso = createobject("scripting.filesystemobject") Set act = fso.CreateTextFile(server.mappath(file_being_created), true) act.WriteLine("<html><body>") act.WriteLine("<table border=""1"">") act.WriteLine("<tr>") act.WriteLine("<th nowrap>id</th>") act.WriteLine("<th nowrap>empname</th>") …

In the expression IIF[SSN]=50,99,[SSN]) when I enter 60, all works well. But if I enter 50, I get "The value entered doesn't meet the validation rule for the field or control". BTW, SSN is defined in the table as Number (Long Integer). What's the problem?

Hello there, I have been given a task where I need to create a website (not worldwide one but just on my memory stick to show my teacher of my work) by using Dreamweaver and Mircosoft Access only to produce it. The area's I'm stuck with is creating a registration …

i want to update the n th row of the ms access table through vb . i request any body to explain the procedure of code giving one example for which i will be thank ful

hi ... Need help i need code for backup a database.. i want to place the code in a button...

Hi. Now to start with I'm not asking you to provide me with a solid answer to this, but enough information so that I know where to start looking would be good. I have a project that I am working on which is an Olympic Database. I have several tables …

Hey All! I'm currently creating a database for a payroll system. I have a table consisting of Occupation_ID (primary key), occupation_description, normal_rate and then 3 different overtime rates. I've created a query to calculate the overtime rates for the different overtime rates, i.e. [code]UPDATE Occupation_Rates_Table SET occupation_rate_overtime_1 = Occupation_Rate_normal*1; [/code] …

Hey all I have another problem with my payroll database. firstly, i've created a form for creating/editing/deleting an employee record, which has relationships in other tables (i.e. a table of hours each employee worked containing the employee number, occupation id and hours worked, etc). When i create a new employee, …

hi all! I'm usuing VB 5.0. I need to store data getting input in VBform in MSAccess data base. I tried with ADO connection but its not working. Can any one send me the basic code to store data in MSaccess and to read the data. You help is highly …

I am trying to automate a process in order to make a monthly routine less time consuming. I have an Excel spreadsheet and an Access database. The spreadsheet contains formulas that calculate values for different fields based on values that are in other fields. The calculation all starts with the …

ei, can anyone could teach me or give some codes on how to create a password verification when opening the database using (msaccess) dao 3.51... thanx

Help! I can't get in to Access 2007. It's not a database password, but an password for Access itself. I can't even create a blank database. All it does is prompt me for a username and password. I've tried all 10 usernames and passwords of mind but they don't work. …

Hello everyone, I realise this may seem like a log winded way of doing it but I need to insert data from a JSP into a database, here is the set up. I have an HTML form, that passes it's data to a JSP. The JSP acts as a bridge …

Ok , maybe i should explain this.... logically i have a form , where i have a drop down list , which lists fields on a table those fields have records on the table, i want to automatically display those records for each field on the form , when you …

Hi all , I am a farmer, macadamia nut farmer. I created all the tables i need too, and set all the relationships. Now: I have diffrents blocks on the farm, each has a name, so i created a table with the names of the blocks as the field headings, …

I created a switcboard (based on 4 forms) in acces with a close command button on it, but wont close the whole access appliaction if i click on it, please help.

Hi I created an DB, that export data to Excel and create a chart from this data, now I want to know, what can I do to filter data and set a criteria eg. A$2:D$46-range, Criteria =2. The filter is not working if I set that critria, for the data …

Hi Guys, I was just wondering if there's a way of restricting access to the contents of a database by creating a list of users and their corresponding password. So when ever someone tries to open the database a form pops up asking for their user name and password. Thank …

What code can I use to open various PDFs from an Access 2007 form. Each PDF has a different name, which I can save to a variable. I have put the procedure on a double-click of a field. Have tried using GetObject but can't seem to make it open the …

Hi, I hope someone can provide some answers for me. I have a large application which creates an Access MDB and tables upon certain conditions. The problem is that the application does not release and close the Access MDB. I do not understand why. Desktop: Windows 2000 Access Drivers : …

Hi I'm hoping someone can steer me in the right direction please. Attempting to export some access data from a subform into a excel file, however the first four lines of data is OK but the fifth line only sends the first row of data instead of all of the …

Okay I have a database that contains records of billing information. I have created the queries I need to display the information but my issue is, is there a way to take the total values that are being produced from the query and separating them depending on amount for instance …