Running Apps From Forms

Dec 11, 2006

Hi,

Im running a very simple app from a link inside a Form - heres the code

stAppName = "D:invoicesurl2bmp.exe -url http://sandbox/customersinvoice.asp?ID=XXXX"

I need the ID field to be the same ID as them record that is selected

does anyone know what code i would have to put in there to make it change from record to record??

Thanks

Don

View Replies


ADVERTISEMENT

Make MSGBOX Come Up Over All Apps Running

Jun 19, 2006

I have a form that runs a timer every 5 minutes. Depending on what I have put in another table it displays a message (or not) to the user with message details. However, if the user has multiple applications running and the Access application is not currently being used by the user (i.e. they may have Word running and have minimised Access) then the msgbox does not appear. So...

When I display the MSGBOX how can I make it override any application running so that the user is always immediatly aware of the message?

Thanks

View 4 Replies View Related

Make MSGBOX Come To Top Over All Apps

Jun 19, 2006

I have a form that runs a timer every 5 minutes. Depending on what I have put in another table it displays a message (or not) to the user with message details. However, if the user has multiple applications running and the Access application is not currently being used by the user (i.e. they may have Word running and have minimised Access) then the msgbox does not appear. So...

When I display the MSGBOX how can I make it override any application running so that the user is always immediatly aware of the message?

Thanks

View 1 Replies View Related

Adding Tables In A Front/Back End Apps.

Nov 12, 2007

Hi Guys,

Thanks for all your help on my last post, again have a problem to update the application, Everything works well but then I need toadd an extra table on my app. At first I thought I can add a table on my Back-End but when I open the Front-End it wont update.

Can someone out there help me how to add a table on apps. from the ground up?

Thanks in advence.

Jepoy

View 5 Replies View Related

General :: Building Multiuser Apps With Access?

Aug 6, 2014

I've always setup Front Ends and Back Ends so that a copy of the Front End is distributed to each Desktop.

I've now joined a new company (been here 6 months now) and the way things are done here is that one copy of the FE sits on a share and users open it from that location. This file contains no local tables and all data is connected to either Access or Oracle databases using ADO. The FE has built been utilizing User Defined Types to read all data in to memory.

View 10 Replies View Related

General :: Query Parameters In Access 2013 Web Apps

Feb 2, 2014

I'm creating my first web app with Access 2013 and I'd like to allow users to run a query after supplying a parameter to be used in the query.Simple example might be to display a list of all records that contain a date older than "x" in a particular field - with the user supplying the value for "x" I understand that query parameters don't work with the web browser and that I need to use a macro to request the input of "x" and pass it to the query, but I can't find any examples of this kind or macro action (OpenDialog, I understand from Jeff's book).

View 3 Replies View Related

Forms :: Making Forms Invisible When Code Is Running

Jan 12, 2015

I'm opening forms to get data then closing using VB code.

Is there a way to stop the screen showing these forms as the code runs

something like Display refresh off then display refresh on.

Just to hide my workings.

View 1 Replies View Related

Running Balance As Opposed To Running Total

Mar 14, 2005

Can anyone tell me how to get a running balance on a report. I know how to create a running total, by setting the "running sum" property of a text box to "Over all".

I can't however see how I can adapt this to give a running balance (as in a bank statement for example). Attempts to do so end up in failure!!

Many thanks in advance.
Peter

View 2 Replies View Related

Running Total In Forms

Oct 23, 2005

I have a form that calculates number of hours each month. So a little box for Jan, Feb, etc.

At the bottom I have another field that sums it up. Well Im using just basic + to add the fields and it only works where there is something in each box.

I can't go through and put zeros in for everyone since a 0 and a blank mean two different things. I tried Dsum and just now after searching the forum, I tried nz.

Am I overlooking a real nice function that would assume a blank entry in the sum is a zero? or perhaps some trick I could try? Also, is there anyway to store the calculated total in the associated table, so I can query it later? It already has its own specific field that up until now was hand calculated and entered manually...like the monthly hours.

Thanks in advance

View 3 Replies View Related

Forms :: Running A Subsequent SQL Query

Oct 2, 2014

I am writing VBA code behind a form that used SQL SELECTS on various tables - the results of one query determine the next. I`m using the ADODB object library:

strSQL = "SELECT * FROM Table1 WHERE Field1 LIKE " & value1
objRecordSet.Open (strSQL)

Then later:

objRecordSet.Close
strSQL = "SELECT * FROM Table2 WHERE Field1 LIKE " & value2
objRecordSet.Open (strSQL)

But, when I access objRecordSet.Fields.Item(x).Value it shows the results of the first SQL statement, not the new one. I'm trying to find a way to reset the object - is there a way to do this?

View 1 Replies View Related

Forms :: Trying To Create A Running Total - DSUM?

May 9, 2015

So I'm trying to create a running total, to be able to graph a cumulative total. After looking around, I think I've figured out that I need to use a DSUM formula.I basically want to get a cumulative sum of profit in the 4th column.

View 7 Replies View Related

Forms :: Running Code On Individual Records

Mar 20, 2015

So in my database i'm creating a live form that will open up a list of patients and when they are seen. one of the bits is a button that before they arrive says "Not Arrived" and after they arrive it says "Arrived". The code works fine:

Code:
Private Sub Command68_Click()
Dim C1 As String
Dim C2 As String

[code]...

The problem is after clicking the button on any of the records, it changes the text on all records, to wit: I tried to attach images or links to images, but my post-count is too low. The before-click screenshot is /3QnBkgG on imgur. The after-click screenshot is 9VZWzzp on the same site.

Bear in mind I've only clicked the button (it's white, so it doesn't look like a button) on the top record.The form is set to continuous forms, not sure if that has anything to do with it.how I can get the code to run on individual records, rather than applying the first-record's results across all records?

View 12 Replies View Related

Forms :: Running Net Value Field In A Subform For All Records

Sep 25, 2014

Is there a way to add a field to a subform that preforms a net value calculation on all the records in that subform?

Fields:
Record ID ItemAmt PaidAmt Need a Net field here? (not part of form; description only)
1 500.00 100.00 400.00 500.00-100.00
2 500.00 50.00 350.00 400.00-50.00

The Item Amt is referring to the main form and should be the same amt.I need the Net field to act as a running balance.

View 11 Replies View Related

Forms :: Running SQL Statement With Combo Box Values

Apr 4, 2013

I have a form that has a combobox with table names in it. I want to execute a very complicated SQL statement but I want to put the table name (from the combobox) into the SQL statement. I'm planning on making a button to do this, but I don't know how to put the SQL statement in VBS which would use the combobox value as the table name in the SQL statement.

View 2 Replies View Related

Forms :: Running Total Of A Field From A Form?

Jul 15, 2015

=([frmservices_2013].[Form]![sub2013])

I have this expression in a field on a form. It's been a really long time since I worked in Access. Is sub2013 a field on a form, in a table?

It's doing a running total of a field from a form. I can't find a subform with this name, or a field anywhere, I'm drawing a blank.

using Access 2007....

View 4 Replies View Related

Forms :: Display Form Without Running Query

Mar 29, 2014

I have a form with a select query running as record source. Once the input for the select query is entered the form runs. Then after that there are some manipulations in the form and it is displayed. In this second phase the form must be displayed without running the same query again. How can I do this?

View 8 Replies View Related

Forms :: Application Running In Full Version But Not In Runtime?

Apr 11, 2014

I have a small database application which is split in fe and be. Its running fine and i have been making changes to the front end regularly and replacing the file on server successfully with no problems, But today i edited some forms and reports and afterwards i ran it on a client in access runtime produced the on click event error ( which is on log in form which is a startup form ). Its working fine in full version of access even on the server but couldn't log in because the clicking on login button display the error. See attached image.

View 6 Replies View Related

Forms :: Running A Query Based Upon A Listbox Selection?

May 1, 2015

I have a list box that is correctly listing resources from a table (tblResource). I would like to select one of the list box entry and run a query against the tblResource to show the information for that resource in a form. I have tried to use the lstindex with the control (lstResource) in the where clause of a query to accomplish this with no success.

View 5 Replies View Related

Forms :: Strange Font Effect While Running Through Records

Nov 28, 2013

It is a strange effect I get when switching among records.

In a form I have a TAB Control with some pages, when I open the form everything is ok:

But, when switching continuosly among records, the font becomes strange, looking like being bold.

It seems to happen only when using TAB control or, if you prefer, only on every TAB control's page except for the first one. Tried on different pc with different resolution.

View 2 Replies View Related

Forms :: Budget Tracking Database - Running Balance On Form

Mar 15, 2015

I have a database tracking a budget. It is like a cash boom. I have deposit and make payments. Supplier, invoice# etc. I would like my form to show a running balance of my deposits and expenditure.

View 3 Replies View Related

Forms :: Running A Query Based On User Selection Criteria On Form

Jan 9, 2014

I have a form which lets the user enter a contract ID and then a combo box that has a list of reports which run against whichever ID is entered.

What I want to know if I put the ID's in a table if theres a way to allow the user to select multiple ID's in one go and run the report against them the range rather than 1 at time?

I'm thinking about utilising the check/tick boxes would this be possible? or another way?

I'm using 2003 and have some VBA ability.

View 5 Replies View Related

Forms :: Web Browser Control Leaves Process Running After Quitting Application

Jul 1, 2014

I'm on Access 2010

I am using a web browser control on one of my forms The problem is that when I close my application down, after using the form with the wbc, an access process keeps running in the background. More severe: every time I start my app again and close it, another access process is added to the processes that are already running.

View 14 Replies View Related

Forms :: Create A Message Box To Flash On Screen To Tell User That Update Code Is Running

Mar 6, 2014

I need to create a message box or a form or something to flash on the screen to tell the user that a piece of "Update" code is running. the update code will be updated reports from marketing returns, but the 3 branches who use the information are separate so I am creating an update form to download and update the table.

The code for the update is already working, but can take a while, so I thought a message or splash screen would be useful as the update runs on start up.

It would have another use, I have a report which is made mainly of calculated fields on an onPrint event and also takes a while to work it out, so a similar screen would be more useful than my current spinning circle and blank screen.

View 1 Replies View Related

Forms :: How To Use Data On A Form When Running Code Before Closing The Form

Feb 4, 2014

I have a bound form with a few fields. I would like to run a sub after some of these fields are modified, but not others. I would like it to run only once, after user finishes his work on the form.

When using the Unload event - the form on the form is not there anymore (or did I get something wrong?).

Is there a way to trap Data on form just before the form closes?

View 4 Replies View Related

Running SQL From Another SQL

Oct 8, 2005

Hi

I want to open a DAO.Recordset from an opened DAO.Recordset.

My code is like this

Dim db As DAO.Database
Dim rs, rsMarks As DAO.Recordset
Dim strSQL, strMarks As String

Set db = CurrentDb()

strSQL = "SELECT Name, SurName, Marks from Table1"
Set rs = db.OpenRecordset(strSQL, dbOpenSnapshot)

strMarks = "Select Sum(Marks) As MarksSum from rs"
Set rsMarks = db.OpenRecordset(strMarks, dbOpenSnapshot)

rs.MoveFirst
Me.txtName = rs!Name
Me.txtMarks = rs!Marks
Me.txtSurName = rs!SurName

rsMarks.MoveFirst
Me.txtMarksSum = rsSur!MarksSum

rs.Close
rsSur.Close
db.Close
Set rs = Nothing
Set rsSur = Nothing
Set db = Nothing

But I got an error message “The Microsoft Jet Database engine can not find the input table or query ‘rs’. Make sure input table or query exist”

While without this second 'rsMarks' my first SQL 'rs' works well

I will be grateful if any one help me.

Regards

Rahulgty

View 7 Replies View Related

Running Sum

May 15, 2006

Is there a function for cumulative row for use in querys (calculated field) or in a code - something like "running sum" in reports?

View 2 Replies View Related







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