Click here to Skip to main content

Submit your article

Microsoft Access

MS-Access

Great Reads

Exploring Computational Number Theory (Part 1)

by William Hey

Classical number theories

Dynamically Add Access Database Columns at Runtime using VB.NET

by Rob Culhane

How to dynamically add access database columns at runtime using VB.NET

Semi-Prime Ordered Sequences (Part 2)

by William Hey

Semi-Prime Ordered Sequences (Part 2) is the follow-on to “Exploring Computational Number Theory (Part 1)” and describes a process for ordering the semi-prime base sequences.

Selecting and Importing Excel File and Sheet for import into Access

by Clifford Nelson

This is a tip that has the code for selecting an Excel file and sheet for import into Microsoft Access. This includes the code required to browse for a file, and populate a ListBox with the sheets of the Excel Workbook, and the code to import an Excel spreadsheet.

Latest Articles

Azure Active Directory Authentication with OpenID Connect and Authorization with App Roles

by DotNetLead.com

Azure AD for authentication and authorization of users for your website

Indian Number Formatting of Currency in Microsoft Access and Excel

by Gustav Brock

Format amounts in VBA using the Indian number format for currency and amounts

Migrating Legacy Microsoft Access Database to Excel (or any other database) - Complete Application and Code

by rohitsies

Helps migrate your Microsoft Access database to Excel

Method to Change Source of a Form’s Subform Source to a Query or Table in Microsoft Access

by Clifford Nelson

Method to change source of a Form’s Subform source to a Query or Table in Microsoft Access

All Articles

Microsoft Access

" Is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. What is wrong?

28 Mar 2016 by Member 12421205

Hi! I'm getting the following error with access. From what I could tell with the other formulas in the query, this should work. " is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. What is wrong?I used the template...

" Is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. What is wrong?

28 Mar 2016 by CHill60

"is not a valid name" means that your column name is invalid, not the data you are trying to put into it.Spaces are not valid in column names unless you surround them with square brackets i.e. [User Name]Better would be to avoid spaces altogether e.g. UserName

" Is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. What is wrong?

28 Mar 2016 by Member 12421205

Solution Found. Formula should equal: Left([staff.FirstName],20)& (".")&Left([staff.LastName],20)&("@valleycentralschools.org")I just had incorrect brackets. Thanks for all who looked.

" PDFLibNet.dll " The process cannot access the file

12 Jun 2012 by sigma_ivan

hi everyonei would like some help with the application that we developed.this is for our office use only, and what our app is doing is extracting the text from the pdf file using pdflibnet.dllbut we lately encountered a problem with a particular pdf file.the problem is when we try to...

"How to make the DataGridView output only the data that I want?

30 Oct 2014 by Member 11194404

Db: accessim using Visual studio 2010what syntax to use for making the datagridview output only the data that is in the database only using for example Birthdate = date today not the year..im making this bday reminder program, just a simply day to day reminder who will be having a...

"How to make the DataGridView output only the data that I want?

30 Oct 2014 by Robert Welliever

I'm not sure I have the syntax correct as I don't want to open Access and find out, but the idea is that you use the DatePart function in Access. You can compare parts of dates with it. Try something like:SELECT * FROM BIRTHDAY_TABLEWHERE DatePart ("m", [BDAY_FIELD]) =...

"How to make the DataGridView output only the data that I want?

30 Oct 2014 by Member 11194404

kinda confused on this part.. =/If Not con.State = ConnectionState.Open Then con.Open() End If Dim da As OleDb.OleDbDataAdapter Dim Sql As String Sql = "SELECT * FROM bene_records where b_date" ''

"No value given for one or more required parameters."

1 Jun 2013 by sahrarainmelody

hi I have a dataGrid that I should insert its columns values to an access database ...but I have problem with " command.ExecuteNonQuery();"my project is not finished just for this error ... please help if you can . it's my code : for (int i = 0; i

"No value given for one or more required parameters."

1 Jun 2013 by OriginalGriff

Do not concatenate strings to build a SQL command. It leaves you wide open to accidental or deliberate SQL Injection attack which can destroy your entire database. Use Parametrized queries instead, and your problem will probably disappear at the same time.

"Standard ACE DB" "Microsoft bas cryptograghic provider" in first line of file, how to open it?

2 Sep 2012 by umar.techBOY

can we break the encryption, all i found by google and experiments is:The first line of a file (78MB 8n size) (database of a free religious books software) contains these strings "Standard ACE DB" "M i c r o s o f t b a s e c r y p t o g r a g h i c p r o v i d e r" (reading in c#,...

"system.security.permissions.h...

19 Dec 2013 by agent_kruger

i have developed an application and it is running fine. But when i uploded the software to one of my client machine it gives the following error.system.security.permissions.hostprotectionattribute from assembly mscorlib.I Am using c# windows application and database is access.Note: On...

"system.security.permissions.h...

19 Dec 2013 by Dave Kreskowiak

Are they running the .EXE from a network share?

"system.security.permissions.h...

21 May 2014 by agent_kruger

Solved it :- as anti-virus software and firewall were not granting me permission.

'Cannot perform 'like' operation on system.single and system.string.'

11 Aug 2020 by Member 14898617

i am building a win form app using access database as data-source , and in the search button of my winform i have this code" private void searchAccessDatabase() { if (string.IsNullOrEmpty(KeywordTextBox.Text.Trim())) ...

'Cannot perform 'like' operation on system.single and system.string.'

11 Aug 2020 by Sandeep Mewara

Think, this should not be in single quotes: 'System.String' Further, can you make sure the strFilter looks like as expected? Surely following corrections: 1. Is it not missing spaces between all the OR conditions? 2. Missing OR in line: ...

'Microsoft.ACE.OLEDB.12.0' not registered on local machine ERROR

22 May 2010 by sporrow

private void ekle_Click(object sender, EventArgs e) { string kaynak = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=gunluk2.accdb"; ; OleDbConnection baglanti = new OleDbConnection(kaynak); baglanti.Open();//error is here string...

'Microsoft.ACE.OLEDB.12.0' not registered on local machine ERROR

23 May 2010 by Estys

The message is clear.Does this[^] help?Cheers

'Microsoft.ace.oledb.12.0' provider is not registered on the local machine ONLY in VS 2010

10 Nov 2017 by Member 12117439

'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. I am getting this in visual studio only after upgrading from 32bit office 2013 to 64bit office 16. I have already installed the 64bit database engine and my published project from IIS is working with the existing access...

'Syntax error in from clause.' VB.NET - access

8 Jun 2018 by Member 13864666

At first, when it showed this error i did put [*FROM] before the From statement e.g: ["Delete student_id *FROM student] Still it doesn't work Can someone pls help me on this What I have tried: Private Sub btndelete_Click_1(sender As Object, e As EventArgs) Handles btndelete.Click ...

'Syntax error in from clause.' VB.NET - access

9 Jun 2018 by Richard Deeming

As the error says, your DELETE syntax is incorrect. Your code is also vulnerable to SQL Injection[^]. NEVER use string concatenation to build a SQL query. ALWAYS use a parameterized query. And you probably want to ask the user whether or not they want to delete the record BEFORE you actually...

'Syntax error in from clause.' VB.NET - access

8 Jun 2018 by phil.o

Never, ever, construct an SQL query like you do by concatenating string obtained from user inputs. This leaves your code wide open to SQL injection attacks. Better use parameterized queries instead. This subject is discussed daily here on CP so you will not have a hard time finding some more...

'Syntax error in from clause.' VB.NET - access

8 Jun 2018 by Maciej Los

As far as i know, MS Access does not support DELETE + JOIN. You have to change your sql command to below form: DELETE Table1.* FROM Table1 WHERE EXISTS( Select 1 From Table2 Where Table2.Name = Table1.Name ) But, when i did look on you query again, i think you need only: DELETE FROM student...

.aspx Page is not display after live my website

7 Feb 2011 by vijay.darji2

I was live my website about a few day ago. It was developed in ASP.Net, C#, and Ms access 2003, SQL server 2005 is used as a database. HTML page is display well, but when we open .aspx page it will not display and giving error. Please somebody help me to sort out this problem

SQL-Server-2005

.aspx Page is not display after live my website

7 Feb 2011 by Parwej Ahamad

Check with your provider, is he providing .Net framework support?

SQL-Server-2005

.aspx Page is not display after live my website

7 Feb 2011 by velmahesh

Check the Code based on Error Message..

SQL-Server-2005

4 Access Tables - How to have a Select Query with Left Join ?

9 Aug 2014 by Paramu1973

Hi, Iam using vs2010, Access 2010. I have Access DataBase with 4 Tables. I wish to have a select query from all other tables as required...Is it possible?Thanks For The HelpsMy Query :-===========Select iv.*,pt.pty_name,cm.commodity,it.itm_description,cy.company_name from (invoicetbl...

4 Access Tables - How to have a Select Query with Left Join ?

9 Aug 2014 by OriginalGriff

Remove the brackets.Select iv.*,pt.pty_name,cm.commodity,it.itm_description,cy.company_name from invoicetbl iv left join partytbl pt on iv.pty_code=pt.pty_code left join commodity cm on iv.commodity_id=cm.commodity_id left join itemtbl it on iv.itm_code=it.itm_code left join companytbl cy on ...

64 bit microsoft professional plus and activex tree view control

3 Jul 2015 by oula alsheikh

i want to use Microsoft tree view control so i had to add mscomctrl.ocxto my project as a reference and because iam working on windows 7 64 bit and the mscomctrl.ocx has 32 bit controls i registered it in the command promptmy problem is even though i add this ocx as reference and i can...

7010 computer project

17 Mar 2013 by Member 9918061

i'm doing a project on a primary school's financial system. the software is complete. the analysis is done. could someone please tell me how i'm supposed to submit the complete documentation at my school by tomorrow? monday the 18th of march is the last date

7010 computer project

17 Mar 2013 by Sandeep Mewara

could someone please tell me how i'm supposed to submit the complete documentation by tomorrow?Submit to whom?monday is the last date For what?We have no idea whatsoever what you are talking of. If you have done a project based on some deadline for someone, please contact that...

940916 - Access Denied error accessing BitLocker encrypted fixed drive

7 Dec 2015 by ilostmyid2

BitLocker was turned on on my previous Windows 7. It was working properly until I had to change my Windows 7 and reinstall it on another drive, this time SSD instead of HDD. After installing Windows 7, I got "Access Denied" error message when i went to unlock the drive. The password was correct...

940916 - Access Denied error accessing BitLocker encrypted fixed drive

7 Dec 2015 by ilostmyid2

it was a security issue, not a bitlocker issue.

951015 - how to connect to access database via C#?

3 Jan 2017 by ilostmyid2

I create an access database file by using Microsoft Access 2007. I use Visual Studio 2010 to write a program which need a database. I want to use the file as the database. I think this is the simplest way to write a rapid program to hold some data and manage them. Am I right?Then, in the...

951015 - how to connect to access database via C#?

3 Jan 2017 by Wendelius

I wouldn't think happened because a user isn't defined. As far as I know 0x8000FFFF is a catastrophic failure so for some reason the connection cannot be established.I would check if the OleDb provider is correctly installed and can you connect to the database from the code using...

951015 - how to connect to access database via C#?

4 Jan 2017 by #realJSOP

I provided a class in my solution to this answer: How do I run access from a WS 2012 and IIS 8 with ASP.NET[^]

951015 - how to connect to access database via C#?

3 Jan 2017 by OriginalGriff

There are quite a few reasons why that may be a problem.Start with the obvious: is the file available to all users? It's quite possible that the Connection Wizard isn't using your user ID to access the file, so if the file or teh folder it's sitting in doesn't have the required access...

[ACCESS] how can I insert a global variable within a field?

3 Jan 2019 by Atipos

Hello first of all I explain what I have in my hands. Two masks, in mask A, there is the "user" field and other fields (what interests me is "user"). While in Mask B it would be the login, with username and password. When I enter a User in Mask A, I automatically open the Login Form with which...

[ACCESS] how can I insert a global variable within a field?

3 Jan 2019 by Gustav Brock

I have no idea what your Mask A and Mask B could be, and the explanation is very confusing. The title, however, is clear, and the answer is simple. In the form, where you have that field bound to a control (textbox), assign the global to the Value property in, say, the OnOpen event of the...

[C#] How will I insert an image to MS Access Database?

28 Nov 2015 by Jeff Garcia Samson

Hi everyone, how will I insert an image to MS Access database after I converted the image into byte[]?I used this code to convert the image into byte[] public byte[] imageToByteArray(Image imageIn) { MemoryStream ms = new MemoryStream(); ...

[C#] How will I insert an image to MS Access Database?

28 Nov 2015 by ridoy

Like this one:var pic = File.ReadAllBytes(yourFileName);OleDbCommand cmd = new OleDbCommand();cmd.CommandType = CommandType.Text;cmd.CommandText = "insert into Table1 (id, picture) values (@p1, @p2)";cmd.Parameters.AddWithValue("@p1", TextBox1.Text);cmd.Parameters.AddWithValue("@p2",...

[C#] How will I insert an image to MS Access Database?

28 Nov 2015 by Krunal Rohit

public static void AddEmployee( string lastName, string firstName, string title, DateTime hireDate, int reportsTo, string photoFilePath, string connectionString){ byte[] photo = GetPhoto(photoFilePath); OleDbCommand command = new OleDbCommand( "INSERT...

[Frequent Non Question]How to call queries of access in vb.net

12 Sep 2013 by DAVID DUSHIMIMANA

Hello Guys,I would like someone to help know how I can call query of access database into visual studio 2010 express( vb.net) using data-bound controls, I need codes to use because I tried like others tables it did not work out. Here are the codes I used to update, or just to save data in...

[help] Correct syntax for the WHERE by date

30 Oct 2014 by Member 11194404

This is the part that I dont know the syntaxI want that my form automatically loads the data from the Databaseby using the b_date but only display the records if there is a match in month and datenot using the year, The program is like a Birthday ReminderPrivate Sub...

[help] Correct syntax for the WHERE by date

30 Oct 2014 by OriginalGriff

Try:SELECT * FROM bene_records WHERE DATEPART(mm, GETDATE()) = DATEPART(mm, dateColumn) AND DATEPART(dd, GETDATE()) = DATEPART(dd, dateColumn)

[help] Correct syntax for the WHERE by date

30 Oct 2014 by Maciej Los

Please, read my comment to the solution 1I'd suggest query like this:PARAMETERS [mnth] INT;SELECT FROM bene_recordsWHERE b_date BETWEEN #DateSerial(Year(Date()), [mnth], 1)# AND #DateSerial(Year(Date()), [mnth]+1, 1-1)# Above query should return data for given month...

[Repost] SQL SERVER EXPRESS EDITION & MS ACCESS 2007

2 Apr 2010 by Ramana Nori

I've written a small MS Access 2007 program having links with the tables of SQL Server 2005 Express Edition. The problem is it worked out in development environment. But it's giving error during production environment.SQL State '08004'Sql Server Error: '4060'Server rejected the...

[Repost] SQL SERVER EXPRESS EDITION & MS ACCESS 2007

3 Apr 2010 by Luc Pattyn

This[^] might apply. If not, look here[^].:)

[Solved] Dateformat while querying the MS Access Data

19 Apr 2011 by RDBurmon

Hello All ,I have one issue regarding the MS access query.I am using MS Access 2007 and Created the DB and tables.The tables having the date column. Better say below is the table definition and data.Id , Member , CollectionDate1 ABC 12/01/20102 DEF ...

[Solved] Listbox using rowsource generated by querydef

18 May 2011 by ChristinaVelez

Hi, I have an Access 2007 form containing an option frame with 5 search options, and a search button. The button generates a querydef for "qrySearch" based on search option,and results are to appear in a listbox on the same form.When I click search the first time, results appear in the...

[Solved] Listbox using rowsource generated by querydef

18 May 2011 by ChristinaVelez

Clearing the textbox is the solution:at the top of the Sub I added:Me.lstBxResult.RowSource = ""then at the end of each option:Me.lstBxResult.RowSourceType = "table/query"Me.lstBxResult.RowSource = "qrySearch"Me.lstBxResult.Requeryand removed the Docmd.OpenQuery since it...

[Solved]Accessing MS Access database from C#

24 Dec 2010 by abi1988

I want to use MS Access as database for my C# windows form application.I have used OleDb driver for connecting MS Access. I am able to select the records from the MS Access using OleDbConnection and ExecuteReader.But I am unable to insert,update and delete records. My code is as...

[Solved]Accessing MS Access database from C#

24 Dec 2010 by Hiren solanki

OleDbCommand com = new OleDbCommand("INSERT INTO DPMaster(DPID,DPName,ClientID,ClientName) VALUES('53','we','41','aw')", con);I am not finding anything that causing error, But the exactly error statement can clarify the thing further, So please post it here.The way you're using insert...

[Solved]Accessing MS Access database from C#

24 Dec 2010 by abi1988

I got solution for this problem.I was keeping the database inside the project(solution) itself.But when I kept the database out of the project as per one's suggestion, the above code works fine. I don't know what is the relation for this problem with the location of the database file.But...

[VB.net/MS Access] Database not updating after removing row.

9 Mar 2011 by RadethDart

Alright, I am having the hardest time figuring this out. I have done research on fixing this for a couple days and I am stuck. It is time to ask for help.In my project I am trying to delete a row out of the database and I read how to do that from many different sources telling me to use Ole...

[VB.net/MS Access] Database not updating after removing row.

10 Mar 2011 by Dave Kreskowiak

I suggest reading the documentation on AcceptChanges and Update. Update writes the dirty records in the DataSet/DataTable back to the database. AcceptChanges tells the DataSet/DataTable that the changes that were made are now the current state of the records. The two operations are completely...

A ease way for my code.

16 Oct 2012 by Aciobanita Costel

I have the following code:private void verificareData() { int regCasa_id; Program.Connection.CommandText = "SELECT regCasa.regCasa_id, regCasa.regCasa_date, regCasa.regCasa_soldinitial, regCasa.regCasa_soldfinal FROM regCasa WHERE regCasa.regCasa_id=(select...

A ease way for my code.

16 Oct 2012 by Anele Ngqandu

Hehe...HiWell since you have this long code and we just don't have time to read it, I suggest you split your code and use the 3-tier Architecture [^]...your code will be much clean and better.

A problem In MS Access , Please Get a Solution for this problem.

12 Apr 2011 by Fadi-1

the expression On Open you entered as the event property setting produced the following error A problem occurred while Stock & Accounting program Ver 1.1 was communicating with the OLE Server Or ActiveX Control

A problem In MS Access , Please Get a Solution for this problem.

12 Apr 2011 by Richard MacCutchan

This looks like a message that should be directed to some individual. If it is as a result of an article then please post in the forum at the end of the article.

a small program (ASP with C#)

9 Jul 2011 by zhonos

hi. can you help me my brother?i have an access database. with these fields for each record: id, name, age, sex.for example my database file has these records:1 ehsan, 23, male2 mohamad, 50, male3 ghazal, 25, femalei want to show the names in a list like this:• ehsan• mohamad•...

a small program (ASP with C#)

9 Jul 2011 by Monjurul Habib

You will get help from here & this is smart approach(Popup Instead Of New Page). Or you can try using same page this is also good, but using another page and a back link/button is not a good one.:) Enjoy.

a small program (ASP with C#)

9 Jul 2011 by thatraja

You may use Gridview control with Detailsview or Formview. Looks like you didn't try with right keywords in search engines. I found this in CP. GridView-DetailsView (Master/Detail) Control[^]

A sudden slow-down for access 2016 VBA application

5 Nov 2020 by Forogar

We are getting an unexpected (massive) slow-down in an Access 2016 VBA application over Citrix. No code changes, possible anti-virus update, possible Windows update, possible Citrix and Security updates. Perhaps the number of records has...

A sudden slow-down for access 2016 VBA application

5 Nov 2020 by Dave Kreskowiak

Everything you listed is a possible cause, and then some. There is no way anyone is going to be able to tell you, "this is what's doing it". You're going to have to investigate all of these possibilities yourself. After checking the size of the...

about sql and vb questions

7 Sep 2015 by Pramod Kharvi

Hi am trying to do simple bank software. Using front end as VB and back end as ms access. I have 2 table namely "newacount" and "deposit". A newacount contain a fields like accholdername,accnum,ledgeramount, and deposit table contains field accnum and depoamount. Now my question is if I deposit...

about sql and vb questions

7 Sep 2015 by Leo Chapiro

Try this in "After Insert Event Procedure" of the "deposit" table:UPDATE newacount AS n SET n.ledgeramount = d.depoamountINNER JOIN deposit AS dON n.accnum = d.accnumAnother one possibility:UPDATE newacount SET ledgeramount = d.depoamountFROM ( SELECT...

Acces to a Remote Queue

20 May 2010 by Ben.Regaya.Hedi

Hi All,is it possible to send a message to a Queue from a client Machine to the a server machine that contain the Queue?Thanks for Help

Access - Missing queries when I view a copied mdb file.

27 Sep 2011 by Central_IT

Hi,I wonder if anyone has come across this problem.I have an Access database and added new queries to this database. I then make a copy of this database but when I view the copied database, my new queries are not there. I go back into the original database and the queries are there.I...

Access - Missing queries when I view a copied mdb file.

21 Jul 2012 by OriginalGriff

Best guess? Your database is not where you think it is.If you have added the DB to your project, then it it quite likely that you have copied the source file, but VS is working from a copy of this in the Bin/Debug folder.

access 2000 bible missing CD

30 Jul 2010 by Yusuf

That is an old book, don't know if it is still printing, may be it is out-of-print. Try Amazon's used book section. We luck you may find a copy of the book with working CD. The price might be about $1-$5 in the used book section

Access 2003 autonumber Define My Own Kindly Guide ,

23 Mar 2011 by Muhammad Aamir SumSum

My Qustion..Table NameJ_voucherFields are:Voucher Number, Date , Narration , Debit , CreditAutonumber on Voucher Number:I want Autonumber Like That JV-TodayDate-000AutoNumber

Access 2003 autonumber Define My Own Kindly Guide ,

23 Mar 2011 by OriginalGriff

Access provides autonumber: it is called an "autoNumber" field, surprise, surprise. Also unsurprisingly, it is numeric only...I would keep the Voucher code separate: The Voucher number is the Autonumber field, the Date field is the TodayDate, and build the voucher code from that using...

Access 2007 query that choose all values when no input

20 Nov 2013 by Domus1919

I've write this query in an access 2007 database:SELECT Ordini.ID, Ordini.Data, Clienti.Cognome, Clienti.Nome, DettagliOrdine.IDProdotto, Prodotti.Descrizione, Prodotti.Prezzo, DettagliOrdine.Quantità, ([Prezzo]*[Quantità]) AS Totale, Ordini.Note, Produttori.Nome, Ordini.Ordinato,...

Access 2007 query that choose all values when no input

20 Nov 2013 by Maciej Los

There are 2 options:1) building queries "On the Fly" using userform and VBA[^] or2) using IIF function[^] with declaration of PARAMETERS[^]PARAMETERS param1 CHAR, param2 CHAR;SELECT ...FROM ...WHERE Field1 = IIF([param1] IS NULL,'*',[param1]) AND Field2 = IIF([param2] IS NULL, '*',...

Access 2007: excel object library

24 Jan 2011 by maccaro

Hii'm developing a VBA application in Access 2007. To run the project, I have to include the "excel 12.0 object library" by selecting it in the "add reference" dialog. The problem is that if i go to the add reference menu, i can't find any library. The dialog is empty. where can i find the...

Access 2007: excel object library

24 Jan 2011 by maccaro

There are no tabs in the dialog...

Access 2007: excel object library

24 Jan 2011 by gammagtmw

Is the "COM" tab really empty? Seems unlikely to me.Open the "Add Reference" dialog, switch to the "COM" tab and scroll down to "Microsoft Excel 10.0 Object Library".

Access 2007: excel object library

24 Jan 2011 by maccaro

Thanks to all!Solved by using the menu in the VBA window instead of the Access one.

Access 2010 - Search a form programmatically

5 Mar 2012 by arpoarpo

Suppose we have an Access 2010 form that allows a user to navigate over every single employee in the table Employees.Suppose also the form contains a TextBox txtId where the user can type the Id that uniquely identifies an employee. After clicking a button OK the form should show the...

Access 2010 - Search a form programmatically

5 Mar 2012 by Clifford Nelson

An Access form has a Filter and an FilterON property. Just need to set the FilterOn to True and the Filter property to the text as would appear in a SQL Where clause (ie, Company LIKE "C*").Me.Filter = "Company LIKE """ + CompanyFilter.Text + """"Me.FilterOn = TrueThis should also work...

Access 2010 Active X interopControl There is no control in this object error

23 Aug 2012 by Belial09

Hi,I have developed an VB.NET InteropUserControl which works properly on my pc.The InteropUserControl is used in a form in an Access 2010 MDA File. If i deploy it as an MDE File to another pc, the Form won’t open with the errormessage "There is no control in this object". The Control...

Access 2010 AllowAutoCorrect OFF for entire form or mdb

17 Sep 2014 by avianrand

I maintain an Access app for a client who had it written over 15 years ago. We've upgraded it over the years and now it's running under Access 2010. One of the users today showed me a combo box that has been giving them problems. I checked it out and realized that it was auto-correcting anything...

Access 2010 AllowAutoCorrect OFF for entire form or mdb

17 Sep 2014 by Sergey Alexandrovich Kryukov

If even you, who probably could look at the full source code, cannot tell "why the heck would anyone want that in an Access app", how can people who cannot see this code guess why one wanted it?I understand that you badly need some resolution, but could you be a bit more realistic. Can you...

Access 2010 AllowAutoCorrect OFF for entire form or mdb

17 Sep 2014 by avianrand

First and foremost.... NOT "TRACK NAME AUTOCORRECT." I'm very familiar with that "bug". MS fixed it in Access 2003 and turned it OFF by default. You apparently didn't read my OP carefully. If you had, you'd know why I didn't post any code. The code has zero, zippo, nada, nothing to do with this...

Access 2010 setting unbound object frame to Excel graph programatically

16 Jun 2014 by avianrand

This worked in earlier versions. But my client has moved to Access 2010 and Windows 7 recently. I'm creating a bar graph in an Excel file. Then I'm setting the source doc of an unbound object frame to that Excel file. This has worked perfectly for years and years and years. But it's not...

Access 2010 setting unbound object frame to Excel graph programatically

18 Jun 2014 by avianrand

Never mind on this issue. I bailed on it completely. I decided to use the chart object in a subreport. I wrote my own code to create the histogram data. It is working better, faster and more accurately than the Excel calls were before.

Access 2013 - error when quitting

19 Apr 2015 by RogerPar

My OS is win 7 prof 64 bit and I use Access 2013.I have a small and simple password creating App which has one main Form. it selects from the User's input, how the password is to be created, like 2 UC chars + 2 LC chars, numerics, and special characters, and then when a command button is...

Access 2013 - error when quitting

19 Apr 2015 by OriginalGriff

If you get an error message you don't understand, the first thing to do is Google it:...

Access 2013 - error when quitting

21 Apr 2015 by PerryMrk

Here already the similar question was discussed: http://www.ask.com/answers/639305081/hi-i-have-a-corrupt-database-and-i-m-trying-to-salvage-my-data-any-ideas-i-have-tried-exporting-the-data-to-another-database?qsrc=14106

Access 97 Frontend - SQL Server 2005 Backend Linked Table Error

2 Apr 2015 by JammoD87

Hi,I have a legacy Access 97 Frontend application which utilises a SQL Server 2005 backend over a SQL Server ODBC Driver (Connection), we use the Linked Table feature on this setup.I create, amend and link in tables on a daily basis and I am aware of the conversions that occur between...

access a different system using its ip and log in credentials using VB.net

12 Dec 2012 by Pyakaa

i want to access the hard disk drive of another system, whose ip and log in credentials are know to me, copy a file and send it as an attachment to my program (running in a different system...)the above has to be done using program(i.e no manual intervention)Plz let me know how to do it..

access a different system using its ip and log in credentials using VB.net

12 Dec 2012 by Sampath Kumar Sathiya

Hi,Please rerer the following link,Access remote PC's share file by UNC path with username/password[^]

access a different system using its ip and log in credentials using VB.net

15 Apr 2013 by Pyakaa

i found the answer to it, as the in-build function impersonate().this will solve the purpose

access a list from another class

29 Apr 2011 by Member 7838027

hi, please help me with this one.i have a list in one class and i want to access that list from another class to add another value to that list.namespace ReportsUIScreens{ public partial class Screen_2 : UserControl { public Screen_2() { ` ...

access a list from another class

30 Apr 2011 by DrNimnull

Hi,you must declare the List as a property. To access the list from an other class you must give an instance from your List to the other class.The classes where you must give an instance from your List to access it://FilterHistory.xaml.csnamespace ReportsUIScreens{ public...

access a list from another class

29 Apr 2011 by Deepthi Aravind

Hi,, Declare a property with type "List"for eg:public List List{get;set;}u can assign values into this property and access this list property from another class...

access addin to open db in read-only mode

4 Mar 2010 by ninadcsl

I am new to addin development. I have to develop an addin for MS Access that will allow the user to open any database strictly in readonly modeIf not all can we at least make a single database readonly. Hardcode the name and path of the database if required.The DB will be readonly in access...

access addin to open db in read-only mode

5 Mar 2010 by DaveAuld

Any database file opened by Access will be read/write unless you use some form of authentication.You could use NTFS security permission on a folder or you could use Database Level security.If you have a mdb file sat on a server, there is nothing stopping someone else opening it with...

21 Apr 2010 by Amean

Hi there,I have a database in access and it contains 10 tables.I have managed to get a selected table to disply on a webpage using Visual Studio, the Access data source, and the Grid view.in the grid view I have selected one out of the many tables I have. This displays without a...

22 Apr 2010 by Tony Richards

My suggestion, based on what I've seen to work:Have a 'chain' of combo or list boxes. Leave only the first one enabled, and get the user to select an item. Make this cause a post-back or an AJAX call (I personally think AJAX is better as it's less 'jarring') and update the next in the chain...