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

    srithea345 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:
  • Value too Long in Microsoft Access

    this is a hypethetical question.. Using MS Access you enter the last name of a student, and you recieve an error message stating that the value is too long for the field. What are your next steps?

    Jeffhill5 pointsBadges:
  • How to insert row number using SQL

    When importing data from Excel into MS Access, how do you insert a row number using SQL?

    JimStAubin201515 pointsBadges:
  • Conversion of Microsoft Excel formula to Access

    How do I convert the below given formula of MS Excel to MS Access for the following data: ID Level Session Gender Regular/Plus Shift Programme Section 13 INTERMEDIATE 2013-2015 MALE REGULAR MORNING FSC ENG FSC B-4 14 INTERMEDIATE 2013-2015 MALE REGULAR MORNING FSC ENG FSC B-3 15 INTERMEDIATE...

    MUHAMMADYOUSAF10 pointsBadges:
  • Cascading combo boxes in Microsoft Access database

    I am a Continuing Education Teacher and I have been asked for help in building a function in a Microsoft Access database. I must say I have not yet found a solution. So, here what is needed: “I have constructed a contacts and networking database that I use to gather information on my professional...

    lawantyson5 pointsBadges:
  • Microsoft Access: Reports in Custom Groups vanish

    I have a couple different groups under Customs Groups in Access, and more than once now, when I open a Group there is nothing in it?

    Jaljets5 pointsBadges:
  • Paste records in OLE Unbound Excel Object in Access Form

    Ok so I have built a database that is used to house and manipulate records that I get from a monthly report that is posted online. Basically I work for the Army and we have over 50 units. Each unit has anywhere from 10 to 1000 soldiers in it. I initially had tried to build a database with a table...

    Brianaaskew40 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