• Microsoft Access 2013 Search Box

    I created a search text box that is on a form off a navigation form. The problem I am having is that I get a box saying "Enter Parameter Value" Forms!2frmHomeOwnerMain!txtSearch. It works fine when I bring up the form by its self, but when it is in the navigation form it does not. I believe I need...

    fubr69z15 pointsBadges:
  • Filtering a Record Selector (Microsoft Access)

    I need help figuring out how to filter a combobox that serves as a record selector. I set up a box that provides clients name & need it to filter them by agents assigned to each customer once the filter is set but, i cant get it to filter out customers under other agents. I would prefer a...

    mmorrison35 pointsBadges:
  • Using LIMIT query in Microsoft Access 2007 database

    For Microsoft Access 2007 - I have created several queries in my database. But for some reason, it's giving me an error when I use LIMIT in my query. How can I correctly using LIMIT in my queries?

    ITKE413,485 pointsBadges:
  • Getting field names of Microsoft Access database table

    Would it be possible for me to get the field names of my Microsoft Access database table? Is there a SQL query I can use? Thank you.

    ITKE413,485 pointsBadges:
  • List Microsoft Access database tables using SQL

    Would there possibly be a way to list all of my tables in a Microsoft Access database using SQL? I know how to do it in SQL Server but not sure of the command in Access. Thanks!

    ITKE413,485 pointsBadges:
  • Compact Microsoft Access database in VBA

    My apologizes for the brief question but, in Microsoft Access, can I compact my current database using VBA? Thanks!

    ITKE413,485 pointsBadges:
  • MS Access 2007: 15 years of contract

    Hello, I'm a student in an intern program right now. My organization give me a MS Access file that contain information of contract workers. They asked me to separate which of the workers that almost work for 15 years and make a reminder for user 6 months before due date. My department scope is...

    Vencro25 pointsBadges:
  • How to get list of tables in Microsoft Access database through C#

    I just opened a connection to a Microsoft Access file through C# but would there be a way for me to retrieve a list of tables that exist in the Access database? I appreciate the help.

    ITKE413,485 pointsBadges:
  • Creating Microsoft Access database in C#

    We have to create a Microsoft Access database using C#. What's the process to do that? Is there an API that we can use for the creation? Thanks.

    ITKE413,485 pointsBadges:
  • Macro in Microsoft Access

    What is a macro in Microsoft Access?

    ajmeeljujju5 pointsBadges:
  • MS Access Query: Plan Summary

    I am trying to update a query that I have currently. I have a field named "Plan" and I have another field that is not in the query yet named "Plan Summary". I would like the query to show me the "Plan Summary", but when the "Plan Summary" is blank I would like it to show the value in "Plan". Is...

    queryquestioner30 pointsBadges:
  • Best way to run a program in Microsoft Excel or Access

    Good day, I would like to find out what is the best way to run a 'program' in Microsoft Excel or Access (at the moment, I am used to Excel only but I'm willing to learn about Access if that's what it takes) that will allow me to type in one or two letters and it produces a word in the particular...

    asphaltanimal5 pointsBadges:
  • Commenting on Microsoft Access query

    Apologize for the short question but how can I comment through on a Microsoft Access query? Is it through Syntax or another way?

    ITKE413,485 pointsBadges:
  • Back end cloud solution for Microsoft Access

    For the past 5 years, our organization has used Access for its database. Now, we're look to keep the same database on the front end but switch to a cloud solution on the back end. We don't want Office 365 (too costly) / SharePoint so what's the best option for us? MySQL perhaps? Furthermore - we...

    ITKE413,485 pointsBadges:
  • Access Microsoft Access database using Python

    Would I be able to access my Access database using Python? If not, how about SQL? I'm looking for something within Linux but for a final option, Windows too. Appreciate the help.

    ITKE413,485 pointsBadges:
  • Uninstall Microsoft Access runtime through command line

    I know this is pretty old but we have Microsoft Access 2007 and that uses runtime. I'm in the process of upgrading several users to 2010 runtime but it's difficult since they are all located in different areas. Can I uninstall runtime through the command line? Thanks!

    ITKE413,485 pointsBadges:
  • Can I add file browser to Microsoft Access form?

    Can I add a 'browse' button to my Access 2007 from so that it brings up the file browser, followed by allowing the user to select the perspective directory? Also - when the user exits out of the browser, I need the path to be written to a text box in the Access form too. Thanks for the help.

    ITKE413,485 pointsBadges:
  • Corruption in Access 2010 databases?

    Hello - is anybody seeing frequent corruption problems in Access 2010? I work with 2 other developers, and we are seeing: tables losing indexes losing ALL the code modules (form & global) in accdb losing the accdb itself (not in the Recycle Bin, not in our user drives; just gone) That third one...

    wilfridsoyer5 pointsBadges:
  • How to structure a Microsoft Access combobox with four columns, two columns from one table and the other two columns from another table

    Sir, I have two tables: Quartier and street. I want a combobox that displays Quartier ID, quartier name, street ID and street name.

    beltibrightGods4lif5 pointsBadges:
  • VB.NET with MS access data type dismatch

    provider = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" datafile = "D:\weighment\weighment.accdb" connstring = provider & datafile myConnection.ConnectionString = connstring myConnection.Open() Dim str As String str = "Insert into WeighingData...

    aishjack45710 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following