MS Access

215K

Solutions

153

Articles & Videos

45K

Contributors

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Refine results

I'm planning out a migration of some access tables to a SQL server database. The tables already exist in a back end file. Once the tables are moved to sql, what is the best way to go through all of th…

20 views
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Hi Experts,

Yesterday I made some changes to an application, Compacted it, Compiled it without errors and to day I can't open it.  If I double click on either the accdb or accde Access opens to the…

178 views

I have a query that when I run it producing the attached error.   I am not sure what it is saying, I am exporting the results of the query to a Excel Spreadsheet with the following:

Private Sub Com…

727 views

Hi Experts,

Wondering if there is a way to have a button in my app that does the following.

Makes a copy of the current file, then saves that file as an executable (ADE in my case), or perhaps t…

1131 views

I have a form that is a continuous form.  I want to add a field to the form that just shows a number that is not bound to the record source.

The first record would show "1", the second record would…

715 views

Hi Experts,

I know I asked a similar question before but I can't find it in EE.

I have a Form Event that Extracts data to a table and then runs a report using the extracted data from the table. …

1422 views

I've got an application running in an old version of Access (have to leave it there because of the toolbars), which I've been using pdf995 to print invoices.
The trouble is, the pdf995 runs async and…

2124 views

Hi Experts,

    I have an MS Access Table MYTable   which has the field MyPath

      The Sample entries in MyPath  (The values corresponding to a  folder structure that  has several subfolders

713 views

Instead of using form/subform setup I am using a split form based on a query that joins two tables. Hence when a new record is added to the child table I use the following code in the Current even to …

626 views

I am using VBA in Access 2010.

I am trying to show the results of a query in a list box.  I am putting the data into a recordset and then using a function to put it into the list box.  I have used …

415 views
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

I use Access 2010.
I have two tables and I want to delete all records from one table that correspond with the second table.
The select query of the records that I want to delete is:

SELECT TblOrd…

210 views

Experts, how would I be able to show a MAX for [Available WC]+[Available OD] AS AvailCumWCOD but for the month?  The field the keeps the date is [date].  

SELECT Import_FC_Archive.*, [Available WC]…

312 views

I'm trying to create an SQL query that will find unmatched records using 2 table.    Here is the query,
SELECT TblAdpClean.[Last Name], TblAdpClean.[First Name], TblAdpClean.[Worked Department], Tbl…

3633 views

Is there a fast/clean way of determining the field type (directly from the form)?  I have a function that creates a shortcut menu when a control gets focus (pretty much every field/control on the form…

49 views

How can I export my query to a text file automatically lets say 3 times a day at specific times or timing intervals. Every 8 hours. Would this be with the DoCmd.TransferText? I am unfamiliar with this…

421 views

I created a report called "Phone List".
I have tried the following to make the report sort ascending by last name but still not sorting:

1. Query to sort ascending
2. Sort function on the report…

210 views

I am just all confused here but I see what is causing some of my issues but just don't know how to fix them. I need to export a CSV file in UTF-8 Encoding. This file is for products. I have done that …

1815 views

I had this question after viewing type mismatch calling function (https://www.experts-exchange.com/questions/28985800/type-mismatch-calling-function.html).
I have  picked a solution from EE to put an…

1318 views

Does anyone know how I calculate lateness by deducting Start Time from Actual Start Time?

1120 views
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

In my setup I have Parent Products and Product Variations (Children). Table [SKUs] is the Parents and Table [Products] is the Children. I have successfully made multiple Select Queries to come up with…

315 views

Hi Experts,
    I have a table in MS Access  with fields like DocName, Path , DocAndVersion

      I need to create 100s of rows of dummy data from a given row and I am looking a way to do that
 …

825 views

Hello all:

Here is my scenario:

I have a form that has two subforms on it.  These subforms (views as datasheets on the main form) are bound to a temp table that stores the data until I post.  O…

2422 views

Greetings!
I have a query that needs to pull certain data from a form, however it isn't behaving.
Please review this SQL code and let me know if you see where I went sideways,
thanks!
Dennis

SE…

1546 views

I am attempting to create a database that combines information from 2 sources.  One is a time keeping system, Table A.  The other is from a payroll system TableB.

I want to create a new table that …

825 views

I need help with an update query as I want to get it right so I don't mess up the wrong IDs.
BackStory:
I had an old Database Software that was horrible. I exported everything out of it as a CSV fil…

613 views
Show more content
201506-LO-Top-001

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. Query Syntax
    (47,285)
  2. Visual Basic Classic
    (163,556)
  3. MS Applications
    (43,147)
  4. MS Excel
    (128,564)
  5. Databases
    (53,487)
  6. MS Office
    (57,066)
  7. MS SQL Server
    (156,655)
  8. MS Development-Other
    (47,926)
  9. VB Script
    (36,269)
  10. MS SQL Server 2005
    (71,484)