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

    ITKE983,410 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!

    ITKE983,410 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!

    ITKE983,410 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.

    ITKE983,410 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.

    ITKE983,410 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?

    ITKE983,410 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...

    ITKE983,410 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.

    ITKE983,410 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!

    ITKE983,410 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.

    ITKE983,410 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:
  • Microsoft Access query: Pull records from later date

    I have 3 fields in a query. (A) is a date. (B) is a date calculated to be 2 business days after (A). (C) is another date. How do I make a query to pull all records where (C) is later than (B). I can't seem to figure it out because of the calculated field.

    jakebbb825 pointsBadges:
  • Network Connection Freezes

    For some reason, at random, among 20 PCs on my network, in the morning or during the day, the network connection stops responding for both intranet and internet communications. The only solution thus far is to remove the NIC from the Device Manager, reboot the PC, and let Windows XP Pro find the...

    DboiSOBE0 pointsBadges:
  • How to get a constant value at specified potion

    Select count(*) asĀ  Ltotal from tblLeaveRequest where ApplyingDate Between '2016-03-01' and '2016-03-05' group by ApplyingDate.

    nadini40 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