I have a DB that runs on a user's pc. It creates a pdf from a report automatically at a specific time of day. The user now wants me to automatically send this pdf to his web site so that his customers can view the report over the internet. The pc that the db runs on has an internet connection but no email system (they do not want email on this pc).
I have not been able to find code to do this. I can find code for sending email but this is not what I want to do. I'm sure it must be possible but I've never done anything like this before.
Is it possible for a website to pull data from an Access database?
We have all our department's policies in a MS Access database on our server. Some of these policies need to be made available to the public on our website. I'm wondering if there's a way for the website to pull directly from the database rather than having to manually upload the policies to the site every time they change (annually, semi-annually).
Is it possible, to input information from my continuous form into a web control form. at my job we a required to tract our jobs by equipmentid and job control number(jcn). When a job is done we have to upload the id and jcn into a website to tell it is cleared. I am looking for a way for that info to automatically be filled in when i load the website based on the job i have selected in my form?
I just created a database and need to connect it to the data source. The data comes from a http website (intranet from work). When I open the link using firefox, I can view the website with the data in it, but when I open it from Internet Explorer, I get a save as pop-up message to save a csv file which contains all the data. The extension of the http website ends with csv. So it is something like http (slash slash...) Intranetname/referral_dbase.csv
Currently, I am opening the file using firefox, copying all the data manually, and pasting it in a text file using notepad. After that, I import the file into access. The delimiter of the data is this symbol: |
I am trying to find a way to link my database to the website where the data is located so that I can skip the manual process of opening the website and copying the data and saving it into a text file and then importing that file into access. I was thinking to have like a form in access with a bottom that will automatically import that data from this link and paste it into a table in access using the delimiter symbol mentioned above.
Is this too complicated? Is it even possible in access 2010?
with the linking tables thing to outlook can it be reversed. ie if i have a table that was linked to outlook outbox would the records form an email just like the emails from my inbox form a record.
i wanting to send emails automatically to many recipients. so i would have to use a record set and i thought that if i build the email in a record then have outlook pick it up then that would be the easiest way.
Our database is in access 2003. It has a form which has a button to send email of orders. I added a new user in this database. That button works in all other computers in the network with the same user permissions as this user, in his computer when he select to email Order it does nothing. It does not open the new email page in outlook and the outlook email is configured in his computer.
Any way to send auto alert without opening Ms. Access program.
I have created a program which requires to send auto alert on certain dates. Due to some travel plans manager might not be able to open the program every day (might not open the program on certain dates where I set the alerts) and the chances are he will miss those alerts if he won't open the program.
When I send an email from Access with SendObject, how does it determine the user name, the 'from' name. Is it just the user's Outlook name? Do I have any control over that?
After inputting data into a text box on a form i want to click on a command button which will open an email program and then put the text there so i can send it.
have a vba code written to have my MS Access 2007 tell Outlook to send an e-mail with several attachments to whom it may concern, but I need it to change the "From" field in the e-mail, because there's many people who can send this, but it's looking like it's all being sent as my user. This is the code, it all works, but it doesn't change the sender field. Should I make some sort of auto-login macro or something?
Call fctnOutlook("Reconsideraciones BCH", EmailTasador, Email, , Subjet, "Agradecer revisar la tasacin indicada, de acuerdo a lo pedido en email adjunto, y me des tu opinin. " & vbCrLf & vbCrLf & "Favor no responder a Reconsideraciones BCH, no recibe correos es solo para enos, enviar a visador indicado en el email" & vbCrLf & vbCrLf & "Le saluda atte." & vbCrLf & vbCrLf & usu & vbCrLf & "Seccin Tasaciones" & vbCrLf & "Banco de Chile" & vbCrLf & vbCrLf & vbCrLf, Nz(Tpath), "Yes;No;Maybe", 2, True)
I have records using a select query that I am sending to a make table. I would like to have those records excluded from being used again for 180 days, at which point they can be used again. Essentially, I have an ID and an email address which gets stored in the Make Table. I would need to ensure that if we send an email out in Week 1, we do not send an email again for another 180 days if there is activity from that same ID. On day 181, the ID/email address can then be resent.
I'm working on a vacation/time off tracker and was hoping to use the collect data feature. I've created a form where a user submits their requested date and number of hours, at which point I'd like the form to be sent to their manager for approval. The manager's email address is stored in a table. Once the manager marks yes or no, I'd like that reflected in the time off requests table, and an email sent to the requester letting them know if it was approved or not. Is this possible? How would I go about it. I'm pretty new to Access, learning on the fly, but I'm pretty good at modifying code to match my situation/working backwards if you have any examples for me to look at.
I am sending an email using SendObject. Sometimes it works, and sometimes it makes the computer freeze up with no error message. I have tried this with Outlook running or not running, seems to make no difference.
Code:
'The sub procedure below sends e-mail in response to a click on the Send button. Private Sub SendMessagesButton_Click()
'For Access, define some object variables and make connections. Dim myConnection As ADODB.Connection Set myConnection = CurrentProject.Connection Dim myRecordSet As New ADODB.Recordset myRecordSet.ActiveConnection = myConnection
[Code] ....
I have added some MsgBox () to narrow down where it crashes. It is after 'Five' and Before 'Six'. On the line:
Set appOutlookRecip = .Recipients.Add(eMailAddress)
I am mystified as to why it works OK sometimes, and not others. The email address being used is valid.
The situation is that we have a split DB on a LAN using Windows Server. The BE is on the server and the FE are distributed to each user PC on the LAN. (For historical reasons there are differing versions of Access at each user which was the primary motivation to split the DB)
We also have a copy of the DB on the company website which is to be updated via FTP on a regular basis. This is used for queries only by visitors. We now want our clients to be able to update their information on line in tandem with our local users.
The question is - what is the best method to keep these DBs synchronised?
My thought is to use replication with the LAN BE as the master DB and the website having a replicated version. Then we can periodically download the website version and synchronise the two - presumably we would have to disable the updating function on the website while we do this and then reload the new replicated version up to the website.
A problem I see already is that the website DB is not split where the local version is - is it possible to rejoin a split database? Synchronise it, upload a a replica and then split the BE and FE again?
I need some assistance parsing some information from a web address. Here is an example of what the web address is.-http://www.websitename.com/ct20/pages2/client_bcphone_service_order.aspx?client_id=160399 4&contract_document_id=924182&cipid=206123444-What I am trying to do is get the client ID and the contract id. The client id being 1603994 and the contract id being 924182. Any ideas would be appreciated.Gregg
I am having a problem with locking, and it is crashing our website. I suspect it is a locking problem because everytime the database goes down, I ftp into the site and see the dreaded *.ldb file. Access is suspose to support from 15 to 20 concurrent users, right? The log files show no more than two or three users accessing the database at the same time. By "same time" I mean within one second.
Below is the code which updates the database. Can anyone see anything wrong with this?
Also, if I wrote the information to a text file with the FileSystemObject instead to Access, would I solve the problem of locking?
BEGIN CODE -----------------
sub OpenDB(sConn) 'Opens the given connection and initializes the recordset conn.open sConn set rs.ActiveConnection = conn rs.CursorType = adOpenStatic end sub
I work for a construction company and am after a bit of advice.
We are looking in to designing a database system to manage one of our property maintenance contracts.
We want to be able to accesss and update the database using a website, so users can gain access via Laptops / Smartphones etc. For Example a plumber can log on to the site on his PDA using a username and password and view a list of jobs outstanding for him and update the status once completed.
We also want to have a section for clients where they can log on and view reports on the status of the project.
What is the best way to impliment this? I have been looking at Access 2007, SQL, Coldfusion, Sharepoint but still so confused.....:confused:
Hello! intermediate databaser here and its good to be here.
I own a bridal shop and i'm creating a website to sell my dresses. I know the first step is to have a database ready, since I have so many dresses. I have my tables done with one table holding customer attributes, including name, address, and other personal information, one holding dress attributes such as color, quantity, style, price etc., and other look up tables that has to do with the styles, colors, and quantity (up to 5). Here is where the problem comes in at:
I want to keep up with the orders placed such as the date ordered, what dress they ordered, who ordered it, price paid, shipping and handling (flat rate), etc. but I do not know how to link this up to run off the website. I would like to know what are the key fields I would need in order to place orders appropriately.
Do I need special type of tables since this will be going online?
Would this be the easiest way to go about doing such a thing?
If you could point me in the right way, or to a tutorial I would greatly appreciate it.
here is a link to my website http://www.justevents.biz if there is anyone who would be kind enough to look at it and tell me how to build an access database for the categories and search by zip, etc. i would be greatly appreciative. I have tried all the tutorial helps and built about 15 different databases and can't get a single one of them searchable under any circumstances. I have tried all I know to do.
Hi every body. I have an access database that u can see the tables and their reletionship in the link i posted. I would like to web enable this db and would like to get some suggetion on what fields should i allow to be edited and what records should i put delete option for? In order to keep the refrential integerity of the acces db.i be happy to get some feed back from u guys.Thanks
I've searched the web for almost 2 days...and i'm completely lost:
I've got a simple online DB which stores information from a webform (e.g. name, adress, order, etc). Let's say it's called: www.mywebsite.com/onlineDB.mdb
Is it possible to link the online DB to my local DB (e.g. c:localDB.mdb), without downloading it manually?
Or do I have to put the webform information in a MySQL DB and link that one to my online DB?
I would love to publish my product catalog from my access database on a website. it should be a browsable catalog with search field on article number range, product group, product type and should be able to display product pictures.Within my access database i have a link to the product picture stored by filename. I'm looking for an easy solution to do this, i'm using mysql as database on my hosting provider.I can do the export to mysql myself (interfacing between access and mysql) but am looking for some hot software to display the catalog easily without programming the front website myself. I already have oscommerce installed but don't want a webshop and don't know how to disactivate all the features within oscommerce to only retain the article browsing.Thanks if you have a hint
Hi, How I can link to website MS Access database? File->Link Tables doesn't understand http or ftp. Provider doesn't support MS Access. Thanks for your advice.
im new this forum and this is my first post, ive tried searching but if anyone could direct me in the right direction that will be great,
bassically i have created a basic Ms access databse for a hotel reservation system, with queries, reports etc. The database works fine.
I need to create an website which will connect to the database so that i can enter,view, query records from the website.
I have very little or no programming knowledge so whats the best solution. I was going to make the website in either dreamveaver or frontpage but ive read that these static websites cant connect to an database.
im sorry if this question problably has been asked a million times before but i need some advise as im a beginer.
