[microsoft:access] Forum Topics

A long shot I know but a colleague has left, leaving behind a couple of access databases that query each other and a sql database, unfortunately one of the databases querys now takes a long time to run to the point that the excel report calling the query timeouts. is …

I'm very new to visual basic 6.0 and I have a very less knowledge in it. My project is about airport boarding pass generator. In my first form,I have a text box for entering PNR by the user. Here, the program has to search for the PNR already stored in …

i need help on this project it really makes me crazy... imnising access 2007 and vb6 together in my code im trying to make a report using sql query inner join on access database with aggregate function so sad the result is really bad.... the many to many relation ship …

I would like to create a Microsoft Access database and integrate it into my VB.net application. I am also hoping to distribute this application to others. My concern though is whether or not users who download my application will also need Microsoft Access in order for the database (and app) …

I had made a Microsoft Office Access 2007 database with more than 2000 records. A copy of which was given to my friend. We both made a number of amendments and added new records in our respective copies. Now I want to compare both databases & merge the databases into …

Hi, For a school assenment I was tasked to make a small database solution for a medical clinic. I am wanting to select an access database table after gaining the ID for the table. I will be needing to read and write to this table as well if it makes …

what is causing this error here "Operator '&' is not defined for string "select * from Miscellaneouse whe" and type 'DataRowView'." provider = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source =" dataFile = "C:\Users\PrintServer\Documents\Visual Studio 2010\Projects\Hr and Payroll1\HR and Payroll.accdb" ' Change it to your Access Database location connString = provider & dataFile myConnection.ConnectionString = …

##vbScript - Browse for Folder or File Please see my post [vbScript - The Basics](https://www.daniweb.com/programming/threads/516400/vbscript-the-basics) for more details on vbScript. Some scripts need input (other than from the command line) from the user. This can be read from the console (StdIn) or from a pop-up textbox (InputBox). This is fine …

private void EnterAcNotextBox_TextChanged(object sender, EventArgs e) { int id; if (!int.TryParse(AcNotextBox.Text, out id)) { return; } string connString = ConfigurationManager.ConnectionStrings["dbx"].ConnectionString; string cmdString = "SELECT '#' FROM tblBasicInfo, tblAccData WHERE ID =" + Convert.ToInt32(AcNotextBox.Text); //string query = "SELECT * FROM tblAccData WHERE ID =" + Convert.ToInt32(AcNotextBox.Text); using (OleDbConnection conn = new …

how??????

We have an Access mdb database originally built in the late 90s. We currently use MS Access 2000 on Win7. Since switching to win7 from XP the database keeps getting locked and corrupted and we are unable to open it. We then have to revert to backup copies made days …

i want to connect adodc control to ms access databasethrogh coding please help me with that and yes there are 4-5 tables in my ms acesss database i want above mentionshed coding for visual basic 6.0

I receive an error message and I don't know what to do about it. IO have a delphi app using a MS Access 2010 database. I connect to it through BDE. It worked perfectly until today when the users told me that they can't enter my application due an error …

We have a MS Access database located on a shared drive. Is there a way I can allow multiple users to access and update the database at the same time?

Dear Fellows, I have an Inventory Management System and a Point Of Sale. App is working well on a local network. But now i would like to connect my Point Of Sale app through internet to another computer another city where the Inventory Management System with Acccess 2003 Database is …

Hi I am useing Lazarus and a odbc connection to connect to a MS Access database I connect fine and get all records displayed in a dbgrid . My problem is to get the changes written back to the db. When i try to write the data back to the …

Really need help how to save all data from datagridview to access database ..?? thanks

Hello, I am creating a code that allows the user to insert data into textboxes and then have it stored in an Access database. The code that I used worked previously but since I added the second query, nothing is added to either tables. Here is my code: Private Sub …

A search button that can find and could post the data saved in MS Access in a new form?

I am currently developing in Visual Studio 2008 (Visual Basic) and I have no problem reading, editing, saving, etc. to a 2007 Access database that is stored locally using the following code: [CODE]Dim NotifyDS As New DataSet() Dim NotifyCon As New OleDb.OleDbConnection NotifyCon.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Data\Settings.accdb" NotifyCon.Open()[/CODE] Ultimately I am …

Hi I Have an App that connects to an 2010 access DB (.accdb) using OELDB Driver. In my dev pc the application works fine. I also tried installing it on different pc and it worked fine using a access database runtime. Now when Installing it on a pc running access …

Suppose we need to populate and filter a Datagrid with the data coming from an Access table. It could be of course a table from Sql Server also. Form dataGridSelect contains two buttons and a DataGridView. Clicking the first button will populate the DataGridView the data comming from a Sql …

Dear Sir I have access data table and vb . project .access data table include ID ,word and description Colum v b project include three text box and one list box. If I search any word in text box through word Colum .I want show description Colum next text box …

Hello there im searching for code where i can filter a report that is placed inside a form. Normally in opening a report the code is Docmd.OpenReport,,, however in my case the report is already inside my form and im suppose to hit a button to apply filter on it. …

Hi there, I’m doing some research around cybersecurity — specifically access management. Does anyone have a moment to answer the below please? 1. Since Windows Active Directory is nearly ubiquitous in enterprises, what are IT professionals doing to secure access? What are the biggest challenges to securing user access using …

Hi good day guys.. i am doing a POS in Microsoft access for my thesis.. the problem .. i create a button and i want to enter a data to the list box.. if you click the menu button it will automatically add the item on list box.. and i …

** Here's my codes: Public Class frmLogin Dim sqlcode As String Dim connstring As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Jim Clinton Amarga\Desktop\Class Records\Class Records\bin\Debug\dbClassRecords.accdb" Private Sub btnLogin_Click(sender As Object, e As EventArgs) Handles btnLogin.Click If cmbLoginType.Text = "Administrator" Then Dim sqlLoginCode As String = "select * from tblusers where User_username = '" …

i can't get DateTimePicker to insert into Access databse. I've tried all the suggestion i can find from this forum, so i'm thinking my problem is different? my table has a column date which has a Date/Time format my code [CODE] Dim cmd As OleDbCommand Dim sqlstr As String, ans …

Hey, Situation: * For an assignment, I am making a to-do program using Visual Studio 2015 and Access. Problem: * I have two forms, one is view the tasks using datagridview through labels, and the other is to add the record to the database. * How can I add a …

“RunTime-13” Type mismatch error in code after access 2003 convert to 2010.

Hi guys I am developing a simple job card creator application with VB.net 2012, using Access 2010 as database. The code I have generated to write data from a datagridview to the database table is successfully saving the data, but with an error "Parameter @name has no default value". The …

I have an existing table in an Access DB that I want my user to be able to copy by pressing a button. When the user presses the button, they should be prompted for what is to be the name of the table. The program should then copy the existing …

I was doing my login access with ms access database (accdb), supposed can work but after i upgrade to java 8, it no longer able to support odbc and i was struggled to solve this problem, and it gave me the ClassNotFoundException list of library i have in my netbean …

HEY GUYS, i need your knowledge thanks! Super newbie here 1. How to specify database path on deployment, when installing the app to a different machine without encountering error. In this case i have MS access as database 3.How to reflect changes on the database to other machines

I'm looking for an alternative to MS Access but don't want to download an entire package e.g. OpenOffice or LibreOffice. Is it possible to do a custom install of either for just Base and not the other pieces?

Visual Basic 2010 and Microsoft Access 2013 I have a product table in MS with fields : fld_id,fld_name,fld_img,fld_price,fld_type fld_img i set it as attachment and of course attached the corresponding image to it - is this wrong? this is my code to get the data into the datagridview. my form …

hey guys i am trying to create a library management system which is supposed to be used to store/keep infp for the library and the library members( book title, author, name and picture for borrower and other stuffs). The app has 6 buttons, delete, save, add,previsous,next, and upload( for upload …

It is a software Development and it's need me a access ,c++ java, programming,database i need me and you

I have a database that I use in VB. As records update there is a lot of useless info in there because access doesn't reuse the same spots. So that information has to be removed. Before I would use compact & repair and access 2000 and it would correct this. …

My client is wanting a 'simple' stock update system in MS Access. I have a form and subform (which is a packing slip) where the user will select the style of shoe eg ASHE_Choc and then enter the number of stock wanted for each size eg 5 for size 6_40. …

While I can't pretend to know what happened to block me from Daniweb, imagine less imaginitive souls. Maybe an article is required about what to do with post or login troubles?

I need to develop aa database to store stock taking information and sales. I was going to use MS Access to strructure and make all the logistics for my database since im quite friendly with access and i find it easy to use. MY problem is, i want this database …

Hello fellow Daniwebians, it's been a bit of time since my last login here. I tried to reply to a post and was confronted with a new login method (dazah.com??). I'm used to only logging in with my username and password via Daniweb directly. What do I have to do …

Hi Dear could you please help for below issue Description: Previously our client is using ms office 2007 now client want to upgrade office to ms office 2013 we have VB5 application with access database (previouly it was .mdb and now it is converted to .accdb) so for that purpose …

This is CimmerianX. Why the move away from ID/PW and over to another 3rd party? Why the need for Dazah at all? Sorry guys, but I won't use Dazah. Good Luck in your future endeavors.

Good morning, I have 2 client applications which do the same thing. The first app which is written in VBA(MS ACCESS) and the other is ASP.Net. We can have multiple items for a client so we use a transaction id. When the access application starts a new transaction the app …

Can anyone please tell me how do I get the total row in my ms access table and put in my label.text at vb.net?

so i have a combox that will tell you that which data will appear like "name", "contacts","website","email" and data will appear in gridview but i want to filter the data in gridview example in name if you type a all data starting with a will appear and everything starts with …

Hello everyone has been a while since i made a question here i have a real problem with a web app that i been doing recently the problem is related with the datetime format when i make transfer data from the webapp to a database in access, the field in …