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
Hi
I have text file which contains different types of Record (identified by RecordType).Its a simple FLAT file having specific record structure for each type of record.
My requirement is
1.Parse the .txt file,identify record type
2.Based on corresponding record structure apply validation rules
3.Generate error report where data violates validation rules.
I am new to access . If any of u have sample code on how to parse any file and show error report accordingly, that will help immensely
Thanks
Hi,
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?
All Ideas / Suggestions welcome
Tony Randell
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
OpenDB sConnStats
'Get ID's by Names
lIdOS = GetIdOS(sOS)
lIdColor = GetIdColor(sColor)
lIdBrowser = GetIdBrowser(sBrowser)
lIdPath = GetIdPath(sPath)
lIdRef = GetIdRef(sReferer)
lIdRes = GetIdRes(sResolution)
sSQL = "SELECT * FROM Stats"
rs.Open sSQL,,,adCmdTable
'Save the data
rs.AddNew
rs("OsID") = lIdOS
rs("ColorID") = lIdColor
rs("BrowserID") = lIdBrowser
rs("PathID") = lIdPath
rs("RefID") = lIdRef
rs("ResID") = lIdRes
rs("Date") = date
rs("Time") = time
rs("IP") = sIP
rs.Update
'Terminate database connection
CloseDB
I am trying to do the following
If any one of you have experienced Abacus ticketing system, each reservation is comprised of a group of names as follows
1.1 Gul/Mohammad Atif Mr 2.1 Gul/Mohammad Adil Mr
3.1 Bond/James Mr
I have to copy the above data from the abacus tcketing system into a text box.
My question is how can i devide the above three names into three seperate text boxes.
hi, im new to both access and sql and was hoping i could get some help...
i have a string of numbers seperated by commas stored in my database. i need to count how many numbers there are in each string and then display all the results with less than 36 numbers contained.
am i able to do this with an sql statement, or am i likely to need vba??
(example string: 9.89007472991943, 12.3332061767578, 14.4694166183472, 16.287145614624, 17.5347270965576, 17.6327610015869, 16.1364498138428, ...)
thx in advance
I am using the following statement in an update query (which by the way I found in this forum) to pull out the first name from the FirstName field. The field could have a first name or a first name and a middle initial. If the field has a first name and niddle intital: John P then I get John. If the field only has a first name, I get #Error in the update field. I have thousands of records to move to a new Oracle table which has a first name field and a middle intial field.
FNAME: IIf([FirstName] Is Null," ",Left([FirstName],InStr(1,[FirstName]," ")-1))
Any help would be greatly appreciated.
Thank You:confused:
I have a field (Name) that is formatted: lastname, firstname
I need to parse the name field so I can update two fields for firstname and lastname....I have done this before, using left and instr functions, but cannot remember how...can you help?
thank you!
Tricia:)
Does anyone know of an expression I could use in a query to parse a full name field into last name, first name and middle initial?
View 4 Replies View RelatedPlease Help -
I have a field called MSG_DESC. In this field resides description of various errors i am logging.
I want to exctract only a piece of data from each field. in each field there is a value called SAP#**********
As noted above, it is 10 digits long. Problem is that there is no set place in the description where it is, so right, mid, lft trim does not work.
Can you please assist in how to extract this piece of data from the field.
Hi all,
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:
Any advice would be great.
Cheers
Craig
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.
Forever Yours
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.
View 2 Replies View RelatedHi 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
http://i5.photobucket.com/albums/y180/method007/dbreletionship.jpg
Hello,
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?
TIA,
Leon
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.
I'm trying to parse text strings by certain spaces and characters within the string. For Example, if my text string is RAST 2006-A1 B1 mtge, how can I 1) create a new field with just the RAST 2006-A1, 2) Create a field with just the RAST 2006-A1 B1?
I appreciate any help I can get. Thanks!
Hello!
I would like to convert existing MS Access forms to an internal Delphi application.
Any information about the fomat of representing forms in the Access database and the method of reading/parsing the forms would be appreciated.
Also, I wonder if it's possible to read the forms without using Window's technologies (ADO, etc)?
Thanks in advance!
Hi,
I need to design a database for a blog hosting website but I have no idea about how to do this. please please please could someone help?
katy_deacon
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
View 3 Replies View RelatedHi,
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.
Hi,
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.
any help much appreciated.
Thanks
I want to import data from a webpage using VBA and then store the HTML contents in a table (well, actually just part of the contents in fact).
View 7 Replies View RelatedI have the following string: NE1220904
I need to remove the left two characters and the right four characters of a string in a query. I have found how to remove one side or the other, but not from both sides. Thanks in advance for the help!
Hi,
Is it possible to parse, and format a textfield in a report on a line by line basis?
What I am trying to do is get a document to be processed into a printable format using reports. The text, and formatting information of each line, and any specific word details are stored in separate columns in the table. If, for example an entire line needs to be made Bold, I can get that done. What I would like to know is that if a word in a particular line needs to be formatted differently to the rest of the line, eg underlined, is there a way to do so?
For example, if I had the line as follows:
The quick brown fox jumps over the lazy dog.
I'd have the default, unformatted text as one field in the table, and the word, in this case quick, and it's formatting in another field of the table.
So rather than stating my question again, can it be done?
Thanks in advance,
Shaitan.
I am having a problem with parsing the array value to Forms!<arraryvaluehere>.dirty.
Please see the code below:
Public strListOfForms(0 To 2) As String
strListOfForms(0) = "frmForm1"
strListOfForms(1) = "frmForm2"
strListOfForms(2) = "frmForm3"
For i = 0 To 2
Debug.Print CurrentProject.AllForms(strListOfForms(i)).IsLoaded
Debug.Print Forms!strListOfForms(i).Dirty
Next i
Note: CurrentProject.AllForms(strListOfForms(i)).IsLoade d works and Forms!strListOfForms(i).Dirty does not.
Is this because it is taking "strListOfForms(i)" literally? Is there a way that I can get around this?