1,597 Topics
 | |
| | Hey Guys, Some of you know (Tim) that I'm working on a Professional Development and Training Database. I'm about to demo it to HR but I would like to add a feature: If a course is "Mandatory for all employees?" is checked in tblCourse, then check "Mandatory for Employee?" field … |
| | All, Having a problem with process flow while printing. I have a process that: 1. Pulls and Prints a summary sheet grouped by client (report 1), 2. Pulls and Prints a seperator page with Client Name (report 2), 3. Pulls and Prints the Client tickets for the Client (report 3) … |
| | All, All the help & HOWTOs say you can get subtotal from groupings and grand totals with the use of: =sum([fieldname]) and I have used this in the past, but current report is erroring by giving the popup, asking for value entry on each of these I placed in the … |
| | Hello Everyone, I have a large database where I'm using Dlookup to find the next record in the database. I need to find the next record providing it meets a specific criteria. If it doesn't meet the criteria then I need to look at the next record to see if … |
| | Hi, For Filemaker 9 I have a pretty big problem here. I have an account layout a contact layout and a Comments layout. The ID for the account layout is attached to the ID for my contacts layout. If account ID = 12 and new contact is clicked Contact ID … |
| | Here is what I got and maybe this will help. In example 1 you are on the company page which shows that company and some information that is needed for this company. The bar that runs about in the middle accross that will have links for CONTACTS - JOBS - … |
| | Hey, again I grace you guys with another question. I've run into another speed bump - REPORTING! I didn't create the database - just simply adapting it to the needs. It was created externally. Since Access allows only a certain number of fields per report, I divided the reports into … |
| | So i'm used to using mysql, but i'm on a project right now that uses an access database, and I'm looking for a way to replace LIMIT. I googled around and found the information on TOP, but it doesnt totally replace the functionality. For example if a user were to … |
| | Hey guys im really new in Microsoft Access my school give a assignment on Library management system in access only. and now im stuck . 1.Condition is Fine - .10p fine per book after 10 days. i could not set this condition on my database.i tried a lot but still … |
| | Hi! I would like to do something like this: [url]http://www.adp-gmbh.ch/ora/explainplan.html[/url] with an .mdb file. Thanks! |
| | I have a query which has a prompt when you insert the year a graph on a report displays.My problem is that when I enter the date the same prompt appears two times after I inserted the year. Also when I what to print the graph it also prompts me … |
 | I'm working with Access 2000. I have a form with data from a table, tblParts, and a list box with data from another table, tblRDM_Numbers. The two tables have a one-many relationship with tblParts.name as a foreign key for tblRDM_Numbers. I would like the list box to update every time … |
 | Hi I want to know how can I make my database that the user can add a field to a table from a form or sth? thanks  |
| | Hey guys, Although I decided against using a listbox and simply just using a subform, I did spend a lot of time trying to figure out how to get the listbox to store more than one values for that field. If the listbox multiselect property is on "None", it stores, … |
| | Hello, This was supposed to be easy but I could not get it! I need to create a calculated field in Access (preferably in a table or maybe a query) that calculates the BMI. I have fields for the weight in kgs and Height in cm. The formula is: BMI=(Wt(in …  |
| | Hello All, I'm wondering if anyone can help me by either directing me towards a source that would help me understand Access syntax better or help me figure out if it's possible to convert this SQL syntax to Access. I've tried but can't seem to get it to work. my … |
| | the heading says it all ... i have stored 6000+ entries in a DB and then now i wanna create a website that can search the DB and print relevant results. (the fields itself..) can anyone plzz help me or give an example for it... ------------------- There are like 6000+ … |
| | I am currently developing an Access 2000 database for the purchasing department at work, and I'm learning as I go. The tables are all set up. I'm trying to create forms to update the tables, but I've run into a few problems. A simple example is the Parts table. It … |
| | i have an access report with two sub reports. A text box in the main report adds 2 values in both sub reports together. One value is 10.22 and the other is 13.08 which should amount to 23.30 but the value is coming out at 23.29 which is off by … |
| | Good Day, I am using an Ms Access Database to design a StockTracker applicaton. The application is used to check the stocks of users. Firstly I need to sign on as an administrator and then be able to add users and their stocks to the database. I have created the … |
 | Good Morning All, I am not an MS Access Expert, so kindly excuse my ignorance. I received a database which is unable to open on my computer (for whatever reason), but is able to open on 5 different computers. At first I thought it was an MS Office version difference … |
| | Hi all, I'm developing an online booking system. I'm freaking-out becasue this is my school assignment project which I'll be evaluated on but i'm pretty new in IT . I'm really struggling. I'm going to use MS Access as my db and Visual Basic.Net to develop the user interface. What … |
| | hii, da values in ms access should be multiplyed wit values given in text boxes in windows form application in c#.fr example: price of a book in access is stored as 50$, in c# form in textbox i entered 2, the resultant answer which i should get is 100$. how … |
| | Have setup several ODBC links to local access DBs, and thought it would be just as simple wanting to link to an Access DB stored on my personal webspace, but no... Asks for username / password when I type in the url of the online DB in the ODBC setup, … |
| | Hi, I have a MS access 2007 form with two fields TEST_ID and TYPE and a button. When button is pressed i want to populate all the entries matching TEST_ID and TYPE in datasheet view from table Test_Data. For this, i have added code for SQL query in FindData_Click. I'm … |
| | I have four to five different Databases and each one has its own forms. I want to make an HTML page which has Four buttons and when you click on any one of the button it takes you to the Appropriate form. How do I do this? Also is there … |
| | Hello I've moved from graphic designer to static site builder and now want to begin exploring dynamic sites. I'm on a MAC and would like to use FileMaker Pro as my database app. Any comments? Thanks |
| | Hi, I've been asked to create a proof of concept for a new database tool we need to develop, combining various existing databases. It’s been awhile since I’ve touched any database work and I’m a little unsure how to go about it. Let me explain the problem...the analogy I’m using … |
| | Hello all I am a total newbee to access so please bear with me if this is a dumb one. I have an unbound main form : frmTest. With fields : [CustomerId](autonumber), [PhoneNum](str), [CustomerName](str), [CustomerSurName](str), [StreetName](str),[StreetNum](str), [aptNum](str), [floor](str), [Notes](str), [RegDate](date) and a subform field called [FrmQryCustomerSearch] which uses DataSheet view … |
| | All, Have a set of nested forms/subforms in this order: frmMain => sfmMain => ifmTABset => sfmUSR => sfmSETcfg where sfmMain & sfmUSR are the control fields containing the subforms being called and the TAB control TabCtl0 resides in the TABBED form of ifmTABset. I am trying to open the … |
The End.