473,836 Members | 1,241 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, second option is best. You can use infopath for customizing default form (Provided by Sharepoint list) or if you want to send your form through email. But just check, if the default form created by shrepoint list is okay with you, then follow the procedure I suggested in my last post.
Dec 10 '11 #11
George Tekos
47 New Member
Well i am working with infopath by the moment. Ive done something like a trick (according to my level of experience) because of infopath form cant open directly when typing the sites url, i created an empty access webDB to take advantage of its "navigation form" ..you know that, right? so in the form i put a photo for the design thing, and a link to the infopath form i created and this form is the one that submits data to the sharepoint list. Unfortunately i cannot get to work the form that will submit data..i have a problem with the query procedure..can you help me on that???
:) thank you friend
Dec 12 '11 #12
George Tekos
47 New Member
CORRECTION: the 1st word, of the 6th line, on my previous message is "RECEIVES" :)
Dec 12 '11 #13
Narender Sagar
189 New Member
Please write more about Problem in Query procedure. Because just mentioning 'problem' is not sufficient enough.
Dec 12 '11 #14
George Tekos
47 New Member
i dindnt want to ask you the question, before i knew how if you wer available..so now i will explain you,
i want to create a form in which i will be able to choose the DATE (from a dropdown box) press a button (that engages the query) and show up the results that refer to the pre-selected DATE value. (to the extra text boxes will have inserted before)...
i know how to make the dropdownbox show the DATE values...the thing i dont know is, HOW TO create a query that its parameter is being passed by the DATE dropdown box...i hope it was clear, and sorry for my english.
Dec 12 '11 #15
Narender Sagar
189 New Member
Dear George,
e.g. If you create a form (Dialog, set its Modal property to 'Yes')
Create a Combobox (e.g. Combo1) for DATE.
In your query (design view), You can type following under "Criteria" :
Expand|Select|Wrap|Line Numbers
  1. [Forms]![Dialog]![Combo1]
This will show result according to date chosen in the form.
But, your original problem was that when you were doing samething (mentioned above)in sharepoint web database, that time you were facing problem. is that issue resolved?
Dec 13 '11 #16
George Tekos
47 New Member
so you probably talk about Access. to set the following parapameter [Forms]![Dialog]![Combo1] means that i have to PUBLISH my whole database to the share point site, first. When I do this (Publish & Parameter) the form is not working on the site.(Im talking about Access).
If I just EXPORT my table to the sharepoint site (so it is not places in FORMS, but as a LIST, i cannot find where to set the parameters from.
1) basic question: Do i have to PUBLISH, just EXPORT table, or both?
2) second Question: after that, how do i create a form that recceives data using a DATE combo(take the existance of the combox, for granted)

thank you very much
Dec 13 '11 #17
Narender Sagar
189 New Member
1. First, export just tables to sharepoint site as lists
2. Then create linked tables from the same site
3. Then you can create queries, forms etc. just like a normal database.
4. If you still didn't understand this, pl. let me see your database and I'll guide you further.
Dec 13 '11 #18
George Tekos
47 New Member
ive done this before..but..
1)i create a WEBdb and export it as list on sharepoint site. OK
2)open a new WEBdb and right click on the table> import>from sharepoint list OK choose the LINKED TABLE at the next dialog box and the linked table is created OK
3)a))CREATING A FORM: i click ONCE on the linked table, go to "CREATE" tab, choose "WEBFORM">>>can not create a web form based on a source that is not web compatible..... . <<<<<<
b))CREATING A QUERY: i click ONCE on the linked table, go to "CREATE" tab, choose WEB QUERY", opens, the box I choose , tables,queries, all, is empty...
if i choose the NON WEBform or query, it works, but no way to present it in a website, it is not web compatible..
which db should i send you?? the one with the linked table? you wont be able to open it, it asks for connection credentials...
Dec 13 '11 #19
George Tekos
47 New Member
if you ever have the time or the will, you can reach my pc through teamviewer, to see directly what i mean...
my mail is giorgostekos@ho tmail.com
and my cellphone is 00306939527034 (if you missed call me once, i will undestand and login.) i live in greece. UTC+2.
Dec 13 '11 #20

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

Similar topics

2
1595
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.
13
2215
by: JasBascom | last post by:
int main() { char record_typec = 'c'; record_typec = toupper(record_typec); * rec->Newcrecord.record_type = record_typec; etc etc \*********************************************\
0
2038
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...
5
3324
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...
2
2149
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
5
2975
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"
39
3093
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.
1
1284
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...
0
2342
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...
0
1461
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....
0
9813
marktang
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...
0
10829
Oralloy
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...
0
10535
jinu1996
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...
1
10582
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,...
0
10245
tracyyun
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...
0
9365
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6976
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();...
0
5645
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
4005
muto222
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.