473,836 Members | 1,265 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 7759
Narender Sagar
189 New Member
Yes, user has to type the date. No, you can't change it to date picker in web query.
Dec 19 '11 #31
George Tekos
47 New Member
too bad.. you understand that this solution is not that easy for the users...
Dec 19 '11 #32
George Tekos
47 New Member
i really wonder why this function is not working. it sounds crazy, microsoft has not programmed something like this..
Dec 19 '11 #33
Narender Sagar
189 New Member
You can at the most write "[Enter Date in dd/mm/yyyy format]" in the criteria place and write same thing in Parameters. This will give users clear idea how to write the date.
Dec 19 '11 #34
George Tekos
47 New Member
ha, yes i tried this actually but in my language so it came up with an error somewhere after..i think i will try it in english again..have you checked that the whole thing works on sharepoint , right??? not only locally..
Dec 19 '11 #35
Narender Sagar
189 New Member
Yes, I have checked it works on sharepoint.
Dec 20 '11 #36
George Tekos
47 New Member
i am creating the final version of the db with the graphics and the rest!!! i have not tried the query trick yet, but if you told me it works, it works.. can you tell me something else please?
in the inputform there is the date picker ok? i want to disable the direct typing on the box, but choosing form the popup calendar. i have also made it Unique and Required but dont know how create my own validation rule, so if someone types something extra or doesnt give a date, a message to show up..is it possible ?? thank you a lot.
Dec 20 '11 #37
Narender Sagar
189 New Member
George, as per this sites rules, you have to start fresh thread for different questions. You can close the existing thread, if this serve your purpose. And post a new thread with details, I am sure you will get help from the members of this site.
Dec 21 '11 #38
George Tekos
47 New Member
ok i will right now.
Dec 21 '11 #39
George Tekos
47 New Member
Mr Narender Sagar, i tried to use the "parameter way" but didnt work. I am using a button that points to a report, based on a query. when i run the button locally, it shows up a parameter window, i type the date and the appropriate results show up. but this parameter window doesnt appear after publishing..can you explain me how you made it work?
Dec 21 '11 #40

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: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
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: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
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: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.