473,320 Members | 1,854 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Can i Filter a query in back-end from a front-end textbox

547 512MB
I can reference a query in a back-end database with this code in the row source of my list box on the front-end, but can i filter this back-end query from a textbox situated on the front-end form?
Expand|Select|Wrap|Line Numbers
  1. SELECT qrylistpatients1.*
  2. FROM qrylistpatients1 IN 'C:\pisprg\PISData.accdb';
front-end database = pisprg.accdb
the front-end form = Home
front-end textbox = sub-district

the query in backend -
Expand|Select|Wrap|Line Numbers
  1. SELECT qryListPatients.Surname, qryListPatients.Initials, qryListPatients.FirstName, qryListPatients.Gender, qryListPatients.IDNo, tblFacility.FacilityName, qryListPatients.FileNo, qryListPatients.ClientID, tblFacility.[Sub-District]
  2. FROM qryListPatients LEFT JOIN tblFacility ON qryListPatients.Facilityname = tblFacility.FacilityID
  3. ORDER BY qryListPatients.Surname, qryListPatients.Initials;
Any suggestions please?
Apr 22 '14 #1
1 1221
zmbd
5,501 Expert Mod 4TB
it is my understanding that if you have a stored query in an access backend datafile, the SQL is first transfered to the local-front-end for parsing and then execution. Rememeber, each installation of Access is acting as its own independant sever at the local level.

Therefor, if the query references a form, it will be looking for that form once loaded and parsed or it will give you the usual generic parameter prompts.

As to if you can then use this as the rowsource, IDK. Please attempt it and let us know what happens (^_^).
Apr 23 '14 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: Drum2001 | last post by:
I have a database where I need to query multiple items. Is it possible to run a query based on a textbox where the information is delimited by a comma. Example: Show me all names where...
5
by: ordy62 | last post by:
I split a database to a FE and BE but the issue is the network shares. I have several groups that need to view this database but the network paths to database are different for example. ...
3
by: DHarris | last post by:
I created a continuous form in Access2003 based on a query that users review customers and once reviewed clicks on a command button that executes an append query to update a table of the reviewed...
2
by: Kaustubha B S | last post by:
hi! this is Kaustubha from BLR , INDIA i had a doubt about Client/server technology 1) how does a backend-frontend tool in clientserver technology work and what ...
0
by: marcelo | last post by:
Could you help me out here. I need to accomplish this: I need to filter listbox items from by entering some characters to the textbox. But the problem is that items (files that are read from...
8
by: Gari | last post by:
Hello, I am trying to build a filter query with some AND and OR. I have three text boxes and 5 check boxes. The checkboxes are linked via code to other textboxes for the purpose of the query. ...
2
by: Tim Ricard | last post by:
Good afternoon everyone, I have created a very robust front end for my backend database that is essentially an all-round office database used for nearly all non- accounting transactions. I have...
11
by: eneyardi | last post by:
I used already fgetname() in criteria in one data field of a query, how can i filter query? can i use again the fgetname() in criteria in other data field of query?
7
by: yanni12 | last post by:
I have a date field in a certain query. I am creating a advanced filter Query to search one date less than another. I was able to accomplish this. The problem I am having is the blank data fields. ...
4
by: jmshipe | last post by:
Okay, so I know this sounds easy, but for some reason I'm having alot of trouble working this out. I've looked for the answer on other posts, but nothing has worked. I have a form with a text box...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.