MS Access

195K

Solutions

150

Articles & Videos

10K

Experts

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

The following code successfully rounds DOWN my time NOW() to the nearest 5 minutes, but I am struggling to edit it to round UP.

(CODE)

How can I do this please? I am trying to get away without a…

83 views
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

I have a form set to "single form", but when I've tabbed through all the controls it still jumps to the next record (form's record source is a table). How do I stop that and make the focus jump back t…

56 views

Dear Experts,

I am trying to setup a delete query and run it from an onClick button event but when I test the query I see records I want to delete but when I try to 'run' the query I get the messge…

177 views

I have been succesful using the procedure outline in:

https://www.experts-exchange.com/questions/26923910/How-to-save-and-read-files-stored-as-FileStream-in-SQL-Server-2008-from-MS-Access-2007-vba.…

713 views

Hi All,
I am trying to connect to an oracle database using access 2013
The  ODBC Data driver can connect successfully to the data source see below.


But when I try to use this data source within…

1812 views

I am working on a inventory model where I have to calculate average demand. My table looks like this.
ToolID       PartNumber      DemandDate     PartDemand    ToolNumber    
ToolID is the primary …

1724 views

Please see the simple database I have included.
The combobox of the included form is unbound and has as its source a simple table with a column named c_name (sorted ascending) and the id column, boun…

58 views

I am using a calendar control so the users can pick their date.  However, some of them like to type in this field instead and are not entering the information correctly, example:  05/03/201.  This wil…

59 views

Experts,

I have a form in Split view and datasheet at bottom.
Was wondering if there is a simple way to filter the bottom datasheet for what is at the top in the form?
Might seem like an odd que…

48 views

Dear Experts,

Need help with VBA code on an button onClick event to randomly display a student's picture and name on the form where classID equals studentClassID.

Does anyone have sample code I…

1325 views
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Access 2010 vba
outlook vba via access

based on previous q:
https://www.experts-exchange.com/questions/28965360/Sending-email-using-a-query-based-on-a-value-from-a-subform-produces-error.html

1218 views

Hi, I need a query which computes different rates averages... However, not sure how to do it as the avg will include the omitted records. I have the following query to date:

SELECT Format([checkin]…

1434 views

Hi, I need to find all entries in table Hotelogix which are not existing in table Reservations but excluding cancelled records in Reservations. I have tried the following statement:

SELECT Hotelogi…

417 views

Hello, trying to display nothing or a 0 if there is a #error.  What is function in Access?  
=Iferror(DSum("Amount","tblDraws_Details1","DrawID1=" & [ID]),0)

thanks

68 views

we have an access 2010 application, with backend / frontend setup. When one of the analysts opens the master copy of the front end in design view, creates a query, saves it - when another user opens t…

318 views

I would like to include a QR code on an inspection form I occasionally use that will easily enable a confirmation to be sent. Using the following code I can easily display the needed code on a web pag…

515 views

Dear Experts!

Please see attached file. What is the proper syntax for referencing a field from a different table in my query? The query works great when I type a date in manually but when I referen…

513 views

Hi Experts

Could you point how to deal with this intricated Relational Integrity when using MS-Access ?

Accordingly to
 

Three columns of tblBooks must have relational integrity with tblAuto…

1619 views

access 2010 vba

I'm trying to send an email in the body of outlook. adding the results from a query.
The query is based on an ID in the subform.

the code is working fine on just a regular query…

125 views
Cisco Complete Network Certification Training

If you’re an IT engineer or technician, it's time you take your career to the next level. This elite training bundle is brimming with all of the information you need to learn to sit for Cisco CNNA, CCNP, and CCENT certification exams.

Greetings!

We have a Microsoft Access Database with an SQL backed that we use in house for managing our ticketing system. A former employee put it together, we love it, it has worked great for yea…

522 views

Hi,
A Form was created to import an external file.  I'm able to open the form in design view, how can I see what each 'button' on the form does?  Specifically, I'm trying to see what location the ext…

413 views

Experts, I have a parent (frmParent) and subform (sub1) and they are linked by ID's as found in the properties.  
I enter details in the parent such as currency (its a cbo) and DrawDate.  After I ent…

57 views

Access 2010
subform on access main form:  MySubform
command button

What I need:
From a command button,

First:
I have a subform that MUST contain records first.

Second:
if it contains r…

913 views

I am trying to show in my query when an object (form, query, report, table, etc) was last modified. I am using this query but the "DateUpdate" field doesn't seem accurate. There are forms that I modif…

179 views

I have some users who have a problem leaving a report opened in Preview mode overnight. Trying to tell them not to do that is like talking to a brick wall sometimes. So what I want to do is have the r…

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

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. Query Syntax
    (46,944)
  2. Visual Basic Classic
    (163,358)
  3. MS Applications
    (43,096)
  4. Databases-Other
    (53,271)
  5. MS Excel
    (127,424)
  6. MS Office
    (56,661)
  7. MS SQL Server
    (155,667)
  8. MS Development-Other
    (47,903)
  9. VB Script
    (36,062)
  10. MS SQL Server 2005
    (71,322)