1,597 Topics
 | |
| | 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.