Summing In Access 2013 Web App

May 5, 2015

I have created a database that is hosted on our company sharepoint. The database contains subcontracts with resource information by geographic location and status. I have built queries and added them as reports to the web app but I need to figure out a way to sum totals on the queries. For example, one report lists all resources of a particular type by 4 different zones and 3 different status. I need to have the bottom row show the total resources.

View Replies


ADVERTISEMENT

Modules & VBA :: Summing Multiple Queries And Summing Time

Oct 4, 2013

I have a sales form. The sales form has many Call, Meetings and Emails linked to each sales record. I want to total all the number of calls, meeting and email records related to the sales record to give a total- Touches.I've created 3 queries;

1 - Counts Calls
2 - Counts Emails
3 - Counts Meetings

These all work fine however when I combine them to attempt to count the results it doesn't produce the correct results.I have a second query as well (no pun intended).

I am trying to sum together a column that has values in Time. The results displays as a decimal. How can I have the result display as a Time i.e. 1:20 (1 hour 20 minutes).

View 1 Replies View Related

Access 2013 - Hiding And Showing Access Window

Apr 6, 2015

I am trying to Hide or Show the Access Window by using two buttons on a Form. Running Access 2013 in Windows 7 64bit.

I have used code from the Internet as below but added the PtrSafe item to the Function Declaration as below:-

Option Compare Database
'Hide Access desktop screen and float Forms on pc desktop
Private Declare PtrSafe Function IsWindowVisible Lib "user32" (ByVal hwnd As Long) As Long

Dim dwReturn As Long
Const SW_HIDE = 0

[Code] ....

I then have two buttons on a form coded as below:-

Option Compare Database
Private Sub cmd_Hide_dbw_Click()
Call fSetAccessWindow("Minimize", False, False)
DoCmd.OpenForm "frm_Test", acNormal
End Sub

[Code] .....

I have attached a Test Database which demonstrates the problem I am experiencing.

Do the following sequence...............

Open the Test Database. DO NOT ENABLE CONTENT
The Access 'Ribbon'Test_Database.accdb is active and usable
Open frm_Test in Design View in order to inspect, all should be as shown above.
Now click the Enable Content warning
Switch frm_Test to Form View

Click button Hide dbw. Closes the Access Window
Click button Show dbw. Opens the Access Window...HOWEVER....

Attachment 20252The Access Ribbon is locked and usable !!!

I cannot find a way to re-activate the Ribbon

View 2 Replies View Related

Access 2013 / Can't Share Access Over The Network

Jul 4, 2014

I have problem sharing an Access 2013 file from one cumputer and then change the data in the file on another computer, or i can change it but the change wont be made one both computers.

I'm working so i need my secretary to be able to change information or add, but i also need to get the change.

View 2 Replies View Related

Different First Page Footer In MS Access 2013

Apr 7, 2015

Using MS Access 2013, part of Office 365, I am trying to construct a report that has a different first page footer than the rest of the document. Googling for answers has produced a few options, but none that seem to work. I have virtually no VBA knowledge. I was hoping that there might be some code that I could place in a label in the footer and have it work.

View 1 Replies View Related

How To Create If Field In Access 2013

Oct 26, 2013

I have an Access 2013 database file with many fields. One of them, I'll call it Field 3, is a box which I would like to either leave blank or put a check mark in it. I would like to be able to create an Iif field for Field 3 where a check mark is automatically inserted in Field 3 IF Field 1 - Field 2 <or= 0, otherwise I'd like Field 3 to remain empty.

View 9 Replies View Related

Summing/Counting Records In Access

Dec 29, 2004

Hello & thank you in advance.
I am fairly new to using Access and would appreciate any help.

I have a file with 50,000 records
Example:
NAME CATEGORY
Karen Shoes
Karen Sports
Karen Collectibles
Karen Cars
Bob Music
Bob Sports
Bob Cars


The results that I am looking for are a sum of the total category purchases by each name.
EXAMPLE:
NAME CATEGORY
Karen 4
Bob 3

Is that something that I can do via Acces?

Thank you

View 4 Replies View Related

General :: Access 2013 - Compact Database To New Name

Jan 30, 2015

Access 2013 ... Is it possible to compact a database to a new name?

(In previous incarnations of Access I regularly 'compacted and repaired' databases to USB sticks rather than simply copy the file in the (mistaken??) belief that this was a more reliable approach)...

I can't see where to do this in Access 2013!

View 1 Replies View Related

Modules & VBA :: Multiple Regression In Access 2013?

Nov 17, 2014

I want to do multiple regression in Access 2013. with the VB code?

View 3 Replies View Related

Reports :: Merge PDFs In Access 2013

Mar 11, 2014

we are moving from Access 2003 to 2013 using Windows 8.1 64bits. We used Leban's code and library to create and merge pdfs. C

Creating pdfs can be done with built-in functionality in Access 2013. But I can't find a way of merging pdfs. I've tried Leban's Dlls files but I am getting run-time error: "File not found:StrStorage.dll" do I need to do something extra to make Leban's code work on Windows 8 64bits ?

View 8 Replies View Related

General :: How To Sum Multiple Columns In Access 2013

Nov 28, 2014

I made a new column in a table in access. The table is not linked and linking unfortunately is not an option. In the new column, I want to create a sum for 5 years of funding. There are multiple columns for a different fiscal year.

In excel, it is simply =sum(range), but I am drawing completely blank how to fill in the column with the sum data.

The end result is the data from 4 tables will be displayed in Forms and Reports.

Essentially what I need is an ability to bulk update a column in access table without a need to reupload the entire datasheet (over 100k rows with about 30 columns).

View 2 Replies View Related

Modules & VBA :: Integrating Sms Feature Into MS Access 2013?

Jun 18, 2013

I'm currently working on a project which requires integration of sms feature in ms access 2013.

The sms provider which i use for sending sms is smsglobal.

View 1 Replies View Related

Transferring Data From MS Excel To MS Access 2013

Mar 27, 2014

I am setting up a database using Access 2013, and am trying to test downloading files from Excel. For some reason it is not allowing me to have more then 4 columns in the excel file, it gives the error "Subscript out of range". I thought it was the type of variable at first, but when I tried deleting different columns on both files, the transfer always worked with 4 columns. How do I allow more columns to be transferred?Also, is there a way to not include the row numbers of the excel file as an ID column and only include the ID given in the first column?

View 4 Replies View Related

How To Create A Standalone Front End In Access 2013

Dec 18, 2013

So I have finished a database and split it which is great. Only issue now is how do I turn the front end into an executable so no access to any parts of the access program or system can happen? I have done this before in a very old version of access but how to do it in Access 2013.

View 2 Replies View Related

Access 2013 Web App - Copy All Text To One Textbox?

Feb 11, 2014

I need to copy all text from all textbox to one text box.

View 14 Replies View Related

Conditional Formatting A Table In Access 2013

Nov 4, 2013

I have a table in access and I need to format it so that when column "Status" = "Closed" column "Closed" = "yes". so it will automatically mark column "Closed" "yes" if "status" says "closed". Instead of having to change both columns all the time.I know how to do that in MS Excel, but is it possible in MS Access 2013?

View 3 Replies View Related

Access 2013 Memo Field Duplicating

Sep 16, 2015

I often get revised versions of a record and make a duplicate and edit as needed.

In 13 my memo fields do not keep line structure

line 1
line 2
line3

Instead they be come one big continuous string of text.

line 1 line 2 line3

At least a space is added before each line.

Is there a fix or is this just something we have to live with?

Of note I am using my office's Dell laptop that was just "upgraded" to Win8.1 why not 10 beats me... 7 was so much better that 8 or 8.1.

View 9 Replies View Related

Access 2013 Display Of Form View

Nov 6, 2013

My forms work well, but in form view are widely separated from the user tool bar. That is, the form is in the upper top left corner of the screen and the tool bar for choosing records is in the left hand corner at the bottom of the screen. I cannot get the tool bar in a position near the bottom of the form where it would be easier to work with.

View 9 Replies View Related

Using Images In Reports And Forms - Access 2013

Apr 29, 2015

Having trouble using .JPG images in Access 2013 reports? I inserted some images (of arrows) onto a label report. Since then, I've had problems with my DB becoming corrupted or "unstable". I can give more detail if wanted, but my main question is do y'all recommend using images in reports and forms. If so, what format?

View 2 Replies View Related

How To Collect Data From Outlook In Access 2013

Feb 21, 2013

In Access 2007 and 2010 there was a "Collect Data" group under "External Data" where I could click "Create E-mail" that would build an email form for an outbound email in Outlook based on a table. I would then send the email out, then collect the data back into the table from Outlook when the recipient of the email responded with a filled out form. I don't see how to do that with Access 2013. I do see the "Email" button, but that's for something else. I see no 'Collect Data' in Access 2013 like the picture below shows from Access 2007.

View 6 Replies View Related

Access 2013 Chart Diagram Modification With VBA

Oct 17, 2014

I would like to do two things

1.) pink arrow // I've changed the titel in a diagram with vba ... is there also a methode to move the position of the titel with vba ( left-center or rigth ? )

Private Sub Form_Current()
' KostenHinweis im Diagram
Me!Dia_WS.Object.ChartTitle.Text = _
"Preis: " & Me.[Roh-Preis] & "€/kg " & _
" Mindestbestand =" & Round(Me.MindestBestand * Me.[Roh-Preis], 0) & "€ ; " & _
" Maximalbestand =" & Round(Me.MindestBestand_Max * Me.[Roh-Preis], 0) & "€"
'Me!Dia_WS.Object.ChartTitle.Left ???
End Sub

2.) red arrow // maybe its because of the titel placement.I would like to change the size of a diagram with VBA code to have the diagram fit nicely to a given space best thing would be if there would be a possibility to resize the diagram in the given space

View 3 Replies View Related

Access 2013 Stops Working With Recordset

Jan 6, 2015

I have a database with a table and 2 forms.One form (frmList) is a list of all records in the database, and the other form (frmInput) displays fields for a single record.There is a button in frmList which runs the following script. The user clicks a record in frmList, clicks the button, and the selected record opens in frmInput. ID is a text field containing digits and an alpha that is in both frmList and frmInput.

Code:
Private Sub Command9_Click()
Dim ID As String
strCriteria = "ID = '" & Me.ID.Value & "'"
DoCmd.OpenForm "frmInput", acNormal
Form_frmInput.Recordset.FindFirst strCriteria
End Sub

This script works as expected in Access 2010. However we recently upgraded to Access 2013 and since then, this script causes Access to crash ("Access has stopped working..." dialog appears).I have stepped through the script and the line causing the crash is

Code:
Form_frmInput.Recordset.FindFirst strCriteria

I can't find any problems with syntax or anything about Recordset.Findfirst being deprecated in 2013 so I suspected some kind of file corruption. To resolve this I have tried: Compacting and repairing the databaseDecompiling and recompiling the VBA modulesCreating a fresh database and copying all the objects into it

could this be due to a missing library or something? Are there other methods of resolving a corrupt database if that is the problem? Or as a last resort is there an alternative method to Recordset.FindFirst that I can use to open a form to a particular record while retaining the ability to navigate through other records?

View 9 Replies View Related

Unable To Re-link Tables Access 2013

Aug 19, 2015

I have been developing an Access (accdb) in V2013 at home for use in my work environment. Ultimately it will be used by a small number of users in different locations hence my need to split the database into a front end and back-end tables. I have done this many times before in other versions of Access and if the location of the back-end files has been changed when you open the database it prompts you to find the new location and re-link them. Since I am carrying on the development at home/work and then taking the front-end into work/home I need Access to prompt me for the new location. However unless you remove linked tables first Access 2013 will not prompt you for the new location instead it just bypasses that and asks you to open a database so you are stuck in a loop. The database has been designed to open offering users minimal possibility of tinkering so I open holding the 'Shift key' down but this still doesn't prompt me to re-link. Why is the linked table manager not being fired up?

View 7 Replies View Related

Queries :: Access 2013 Crashes When Printing Reports?

Dec 9, 2013

We have run into a problem with Access 2013 when trying to print reports. The program always crashes. Have updated printer driver for the HP LaserJet P2035.

View 1 Replies View Related

Tables :: Access 2013 - Unable To Link To DBF Files?

Sep 19, 2013

2013 does NOT recognize DBF files, we are trying to find a solid work around to LINK to our DBF files.

There are about 30 DBF files that get updated EVERY week. And there are about 60 employees that LINK to the various DBF files. Importing is not a realistic solution given these circumstances.

View 4 Replies View Related

Queries :: How To Calculate Number Of Workdays In Access 2013

Aug 11, 2014

In the attached image I was trying to calculate number of working days(throughput) b/w item received_date and item_released date by using datadiff with "w" interval . but if I use "w" interval it brings value zero .but if I use "d" interval then it brings result with inclusive of Saturdays and Sundays.i don't need that.

How to calculate the number of working days exclusive of Saturdays and sundays.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved