Explore Access on Experts Exchange

Expert Solutions for Your Tech Problems

AccessMicrosoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications,...

Read more
  • 226K Content
  • 16K Contributors

Expert Spotlight

Independent consultant specializing in the writing of custom packages for businesses.

Advice Solution

Implementing AI with Windows Based apps

4

Hey Experts! I have been chartered with implementing AI into existing windows based apps and am

Advice Solution

Creating Gantt Chart programmatically on Continuous Forms

5

I am trying to create a Gantt Chart in MS Access without using the graphics module. I believe I can

Troubleshooting Solution

Adding minutes to a time

11

I have 2 separate forms,AppointmentScheduleTime, SQL SELECT AppScheduleQuery.Arrival,

Advice Solution

Emailing multiple email in access vba

2

In microsoft access i created a database system that keeps track of farmers catfish processing

Troubleshooting Solution

Why is this query throwing this error

4

Why is this query throwing this error?

 

Msg 2628, Level 16, State 1, Line 5
String or binary data

Troubleshooting Solution

SQL INSERT STATEMENT vs STORED PROCEDURE

6

Looking for a few Pros and Cons on inserting new records into a table.

 

I have a TRACKINGNUMBERS

Troubleshooting Solution

Export long text into excel

5

i Have a table I export into excel. One of the fields in the table is a long text. When I export it

Troubleshooting Solution

MS Access Query to Dynamically Calculate Aging Bucket BalanceDue after Debtor's Payment Made

7

Hi, I am working on a small project which involved Statement of Account Report and Aging Bucket of

Troubleshooting Solution

Report Date Filter Criteria Failing to Return Specific Records

13

I have an Access form on which I collect a date range to use as filter criteria for a report. I then

Advice Solution

VBA Scripting for PDF Header/Footer functionality

4

I have a need to use access vba with Adobe scripting to manipulate a pdf's Header/Footer.  I find

Troubleshooting Solution

Code error

2

What is wrong with this code?

 

Docmd.OpenForm "InvoiceListF", acNormal, "", "[ClientID]=" [ClientID],

Advice Solution

Have schedule duration set according to limit of billable hours

bybfuchs
7

Hi Experts,

This is related to the following solution.

Troubleshooting Solution

Access 2000 Query Not Displaying SQL View

3

Hi Experts,
 

I’m working with an Access 2000 format database, and I’ve encountered an issue: the SQL

Troubleshooting Solution

Ms Access report field float

3

In the image, field 10 appears after field 6 is expanded (if). I want field 10 to be unaffected by

Advice Solution

Stock control module

13

We have a client that wants a stock control section included in our software. Is it likely that

Troubleshooting Solution

MS Access error in concatenation formula

7

in MS Access i am trying to combine a text (from a text field) and currency value (from a currency

Troubleshooting Solution

How exclude part of a field data

1

If I have for example…  “abcdef Products fedcba” OR "Something Products Else", in a table field, how

Troubleshooting Solution

how show info on a report

4
I have two tables. one of them contains order details for various states. not all states are in this…
Troubleshooting Solution

Move Record by Record on a Datasheet

8

I am using the latest version of MS Access.

 

I have a form that displays orders and order details.

Research Solution

VBA Function to return if date is holiday.

bybfuchs
8

Hi Experts,

 

I am looking for a VBA function that will return if date given is either one of the

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more