• Automatically update Access table into a database

    I have a access table I want to automatically update into a database. I've linked it through an expression on load but it does not update the database. Where did I go wrong?

    LauraBarrows5 pointsBadges:
  • Fill in cells between specific date range in Microsoft Access

    I have a file where customer's terms changed on a specific date to a specific value. I would like this value to populate for every day until the next change. For example: Customer 12345 was changed to term A on 1/1/2015. Customer 12345 was changed to term B on 2/5/2015. Customer 12345 was changed...

    novice3215 pointsBadges:
  • Conversion from FileMaker Pro to Microsoft Access database

    How do you convert FileMaker Pro 7 database to an Access 2007 database file?

    Ccardona5 pointsBadges:
  • How to delete specific files in a folder with Access VBA

    I'm looking to delete all files in a folder, except 3 specific ones. All files in this folder are .csv files, and all of the file names are different. Let's call the 3 files I do not want to delete "Jim.csv", "Chuck.csv", and "Matt.csv". Is there a way to delete all files EXCEPT the ones you...

    JimmyJames10 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:
  • Decimal places rounding to whole number

    In my Access 2003 form values with decimal places are rounding to whole number. I've set the property to fixed formal with 2 decimal places and the problem continues.

    Juju335 pointsBadges:
  • Connecting C++ to MS Access database

    How can I connect C++ to my MS Access Database? By the way, my database is Payroll system so all I need to do is make it connect to C++ and C++ will be the search engine for the employee/s names, salaries, deductions, bonus and whatever the payroll should have. So can anybody answer this?

    AnimatorWannaBe5 pointsBadges:
  • Error message when running code to load data from Access database

    Value of '-1' is not valid for 'Value'. 'Value' should be between 'minimum' and 'maximum'. Parameter name: Value. I'm getting this message when I was running the code to load data from Access database.

    chamlingrai5 pointsBadges:
  • DSum in Microsoft Access

    How to give DSum function with multiple condition in Microsoft Access Form? Value need to sum from Form.

    Sreelalts5 pointsBadges:
  • .MB files Pardox message blobs

    Hello hello! Does anyone know how to open a paradox .mb file? I got a converter for the DB files which are all Access tables now but the MB files are yet another puzzle.

    Clementine775 pointsBadges:
  • Can’t repair MyoVision Access database

    One of my clients has a 130MB Access MDB which contains thermo image scans from an application called MyoVision. Recently, the database became corrupt and MyoVision is offering no support to fix it. What I'd like to attempt is Repair the database as it seems to be corrupted. Create a new MDB file...

    DavidCum7775 pointsBadges:
  • SQL Server login problems

    I am using Access as a front end to SQL Server 2014 backend database using DSN-less connections to tables and for pass-thru queries. All works fine. I have recently created a second database within the same instance of SQL Server, and believe I have set log in credentials the same for both, but am...

    DataSense45 pointsBadges:
  • How to fix error in database: Microsoft Office access has detected corruption in this file

    I am in the process of developing an Access 2003 application, and almost done. While I was fixing some errors with controls on one of the reports, seems like the database corrupted. Now, I keep getting "microsoft office access has detected corruption in this file....etc". It instructs me to Compact...

    kennethrich047x5 pointsBadges:
  • Access – Word Mail Merge email address duplication

    I have an email field in my Word document when the data comes over from Access it lists the email address but then repeats it again surrounded by # signs ex. blahblah@yahoo.com#mailto:blahblah@yahoo.com# Any tips on a switch I could use to remove the # signs and duplicate address? Thank you!

    jengrn265 pointsBadges:
  • How to transition an old local CRM system to a more modern networked CRM Solution

    Hi. We have an old CRM system that is currently local to only a single location and we are looking to transition it to a more modern system with network capability and would appreciate any advice about the best way to go about it. Basically, we currently have a fairly simple Microsoft Access (2007)...

    ericw19755 pointsBadges:
  • Apply 2 mathmetical operators on Access fields

    Hi all, could you help me to create new field on Access table calculating the sum of two other fields and divide it by 2? I am struggling with its syntax. Thanks a lot.

    Knowledgeislight5 pointsBadges:
  • Date dd-mm-yyyy reversed to mm-dd-yyyy

    Hi guys, Could you tell me why when I insert date into a database table, it's reversed from (dd-mm-yyyy) to (mm-dd-yyyy)? I have well defined my date format on form design already, but when it's inserted into the table it automatically reversed. How can I solve it?

    srithea190 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:
  • Random generate in Access SQL

    If one random generate program on web, can it be hacked by a hacker and get the result?

    eessm13975 pointsBadges:
  • Measure occurrences in MS Access SQL

    I was wondering whether it is possible (and if it is, the way) to perform the following task in Microsoft Access: there are two tables; first one consists of three columns 1) ID 2) tweet text and 3) date. Second table is a single vector of words, like a lexicon. For every row of the first table, I...

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

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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