[microsoft:access] Forum Topics

For years, I have programmed pretty complex Access databases used by hundreds of end users. I am now tasked with learning FileMaker Pro 9. Can anyone recommend a FileMaker Pro book that would be good for someone who already has database knowledge but would like to transfer skills to FM …

A project that I have been working on requires multiple users to access a ms access db. I understand that I can split them and create a front end and back end. The backend would contain all my tables and I could place anywhere on a local network. My question …

I work in the IT department. I have been given the task of compiling a list of all the Access databases we have on our server and creating an Excel spreadsheet (using MS office 2007) with certain data such as name of database, access date, owner etc. My problem is …

Hi Everyone, I'm designing a database for a Motoring School and I've been given the following information: • Pupils book either a single lesson or a course of lessons. Pupils are allocated a particular instructor when they register with the school. Sometimes, pupils ask for their instructor to be changed. …

I have two tables as below table 1 ProductID---Int Descritption---Text table 2 Id FK_ProductID--Int Category but on the FK_ProductID I dont want my table not to display a number but the description from TBLA.

hi there i need to build a basic forum with admin rights through asp.net v-studio , access database. i keep getting mixed up when trying to create the p keys and foreign keys if any one could help me or show me in the right direction i would much appreciate. …

Hi All I am using[B] MS ACCESS 2003 and VB version 6.0.[/B]I made a Blank database in ACCESS with a table having fields [B]Username & Password.[/B] My VB application consists of [B]2 textboxes and a command button[/B]. I established the connection using [B]"Microsoft.Jet.OLEDB.4.0[/B]"(coz i tried first 3.51 but it wasnt …

basically I have a form with 3 fields, ID, NAME and ADDRESS. What I want to do is after I enter my ID it will fetch the NAME and ADDRESS data from my access database. I want it to fetch the data after I finish entering the ID, but the …

My program is using Access mdb database through ADO. I have Access installed here, but there is no Access on that machine which has the database. There is a query, which takes much more time than it should... My question is: - How can I profile that query (under Access …

How to add Cristal Reports 9/19/11 Professional into Access 2007 ??

I attach a file what was send by Shaik Akthar. I work with it a new access file. He use Table, I use querie. But it not work.I modify some code like: MSFlexGrid.FormatString = "<DATENOW|<NAME|<DIAGNOSIS|<REMARKS" MSFlexGrid.FormatString = "<Student ID|<Student Name|<Jamal|<Roll No" Con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=" & App.Path & "\DB2.MDB" …

I have a database here that I'm re-building to make it more up to date for my customer. They need a Quote table, form, report, etc. Their quote numbers are generated as "2008-000" 2008 being for the year, and 000 goes as the automated number, for each individual quote. This …

Hi, I Have data stored with the following structure: Version Month Amount 1 Brand1 Jan 100 1 Brand1 Feb 200 1 Brand1 Mar 150 1 Brand1 Apr 500 .. .. .. Id'like to transform it in the following table: Version Jan Feb Mar Apr May ... Dec 1 Brand1 100 …

hey all, i keep having a problem using vb with an access database. anything i try to do with access brings up the same error message saying database format not recognised. any ideas what i need to do. thanks

hello every1, I am a college student and a new user on this forum just like I'm new to VB, please take it as if I know NOTHING about VB, I have VB 6.0 on my system, and I av a mini project to submit b4 February 20, 2009. I …

I inherited a database using Workgroup security. I was given the Admin priveliges but I find it is a bit too restrictive for my department. Is there anyway of disabling the Workgroup security so I could put in a designer security instead? Thanks for any help, Papa

Hi, I am using VB.Net 2005, VS 2005, and an Access Database. I have a datagridview on a form that gets populated from a table in the Access DB. What I'm needing to do is take the data from the DGV and put it into a table, "not the original …

Hi @ all: I've been looking for an ODBC-Driver for Filemaker. I've searched the web for hours, but i always found Trials of ODBC-Drivers, and that Trials were only for MAC OS. In an other forum, people where talking about a DLL, called "fmfmp50.dll", which should be an ODBC-Driver, but …

I work at a college and we have a file that looks like this: ID DEGREE 0001 BA 0002 BS 0002 BA 0003 BA 0003 BA 0004 BS 0005 BS 0005 BA 0006 BA 0006 BA 0007 BS 0007 AA 0007 BA Each student has a unique ID and could …

Hi, I made a small Access DB that has a Date field in it (DUEDATE). The DB is used for demonstration purposes to show current orders. I need a function that would randomly update the orders due date in the table (orders). I would like to input a starting date …

My company has been using an Access 2003 database for a couple years now and the person who previously worked on it just left, the problem is he never gave me the password to unlock the Visual Basic editor window, and I can't seem to contact him. Does anybody know …

Hi I have create database by MSaccess in the my computer and I need publish on the Internet to use direct from website. the database contain tables, queries and forms that is as application. I want open the application through the internet. I have background of MSaccess, and what comes …

I have two databases and want to combine them. I tried sharing the tables but could not make that work. I tried importing the fields into the master table and that did not work (could not find a copy button). So I laboriously typed in the fields (copied them to …

Hello to all, I have a problem in connecting VB6 to MS Access 2003. I have tried all the instruction posted here in forum until the message appear every time I run the program "Supplied Provider is different from the one already in use." What does it mean? I am …

heloo. i created checkboxes in my web interface and each time a checbox is ticked the value is stored in database but however the checboxes which is not selected , the value is stored as Undefined in database. where did i do wrong? here is my coding for the checkbox: …

i want to link my forms with access tables and dont want to use the odbc object. i need to use the ADO is it posible and how. for in my first instance it worked, but when i moved it to another computer it signaled "Canot find database" Help pliz

I have a database used for Phone record auditing. I am trying to see whether it is possible to have labels within a section disappear for 1 page but appear for another. I'll explain below. In the page header, I have it display the customers name and phone number as …

Hullo, I'm an Access novice programming a db for data entry and would be very grateful for any help - I'm stuck on this one! When I attempt to save a new record on a form, I'm getting an error that reads "The record cannot be deleted or changed because …

Hey guys, quick question. I have a movie table which records information about certain movies. See below for the table structure. id Title Length ------------------------------------------- 1 American Pie 160 2 Van Wilder 115 3 Not Another Teen Movie 115 4, Road Trip 130 5 Shawshank Redemption 130 6 Scarey Movie …

hi, im a student and have my own website. i want to offer my user's a forum but ...well to be honist i have no bloody idea how to create a database. ive never needed to and need a access database for phpbb3 forum. can anyone help me?? p.s will …

help me how to select the record between two date...........................................

I have a really weird thing happening in my database. It used to work fine but all of a sudden now when I preview the report, it shows up too large. Please see the pictures to understand what I mean. I have tried undoing every change that I had made, …

Hi, My wife and I own an bush air service in semi-remote part of alaska and we are looking for a way to fine tune a reservation system (in Access) that a friend developed for us. We paid a bunch of money to get some things fixed on it but …

Hi Folks, I Trying to Copy File UJF.mdb in another Location which is User Specifyed. I Closed All Connection, But Still ERROR 70 'Permision Denied' Occurs :'( [ICODE] rs.close con.close FileCopy "D:\UJF\UJF.mdb", "D:\Person.mdb" MsgBox "Backup Successfully Compleated", vbInformation [/ICODE] How to Copy Access 2003 .mdb File to Another location Without …

Hi friends, Please give me the solution of making a project multiuser on LAN. I am using Ms Access as backend tool. When i run that programme on another PC then it shows file already in used and programmes goes out. Pardeep

Hi The menu form that starts up when I open access has a bug in it...I wanted to close the form when a certain condition exists but I used the quit command (instead of close) so it quits access completely! I cannot get in to fix my bug. Is there …

I am new to ASP, and I used to write the connection for my Access Database using DNSLESS Connection like this: <HTML> <BODY> <% 'Actionvar=Request.QueryString("actionvar") '** Set Up a DSNLESS CONNECTION<BR> Set conn = server.createobject("adodb.connection") DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)}; " 'DSNtemp=dsntemp & "DBQ=" & server.mappath("Record.mdb") DSNtemp=dsntemp & "DBQ=" & server.mappath("MyWeb/MyRecord/Record.mdb") …

hi all i am a software developer mainly working in C# ASP.NET. i have 2 yrs of experience and i m a microsoft certified professional. till now i have worked in SQl 2000 and SQL 2005 database however now i m required to work in access 2003 database. so here …

Hi, first post, and am a real novice, looking at the problems and solutions posted here. I have a database (Access 2003) where I want to change the name of a field within a query (to be used in forms and reports), depending on a decision the user makes. Can't …

hi i have a window application, wherein i have to choose the database,its table and rowfields present in the table at runtime. Now i want to remove all the duplicates from database. my database is access and whichever row field the user chooses the duplicates should be removed leaving the …

hi everyone, I have my website which i used microsoft access as my database. everything's working fine except when i submitted the site to my boss for approval, they rejected it because they dont want me to use ms access as our database because they said its not a strong …

Hello Friends, I am a student. I have to complete a project and would like to learn few things from all you experts on ms access. I have to make a personal contact directory with id, date, name, address, phone, email and photo. To feed data, I have to make …

i need help with linikin my smart devices to microsoft access.....i am using smart devices, but i cant use my imports system.data.ole db...i know how to use tht way to link normal forms,is there a way to link smart devices to access in vb.net,i tried to google but i did …

Hi guyz, i have a question about crystal report . How to connect the Crystal Report in MS Access (w/ a password security).. Cause i can't seem to connect it with a password database..tnx in advance

Hi All, My name is Gail Edmonds and my business partner, Missy Scardina, and I own a small software training and consulting company called Core Solutions, Inc. in the Chicago area. Many of our clients are in the west suburbs, as in Naperville, Aurora, Lisle, etc. We do a lot …

Hi All, im currrently working on a cover system for a school. To book the cover in i am using a form which shows the day (period's 1-5) as labels with tick boxes below them. i want to make the labels change it the actual subject that period. so what …

Hi, hope all are doing fine.. need some suggestions. I am using VB and Acccess and am trying to fetch a record from database by: "Select * from accounts where emp_code='"+d+"' AND emp_name='"+n+"'"". The inputs are fetched from an Inputbox. but i get a compilation error... [B]Run-time error '13': Type …

Helo friends; [code] If lbDriverName.SelectedIndex = True Then sql = "SELECT * FROM tblDriver WHERE dName =" & lbDriverName.SelectedItem Else sql = "SELECT * FROM tblDriver" End If [/code] and my error is... [TEX] Syntax error (missing operator) in query expression 'dName ='. [/TEX] where dName is the column in …

Am supposed to be programming a few forms in Ms Access and the forms seem too crowded that this might not happen on a single access form. Question is there a way i can bypass the 174 max limit num for controls per form because when i get to some …

I have a table with data that i need to plot on a graph using pivot charts and selecting data for a particular patient number that is repeated severally someone with an idea.