1,557 Topics

Member Avatar for
Member Avatar for thangasiva

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 …

0
67
Member Avatar for James890

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. …

0
64
Member Avatar for thangasiva

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 …

0
50
Member Avatar for nehashri

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 …

0
65
Member Avatar for ttamilvanan81

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 …

0
80
Member Avatar for agrothe

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 …

0
73
Member Avatar for jimcooper

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 …

0
61
Member Avatar for Fenerbahce

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

Member Avatar for Henry Schubel
0
85
Member Avatar for AndrewHolness

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 …

Member Avatar for TyIzuka
0
102
Member Avatar for hamerw

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

Member Avatar for Rupeshba
0
112
Member Avatar for hvelador

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 …

Member Avatar for Rupeshba
0
123
Member Avatar for Bennita Martin

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%.

Member Avatar for Rupeshba
-2
116
Member Avatar for mrwatson54

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:

Member Avatar for davidcairns
0
544
Member Avatar for bhuvan83

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

Member Avatar for bhuvan83
0
85
Member Avatar for shar164

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 …

Member Avatar for carolraydon
0
98
Member Avatar for port80

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 …

Member Avatar for port80
0
104
Member Avatar for yikes2006

[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 …

0
63
Member Avatar for kramero

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:

Member Avatar for jbennet
0
214
Member Avatar for Athlete

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 …

Member Avatar for cpopham
0
107
Member Avatar for zqurra

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 …

Member Avatar for s_sana
0
97
Member Avatar for ollie_jennings

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 …

Member Avatar for ollie_jennings
0
93
Member Avatar for hygeena

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

0
55
Member Avatar for dontell

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.

0
56
Member Avatar for ekeyte

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] …

Member Avatar for TJ Bowers
0
118
Member Avatar for Jeremy20

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 …

0
52
Member Avatar for Robert S

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 …

0
91
Member Avatar for jgabrielson

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 …

Member Avatar for cynicl12000
0
76
Member Avatar for jmanels

I need help in setting up a connection string from MS Access to Pervasive SQL.:rolleyes:

Member Avatar for Fenerbahce
0
72
Member Avatar for dstat

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 …

0
59
Member Avatar for Fenerbahce

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 …

Member Avatar for Fenerbahce
0
102

The End.