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?
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 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?
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.
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).
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!!
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.
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?
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.
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?
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.
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.
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?
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.
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.
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.
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.
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 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.
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.
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?