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

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 …

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

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] & 

510 views

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

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

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

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

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

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

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

416 views

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

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

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

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

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

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

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

520 views

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
Instantly Create Instructional Tutorials
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

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

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

932 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

I have an Access 2016 database that I've written on a Windows 7 with Access 2016 and am able to register the MSCAL.OCX in the SysWow64 folder. The Date Select works fine on the work computer. However,…

434 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