1,597 Topics
 | |
| | Dear all, Thanks for keeping this wonderful forum going. I am having a problem with my application which I have developed using MS Access. I have a form which I use to enter workorder information which is not bound to the workorder table, I am using VBA t save data … |
| | Hi, I recently got a project where i have to make a simple access database and a webpage which serves as a form to enter data to the database. I dont have experience with web design but i have some experience with access. Would anyone know any good books to … |
| | hey all, I am developing application which has a huge data base. From that application, I generate REPORTS in Excel and FORMS(MS ACCESS) and also some PIE and BAR graphs in MS ACCESS file itself by linking to MS ACCESS back end. Now , I am wondering if i could … |
| | I have column table which has values 1 and 2. What should i code in CRITERIA of query builder so that when checkbox is ticked in form all records in the table with column value 1 appear and records with value 2 appeas if unchecked. path for check box: [Forms]![frm_Main]![opt_prr] |
| | how do you connect 2 access database files(mdb) and have the 1st one as the form and the 2nd one as the database and if you you the 1st mdb with the forms the database will be opened and showed in the same file? anyone who has an ide on … |
| | Hello. This is my first post. I have a problem, it goes like this: I have a Table named "Documents". Each document has a category and a sub-category. I also have a table named "Categories" and another one called "Sub-Categories". The categories table has 2 columns: 1)Id 2)Category name. The … |
| | I am sorry to take the liberty to email you directly, but I am in a really tight situation that I cannot seem to figure out. I am creating a database in MS Access. I have created several tables that I would like to link with each other. I created … |
| | Hi! A bit of a stuck-up. I have a problem which is probably simple to manage (not for me though - my brains work 24hrs/day and don’t come up with nothing). I want to show several different values from one field (in query) on the report - now check this … |
| | If anyone can point me in the right direction I would greatly appreciate it. I am making an Asset Management database. I'm looking at having about 50 fields in a table. Of those 50, 25 could potentially be used for searching. In some cases multiple fields would be used to … |
| | All, I'm writing a script/function to automated putting buttons on the screen. I'm running into a problem with var substitutions in my strings, which is necessary to make it run. Here is my code: [code]Function Get_Btn(MyForm) Dim Wspace As DAO.Workspace, dbs As DAO.Database, rsDEST As DAO.Recordset Dim SQLstmt As String, … |
| | Hi, im new hear and at access programming for a ear now. I'm looking for ways to improve response time on or access CRM here inwork. Currently we have a frontend(forms and queries) and a backend(tables) stored on the file server, the users here(about 25) use access on terminal server. … |
| | We have an MS-Access DB that we would like to create emails from is that possible. Approx. 140 employees we like to create emails to from Access. Thanks for any pointers. Russ @ scaninc.org |
 | I have 2 tables: Match and Team. Match(matchID is primary key, team1, team2, ...) Team(TeamID is primary key, ...) I mean how to force team1 and team2 is different from each other. Ex: We won't want to see: Brazil vs Brazil ^^ Any help is appreciated... |
| | HI, I am a beginner. I have designed a simple site in HTML. I want to add a login and register page. And I want to add a database to store the login and register informations. Can anyone help me with this? I am beginner in database. |
| | 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 … |
| | how to convert the file format of access .mdb to .dll system? can anyone know? |
| | 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 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 … |
| | 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) … |
| | 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 … |
| | 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 … |
| | 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 … |
 | 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 |
| | 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 … |
The End.