Microsoft Access

216K

Solutions

173

Articles & Videos

51K

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.

Related Topics

  1. Query Syntax
  2. Visual Basic Classic
  3. Microsoft Applications
  4. Databases
  5. Microsoft Excel
  6. Microsoft Office
  7. Microsoft SQL Server
  8. Microsoft Development
  9. VBA
  10. VB Script
Refine results

Experts, I have a form and want to create navigation buttons (new record, next record...etc)

I click Design then choose the Button and go to the form to create the button and from what I remember …

28 views
Independent Software Vendors: We Want Your Opinion
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Hi Experts,

I have a report that has data from a number of tables.  I have an Event in a Form that extracts the data required for the report and writes it to a single Generic Report Table.  The …

1923 views

I have this query, but it needs to work as a view in SQL Server:
SELECT tbl_raw_material.raw_material_id,
[packaging_type] & 
IIf(IsNull([packaging]),"","|") & [packaging] & 

519 views

Does anyone know how I can stop my database from crashing every time I try and create a macro?

89 views

I have all change in mysql server syntax but just  ((IIf([WHPrep]![Inprogress],"Yes","No"))="No") is create error ,How can I change this condition  for mysql query .I did not understand ! symbol …

324 views

I created an access data base on my desktop. I split the data base and saved the backend in a folder on a shared server. Then I saved a copy of the front end from my desktop to another folder on the …

737 views

I have a file path and I want that file path to include whatever the PCs Name that I am currently on. Such as...

(CODE)

So how would I make the VBA understand my current PCs Name?

Thanks.

524 views

Hello, all you Access experts on this site.  I hope you can help me resolve the problem described below.

I have two tables in a database with approximately 200,000 records in each table with 165 …

118 views

I have a query of 2 tables with a join on acct number and another field that produces a typical horizonal result. However I need to make it vertical of field names and value.Is this possible - any …

1436 views

I am trying to use a form created in Excel to populate data in an Access database when a button is clicked. Here is an example of my code thus far.

(CODE)

I get an error "Run-Time error …

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

I have three fields in access table.  They can each contain either a number, or be null.
[ON_HAND_QTY]
[WIP_QTY]
[Pending_Qty]
The formual is  [ON_HAND_QTY]-[WIP_QTY]-[Pending_Qty]
but if any …

212 views

I have this in a standard module

Public Function EndDate0(Ender As Boolean, Start0 As Date, Start1 As Date, Start2 As Date, Start3 As Date, Start4 As Date, Start5 As Date) As Date


If Ender = …

232 views

Hello experts. I am not an access expert so I'm hoping to get some help here. I have an ms access form on the front end connected to a sql database. The form has several tabs. On the payroll tab there…

933 views

I created a table with two fields.  one the same as another table so I could create the relationship.  (However not sure that is needed)  The second field is used for data.  e.g. Abandonment, Guard …

519 views

I have a database where I need to search a table and return only the results matching the criteria.  I have the following code that works for one criteria, but I need it to return results if there are…

716 views

I have a database where information is stored in a table.  There is a column names "Errors".  If there is at least one value in one of the error fields I want to run a macro, otherwise, if the Errors …

520 views

I have a large database that has essentially 3 databases combined into one.  Each report I currently have is tied to criteria that is entered into the form that the queries are attached to.  Now that …

121 views

Hi
I am writing an ms/access app that needs to print ID cards from a table. in the table I do have an hyperlink to the ID image. How do I do in the report to substitute the hyperlink by the …

623 views

I have a DB that is being used as a audit compliance checking tool. The main form has a date of audit & auditor name combo box as well as 16 specific audits. Each of the 16 audits have combo boxs with…

522 views
Free Tool: ZipGrep
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Can anyone tell me how to identify the name of a missing DLL in Access 2010.
The Access 2010  application I'm running is loaded onto the local C drive of about 10 PCs (Access 2010 frontend database …

1132 views

I have a database in both Access and Excel with 6 columns and 816 Rows, I want to create a search and retrieve windows app using VB.Net, please help
Thanks in advance

2245 views

Hello,

I am creating a form to fill in information for a table that creates an invoice report. In the subform there are job numbers, tasks, descriptions, and amounts. In the main part of the form …

618 views

I have  a table
let say that the fields are:
Rec#
StartDate
Status and so...
i need to calculate the number of days between StartDate and today
in excel i will use NETWORKDAYS(Date1,now(), list…

933 views

I am trying to import emails from a folder in Outlook to Access.  The problem I am having is that some of the Mailobject items won't work.

These two will work.
rst("Subject") = Mailobject.Subject …

831 views

I have a table with SellPrice and Cost. I need to find out the percentile difference (Profit) between the two and display it as percent. So, if SellPrice was 100.00 and Cost was 50.00, the Profit …

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

Microsoft Access

216K

Solutions

173

Articles & Videos

51K

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.

Related Topics

  1. Query Syntax
  2. Visual Basic Classic
  3. Microsoft Applications
  4. Databases
  5. Microsoft Excel
  6. Microsoft Office