• How to export Access file to Excel automatically

    Our department has a Microsoft Access database file that updates all of the time. We need to export all of this data to Microsoft Excel automatically. So whenever we need the newest updates, it happens automatically (not manual process). How can we do that? Would a Power Query work?

    ITKE1,048,075 pointsBadges:
  • Create forwarding account to Access Database

    I work at a small low-tech agency and we need a simple solution for employees of all abilities to frequently document specific types of emails in a searchable way across the agency. My preference is to set up a way that each person can forward an email into an Access database which collects basic...

    mpd3615 pointsBadges:
  • Edit Microsoft Access database by multiple users

    Our team works on the same Microsoft Access database throughout the day. It's access my multiple users at the same time. If a user makes an edit, will it immediately reflect for all of the other users? Or just that one specific user?

    ITKE1,048,075 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:
  • What would this Microsoft Access query be?

    I'm trying to write a query to show all patients along with their diagnosis. The result should have 4 columns: patient ID, patient first and last name, and their diagnosis. Sort the results based on patient last names. How can I do that?

    pedrosgirl165 pointsBadges:
  • Microsoft Access: How to add a table that lessen the room’s availability?

    I have a table in access showing the rooms with a field: roomID, price and availability. And another table showing the transaction: TransactionID, CustomerID and RoomID. How to less the room's availability if I input the roomId in the transaction table?

    euhipolito5 pointsBadges:
  • Importing Excel to Access auto populating data

    I have imported an Excel spreadsheet into Access (2016) and am trying to figure out how to populate data. For example, I imported a spreadsheet containing employee name, ID, Department, Supervisor. If I select the employee name, I want my form to automatically populate with the rest of the data....

    motogirl15 pointsBadges:
  • Define relation in Microsoft Access

    In Microsoft Access, what is meant by define relation?

    farasathussaintaajwar5 pointsBadges:
  • Microsoft Access menus

    How do you setup menus using MS Access?

    Danljonessr10 pointsBadges:
  • Paste records into Microsoft Access database

    Hi, I have a highlighted set of records in a Microsoft Access database. Would I be able to paste them into a new table? I know it's possible in an existing table.

    ITKE1,048,075 pointsBadges:
  • Compare two Microsoft Access databases

    For my job, I have two Microsoft Access databases that I need to compare. Basically, I need to look at the structure / content in each database at the same time. Is there a tool for this? Is it even possible?

    ITKE1,048,075 pointsBadges:
  • Issue With Buttons in Access

    I'm building an Access DB and would like to have people interact with it through forms and command buttons.  Adding command buttons should be very straight forward with the wizard, and it is until I test the button - the buttons I create don't work and give me this error message: A problem...

    JTB15 pointsBadges:
  • How to delete a database – MS Access 2007

    I am using MS Access 2007 and I thought that I had managed to delete a database, but every time I open MS Access 2007 the database is still showing in the Recent Database list. Is there a way that I remove all traces of that database and stop it from showing in that list?

    NLC30 pointsBadges:
  • VB6 retrieving MSAccess all records in VB6 ComboBox

    Im beginner to VB6 and I have project to buildup company Database, I will be so grateful if anybody could help me in that: "How can I get all records of any field of MSAccess database in ComboBox or ListBox of VB6

    ScorpionEyes45 pointsBadges:
  • Microsoft Access Subreport suppression not working

    I have a fairly simple Access report. It has a report header, no page header and in the detail section it displays a field from the query the main report (PaymentsandRecordings) is based on, then there are two reports, one for Payments (PaymentsSubreport) and Recordings (RecordingsSubreport) which...

    geekylori5 pointsBadges:
  • Import of Microsoft Access database file to SQL Server is slow

    I've noticed that there's an issue whenever I'm trying to import my Microsoft Access database file into SQL Server. My Access file has a ton of data but whenever I try to do the import, it takes a long time. Is there a way for me to speed it up? Thanks very much.

    ITKE1,048,075 pointsBadges:
  • SQL code for deleting Microsoft Access database rows

    I need to delete all of the content in several rows on a Microsoft Access database. How can I setup SQL to do this? I found this but I'm not sure if this works: Dim SqlQuery As String = "DELETE * FROM QuestionResults WHERE Quizname = " & txtQuizName.Text & ";" Can anyone help?

    ITKE1,048,075 pointsBadges:
  • Transfer data from SQL Server to Microsoft Access

    Hello, we need to move a large amount of data from a SQL Server database to a Microsoft Access database. The table structure is already setup. Is there anything from SQL I can use for the migration? Or do I have to use a ODBC data source? Thanks.

    ITKE1,048,075 pointsBadges:
  • Import Microsoft Access database into MySQL

    I'm currently on a Windows machine with a Microsoft Access database. I need to import that into MySQL on another Linux web server. Here's what I'm doing right now: Exported as text file Copied with FTP Loaded into MySQL Is there a better process for this? Any help would be appreciated.

    ITKE1,048,075 pointsBadges:
  • How to show last entry in data environment in Visual Basic 6 and Microsoft Access

    How can I show the last entry in a data environment. I'm using VB 6.0 and Microsoft Access in the back end.

    HARDIKJOSHI5 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