I want to build a web site that people can access over the internet. I want the user to have the ability to run one of my Microsoft Access databases just as they would if the database was loaded on there PC. Is Microsoft Frontpage the answer or do you have any other recommendations of a web building software package?
THANK YOU IN ADVANCE - jOHN
Hello All
I am doing an assignment, which is fantasy football database and instead of entering the data i thought could i import the data from say another site which is updated regularly. Can it be done with VBA Access also wanted to link the database to a apache server. Any pointers on how to do this would be appreciated or if it is feasable. Have to have assignment in before Aprial.
John
I get XML's from a site and want to import the data to Access. If I use the native import then I get multiple tables and the data is a little jumbled. For instance: I get 1 table with track names and a different table for track numbers with no way to relate the to accurately. I would like to be able to parse out the XML and have it update my table as it goes so I have less "junk" in my DB. I just can't figure out how to call out the XML tag and tell it to copy that info to the correct field.
View 1 Replies View RelatedDear all,
Does anyone know if ti is possible to link an access table to one stored on an intranet site? This is used for logging help desk calls and various locations need to look at it at the same time.
I have tried it and seems to work but I get a "Not a valid file name" message
thanks for looking
I am attempting to split my Access Database and will upload the back-end portion to a SharePoint site. No matter what I do, I continue to get a "Not a valid file name" error.
View 1 Replies View RelatedI 'm downloading the excel data from the site and connecting it to access.
In excel the particular column (Time Taken) is in the format of "00:12:26".
After connecting it to access and appending it to the table, the format changed to "12:12:26", the first two digits changed to "12" and the remaining are as it is how it looks like in the excel. I need to change it to format what it looks like in the excel.
I Work For a school district and have been assigned the project of creating a Campus Improvement Plan Strictly using an access back end. I'm having some trouble sorting my data I designed the Report exactly how it has to look but I cannot get more than one entry per form on the report. So i was wondering if anyone knew a quick fix for appending to the report. Thank you
View 2 Replies View RelatedI am working on a laptop computer running MS Access version 2002. I'm trying to access a data file located on my desktop computer via my wireless network. (Same version of Access).
I can see the file without any problems, but when I try to open it I just get the following error message:
this file is located outside your Intranet or on an untrusted site. Microsoft Access cannot open this file.
Both computers are running under Windows XP. O/S: MS Windows 5.1 service pack 2
How do I resolve this?
The problem:
I have a table: TBL_INVOICES
and I have table TBL_SHIPMENT_NOTES
One invoice can have many shipment notes, so a created a
One to many relation between TBL_INVOICES and TBL_SHIPMENT_NOTES
However, the shipment notes are created earlier, thus there is no
invoice_ID when I create a shipment note.
How to deal with this problem ? Please, help ...
Наверняка ниже должна быть масса профессиональных терминов: про регистрацию в каталогах, поисковую оптимизацию, релевантность запросов, целевую аудиторию, продвижение бизнеса в сети, результаты поиска, исследования поисковых систем...
По идее текст должен содержать: Узнаваемость сайта, стратегии интернет маркетинга, контекстная интернет реклама и пр.
Документов должно быть много. Статьи по темам, помощь в раскрутке, советы профессионалов и прочее, что может быть полезно начинающему веб-мастеру самому освоить "науку раскрутки" (а фигли, мы ж не жадные ;) ). Обязательно по всему тексту должны быть расставлены ссылки на самых "вкусных" словах:
Регистрация сайта в поисковиках и каталогах
Уверен, будет текст, призванный окончательно убедить клиента сразу оплатить услугу и получить гору клиентов. Примерно такой: Мы обладаем огромным опытом в оптимизации сайтов, ведьу нас работают только признанные специалисты интернет маркетинга и рекламы. Используйте опыт специалистов в области оптимизации сайтов, знающих свое дело.
Ну вот примерно так. Представили? А теперь к делу!
оптимизация сайта (http://www.mulka.ru)
раскрутка сайта (http://www.mulka.ru)
раскрутка сайта (http://www.mulka.ru)
оптимизация сайта (http://www.mulka.ru)
оптимизация (http://www.mulka.ru)
интернет реклама (http://www.mulka.ru)
создание сайтов (http://www.mulka.ru)
создание сайтов (http://www.mulka.ru)
раскрутка сайта (http://www.mulka.ru)
раскрутка (http://www.mulka.ru)
поисковое продвижение (http://www.mulka.ru)
If you're building a database to represent a web site architecture, what's a good way to design the tables?
Would you make a table for parent sections, and then another table for the first child of those sections, and then another table for children of that child and so on? Sounds clumsy to me. What happens if a parent section can be drilled down into 15 pages deep? You'd need 16 tables.
What I'm doing is building a test plan manager for a site that has varying levels of depth in each parent category and I'm trying to decide how to develop the input/browse form.
Hi!
I need help!!!
I have made a books-database in MS access. I want to publish it on my web site. It should be possible for the visitor that search different books on my database.
I am able to write HTML code (using MS FrontPage) but how make a search form and how would the HTML contact my database (book.mdb) on my web-server?
I have find some HTML code.. for search-form but here it is used kbook.asp what I don’t understand it . I have tried to replace kbook.asp with book.mdb, but it does not working.
I have heard that there are some software that you can easily publish your database on your homesite but which software???
Kind regards, sofi
Code:<HTML dir=rtl><HEAD><TITLE>K</TITLE><META content="text/html; charset=windows-1256" http-equiv=Content-Type><LINK href="kformat.css" rel=STYLESHEET type=text/css><META content="Microsoft FrontPage 5.0" name=GENERATOR></HEAD><base target=kDown ><BODY bgColor=#EDF2EC text=#000000><FORM action=kbook.asp method=post name=SEARCH><TABLE align=center bgColor=BDCEB9 width=420><TBODY><TR><TD width=120>Choose</TD><TD width=220><SELECT name=Kids><OPTION selected value=DIV>Kids<OPTION value=CHD>History</OPTION><OPTION value=CIN>Animales</OPTION></SELECT> </TD><TD align=right width=80><INPUT type=submit value=Show></TD></TR></TBODY></TABLE></FORM></BODY></HTML>
I just found out that this years project wil be setting up a remote office location. There will be about 5 users at this location. They want complete control over all equipment. What they have in place here is Terminal Services and thin clients.
Our db is Access front end with SQL backend.
My initial thought for the remote office is:
High Speed Internet
Either CAT5 to each desk or Wireless Access Point
5 thin clients.
Using RDP they should have no problem accessing our network unless they can't all use the same public IP address for our main office.
The other thought is Setting up a Point-to-point VPN. My biggest problem is I havn't worked with thin clients until I started working here. I don't know what I would need at the remote end in order to connect the thin clients through the VPN. They don't want any servers or desktops if we can help it.
Does any one have any suggestion or thoughts on this?
Thanks,
Dan
Hi,
I need a little help with my Query design.
I have an Arrival Date and a Departure Date for campers checking in on a campsite. I need to produce a report for the warden to have to check who's on site.
So far, the best way I though was using a new field in the query for "On Site" (which isnt in the control table) and then using an expression such as...
[Date of Departure] < Date()
However this isnt working, probably for some silly oversight on my behalf.
Any help?
Thanks, Adzi.
In 2007 how do you add a site or publisher to your trusted list.
View 1 Replies View RelatedI am very new to ASP and Access. I need to learn how to create a database full of images and text to feed dozens of webpages for a new site I am doing. I have googled many times and can't really find what I am looking for. I've come across ADO several times. Is this similar to what I am looking for? Thanks.
View 5 Replies View RelatedIs there a tutorial on how to split a database so that it can be uploaded to a sharepoint site and one part of it allows updates and the other part only viewing?
View 3 Replies View RelatedI have a master table with all of my Site Names in it. I have a collection table that when a barcode is scanned it records the site name as being received. I built a query that counts the number of times the site name has been received.
What I want to do is list all of my sites from the master then display the count next to the corresponding site name. This will identify those sites that did not send in an item. Is there criteria in the query I could use so that 1) I could list all of my sites from the master table and then the count can be displayed from the collection table next to the correct Site Name?
I need to update a table at a client's site to change a couple of fields, and would like to be able to send them something that they can run on their end to perform an insert query.
I cant update the tables via RDP etc. because the database needs to be in Access '97 format, and they all run access 2003.
I also cannot get them to send me the file for updates since it needs to be online basically 24/7.
Is there any way for this to happen?
Hello,
I have installed Microsoft Access 2003 and Microsoft Access 2003 Developer Extensions. I can create Access application by using the Package Wizard.
But after I upgrade from Microsoft Access 2003 to Microsoft Access 2007.
I can't use the Package Wizard.
How can I do to solve this?
Thanks.
Hi,
I have been using "fSetAccessWindow (SW_HIDDEN)" in the open event of my
main switchboard to hide the grey Access screen from being visible behind
forms, reports, etc in this db. But when I started using a .vbs script file
to launch the db, the Access window stopped being hidden. (The reason I use
the script for launching is that it temporarily sets the db's security level
to 1 which stops the macro security warning from coming up.) Apparently MS
knows about this happening and released a technique to rectify the situation,
but I don't understand their instructions. It looks like they expect one to
have more understanding than I have. Could someone help me get this
impliemented? Here is the article:
http://support.microsoft.com/kb/167659/en-us
Thanks!
Hi!
This is Kishore, working on VB Project which is using MS-Access95 as backend.
Now, i want to change the Database login Password.
Could anyone guide me in this context.
Regards,
Kishore
Using Access's User and Group Accounts or Using a Login Form to access database?
I've been researching on how to make a database secure. How to create User and Group Accounts on access, I see the step by step instructions and tried it out myself.
I also saw some sites where they give an example of a Login Form and how to create one.
My question is do you need to create both. First create the users and groups to permit or deny access to certain forms and then have a login form?
But would that mean that they'd have to login twice? Once when the database opens because it activates the db security that was created and then login again in the login form that was created?
Also when the user logins in and clicks on the cmd button on the form which opens up another from, frmWorkLog, I have an Employee field. This field I want it to have the user's name entered automatically and "locked". So that info, employee name, is extracted from the user's login. So then the user can only see his or her records only and no one elses.
How would I go about creating that. Hope I made my explanation clear.
Thanks in advance.
I have two database applications and they are:
- the (A) application is for administration use.
- the (B) application is for normal users use.
the idea is that: I made the (A) application for administrators who have full control over the database objects (tables, forms, queries, and so on ...).
the (B) application I have created for normal users who will have only to use forms to insert some data and display data only.
but the two applications has a respective table called "vacation request" table. where I linked them, so the both administrators and users can share the data.
The real question is that: How can I prevent the users from seeing the database objects in their application. I used the database options which have helped me in hidding the database objectives when the users open the application, but unfortunately they managed to access to the database objects by pressing the special keys.
I would like to have an access to the (B) application when I want to make some modifications to the forms and then lock it from users where they only have to use the forms for requesting vacations and view the vacations.
I have a simple access search form , that's based on a query that fill parameters from the form textboxes, when the access form loads its keeps prompting for parameters value which looks ugly .. I want to open the form, displaying all the records in the table and filter when i click search ..
I have a data entry entry form, that i want to generate success message after successful insert in database. I have done it in the button event if no error happens, still if i left all fields blank and clicked save, it displays the message ..
I need to change that to display please fill the textboxes then click save , and display success message when the row is actually inserted ..
Check the following attachment for sample.
I've been using the following code successfully in Access 2003 & now I need to migrate to Access 2010. The purpose of the code is to use the items that the user selects in the list box to build the criteria of a query. Access 2010 keeps giving me a syntax error when I try to run the query & I don't know why:
My code is:
On Error GoTo Err_Command151_Click
' Declare variables
Dim db As DAO.Database
Dim qdf As DAO.QueryDef
Dim varItem As Variant
Dim strCriteria As String
Dim strSQL As String
[Code] .....
The syntax error I get in Access 2010 is:
Syntax Error in query expression 'SELECT * FROM
qryContractListSummarybyDateContract3TYPEBREAK WHERE
qryContractListSummarybyDateContract3TYPEBREAK.Rep ortableName IN('Adbri
Masonry NSW');'