• .MAR File opening with Microsoft Access

    How can I open a MS access report shortcut file using MS Access?

    NehaSoni5 pointsBadges:
  • Many to one relationship in Microsoft Access query

    I have the following tables: ISSUEREASONS(issueID, issueReason = "PNR Change"), Issues(issueID, partNumber), Parts(PartNumber, DDSID), PNR(PNR, DDSID, PNRChangeReason="PNR Change") where there is mostly all one to one relationships besides there is multiple PNR to DDSID. I need to query for both...

    tabooka15 pointsBadges:
  • Microsoft Access: How to create an entry form for a team event with up to 4 members on each entry form

    I am trying to create an entry form (order form) for a golf event. (There are 5 events per year.) Each event is a team event, involving 4 entrants (members.) So I want the entry form to have the event name once, but each of the four members' names on the entry form. I am having great difficulty...

    janeyr5 pointsBadges:
  • Microsoft Access 2016 MSO – How to save data to Table A

    I don't know if the table has to be attached to the form to copy to the table and do I have to click save or does each record save when I reach the end of the row

    dannyboy14145 pointsBadges:
  • How to save query in Visual Basic

    There's one other thing that might cause a problem. Microsoft Access, if that's what you're using, doesn't support COUNT DISTINCT. (At least, it didn't in Access 97. I don't have Access 2000 or 2003, so I can't test it.) To get around this, just use a saved query, which is the equivalent of a view...

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

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