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 Replies
ADVERTISEMENT
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
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
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
Jan 2, 2014
I want to create a Web App in Access 2013 that contains a table of client names, addresses etc, and a second table that contains order details, including client name. It would be nice to ensure that as someone adds a new order they are give a drop down menu containing existing client names, and I can see how you can do this for a brand new table using the lookup data type. But I already have an Excel spread sheet containing client names. If I import this into my Access web app to create the client table, and import the existing orders to create the order table, I then try and change the data type of the client name (in the order table) from short text to lookup, it won't let me!! (If I create an empty client table from scratch, it lets me define the company name as a lookup data type - but I can't then import from Excel into this empty table)
View 14 Replies
View Related
Jul 18, 2013
how to disable the main close button so the user is forced to click the Quit Application button on my main switchboard?
View 8 Replies
View Related
Jun 3, 2013
Is it possible to play any kind of sound file from Access?
View 1 Replies
View Related
Dec 16, 2014
I am regularly getting the error "There is not enough free memory to update your display, close unneeded programs and try again"
Access 2013 on a windows 7 machine with 4 processors and 24GB total RAM.
Today I have 14 GB free memory (unbelievable! my first laptop had 136 MB total memory!) when I got this error (Access using 38MB) which makes me believe its not a system memory issue but to do with how much (or quickly) memory is allocated to Access.
View 5 Replies
View Related
Feb 13, 2014
I've recently moved up to Access 2013 (from Access 2010) and everything went well, until one day my splash screen was blank and the program had empty fields...after seeing that all the links to the BE were OK, I re-booted and everything worked fine....until the next day the same thing happened...... The program randomly falls over about once or twice a week and I have to re-boot to cure it.....
My splash screen has a standard dlookup ( [=DLookUp("Banner","tblCompanyInfo")] ) to display the active company name...and sometimes its populated and other times its not..... if its not populated then loads of other fields on the forms are also blank - even if they point to valid data in the database!
I run Win7 (both 32 and 64bit) with Access 2013 32bit on three PC's - same problem on all!
View 3 Replies
View Related
Oct 10, 2013
Through a set of circumstances, I have had to quickly migrate a long-standing (and business critical) database from Access 2003 to Access 2013, without the sort of prepping and planning that I would normally do in such circumstances.
Most functionality appears to be working ok...
Many of my database objects, especially queries, were given meaningful descriptions.
For example, a number of queries might have been described as "Accounts Data Validation".
When I wanted to run validation of the Accounts data, I would simply sort the database queries window by description, then scroll to the relevant section and run all of the tagged queries in turn.
However, having migrated to Access 2013, although the descriptions are still shown, I can no longer sort by them !
Medium term, I could probably assign different database objects to "Groups", but we are talking hundreds, perhaps even thousands of different objects and that would be a laborious and extremely tedious process.
Any way of sorting the database window by description in Access 2013 ?
View 3 Replies
View Related
Nov 3, 2013
I have problem to create Stock query in Access 2013..I want to sum Purchasing numbers base ItemName in Purchasing table by query .. but i found error in summing?
View 4 Replies
View Related
Jan 21, 2014
I have made a new access 2013 database. I have created a linked table that has imported a substantial amount of data from an external data source, (an Excel spreadsheet). So far no problem. I created a select query that plucked data from the original table mentioned. Again, no problem. Then I decided to create another table, using certain fields only from the select query. Microsoft's guide tells me to start with CREATE, then Table design. I am happy to use just 4 fields from my query, but what I keep ending up with is a table, that, when I double click on it gives me the following:
ID Field1 Field2 Click to add
(New)
It is presumably expecting me to enter an ID number and it will come up with some record, but I want a complete table that should show several hundred records.
View 1 Replies
View Related
Apr 13, 2015
I'm working with a form in Access 2013 that uses the navigation buttons. I'm trying to have my criteria for a query link to a dropdown box on the form. I had no problems doing this in Access 2010 with normal forms, but I can't link the criteria, in the query to the Navigation buttons form box. I'm tried using
[Forms]![TheNavigationTab]![NavigationSubform].[Form]![Field]
And various forms of the above... but i still can't see to tell the query to find the critiera at this location...
View 1 Replies
View Related
Jun 4, 2007
Hey folks,
Not sure if this is the best forum but decided to put it here anyway.
I have a Access query that reads:
SELECT bleh
FROM blah
WHERE something > 10
Then in Excel I pull the data across using:
Set qdf = db.QueryDefs(qryName)
Set rs = qdf.OpenRecordset
and paste the data using
ws1.Range("IV1").End(xlToLeft).Offset(0, 2).CopyFromRecordset rs
I now want to change the query so the where statement reads
WHERE something > [amt]
So the question is how do I pass the value for the parameter value for [amt] from excel to access?
View 1 Replies
View Related
Jun 9, 2013
I have a table field that contains a lot of part numbers in different format. One could be with hyphen while others are without hyphen.
record#1 : 4535-300-34567
Record#2: 453530034567
Record#3: 4535-301-56721
In this case record# 1 & 2 are same part number only difference is hyphen.
I want to set my query parameter [Enter part number] such a way, when some one enter 453530034567 it should pull both the record (record#1 & 2).
View 5 Replies
View Related
Nov 9, 2007
Hi,
I really hope someone will be able to help me with this one as I am sure im just missing something simple.
I have an unbound form which has 20 yes/no unbound check boxes. The purpose of the form is to allow users to tick the various fields and a subform return the results. The subform, which does requery when a check box is ticked is based off a query. Initially, I wanted all the records to display before any check boxes are ticked so I have used the following criteria:
Like IIf([Forms]![Search]![Field1]=False,"*",[Forms]![Search]![Field1])
Which basically reads if field1 is no then display all records, else display all yes. Now that works fine but what I would like to have working is that if a client ticks field1, field2, and field3 it displays all records that have ‘yes’ in either field. Currently, if more than field is ticked the query treats it like:
Field1 And Field2 And Field3 And etc = true
I want to be able to select several check boxes and have the query return results for each check box that was checked. I would like to avoid doing this by having an append and delete query per checkbox.
Thank you
View 13 Replies
View Related
Jul 19, 2007
Hi everyone...
I'm a high school student working on an Access project for a summer internship. I needed your assistance in writing a criteria for a select query.
Table1 has the following fields:
ID, First_Name, Last_Name, Org, Email, Status
Only "Email" is mandatory, ID is autonumber, the rest are optional.
I have to create a query that will allow users to search the table with any of the fields above. A user may search with only one field, e.g. all users where "org" = "YMCA"
Presently, I am using the similar criteria for all the fields:
Like "*" & [Forms]![Search]![txt_FirstName] & "*"
The problem occurs when, for example a record exists with the following -
First_Name = Null or Blank
Last_Name = "Smith"
If you search for "Smith" in Last_Name, then the record does not show up, because First_Name in the record is blank.
How can I alter the criteria for it do search correctly?
I already tried:
Like "*" & [Forms]![Search]![txt_FirstName] & "*" & ""
Thanks,
Gautam
View 7 Replies
View Related
Jul 19, 2007
Hi everyone...
I'm a high school student working on an Access project for a summer internship. I needed your assistance in writing a criteria for a select query.
Table1 has the following fields:
ID, First_Name, Last_Name, Org, Email, Status
Only "Email" is mandatory, ID is autonumber, the rest are optional.
I have to create a query that will allow users to search the table with any of the fields above. A user may search with only one field, e.g. all users where "org" = "YMCA"
Presently, I am using the similar criteria for all the fields:
Like "*" & [Forms]![Search]![txt_FirstName] & "*"
The problem occurs when, for example a record exists with the following -
First_Name = Null or Blank
Last_Name = "Smith"
If you search for "Smith" in Last_Name, then the record does not show up, because First_Name in the record is blank.
How can I alter the criteria for it do search correctly?
I already tried:
Like "*" & [Forms]![Search]![txt_FirstName] & "*" & ""
Thanks,
Gautam
View 2 Replies
View Related
Aug 12, 2015
I need to lock down my DB so that the users cannot open the navigation pane. The DB opens with an AutoExec that puts them on a Swithboard form.
View 3 Replies
View Related
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
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
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 1 Replies
View Related
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
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
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
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
