1,597 Topics
 | |
| | 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 |
| | 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 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 … |
| | 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 … |
| | 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. … |
| | 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 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 … |
| | 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 @ 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 … |
 | 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 … |
| | 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 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 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 … |
| | 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 … |
| | 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 … |
The End.