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

Hello Experts!
I have a MS Access 2013 Search Form.
It queries data from one Table1 with 20+ columns.
I have 3 search criteria (combo boxes?)
(1) District
(2) Manager
(3) Status

Above 3 are …

715 views
Ransomware-A Revenue Bonanza for Service Providers
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Hi,

I'm starting a project to integrate a third party add-in from SagePay to our in-house Access database and unsure on some of the basics. I've completed the following steps but not clear on where…

1416 views

Hello,
i have a multiuser (Databse not splitted yet as backend) database. Need to know if following additions can be done ?

1. Can i know How many users are logged into the system ?
2. Can a …

1628 views

I develop in Access 2010.
My client has a few users for the access database which I develop and support for him. The users only use the database and do not need any development abilities.
However …

613 views

I have a form that allows a user to enter data that goes into a existing table and at the bottom of the form, I have a "Save Record" button.  The problem I'm running into is when a user only partially…

318 views

Hi Experts.

I have an Access Application that was created and compiled in Access 2010.  It installs and runs correctly on a Windows 7 64 Bit PC with Access 2010 Runtime.

When I install it on a …

2233 views

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 …

212 views

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
    …

77 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 …

517 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
Three Reasons Why Backup is Strategic
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

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.

613 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:

1113 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, …

216 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?

1917 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 …

317 views

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. …

1125 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 …

810 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
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.

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 …

2343 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 …

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

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. Query Syntax
    (47,625)
  2. Visual Basic Classic
    (163,625)
  3. Microsoft Applications
    (43,173)
  4. Microsoft Excel
    (129,507)
  5. Databases
    (53,716)
  6. Microsoft Office
    (57,292)
  7. Microsoft SQL Server
    (157,613)
  8. Microsoft Development
    (47,952)
  9. VB Script
    (36,405)
  10. VBA
    (5,830)