1,597 Topics
 | |
| | 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 … |
| | 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 … |
| | I created a database within MS Access - no SQL code - and set a field to "Memo". When I go to my web app that inserts some form data into the database, if I type too much into that one field on the form, I get "Invalid Precision Value". … |
 | Hello friends, I want to clear a table by clicking a button on a form. I have created the query to clear the table but I cannot make it the source for the command button on the form. Is this possible? Thanks for your time and help. |
| | I have an Access 2003 database to track employee call-outs. I have to run the report for the current day and for the last 7 days. I only want to show the employees who have call-out more than 1 time in this seven day period. The report must run automatically … |
| | I can't figure out how to perform a calcuation in a query and have the result output for use in a chart within a report. Forgive me I'm a newbie |
| | I am using the following code to retrieve the last entered value from a table and insert it into a textbox called rf. The code below works but the DB remains open until I restart my computer. [code] Sub Page_Load() If Request.QueryString("VesselName") Is Nothing Then VesselName.Text = "Blank Name" 'some … |
| | I'm in the planning stages of an inventory db. The part I can't figure out is how to design the database as far as changing costs go. If I have a cost associated with an item, how do I handle when the cost changes? I know I need to have … |
| | Ok, slight problem. I have a reservation with rooms. I need a query which will look at the "Arrival Date" and "Departure Date" So the query basically tells me which rooms are available from that. I would also like to no how to actually send emails from MS Access? Thanks |
| | I have an issue wherein the number of fields(columns) in a table exceed 255 in MS Access.ie(370) So i decided to split the tables into 2 diferent table each containing 185 fields. Then before running the QTP script, I join the 2 tables and store them as a view. View … |
| | Dear Friends, I am designing a database for a local garage where they repair and sale cars. I have come up with the attached normalisation. I would be very grateful if someone could have a look at it and give me some feedback on it. Kind Regards HB25 |
| | I am having a problem wit searching my database when i click search it says syntax error with FROM Clause. Here is my code n screen shot! Its the code for the find button!! [code]Option Explicit On Public Class Form1 Private Sub DisplaySearchResults(ByVal objectname As String, ByVal FieldName As String, … |
 | Hello, I spent hours wondering why this statement doesn`t work. I would like to insert record in a table if it doesn`t exist already.If record exists then a message will come out saying record exists. The values for the record to be inserted are current selection in combos on a … |
| | All, Have a form with over 189 controls on it and trying to automate the save. I currently use the following script to init the fields: [code] On Error GoTo Err_Msg For Each ctl In Targetform.Controls ' 100 = Label, 106 = CheckBox, 109 = TextBox, 111 = ComboBox Select … |
| | Hi, I would like to query from you people if its possible to change back color either row wise or CELL wise in List box. Also I would like to know any other ways of listing record in forms other than in List box, Flex Grid and Data grid. Regards, … |
| | just wanted to know how i can input a search facility to my webpage, which is on short courses. i want it to retrieve information from my database to display on my web page. my webpage is linked to an MS Access database. if anyone could help me u would … |
 | * [B]Edit:[/B] Sorry about double negative on the title, I don't know how to edit it back First of all, I am fairly new to Microsoft Access VBA. I created a form with 2 textbox (txtUsername and txtPassword) and one label act as button (I use label instead of button … |
| | I'm working through the lessons at Programmer’s Heaven's "C# School" tutorial ([url]http://www.programmersheaven.com/2/Les_CSharp_0)[/url], and I'm currently on lesson 13, "Data Access in .Net using ADO.Net", so of course I've been trying to connect to Programmer’s Heaven's SQL and MS Access / OleDb databases. Unfortunately, they're now offline. Can anyone please tell … |
| | Hello there! I developing a database simple enough for my friends to use using ACCESS. I wanted it to be only one Table only. The fields I want to play with are: TrackID, Member_Lastname, Member_Firstname, IDcolor, IDnumber, ReferredPerson_Lastname, ReferredPerson_Firstname, RPIDcolor, RPIDNumber. I created a dropdown combo for each on the … |
| | This seems like it should be an easy one to answer, but I remain clueless after many days of searching and trying different fixes. Basically I have a report with many sub reports, such as a form that shows family information and insurance beneficiaries, which all have their own subreport … |
| | Basically I have made a database that does all of my company's human resources needs. Now I have no training and everything has been learned from trial and error and/or looking up on the internet, but try as I might, I cannot find the answer to this question. Basically on … |
| | Hello all, I am having a bit of an issue with a report / query I'm running through a form. Thanks to your wonderful forums I have figured out how to take a value from a combo-box in a form, and run it to a report, however, when it does … |
| | Hi, I am creating a survey where 2000 people people will attend. I use Ms Access 2003 as a database. Do you think, Access is capable to do this? I am wondering, if more than one person use Ms Access, will it be still safe. Thanks |
| | Hi, I have 2 questions for concurrent access to a TXT file and Ms Access. I have a TXT file to store user entries (Name and Surname). I also use Ms Access Database to do same thing, storing user entries. If more than 1 user uses my service, will it … |
| | Hello everyone! Would like to seek help from experts. How can I make a "command button" in MS Access 2003 that will automatically convert "a record" (in a form view) to a PDF file? Will it be done using a code builder? Please help me..tried many times but it all … |
| | All, Trying to get a date WHERE statement to run to pull all records for the month. What I have is: [code] Dim SQL_Str, DatStr, MonVal MonVal = Get_Month(TargetForm![cboxMON]) DatStr = MonVal & "/*/" & TargetForm![cboxYER] SQL_Str = "SELECT * FROM qryREPrev WHERE ([tim_ted]= like #" & DatStr & "#)" … |
| | Hello, My first post and I am hoping someone can resolve this strange dilemma. I am creating a text file by exporting the results of a query. One of the fields is a phone number that is formatted 999.999.9999 Unfortunately not all exported phone numbers are correctly formatted in the … |
The End.