Forms :: Cannot Open External App Using Shell In Access 2013

Aug 19, 2014

In previous versions of Access (i.e 2003 and prior) I could use the following code in the On Click event of a form's command button to open an external file:

Dim stAppName As String
stAppName = "C:Program FilesCadroTransPost PlusTransPostPlus.exe"
Call Shell(stAppName, 1)

However, I'm now using Access 2013 and it wont allow me to use this anymore, it gives me the following error:

Runtime Error '5"'
Invalid procedure call or argument

Why this doesn't work in Access 2013?

View Replies


ADVERTISEMENT

Modules & VBA :: Send Email From Access 2013 Through External SMTP Server?

Jun 5, 2015

I have Access 2013, Win 7, Outlook 2010 (32-bit).I want to send an email from Access, but not through Outlook. Instead I want to connect to an external SMTP server. I've found a few examples that doesn't work for me. With code including for example

Code:
Set ObjMessage = CreateObject("CDO.Message")

I get an "Error 429: Object can't be created in Active X-component" (My translation from Swedish).With code including this:

Code:
Dim oEMail As New CDONTS.EMail

I get "user defined type has not been defined" (my translation again).I have working code for sending email through Outlook, which works fine. But, Outlook adds a lot of span tags, making it impossible to read for certain screen readers used by visually impaired people, therefore I can't use Outlook.

I've tried to read up on the matter (CDO), and think that maybe the CDO library etc is not included on my computer?can I download it?

View 10 Replies View Related

Modules & VBA :: Shell Function To Open Calculator

Dec 17, 2014

I want to open the Calculator by clicking a command button (using the On Click event).

I have tried the code below but can't get it working. What do I need to change?

Private Sub Command7_Click()
Dim RetVal As Integer
RetVal = Shell("C:Windowscalc.exe", 1)
End Sub

View 2 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

Forms :: MA Access 2013 Before Insert Raise Validation Error

Oct 11, 2014

I use before insert code procedure to insert default value for one, or more fields in row. It is normal to have these fields are disabled. This event occurs when you try to enter a value in any another field in a row. However , when I finish entering the field going to the event before update regardless and trigger a validation of all fields in a row. I am not leaving from row , I want to go further input in other fields.How to insert default (calculated) values in new row.

View 2 Replies View Related

Forms :: Access 2013 - Multiple Data Sets On Chart?

May 5, 2015

I have a simple line chart plotting price against date.

I would like to plot a secondary line on this chart from an array of data that I calculate. I've searched hi and low but can't seem to find a way of doing this.

The closest I've found is from this:-

[URL]

I can create my array of data but I can't seem to get it to work and think it may be for pivot charts....which access 2013 can't do anymore.

how to plot multiple data sets on the same graph in Access 2013.

View 9 Replies View Related

Forms :: Entering Data Into Table - Syntax Error With Access 2013

May 20, 2013

I am pretty new to access and trying to create a form to enter data into a table. I keep getting a syntax error. Below is the part of code where I keep getting the syntax.

CurrentDb.Execute "INSERT INFO [Tb1 - Information]([Zone], [Controller], [Controller Type], [Panel], [CB #], [Controller Unit], [IP Address], [Modbus Address], [Sub Address/ HTC#], [PP Location], [Opp Priority],[ Startup Priority]) " & _
" VALUES('" & Me.Txtehtzone & "', '" & _
Me.Txtctrler & "','" & _
Me.TxtCB & "','" & _

[Code] ....

View 1 Replies View Related

Forms :: Prevent Duplicates From Multiple Drop Downs In Access 2013

Jul 28, 2015

I'm in Access 2013 and I built a form with multiple drop downs. Here is what I have in the same order of which the user must choose from......

Document "Field Observation", "Monthly Inspection", "Safety Roster" (The user must first choose the document from this drop down he is recording)

Supervisor "First & Last Name" (The user then chooses the first & last name of the specific Supervisor name he is recording the document for from this drop down)

Manager - This field automatically populates based on Supervisor.
AOR - This field automatically populates based on Supervisor.
Org Unit - This field automatically populates based on Supervisor.

Month "January", "February", etc. (The user then chooses the Month of which the document will need to be applied to)

I would like the form to trigger an error with "This document is already recorded for this month" when the user chooses "Monthly Inspection" OR "Safety Roster" for a specific "Supervisor" for a specific "Month" that is already recorded in "TBL_DataTracker". The TBL_DataTracker is where all of my records are stored.

View 14 Replies View Related

Forms :: Syntax To Refer To A Control On Nested Subform In Access 2013

Mar 20, 2014

I have searched to find the correct syntax to refer to a combo box control on a nested subform. All the examples I've found Access 2013 will not recognize or find the appropriate control.

I have a parent form called IncidentDetails. On that form I have a control called ctrlLogDetail. Within that control is a form called sfrm_LogDetail. On sfrm_LogDetail, I have a control called ctrlType which houses a form called sfrmType. On sfrmType, I have a combo box called cboType. I need to be able to place the cboType choice into a query to filter records for another combo box on that same form. the query works appropriately when I have sfrmType open, however as soon as I try to call the query from the IncidentDetails form, Access cannot find the cboType control.

I've tried multiple variations of the syntax to call to cboType that I've found online. I found a very useful reference from BTA Development: however the syntax there will NOT work in Access 2013.

What is the appropriate syntax would be to get to my control within my 3 deep nested subform? I'm working Access 2013 and won't have a choice regarding Access versions.

View 5 Replies View Related

Forms :: Access 2013 - Click On Memo Field And Hit Enter To Go To New Line

Apr 12, 2013

When I click on my memo field and hit enter to go to a new line, it moves to a new record. Where do I look?

View 2 Replies View Related

Forms :: Input Data Into Multiple Tables Using Single Form - MS Access 2013

Jan 15, 2015

I have 5 tables that I would like to input data in. It can only be done with a single form. The fields I want to input in have the same names in all 5 tables, for example:

Table 1:
Name
Age
DOB

Table 2:
Name
Age
DOB

Table 3:
Name
Age
DOB

Table 4:
Name
Age
DOB

Table 5:
Name
Age
DOB

Is it possible to input data into all of these fields in each table using one textbox for each field?

Preferably without having to use code but if it cannot be done without it then that would be fine.

View 7 Replies View Related

Forms :: Change Textbox Color On Form In Access 2013 For Dyslexic User

Apr 29, 2014

I have a new staff member in my office that has informed me that she has a degree of dyslexia. To assist her I've trialled changing the textboxes on one form in my Access 2013 application to a light pink color & this has instantly worked for her to read/input text.

Is there a way to automatically change each textbox to light pink on every form in my application on startup based on user login (say using an IIF statement in the OnLoad event of the startup form).

View 4 Replies View Related

Open External Database?

Oct 3, 2006

I was wondering is there a way to open up another database from within a database? Not to combine but just to open another one up instead of looking for it on a drive....

View 2 Replies View Related

Forms :: Access 2013 - Adding Cross Close Command On Tab In Tabbed Documents Mode

May 25, 2015

I would like to add a cross close command on the tab in tabbed documents mode. Is it possible to accomplish?

View 2 Replies View Related

Access 2003 Shell Error

Jul 20, 2006

Hi

I am attempting to open an Access db from another access db like this:

varDST = mymdbpath
varEX = path/msaccess.exe

varSHELL = Chr$(34) & varEX & Chr$(34) & Chr$(32) & Chr$(34) & varDST &
Chr$(34)

Call Shell(varSHELL, 1)

but I get this error:

MS Office is unable to open the data access page
The field does not exist etc
or
The file you attempted to load not recognised as HTML etc.

It works ok in Access 2000

please hlp.

Thanks
Andy

View 3 Replies View Related

General :: Hidden Access Shell / Runtime And Print Preview Custom Ribbon

Dec 17, 2013

I have created an application. It has a split front end and back end. I plan to distribute the runtime version. I have used code throughout that "hides" the microsoft access shell for popup (modal) windows. In every form & report I have a function to show or hide the access window. Everything works great until I get to my reports. I open reports in print preview. I created a custom table (USysRibbons) and added a Reports print preview ribbon & xml. I assigned that ribbon to my report(s), and I assigned it in options as the default ribbon. If I test the ribbon (by working in the database using "shift" open) I see my ribbon. But, in when I open app without shift or or if I emulate runtime, I can't get the ribbon.

I have multiple popups forms, several non popup forms and a couple of reports.I just want to keep all the access background stuff hidden - except for needing the ability to print.

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

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

Forms :: Open Access In Design Mode From Within Access

Jul 23, 2014

Can I for instance while my db is open, open it in design mode from my form via code?

View 3 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

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







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