Microsoft Access

216K

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.

Related Topics

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

access 2010
sharepoint linked table

I have a sharepoint linked table

tbl_Dashboard

In that table is a field called:  Seller_name - it is being linked as a "Number" datatype.
It is a field …

46 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 a Form (Sponsorships) with a Combo Box that is linked to a Table (Vendor)... The Vendor Table has "ACTIVE" and "INACTIVE" vendors. I want the Combo Box for the Vendors Names to only display …

818 views

I need to create a query to categorize every 30 mins.
would it be possible to use format([time], "mm")?

119 views

Here's what I am trying to accomplish:
From Access, I have vba code to copy records from a form and open Excel and paste records. The Access datasheet columns can be hidden / displayed by the user …

521 views

Can anybody help whats wrong with this code ?

It considers date format sometime as DD/MM/YY and sometime MM/DD/YY... i am bit confused.

Private Sub cmdSearchDatewise_Click()

Dim strCriteria, …

811 views

Hi All,,,

Q: Text Field in a Table Has values like n1...Xn2...Yn3... How to pick up the numerical values of n1, n2 , and n3 ?

(Might sound strange but I am working on an old DB imported from …

919 views

I am a new access user and have little coding experience.
Can you help please

428 views

I have a report that provides a list of all transactions and there details.  I would like to sum a field within the report but restrict the items to to a field value that is within the parent form.  …

110 views

I've developed a small Access database to generate reports in Excel for myself and co-worker.  I have code in an auto execute macro that is supposed to find any broken references, remove them, then …

810 views

I have Access 2010 and Adobe Acrobat 11 Pro.

When I was using Access 2010 with Adobe Acrobat 10 Pro, I used the following code to save my report to a PDF file.
   DoCmd.OutputTo acOutputReport, …

1323 views
Ransomware: The New Cyber Threat & How to Stop It
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Whenever an Access Application using VBA code is installed for the first time, the system blocks execution of VBA (as a precaution against running potentially malicious code) and I get a message …

419 views

I need some help adjusting some code to compile in both 64 and 32 bit Office environments.  The follow code works perfectly in the 32 bit world but not 64.  I figured out that I needed to PtrSafe all …

317 views

I need to store a string of 16 bits in two different tables and do bit operations on the values.  For example, a field in one table might be the value "0101010101010101" and a field in the other table…

1121 views

I have a table with a xfrm_ID, and an amps value. There will be many records where the xfrm_id is the same. I have a column called Amp_seq that for each Xfrm_id I would like to number 1 to ..... from …

1328 views

Over the past 10 years I have developed several applications using SQL Server as the back-end database with Access "projects" (.ADP) as the front-end applications.

Now that the Access ADP Projects …

916 views

I have a continuous sub-form that is designed to look like a datasheet sub-form.  the bottom record of the sub-form is always blank (because it is a potential new record). I want to make it so if a …

417 views

Hello,
This should be an easy one, but I can't seem to find anything that works.  I simply want to have a function where I pass the zip filename and path as well as the destination folder and have it…

312 views

I have a query (attached) that shows a part number and how many of that part # we shipped. I narrowed the query down to the last two years. I created a report (attached) and it is fine. But now I want…

320 views

I have a report with a sub-form that will display all the doc numbers associated with each record:
Record 1
Doc 1, Doc 2, Doc 3, Doc 4

How can I update my report to:
Record 1
Doc 1 - Doc 4

513 views
Free Tool: IP Lookup
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

I have the following code in an AfterUpdate event of a number field on a subform.  But after making an entry in the field I have to press the tab key twice to go to the next field as determined by the…

418 views

Hey,

I am looking for a Macro / DB Structure, where I can import a predefined raw data format which includes start and stop dates for individual User entries being enabled for various services …

513 views

I have a form that I want to use to be able to search for records in a table.  The table has various field types...  short text, data, etc.  On the search form I want just one field where the user can…

1428 views

Hi Everyone,

I have a select query that takes a selective amount of fields from a table and then sorts them.  I then use the results of this query to export to a text file that has specifications …

2020 views

Get the above error when trying to set the BindingSource DataMember property to the name of a table in an Access Database. The table name is in the Schema as the code snippet shows.
(CODE)

427 views

I am using Access 2007 with win pro 7. My form contains a big query and it work just fine but when I click the mouse anywhere inside the form the message Access Not Responding appears in top line with…

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

Microsoft Access

216K

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.

Related Topics

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