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 have this in Access:
60%: IIf(IIf([Months]>19,IIf([Months]<=25,[StkValue]*0.6))>0,[StkValue]*0.6,0)

Does anyone know the SQL syntax?

In English: if Month number is greater than 19 and less …

514 views
Backup Your Microsoft Windows Server®
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

I have an Access database with split front/back-end.  It has a function that allows users to add fields to a table in the back-end.  To facilitate this, it comes up with a form asking for the field …

40 views

I have a table where the table wont allow a duplicate PK. How do I detect this in the vba function so the write is not attempted or at least exits smoothly without reporting? I had hoped that with the…

314 views

Dear Expert,

I have an excel file , this excel file contains so many worksheets, I have used successfully and thankfully the -below mentioned- code published in …

75 views

Hello All,
  I want to change the color of the button once it was pressed and change it back after the Shell command.
   how can i pause the second  Me.Command290.ForeColor = 8388608 to wait till …

1010 views

In MS-Access 2013, I added an OLE object to a table.    This fields is intended to display images in a form.

I stored my images (at this time, 29 BMP files at approximately 700 kb each) in a …

411 views

Had to repair a broken access mdb and want to find which records have been lost by searching the PrimaryKey field
Thought this would do it but there's a syntax error maybe because the table name has …

916 views

Hello,
i am trying to calculate shortage value on the form (Qty X Rate) and form user accepts the above to close the deal.
Below is code.. i am getting error as Error 2185 (Control ... focus error)…

315 views

My Access database needs to give the user the ability to add fields to a specific table (stored in a linked back-end).  I can add the fields using something similar to the following:

(CODE)

413 views

I have multiple check boxes in an access form that I need to combine all of the values for those that are check so that I can put it into a table.  The problem is that the result has blank lines for …

321 views
Complete VMware vSphere® ESX(i) & Hyper-V Backup
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)

I am trying to get a column to calculate a running total in Access. I have seen a lot of suggestions for DSum however when I try to use that formula it returns the total sum rather than a running …

419 views

access 2010 vba

I have a tabctrl127
I have several pages
my specific page52

I have code in the click event of that page.
I also have events happening on the other pages

My code will not …

912 views

I have imported 128591 records from an old database>What is the best approach to get the total and unique record count.I have been getting system resources exceeded errors
thanks

2028 views

I have a query that appends to a table, and I need to ensure that after the query runs the table records are sorted by a specific field. I figure doing it via code after the append query runs will be …

58 views

OK, I am out of my element but willing to learn!  I created an access database and have a report that I need to export into various folders by office each week.

Not knowing better, I coded each …

1425 views

I have some code that will highlight a string within my text box in an access form, but it will only work if the text format is set to rich text.  The problem that I’m having is the view.  In rich …

311 views

I’m trying to highlight a phrase like “Activate Port” within a text box.  I found the below code, but I can’t seem to get it to work.

The string to highlight: "Activate Port"
Name of text box …

414 views

See attached database with a single datasheet form and single table.

I want the "Age" field to be disabled IF the Adult_or_Child="Adult"

The code below does not work properly

Private Sub …

921 views

A couple of weeks ago I posted a topic that had may experts confused I think because of my lack of understanding how the number field was supposed to be working.  I think I have it straight now.  

1618 views
Comprehensive Backup Solutions for Microsoft
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Hi -

on my app I have a routine to test fields in a record and the insert of a new record should only occur if the fields are pass through the set of tests.
I reckon that I should put the tests on…

510 views

I had this question after viewing Continuous form..  Conditionally make cell invisible. (https://www.experts-exchange.com/questions/28924263/Continuous-form-Conditionally-make-cell-invisible.html).

719 views

hi there,
I only post this here as I've exhausted Google to no avail.
I have an Access db that creates an outlook meeting request.

How do I format the meeting request in Outlook? It is my …

522 views

Hi,

I am opening a form that I was able to open in matrix view but now I don't see this option. I now have Access 2013. Did something change?

1415 views

Hi Experts,
I have a coding question that need help.  below is my code:

Private Sub Command11_Click()
On Error GoTo Err_Command11_Click
 Dim rs As Recordset
 Dim db As Database
 
 Dim …

214 views

Hi every one, hopefully someone can help modifying this code below, What I need is to make this code Print out as PDF only the CURRENT Page or CURRENT record (anyway every record will not be more then…

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

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. Query Syntax
    (47,425)
  2. Visual Basic Classic
    (163,589)
  3. MS Applications
    (43,158)
  4. MS Excel
    (129,048)
  5. Databases
    (53,621)
  6. MS Office
    (57,159)
  7. MS SQL Server
    (157,155)
  8. MS Development-Other
    (47,943)
  9. VB Script
    (36,326)
  10. VBA
    (5,463)