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

    ITKE440,495 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...

    ITKE440,495 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.

    ITKE440,495 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!

    ITKE440,495 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.

    ITKE440,495 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:
  • Adding Serial Number to an already existing access document

    Hi , I want to add a row of serial number for the existing records in MS access .Whenever I am trying to define a new row with type as "Auto Number" and save the same it automatically gets changed to Text type.Please suggest. Thanks, Ansh

    Ansh12320 pointsBadges:
  • Microsoft Access subform modification problem

    I have a main form with 6 tabs. I added a 7th tab and inputed a subform. However, when I rearrange the subform in design view, the edits do not show in form view. It appears I can only make changes to the subform when a I use the "Subforn in new window" button. With all my other subforms I can make...

    fjn0bu15 pointsBadges:
  • Pass data from Access subform to another form

    In Access - How do I select or pass data from a subform to another form? I can pass the data back to the main form, but I want to pass to the subform data to another form

    Bdbarnes5 pointsBadges:
  • Dbase III files exported from Access

    In Access you can export data to a dbase III, dbase IV or dbase V file. However when I do this for a dbase III file and try and open it is dbase III plus software it says it is not a dbase III plus file. How can I open the file in dbase III plus? I could append it as a CSV file but I was hoping the...

    cornisht20 pointsBadges:
  • Query pulling combo list box data

    I have a basic table in (column 1) list of individuals and in (column 2) lists the state(s) that the individuals hold licenses. Column 2 is a Combo Box Value List and several individuals hold multi state licenses. I am trying to figure how to pull out the states that require continuing education....

    emclean5 pointsBadges:
  • Fingerprint recognition in Java

    I want a programing source code for fingerprint recognition time and attendance payroll system in Java language. I also want the source code for capturing a fingerprint image and storing in MS Access in Java language for the same project.

    Anikketthakre5 pointsBadges:
  • Access Forms

    I am viewing my form in access that I have made in form view and the form is cut off half way down. It does scroll all the way down on the right, however the scroll on the left only goes halfway down. How do I get it to stop doing this?

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