3,842 Topics
 | |
| | 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 … |
| | I've created an Excel spreadsheet that I use to incorporate data into a Microsoft word document. (Word/Excel 2003) When I do the mail merge and bring in the data, Excel takes a few of the data cells and adds zeroes after the decimal. I've attached a .jpg image of 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 … |
| | Hi Guys, I'm new to SQL and just know the basics. My boss has asked me to help him with a new system they are developing using MS. Access. In the form, the user enters their information as well as checks the applicable check boxes. When they have completed the … |
| | sir, i m making a simple database in ms access 2003. i m using hindi krutidev fonts in labels & text box. please help me will any problems creat in futrur. |
| | Hi all It’s required from me to create a database for a company which have three branches; the company does repair and sale second hand cars. I have created the database with my tutor but I think there are things missing but I don’t know where they should go and … |
| | Hi, this is the first time I have posted a question. I'm really hoping for somebody to help me. I have a text box in a report that I need to populate via a function. The data required (OPENING BALANCE) is already in another query titled: "qryEOD Report Query". I … |
 | I dont actaully know where to post my question below, so this looked like the best place next to a "generel web discussion" forum but none found. OK, basically i need some advice from you guys on excately what steps i should follow on how to create a browser based … |
The End.