473,836 Members | 1,405 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 #1
40 7761
Narender Sagar
189 New Member
I think, instead of creating web application (by publishing), you can export all your tables to the SharePoint, and then link your Access Database tables to the SharePoint. This way, your access database will work just like your other normal database, and your query will start responding properly.
By creating web application (on sharepoint) you can not give name of forms in the query as a ref. simply because all those forms are actually not on the sharepoint site.
regards..
Dec 5 '11 #2
George Tekos
47 New Member
Mr Sagar thank you for replying.

So,
1)I will have to recreate my database in a non web-mode..the normal way, right??
2)how do you mean "link the database tables to the sharepoint"?

the point is that i want the users of the db to fill up the forms using the browser..i mean by just opening the browser and the form or something else before the form, pops up...is this possible, by just exporting the tables and linking them??
Do i have to use Sharepoint Designer to create the site, or the button that link to the form??


you understand that there are some basic things i am not aware of, but believe me just a piece of instructions from you and i will make it ! :) thank you very much
Dec 7 '11 #3
Narender Sagar
189 New Member
Dear Mr George,
The method is that you can create tables and exported to a sharepoint site as lists (This will be backend for your database). Then you can link the tables to the Access database itself to the sharepoint site. Now you can create everything like queries/forms/reports etc. in the Access Database (which will act as front end for your database), And distribute this frontend. Now you can distribute users the copy of this database for their routine use.
Please note that you need to have MS Access 2010 for this. (I am not quite sure for MS Access 2007)
This way user can have full potential of MS Access database. The beauty of this is that, even when the user is offline or if the site link is down (due to any reason) users can still work normally and the data can be synchronized whenever the link is up.
You don't need sharepoint designer for this. (But if you have it you can o course use it)
Hope I am clear..
best regards
Dec 8 '11 #4
George Tekos
47 New Member
you are very clear. I will try this method, and it really sounds THE ONE. I guess it is not a problem for you if i asked you more questions while working on it?!!

In case i made it, i am willing to pay you for the potential solutions you offered me. please, it is something that must be done, so i can feel comfortable. Anyway! thank you again and i will write you again.
George
Dec 8 '11 #5
George Tekos
47 New Member
unfortunately i spent some more hours but didnt make it.
Of course i saw how the thing, you described me works, but its impossible to create a web form (which is the only object that can be browser-viewed) even based on a linked table...
i wish i am mistaken..

you see its crucial to me, the users to JUST open the browser and fill up the forms, because some of them will be parents and i cant tell them to download or, set up their access for that..
Dec 9 '11 #6
Narender Sagar
189 New Member
Okay, for this you can also use, MS Infopath form. You can create the form and publish it on your sharepoint site. Users can fill the form and data will be stored in your sharepoint database. You can also send Infopath forms through email. And best part is users just have to click reply on their mail (through outlook) and fill up the information right there, and send it to you. Moment you receive the mail, the data will get stored in your database.
Only condition is you have to have Office 2010.
kind regards..
Narender
Dec 9 '11 #7
George Tekos
47 New Member
yes. this is another thing i forrgot to tell you. last night , which i spent on my computer :) i was working on infopath. i published a form anyway (after enabling services on server, on sitecollection etc) but the result was as in every tutorial i saw, that the form opens in browser After the user gets in a LIST and presses NEW DOCUMENT (or ADD DOCUMENT)...i mean i would like this WebEnabledInfop athForm to open when entering a site ...(and i couldnt find a hyperlik for that so i put it on a webform, for example!
Dec 9 '11 #8
Narender Sagar
189 New Member
Hi Geroge,
If that is only the issue, you can just right click on the "Add New Record" link. Click Copy Shortcut. And you will have direct link to the form. You can circulate it to the users. And it will directly open the form for the users. I just checked it on my sharepoint site and it works perfectly fine.
Dec 9 '11 #9
George Tekos
47 New Member
i will explain you.
i have a sharepoint site. i can access it by typing http://server.
on this site i have exported a table from access called MAIN_TAIBLE.
(all site content and it is there).
i open an infopath form. should i open it blank or to create one FROM SHAREPOINT LIST??? probably the second. right?
Dec 9 '11 #10

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
9661
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,...
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
10247
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
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...
0
5815
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4446
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
3
3108
bsmnconsultancy
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.