Microsoft Access

215K

Solutions

161

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

Good Day,

I want to create a delete query to remove records other than the max appended record which is based off an autonumber  field "Current Post". I'm not to familiar with SQL or if it can be …

23 views
Simplifying Server Workload Migrations
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Experts,  

I have a rpt with a line in the detail section that i want to be visible only if me.PaymentYN = "Yes"

I have code on Load of the rpt

If me.PaymentMadeYN = "Yes" then
    …

75 views

I need to sum with a where criteria.
I have the following but its wrong

=Sum([USD Equiv Rpmt] & [PaymentMadeYN]= "Yes")

The part after the & is not correct.  The YN field is a value list with …

513 views

I have a Navigation form with 2 continuous sub forms.
PLU is the common key field

 1 sub-form (sub_vendor_item) is for entering vendors, order numbers, and costs - with a corresponding table …

109 views

Hi Experts,
I have a problem that I could not figure it out.  I have a combo box in a employer form, this combo box is list all the employers.  on the employer table I have a field Status (A- for …

68 views

In your Expert Opinion,

how should I determine when to use a tabbed subform vs a navigation sub-form.

68 views

I am attempting unsuccessfully to format data in Excel as a table from Access.  I was hoping someone could tell me what I'm doing wrong:

First way:
(CODE)

Second way:
(CODE)


Third way:

1112 views

We have 2 Access databases where database A has all of the information stored and we need to append that information into a table in Database B.  Currently we are importing the table into database B, …

213 views

I wonder if thats even possible. Is there a way to store via VBA a value in a Label control, and that value sticks, even after closing and open ms access without aid of a table?

1914 views

Hello Fellows

Im about to implement a control on a form with the characteristic of a listbox that show to the user what record as been "updated", for this i need a listbox with row color, but for …

316 views
Use Case: Protecting a Hybrid Cloud Infrastructure
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Hi Experts,
I've got some codes for showing progress bar in access form and is working fine on the sample form but not getting it worked with my form. Actually I'm not able to fit it at right place. …

1019 views

this is a continuation of :Display <> "Yes" records (https://www.experts-exchange.com/questions/29004787/Display-Yes-records.html).
HI Ryan,

 I need to add some fields from tblRepayment and …

88 views

experts,

I have 2 tables:  tblDraws_Details1 and tblRepayment.  
Joined on tblDraws_Details1.ID and tblRepayment.DrawIDrpmt (one to many)
Each record in tblRepayment is a repayment
after a …

1010 views

Hello Fellows

Im trying to insert a new line in a memo richtext control, but the vbNewLine and vbCrLf dont work there. Is there a way  to do this?

Thanks in advance for your suggestions

817 views

I have a table of thousands of documents, and when they get revised we need to track the relation between other applicable documents that reside in the same table.

If I input the first line below …

2342 views

I have an ms access app that is created centrally and then put in a remote users dropbox. The app contains several linked dbase tables. These  linked tables will be re-linked to the proper path when …

107 views

When I run my code, I'm getting the following errors:

 Error: 1004
 ExportToExcel
 Application-defined or object-defined error

 Then if I click on OK, it continues through the code, but  then …

1017 views

How can I achieve the following please? I want the data shown in the first column to be summarised to only show one of the possible values in the Colour Column. Have a look below and it should make …

216 views

I am working on a query to delete from an existing linked table where the Batch Id is all the same. So my query is as following :

 

i am using an explicit parameter called BatchID and when i …

1332 views
The Eight Noble Truths of Backup and Recovery
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

I had this query in access which gave output specifically only where an item went from no value to a value or either value changed
(CODE)

AbiCode               minYM          maxYM      Tprev      Tchange
81140561      …

320 views

I have a subform that displays a list of orders  and/or quotes based on the parent form criteria selected. Many criteria on the parent form can be selected to query specific records. the SQL is …

636 views

I had a problem to export an Access (2010) table/query to Excel 2010 format.
I've tried with these two commands:
1. DoCmd.TransferSpreadsheet A_EXPORT, acSpreadsheetTypeExcel12, <tableName>, …

1310 views

I had this question after viewing Printing to File then Sending File to an IP (https://www.experts-exchange.com/questions/28898167/Printing-to-File-then-Sending-File-to-an-IP.html).  Towards the end …

1117 views

Hi,

I have some cells in a excel file , one of them contain xml string.
i have imported th file into access table .
the cell contains xml string imported into text field.
now, what i want is to…

2124 views

Hi Experts,

I know when someone has an Access app open with one version (lets say A2003) and another user has a different version (A2010), then it will not open just by double clicking on the …

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

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. Query Syntax
    (47,620)
  2. Visual Basic Classic
    (163,624)
  3. Microsoft Applications
    (43,173)
  4. Microsoft Excel
    (129,491)
  5. Databases
    (53,713)
  6. Microsoft Office
    (57,271)
  7. Microsoft SQL Server
    (157,603)
  8. Microsoft Development
    (47,951)
  9. VB Script
    (36,402)
  10. VBA
    (5,819)