473,836 Members | 1,509 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access web-query problem

George Tekos
47 New Member
I wish someone could help me on the following.
My target is to choose a value from a combobox (ok with that) and pass that chosen value as a criteria to a web-query.
When I type to the criteria box>>
=[Forms]![formThatContain sTheCombobox]![NameOfComboBox]<<
and save and close, the thing works ok. The query runs and the report is accurate.
If I published the db on my sharepoint site and try to access it, its is not working. It says somehting about invalid reference to expression. Ofcourse if i removed this expression, the database is displayed properly on the web but of course the query returned all the records (and not filtered by my choise in the combobox).
I swear i been infront of my computer more than three days because of that, so you can tell how useful an information would be.
Dec 3 '11
40 7762
Narender Sagar
189 New Member
Okay, Since you are creating WebDb, and web query, So in that case WebDb does now allow to give ref. to a form for passing the criteria to a query.
So here my suggestion is, if you just want to filter the record for a particular date (I believe), then you create a query and under Criteria , right click , then click build, then under Expression Categories, choose desired field. Then click Parameters, write the field name in brackets [your date field name] and choose desired Data type. Click Ok. And Run the query. It will ask user to enter date, and show the desired results.
Dec 14 '11 #21
George Tekos
47 New Member
1) what type of query you mean?? Web one? i created WEB.
2)I assume you suggest me to involve all the fields in that query.
3)there is nothing under DESIRED FIELD, and i what do you mean by "choose desired field".??? i know it breaks your nerves but lpz be 100% specific
Dec 14 '11 #22
Narender Sagar
189 New Member
1. Yes, I mean Web query only
2. Choose desired field means, you have to Criteria for record filter under the field you want. (For your case it will be a date field for which you wanted to create combo box in a form)
Hope I am clear now. and don't worry I'll answer your queries until you get results.
Dec 14 '11 #23
George Tekos
47 New Member
ok . if i choose to create a web query, based on a LINKED TABLE, the query opens there are NO AVAILABLE fields to add, at all....you know, the small window withe the three tabs,that pops up ,after you press the QUERY button..there is nothing inside...so i cannot add fields in the query...at least automatically.
Dec 14 '11 #24
Narender Sagar
189 New Member
I would like to see your database, Can you attach it in zip format.
Dec 15 '11 #25
George Tekos
47 New Member
i am sending you the database (just before being published) on my sharepoint site
Attached Files
File Type: zip WORKING_SO_FAR.zip (58.0 KB, 144 views)
Dec 15 '11 #26
George Tekos
47 New Member
hi!! did you get my database???
Dec 18 '11 #27
Narender Sagar
189 New Member
yes, I'll get back tomorrow
Dec 18 '11 #28
Narender Sagar
189 New Member
Okay, Geroge,
I am attaching pictures for your understanding..
1. Go to design view of 'Query1' (A1)
2. Enter [Date] in criteria (A1)
3. Click 'Parameters' (A2)
4. Give parameter setting (as per picture) (A3)
5. Run your quuery. (A4 & A5)

Hope this will serve purpose.
Attached Images
File Type: png A1.png (9.7 KB, 498 views)
File Type: png A2.png (3.1 KB, 340 views)
File Type: jpg A3.jpg (18.3 KB, 431 views)
File Type: png A5.png (11.9 KB, 427 views)
File Type: png A6.png (4.7 KB, 335 views)
Dec 19 '11 #29
George Tekos
47 New Member
well, it actually works, (havent tried it after publishing though) but in the "enter parameter value" pop-up window you have to type the date yourself ..right? i mean the user has to type down, 12/12/2012 for example. can this change to a date picker box or something?? no way i think.
Dec 19 '11 #30

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

Similar topics

by: Jaunty Edward | last post by:
Hi, I am sorry to post this msg here but i could not find any group on ASP. Please forgive me for posting OT msg here but I need to get this ASP program to work with ms access instead of ms SQL... I have converted the DB now I just wanted to know should I just change the DB connection settings or there is more to be seen and taken care of. will I have to change the intire sql commands or its just the database connection setting.
by: JasBascom | last post by:
int main() { char record_typec = 'c'; record_typec = toupper(record_typec); * rec->Newcrecord.record_type = record_typec; etc etc \*********************************************\
by: christopher keller | last post by:
Hello, Using MS Access 97, SR2 mit MDAC 2.7 / 2.8 English/Deutsch we get the old problem of 'object not found' in DB2 Connect Version 8. ( From MS KB Q129814: "When you try to attach a DB2 table containing an underscore (_) or a percent sign (%) in its name, you receive the following error message". Cause: "The Microsoft Jet database engine misinterprets the underscore or the percent sign. This causes the Jet database engine to pass...
by: will eichert | last post by:
Greetings. I have a problem with a combo box incorrectly displaying blank items when returning to a form from a modal form. It's fine when the main form first comes up, but gets messed up when the main form is reactivated following opening and closing a modal form. Strangely, this was not a problem until I started using my Access 2000 db in Access 2003 (as an Access 2000 db). Details follow... I have an unbound combo box on my main form...
by: Shaun | last post by:
Ok here is the situation… Have an access 20002 application that I'm converting to have a SQL Server backend (2000), the application has been in use with an access backend for years, no real problem, just getting large so needed to migrate to SQL. I've converted the tables in SQL tables (I've used SQL quite a lot) and link the tables when the login screen for the application pops up using the following code Dim CurrTableTDF As TableDef
by: lappy | last post by:
Hello, I have written a small programme to compact an access 97 database. Dim je As New JRO.JetEngine ' Compacts database Data.Mdb to Data2.mdb. je.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=C:\Dump\DataOld.Mdb", _ "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=C:\Dump\Data.Mdb"
by: Marcin Zmyslowski | last post by:
Hello all! I have the following problem with MS Access 2003 permissions. I have two users. One is admin and the second one is user who has full permissions to enter modify and read data. I have one table and one queries which is based on this table. This query is good working for these two users.
by: jay | last post by:
Hello, The problem: When in the print screen to print an Access 97 report, in the printer drop-down list, there is only one printer shown, but it is not the printer I want to print to. There are multiple printers installed on this computer. I cannot find a way to make all the printers set up on the computer show in the Access 97 screen. This problem is only occuring in one profile. I've deleted the profile and reloaded it with no...
by: jayohare | last post by:
Hello, I have code within my DB application to process credit cards through authorize.net. Ive been using the same code for several years without a problem. I have an order entry computer and after reinstalling Win XP, we used Office/Access 2003. When we try to process CC's we get a debug screen and Access itself crashes. However, the code still runs fine on Access/Office XP. The debug screen says: Method 'doSSLPost' of object...
by: JACompute | last post by:
I have an invoicing system that uses a VB6 program to post new invoice entries to a centralized Vendor management system (also in VB6), via a Web server and some ASP code. The system has been in production for some time now, but one pesky little problem keeps surfacing periodically. System Description: 1. For each new line on an invoice, a specially formatted query line is appended to an Access database along with a blank time/date field....
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.