1,597 Topics
 | |
 | I really need some help here and hope there are some Access database whizzes out there...and i know...there are.... my friend and I are doing a database project for a health care service... and we are trying to use the expression builder to perform calculations But for our fields, we … |
| | hello im preparing a chemical database where i need to store chemical structures. ASP as front end i want that when the user draw a structure(user will manually draw the structure) in frontend there should be a search in the database for similar structures and all the similar structures should … |
| | I am done wracking my brain on this one, so if anyone has an answer I would be most grateful! I am trying to format a form in Access where users could check off a box and have the home address (already enetered on another subform) auto-filled in the fields …  |
| | Hi - I am using Access 2002 (Office XP) I am trying to design a database to use in my business. I have created the following tables: Suppliers, Products, Salespersons, Locations(where the products are sold). I now want to input sales info. I need to input Daily Sales for each … |
| | hi i don`t know if this is the right forum for this but its an emergency.... does anyone know how to add pictures to MS Access database!! like, to add a column called pictures and under that column we have all the pictures displayed!!! plz HELP |
| | I have an Access 2002 managed replica set running on about 80 sites which communitcate via Indirect Synchronization with a hub replica on a server in a State Government network. Some users are connected directly, some are on DSL and some of us are on satellite or even dialup. All … |
| | How do I select more than one data option from a look-up and save these options into a list box or combo box please? Newbe:| |
| | [COLOR=#008000][COLOR=#000000]Hi, please give me the script (syntax) and place, to be written it in a form in ms access 2003. [/COLOR] [COLOR=#000000] [/COLOR] [COLOR=#000000]1. Text box1 should be displayed the value of field[B]1[/B] from table [I]randomly[/I], when I click the command button1.[/COLOR] [COLOR=#000000] [/COLOR] [COLOR=#000000]2. Text box2 should be displayed … |
| | I have a Access 2003 database which has a table we'll call orders. There are 10 other tables linked to orders through Order_ID. I'd like to be able to create a duplicate of a record and all the associated records in the linked tables. I've read it possible with an … |
| | I am using Access 2007 to try and calcualate the difference between two time fields and when I enter in the validation rule I receive the following error! I do not have the field indexed. "Invalid SQL syntax error - cannot use multiple columns in a column-level CHECK constraint" Can … |
| | 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 … |
The End.