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