1,597 Topics
 | |
| | hi this is my problem. there are three columns should be created in a table. the first column should be in tamil (a language in india) the second and third columns should be created in english can i keyin the tamil words in the 'tamil' column of a table if … |
| | I'm wanting to use a calendar to select dates in Access 2003 and want it to pop up when a date field is clicked on. So I will want the same calendar to pop up to be used to select a date, from many differenct date fields on the form. … |
| | i have a doubt can i keyin the tamil words(a language in india) in the 'tamil' colum of a table if yes how please? what are the all other tools needed and how can be added with ms-access and vb (front end) letters should be in tamil when it displayed … |
| | i want something like below: [U]table A[/U] [B]codes address[/B] 1 2 3 4 GO:0000166, GO:0000775, GO:0000795, GO:0000800 5 6 7 8 GO:0042802 9 10 GO:0005509, GO:0005856, GO:0007010, GO:0016020, GO:0051016 [U]table B[/U] [B]codes name information[/B] 1 alex builder 2 3 john IT 4 rupa IT 5 6 lex washer suppose i … |
| | Hai. I needto Receive Email using Ms-Access and Outlook. [I]On the receiving end, the user receives the email at the Outlook. When they opens the Email, the message box should have a button called “Save to Access”. [/I] [I]When this button is pressed, a dialog box should pop up where … |
| | I'm trying to filter a subform based on combobox selection and getting a runtime error '424' - object required. I downloaded the code from [URL]http://www.techonthenet.com/access/forms/filter_form.php[/URL] and verified that it works in the provided sample database. I copied the example and I'm getting the runtime error. I tried copying everything to … |
| | I'm attempting to upgrade an Access database to use a SQL Server 2000 back end. I have installed SQL Server and created a DSN. However, when I attempt to link to the SQL Server database from Access (File/Get External Data/Link Tables/Select ODBC Databases) nothing happens! Any ideas what I'm doing … |
| | Hi, SELECT * FROM veriler WHERE (name LIKE '%in%') This line doesn't work in Ms Access, IN either. No error is given is well. But It works in SQL server. How can i do in Access? Thanks |
| | I have been trying to get filemaker to give running balances but its impossible. Lets say I have an accoount with the following transactions: OpenBal Deposit Withdrawals ClosingBal Date Rec1 0 10000 0 10000 30 Sept 2005 Rec2 10000 0 5000 5000 31 Oct 2005 Rec3 5000 2000 0 7000 … |
| | Hello I have successfully exported a recordset to an Excel template and saved the template as an xls file. However, when I open the Excel file all the worksheets are hidden. Does anyone know why and how to stop this from happening. thx Wayne |
| | Hello everyone, I have an Access question. I have two date fields (field 1 & field 2), and both are formatted for "General Date". Since they are used in a calculation of Date and time, I need both segments to be entered. What expression can I input into the "Validation … |
| | I am trying to complete a deliverable with an acess database, below IS the formula that I used and it returned errors with the brackets and commas. Age: IIF([P1]>12,0),IIF([P1]=12, 12-[P2]/12)ELSE, IIF([P1]<=4, 100%. |
 | I need to be able to have users click on a form field that is an email address to contact the "contact" - it is proving more complicated than I thought. ANY Suggestions will be welcome.:eek: |
| | Hi every1, Is there any way that i can secure my ms access. i want when ever any one opens my database,it should ask for a password. any way of doing it? the database has already been created thanks in advance |
| | I have a field on a form which is calculated (A minus B). It displays properly on the form with the correct answer. I can't figure out how to get it to pull into a query? My query is pulling any record with that field criteria >0 and no records … |
| | Hi, Sorry for posting in Web Dev even though this is an App Dev question. We're looking at methods to create a new application. The application will be used heavily by about 20 people concurrently, it needs to be very user friendly and highly interactive. IT have nominated Java/Python/.Net or … |
| | [COLOR=#555555][FONT='Verdana','sans-serif']I have a very beginner type question. I use File maker pro to maintain records of member for a local Historical Society. We want be able to move a single record/member from one database to another. We do not want to import the whole database. Is there anyone out here … |
| | Hi, I forgot my Ms. Access Database password. :eek: Is there a way that I can recover it..? For your information, I split the database into two files, the front end and the back end. Now, I can't open the back end, although the front end still works. Help.... :confused: |
| | I need to create an environment that allows a data-entry person to change the default date for records on the fly. i.e. she's entering row upon row of historical data, and the date changes. I don't want her to have to manually enter the date for each record but I … |
| | Hi All, O/R Mapping and code generation are those topics which are under consideration for last 4-5 years. there are many tools available in market i.e. TierDeveloper @ [url]http://www.alachisoft.com[/url] Deklarit @ [url]http://www.deklarit.com[/url] LLBLGen Pro Raptier Codecharge etc. are some of the tools available in market. What are ur experiences about … |
| | Hi im new to this but i am doing a project for my business, i was wondering how in the validation rule you can set it so that it will have an error message if i do not insert a decimal point e.g for car enngine size 1.6 if enetered … |
| | I m havin ShiftTime nd actual Time.I want to get the difference between these two fields in the time format itself.But its comin like.234222........Can u help me hygee |
| | When user selects an item in a combo box that has already been selected and stored in a data table. (1) I want the item in the combobox ghosted or not visible in the combo box. or (2) Give user a msgbox that says record has already been selected. |
| | Hello, I am a novice Access 2002 user and I'd like to delete all rows where the "category" fields says "buyer" as I do not need this information in my Real Estate database. For example, I tried setting a query in SQL view with these parameters: [code] DELETE FROM [dbRealEstate] … |
| | Hi I have a "Repair Record Entry" table and form where the form is used to enter the information and it will be saved in the table then. I placed a command button with queries written at the side of the textbox on the form so that i can be … |
| | Hi, I am trying to deploy an Access database application that refers to a dll in VB code using a DECLARE statement. I wrote the dll in using VC++ 2005. I have tested the dll and it really does work fine, on some systems. The application runs on one computer … |
| | Hello, Does anyone know how to extract data from a record for a query? For example I have a sample number (Example: 1555A-S-070202-105500) and I would like to query todays date against it, the 070202 part of it. I would like to have Access show me all records with todays … |
| | I need help in setting up a connection string from MS Access to Pervasive SQL.:rolleyes: |
| | Hello, Being a novice at MS Access and the help menu being of no help I would like yours. I have a form that has combo boxes with the pull down information entered in under Row Source Type as a value list. The value list shows what I wrote in … |
| | table : kisiler name surname points ----- -------- ---- ali elli 1 ali elli 5 ali elli 5 veli kollu 3 veli kollu 4 adem bacakli 2 ali elli 4 veli kollu 5 Q ; how can i get result has been showed below; ali elli 15 veli kollu 12 … |
| | Hello, I'm a novice at microsoft access and I'm trying to make a validation rule to limit what can be entered in a field for hours worked. I set the field size to decimal. I set it up to have 2 digits to the right and left of the decimal …  |
| | Hello, I'm a novice at [URL="http://www.daniweb.com/techtalkforums/thread67883.html#"]microsoft[/URL] access and I'm trying to make a validation rule to limit what can be entered in a field for hours worked. I set the field size to decimal. I set it up to have 2 digits to the right and left of the decimal … |
| | I have been using a program that I wrote years ago. It is an Excel sheet that collects data from a MS Access database using queries. Everything was fine until this year (2007) My old queries work but none of my new ones.So I made a copy of and old … |
| | I get a "too many indices" message when I try to access a sequel table via MS Access. Is there a work around for this.:rolleyes: |
| | I ahve a client that exports an mdb file to a server folder from Access and their website auto updates with this information, it there a way to expot a file from FM8.5 that will do the same? TIA mac |
| | :cheesy: Help... I am not exactly a novice, but I am. I have been secured to develop an Access database for a very small organization. There are a total of 13 members who will be updating and pulling reports from this DB, so I am not overly concerned about heavy … |
| | Hi! I am creating a database for a class. It is supposed manage the hospitals Drug inventory as well as the patient's information and what patient is on what drug. I created a drug table (with drug_id, num_in_stock, and num_prescribed) and a patient table (with patient_id, name.. blah blah blah) …  |
| | I have a very simple table in "MS Word" (all fields are text fields) and I want to transform it into an "Access" table. How can i do it automatically? Is there any macro or a programm code that would allow me to do it automatically? (In the future I … |
| | I'm new to FileMaker Pro and am very very puzzled. The words E-Mail Campaign Manager suggested it would have powerful tooks to send e-mails. However, my staff seem to be unable to find a way to sort e.g., for all "journalists" in "Taiwan", and then send emails to all the … |
| | Hi, how can i display images in a form in Ms Access 2003. I have fields in a table and path of images. Thanks |
| | Hi Folks, I'm trying to pass a string between two different forms in ACCESS with code, and I'm having some difficulty tracking down the proper way to do this. Assistance in completing this task is greatly appreciated.. Thanks in advance! - Jordan Here's what I want to accomplish: [B]Form 1: … |
| | I'm try to let a form have a drop down bar (linking to a field in a table) which when any name within it is click it will display on the report that area |
| | Hey all, I'm using Access in conjunction with C# and ASP.net 2.0. I can't get the following query to work in Access, and I have no idea why it's throwing a syntax error. Any help would be appreciated. Thanks! [code]SELECT a.name, a.origDate, b.firstName, b.lastName, c.priority FROM afmMain AS a INNER … |
| | Hey all, i am new to these forums and was wondering if anyone could offer some advice/help Currenlty we have MS Access databse which was created well before i started, this database has all our work instructions mixed into it. Unfortunately it isn't the easiest thing to navigate and seeing … |
| | I'm creating an app with an Access database backend, and I seem to have encoutered two problems that I can neither explain nor solve. 1. When I run the app, there is a blank record that I can neither edit nor delete, and I am forced to click to add … |
| | Is there a easy way to import emails from outlook to a access table? I know I can go file, get external data, etc but I am looking for a macro that will do it or some code for a button to do it. Thanks in advance for any suggestions … |
| | Please let me know the code to populate the data from Table to Forms. What's the code for assigning values to Form buttons? |
| | I need help. I need a MS Access Database to submit for my final project in my Database Design class. Does anybody have one they could discuss with me? |
| | We're using Access 2000 and have 9916 entires. I've been told we're limited to 10000 entries. Is it so? If so, can we upgrade to a new Access? Or, must we go to a more sophisticated database? What's a body to do?? |
| | Hi All, I'm trying get access to a Firebird BLOB field. I have linked the input table using ODBC(FB 1.5). I have tried to extract the blob content various ways, so far unsuccessfully. Is there any way I could declare the BLOB_get, BLOB_open FBCLIENT.DLL functions in MSAccess code module? If … |
The End.