[microsoft:access] Forum Topics

I have a small app im working on that allows users to input data into an access database. This data represents incoming and outgoing items. Currently, the user can input all incoming and outgoing transactions, but I haven't been able to set them up to cancel each other. What I …

Hi Friends... i have searched google and this forum and etc, but i didn't get the answer to my question.. i want to use the CRYSTAL Report template, i have C# 2008, but in Add Items there is no template of Crystal Report.. so please tell me what should i …

i want to connect asp.net 2005 with access . now i need for the code do do this connection

Hello reader(s), Here is my code: [code] Private Sub Combo1_Click() Dim r conName.Provider = "Microsoft.Jet.OLEDB.4.0" conName.ConnectionString = App.Path & "\rosterdb.mdb" conName.CursorLocation = adUseClient conName.Open rsid.Open "select * from DayWiseRoster", conName, adOpenDynamic, adLockOptimistic ' in below loop i got the problem. it prompts "loop without do" Do While Not rsid.EOF If …

All, Trying to get a date WHERE statement to run to pull all records for the month. What I have is: [code] Dim SQL_Str, DatStr, MonVal MonVal = Get_Month(TargetForm![cboxMON]) DatStr = MonVal & "/*/" & TargetForm![cboxYER] SQL_Str = "SELECT * FROM qryREPrev WHERE ([tim_ted]= like #" & DatStr & "#)" …

Hi: I have a problem.. I have 3 text boxes and 12 comboboxes. the idea of the form is that the data entry on form has to be stored in Access.. which happens.. but i to limit the user in choosing only the values available from the combo boxes and …

Hello, My first post and I am hoping someone can resolve this strange dilemma. I am creating a text file by exporting the results of a query. One of the fields is a phone number that is formatted 999.999.9999 Unfortunately not all exported phone numbers are correctly formatted in the …

Dear all, Thanks for keeping this wonderful forum going. I am having a problem with my application which I have developed using MS Access. I have a form which I use to enter workorder information which is not bound to the workorder table, I am using VBA t save data …

Hi, I recently got a project where i have to make a simple access database and a webpage which serves as a form to enter data to the database. I dont have experience with web design but i have some experience with access. Would anyone know any good books to …

Hi, I have an Access database with a massive table of customer details e.g. ACNumber CustFName CustSName Contact etc etc etc What I want to do in Excel is have the user type the customers' ACNumber in a cell and automatically that row will be populated with the customer details. …

Hi i am developing an application i want to store data and image in a single table pls give the solution ?

hey all, I am developing application which has a huge data base. From that application, I generate REPORTS in Excel and FORMS(MS ACCESS) and also some PIE and BAR graphs in MS ACCESS file itself by linking to MS ACCESS back end. Now , I am wondering if i could …

I have column table which has values 1 and 2. What should i code in CRITERIA of query builder so that when checkbox is ticked in form all records in the table with column value 1 appear and records with value 2 appeas if unchecked. path for check box: [Forms]![frm_Main]![opt_prr]

how do you connect 2 access database files(mdb) and have the 1st one as the form and the 2nd one as the database and if you you the 1st mdb with the forms the database will be opened and showed in the same file? anyone who has an ide on …

Hi, I'm new to using queries in Access and am stuck on trying to run a query from a table. I have thousands of records with fields such as customer name, Company Name, Company Country and Balance. What I want to do is run the query to count the number …

K my question is so simple but i never got any clue from anyone yet i think i've been asked about it from here too but there was no response may be people couldnt find out what i was asking or wot i was trying to ask ? But i …

hi Alls, I really need your help regarding this method, Actually i need to create one search box using textbox and the result will display on listbox. I have textbox1 as inputbox, button1 as search button , listbox1 to display the value , Database1.mdb as my database. Can u guide …

Hello. This is my first post. I have a problem, it goes like this: I have a Table named "Documents". Each document has a category and a sub-category. I also have a table named "Categories" and another one called "Sub-Categories". The categories table has 2 columns: 1)Id 2)Category name. The …

I am sorry to take the liberty to email you directly, but I am in a really tight situation that I cannot seem to figure out. I am creating a database in MS Access. I have created several tables that I would like to link with each other. I created …

Afternoon all, I have taken up a task where end user should be able to enter information via vb interface into microsoft Access database. This then will be displayed onto the Datagrid via VB interface. The program needs to be setup in a way that first entry by end user …

Hi! A bit of a stuck-up. I have a problem which is probably simple to manage (not for me though - my brains work 24hrs/day and don’t come up with nothing). I want to show several different values from one field (in query) on the report - now check this …

This is probably a newbie question but I've figured out how to connect and query a microsoft access database via ado, but I can't figure out how to export the tables......need to export them to dbf???? Any help would be greatly appreciated.

I have to submit the assignment and I get stucked, so I need urgent help. Down is the Question. I have done a Query called Mtangoo_shop_query but I don't know what to do to filter out other fruits and leave only banana. Help! (Believe me MS Access is too complex!) …

If anyone can point me in the right direction I would greatly appreciate it. I am making an Asset Management database. I'm looking at having about 50 fields in a table. Of those 50, 25 could potentially be used for searching. In some cases multiple fields would be used to …

Hello, I connected my Delphi application with MS Access database and I am stuck a bit with a problem: how to execute UPDATE Query stored in MS Access database from Delphi ? Stored query in Access works properly. All other queries (mostly SELECT) stored in Access I have connected properly …

Hi, I have an ms-access database (.mdb) which I need to import to mysql. Is there a free software to make a .sql dump of this ms-access database? I have been trying some softwares (google searched) but none of them worked. One of them was able to replicate the table …

All, I'm writing a script/function to automated putting buttons on the screen. I'm running into a problem with var substitutions in my strings, which is necessary to make it run. Here is my code: [code]Function Get_Btn(MyForm) Dim Wspace As DAO.Workspace, dbs As DAO.Database, rsDEST As DAO.Recordset Dim SQLstmt As String, …

Error is coming Registry Access is not allowed.While Opening a Key. Can Somebody help me out. [code] Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click NewDelete("HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Run", "Sonia") End Sub Private Sub NewDelete(ByVal KeyPath As String, ByVal KeyName As String) Dim sMainKey As String Dim sKeyPath As …

Hi, im new hear and at access programming for a ear now. I'm looking for ways to improve response time on or access CRM here inwork. Currently we have a frontend(forms and queries) and a backend(tables) stored on the file server, the users here(about 25) use access on terminal server. …

hi everyone, im very new to vb.net. i have a textbox and a save button on my form. i have already connected the database to my application... pls can any1 tell m how do i save the data in the textbox to my ms access databse when i click on …

Hi all, I have developed a software that is basically a Question Paper Maker, I have stored all the questions in a MEMO field in an MSACCESS table. Now while I try to print the random questions on a report, it shows the question with all the rtf codes and …

hi guys i m doing my final yr project in vb 6.0 and back end in ms access i want help about how can i send a vb form as an attachment to outlook express or else how can i convert it into a word document is there any code …

Hello, Please can someone enlighten me. What I need is to fetch data back from my access database using an SQL query in order to present the data entered into the database in the last hour.

hi there, i have a form in Vb6 and a msacess 2007 database connected using ADODC, on a form is a listbox that i want to populate with the table data from the database, the name of the database is Storenw and the table from which i want to access …

We have an MS-Access DB that we would like to create emails from is that possible. Approx. 140 employees we like to create emails to from Access. Thanks for any pointers. Russ @ scaninc.org

Hi Friends, I'm a web developer bit a new to asp.net. I want to access my remote Ms Sql database through [B]Visual Web Developer[/B] or [B]Sql management studio[/B] but despite of spending so much time and googling I'm not able to do that. My [B]database( [url]www.peclive.com)[/url][/B] is on a server …

hi everybody, my connection code is like this: Set conn = New ADODB.Connection With conn .ConnectionString = "Provider = Microsoft.JET.OLEDB.4.0; data source = C:\Documents and Settings\kullaniciadi\Desktop\reservation97.mdb; persist security info = false" .Open End With This database (reservation97.mdb) is going to be moved to a server.. How is going to be …

Hi, I am just start programming by using C# not longer time,there are few thing i don't understand. 1) I have a task that need me to access to the database in the server. Can i know what coding what i should use in the C# webform for me to …

hi....i m actually developing a tool which uses access as the database source...i hv created 2 coloumns in the database....username and password....now in my tool i need to ask the user fr his username and password....if it matches with any of the combinations stored in the database then the user …

hi can anyone know how to save a data from flash and save it into ms access? because our professor make a program in visual basic w/ flash with a input text, static text, radio button and etc from flash, he can input a record and he have a command …

Hi I am trying to insert data into 1 of my table and I get this error: Microsoft Access can't append all the records in the append query. Microsoft Access set 0 fields to Null due to type conversion failure, and it didn't add 1 records to the table due …

I have 2 tables: Match and Team. Match(matchID is primary key, team1, team2, ...) Team(TeamID is primary key, ...) I mean how to force team1 and team2 is different from each other. Ex: We won't want to see: Brazil vs Brazil ^^ Any help is appreciated...

Hi There I want to open access from VB6 and join the tables of my database from VB6 and store the value in an array. THis is what i have done till now. but i can't make the query from VB6 with SQL. I don't know what is the problem …

hi, i want to display one table in a access database using datagrid. i tried to do like this. [COLOR="Red"]con.open constring set rs=con.execute("command to select the table") set datagrid.DataSource=rs[/COLOR] but it shows an runtime error like this: [B]RunTime Error '7004' The rowset in not bookmarkable[/B] wats' the reason... pls post …

HI, I am a beginner. I have designed a simple site in HTML. I want to add a login and register page. And I want to add a database to store the login and register informations. Can anyone help me with this? I am beginner in database.

I want to make an appointment manager type thing in Delphi. In which I can add/edit/delete/make sure appointments dont clash. Its part of a larger program I am making in Delphi which is why I cant use anything else (apart from microsoft access via a DBGRID) and it is really …

hi, I have Created a vb.net Application with MS ACCESS DATABASE, everything is working fine, But, There is a small problem . Everytime i ADD a new record it saves succesfully but i can only view that particular saved data only after restarting the application..Pls Help me ****************************************************** Imports System.Data …

Hello ! I finally took the leap and joined DaniWeb. I will tell you why. Daniweb is easy to use and I find the answers I am looking for here all the time. I am not a newb, but am not a programmer by any standard. I manipulate access pretty …

Hello, Im trying to create an application, where its upto the user to create and delete the database dynamically and at runtime. But i don't know how to make it. Can anyone please help?? Whenever i tried to contact u people for help u all have always helped, hope u …

Dear DANIWEB Members and Guests, HAPPY NEW YEAR 2009 I am a beginner in VB and so interested in programming. I am doing a small program in VB with back end MS Access and Crystal Report for report making. I humbly request your help and support in som matters. 1. …