[microsoft:access] Forum Topics

I hope this is the correct forum to post this. Wondering if anyone could help... On a form a continuous record list is displayed as results of running a QUERY. While this QUERY is displayed, I’d like to filter it. QUERY would display on a FORM showing: (customer: being the …

Hello, I used dreamweaver to create a website, i used the dreamweaver features of 'Log In User' form which is ingregrated into dreamweaver application, now i made a registration page using dreamweaver as well using the 'Record insert wizard' i have microsoft Access database connected to this, now my assignment …

Hello everyone, I am searching for help with a current problem involving MS Access and VB6. My situation is this: I have a (rather large) program written in VB6 that uses an MS Access database. I have user-level security implemented on the database itself, which (though a not-often used capability) …

Hi! All I m working on a project in which i requred to store Table and Queries in to new Ms Access .mdb file You know in MS Access we are able to make tables, macro, reports and queries, and save in it. just same like that i wnt to …

Hi everyone, I need some help here, i'm new to asp.net, need your help here. What i want to do is retrieve data from access database and show as a dropdownlist twice in a form, the dropdown list will look something like [ data ( data_group) ]. how can i …

Hi all, I am running a query on an MS Access table that has some fields that are the same and some that aren't. For example, the customer number_field is the same, but the start_date field is different. I'd like to run through the query and when the customer_id is …

guys, i need help in using VB 6.0.can you help me to get a data from an excel file from ms access and put it in ms excel..pls help me guys..:'( here is the sample of the file in access: sum1 sum2 22321 123123 here is a sample of the …

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 …

I've written this program which at the mo only has two buttons. One to exit the program and the other to open a report from an external Microsoft Access database file. I'm getting this error message: [B][U]Debugger Exception Notification[/U] - Project Project1.exe raised exception class EOleSysError with message "Operation Unavailable". …

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:|

Hi, 1 ) I must take a back up of a access data base daily and store in my desktop. Please give me coding to copy the access data base from the c drive and to paste in my desktop. Every time when i save the access in my desktop …

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

Helllo , how to create a Monthly wise Data report in VB? data base MSAccess... can any1 help me plzzzzzzzzzz....

I want my c# program to connect to my Access database so that i can update, insert and select from my database using c# 2003, can someone show me the steps of connecting to it. I know the part where you right click 1. Data connections and click add connection, …

[COLOR=blue]Hello everyone…. [/COLOR] [COLOR=blue] [/COLOR] [COLOR=blue]Can someone help me? Please.[/COLOR] [COLOR=blue] [/COLOR] [COLOR=blue]I have got a form with listview connecting access database.[/COLOR] [COLOR=blue]Some how I have managed to call the data to the form. As you can see the code below. It will open all the data to listview. And …

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 …

hi i want to save a query design by me to Ms Access in Query tab by C# coding . my question is. You know in MS Access we are able to make tables, macro, reports and queries, and save in it. just same like that i wnt to make …

hi i want to save a query design by me to Ms Access in Query tab by C# coding . what i have to do , pl'z do it fast

This is a dumb question. I'm trying to find a way to put a button on my ASP page that will reset a date field in my access database to now(). I'm an ASP beginner and I have scoured the web for awhile now looking for an answer to this …

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 …

Hi! Beginner here. I'm using VB 6.0 . I created a new Access database (.mdb) using Visual Data Manager (from Add-Ins). If I right-click on a blank space in the Database Window, and click New Table in the context menu, a Table Structure window would appear. In it, I'm supposed …

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

Hi guys, im new to ASP.Net and was wondering what the code was to display a Access DB Also does anyone have any good easy to follow tutorials which will show me how to manipulate the data etc - edit, delete, add Thanks :)

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 …

i have a doubt can i key in the tamil letters(a language in india) in the 'tamil' colum of a tabe if yes how ?can i add tamil fonts and create colum in a table. letters should be in tamil when it displayd (not in english letters like v a …

Hello eveybody i have a calander in my project, when i click on date it retain in list box the information related to this day but the problem in Access in the feild date , it dosen't save the date in the format it takes from the calander , thats …

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 …

Hai, I need to Send and Receive Email using Ms-Access with Attachments. Anybody know how to send and receive Email's usin Ms-Access. please post me the details. Thanks Tamilvanan

I need help in updating a database in MS access using VB....i need only 8 entrises (rows) in the database...all i need to do is delete all the rows in the database and then add the new data....i am delelting the whole data since the no of new entries(rows) maybe …

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 …

hi! I need a program in vb that does this as soon as possible, I'd be very grateful if anyone could tell me how to do it: the customer gives a table containing the old values and new values in an excel sheet which will be connected to an access …

Hi Frns, Plz som1 help me, I want to add the values of a coloumn in MS Access db, I m using Visual Basic as a front end. The total should be displayed on the Form. So if possible then plz tell me the VB coding. Thnx in advnce.

[B]i want to disply the database content on webbrowser . The program writeen syntax free but it can not display anything on web browser [/B] [B]why ? [/B] [B]i can use the MS Access 2000 database[/B] [B]plz help me [/B] [B]code is ..[/B] [B]#!usr/bin/perl[/B] [B]use Win32::OLE; use Win32::OLE::Const 'Microsoft ActiveX …

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

BackGround: I'm working on a small application that is to demonstrate viewing of a database. I have 3 tables customer, transaction, account that are added to the project. (Access OLE DB). I am to log in with userid and PW from the database, once logged in the user can select …

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 …

[B]how can I extract all the values of one field from the database table (ex : all the names from the field NAME) and put them in a combo box in run time in the dynamically generated page…[/B] [B] [/B] [B]and secondly, if all the values are available in the …

Hi, I am using the following items in my s/w.... ------------------------------------------------------ Reporting Toolkit: Crystal Report (CR 11). S/W Front End: Visual Basic 6.0 with Service Pack 6 Back End RDBMS: Microsoft Access 2000 ------------------------------------------------------ I am almost done with CR 11 and its integration into my s/w. Great Thanks !! …

hi all!! im using ADODC as the connection with MS access. hw can get the selected data in the datagrid on the click of the command button? i.e If user want the employee info from company then user enters the emp code and by pressing 'search' command button user gets …

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

Hi people, i have a login via my Access DB - thanks to paladine Now i want the following When the user has logged in and they are taken to the Default.aspx page i would like a 'Welcome [UserName goes here]' feature showing who they have successfully logged in as …

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

Hi, I am using MS access database with ADO control in VB. I want to display only those names in the combo box when I type a first letter in the combo box using visual basic. For Eg, When I type letter 'm' , the combo box should give a …

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 …