How To Make Checklists And Other Info Docs From 'database' ???
Jan 16, 2007
Non-techy IT type of question...
How to best setup a database (knowledgebase) for use in making various work place hardcopy and electronic intetacive version process checklists that may share some of the same info ?
Eg, checklists for a building dept for how to get permits for different types of buildings that may all require some of the same types of plans and permit application docs, but may also require other plans/docs specific to the particular type of building... but in order to update a requirement in the checklist/s only one database item would need to be changed in order to update all the checklists that include that common item.
Then to carry it one step further... to use the same database to update info publications that may have checklist type information in the narratives about the same building permit requirements.
Hope that makes sense.
Thoughts ?
Where else to look ?
My application is a series of checklists, represented each by a table. They all have a common "Job ID" which is entered by the user in the first form/table. This "Job ID" is a common value with all other tables.
What I want, is that the user doesn't have to enter the "Job ID" every in every form. I just want him to enter it once in the first menu, and then it's copied automatically to all the other tables (creating a new record in each table).
Im doing a login page for my website, and i am having trouble connecting to the DB:
'Database connection info and driver strCon = "DRIVER={Microsoft Access Driver (*.mdb)};uid=;pwd=letmein; DBQ=" & Server.MapPath(strAccessDB)
where strAccessDB = "cs334-45/Kosy/Kosy.mdb"
cs334-45 is my computer name in the virtual directory.
Im getting this error:
Server.MapPath(), ASP 0172 (0x80004005) The Path parameter for the MapPath method must be a virtual path. A physical path was used. /Kosy/check_user.asp, line 21
I dont understand. I thought that the virtual directory was mapped to the physical directory anyway? So why do I have to enter a virtual path?
I have searched this topic but can't find exactly what I'm looking for so I hope someone help.
I have a directory full of doc files which are constantly being updated. I would want to be able to browse the directory from Access and click on the relevant file to open it directly.
So there's no storing the pathnames in a table etc...just open the doc to view.
Quick overview so you understand: I have two databases, one which contains form(s) that allow users to enter in legal type cases. It has a subform in which has four fields to insert OLE objects. This form draws its data from a linked table in a database called Attachments. Not all cases have 'attachments' & the attachments are associated to cases by case number.
Anyway, my delima is - I am trying to make a less 'clunky' way for the end-user to insert objects to the cases. Currently, they can click on a button that will open the Insert Object box. It isn't that complex for a developer to use, but the regular end user, it is quite complex. Also, once an object has been inserted, it renames it. (FYI: These objects are being imported & not linked) When inserting the object, you can decide you want it to be an icon shown in the OLE field & thus you can name it there. But the problem is, if you double-click to open the document it gives it a new name that is associated with the form name. It does not retain the original file name. Does anyone know of a way for it to retain the original file name??
That is my 'biggest' problem here since these files maybe updated & even emailed - Being that they are legal documents, it would be good that they retain the name. I have just begun to use OLE objects fields so I am very, very new to this.
Just looking for some more advice I am creating an application that contains employee details in access. I have the majority of the database working but I am stuck on a couple of thins, Firstly I would like to add the option to be able to add an employees CV to the databse and an option to open this. I found a good example that I thought would help me and it did in post 11 of the thread below but I cannot get the files to open in MS word so they can be viewed. The majority of the files to be opened will be ms word format. I just get the error object doesnt support this property or method
I have a access database with 125 names and addresses and need to merge and send out the a doc for each one. Does anyone have experience with the multiple factor of this process. I can merge one but then have to repeat several times.
I want to filter a database based on the info typed into the text box, after this, clicking on the button search and filter the database..I have an issue in my code, because I know just how to filter it based on a field but not for all..The fields I have are: Batchnumber, ModelnumberID, OperadorID, Datet, TestResults, Units and Status
I am very new to access and have a question which I think is very easy to answer. What I have is an access file with a listing of companies, their contacts and what services we provide for them. (each company/client/service is listed in a row with each new set of information on the row below it).
What I am looking to do it to create a data access page that anyone in our office can view. I want the access page to have a text box where they can type in the name of the company, then click a 'search' button. That will then display the results in a box below everything. The results would be the contact and the services (there are other columns in the datasource as well, but I didn't list them).
If anyone can shed some light onto my problem it would be most appreciated!
Is it possible for me to give them access to part or all of the database so that they can run queries to target venue mailshots etc if so how would i do this?Secondly my concern is that the database is valuable and I want to protect myself from potential theft of info, ie what stops them taking the database and using it for there own purposes?
I want to create a country info database. For example, Qatar (country) and the Driving info required when driving in qatar and the visa info required.
I would like a form with drop down options and when i selected which country and then driving or visa, at the bottom it would display the specific info based on my selection in a memo field lets say.
I have an access database and I plan on splitting it so the FE will be on each users workstation and the backend will be in a folder on the server. But is there anything else I need to do to allow for the possibility of multiple users using the database and changing info at the same time?
I want to develop (create) a database using MS Access 2007 or 2010 about Amazon.com.
My ideas are:
1. Create a form to lookup items in the actual amazon website, and then sort the results of the search. 2. View the results. If I select Add to Cart or Add to Wish List, send the item information to my Access database.
I'm using this code which I think Came from a Button Wizard many moons ago but when I use it It opens the app for the function but does not display the default Blank Doc.Could anybody point me in the right direction for getting them to show the default blank DocsMany ThanksMickPrivate Sub CmdRunWord_Click()On Error GoTo Err_CmdRunWord_Click Dim oApp As Object Set oApp = CreateObject("Word.Application") oApp.Visible = True oApp.Caption = "Database Dreams - Word"Exit_CmdRunWord_Click: Exit SubErr_CmdRunWord_Click: MsgBox Err.Description Resume Exit_CmdRunWord_Click End SubPrivate Sub CmdRunExcel_Click()On Error GoTo Err_CmdRunExcel_Click Dim oApp As Object Set oApp = CreateObject("Excel.Application") oApp.Visible = True 'Only XL 97 supports UserControl Property On Error Resume Next oApp.UserControl = True oApp.Caption = "Database Dreams - Excel" Exit_CmdRunExcel_Click: Exit SubErr_CmdRunExcel_Click: MsgBox Err.Description Resume Exit_CmdRunExcel_Click End Sub
I have created a table with ole object types and linked word documents. I am now trying to create a report with the word documents showing up. The problem is that the size of the word document varies, some are half a page some are several pages. When I create the report with the object frame, I can't seem to find a control property to 'can grow'. Is there some way, possibly using VB, to create that feature. I'm thinking the VB way might be to access the embedded file and find out it's size and then size the object frame accordingly. I don't want to make the frame set to the largest document because then there will be blank pages that I don't want in the smaller documents.
Lets say we have 100 documents. 30 of these documents contain the same exact set of instructions that i want to update/change. what options would i have that would allow for this 'mass update' so that i can change that specific instruciton and every document with that line would be updated to reflect it?
I need help on this, from what the best concept is, to what I need to look into using:
I store Quote data from phone calls into tblQuotes. There is a seperate table that holds much of the same information except that it is for actual orders called tblOrders.
As far as function goes, I have each working much the way I need it to except for one thing... If a sales person is on the phone with a customer with a quote already in the system, right now they re-enter the data into the Order table. Most times, the order is what was quoted, but maybe with a few small changes (so I will wnt to keep a historical record of the quote). How could I copy the contents of the quote recordset into the recordset for an order, where all the sales rep does from there is edit the quote to the actual order?
Would I use VBA or an update query that is executed via VAB? Honestly, I am unsure how to do this at all, I hope someone has seen this before and has a good suggestion...
It's an Access 2003 database which I want authenticated web users to be able to write new records to.
I don't think a Data Access Page is the right way to do this, is it? If something else, e.g. ASP could someone possibly point me in the right direction with steps 1, 2 and 3 :D
I've been fiddling around with the Tools>>Security settings but I can't seem to find a way where only I can make changes to the database and the users can't just use the switchboard. If you are regular user you don't need password but if you are admin you do.
I have been searching online for the past couple of days for a thorough tutorial that aids the user to make his/her own detailed database based on example data (that does not necessarily have to be adhered to) supplied as the tutorial progresses.
As a student participating in an advanced computing class, I feel that this would benefit me as I can do as the steps ask and see how certain things are done. I am not a complete Access mug... I have a basic knowledge of the fundamentals, but stumbling accross an in-depth tutorial that details all of the standard features (tables, queries, forms etc) along with possibly some example modules would be excellent and beneficial.
All I have found so far is various snippets - "SQL basics" and "Macros: what they do and how to implement them" for example - these miss the bigger picture I am looking for. Surely a step-by-step tutorial on "Designing and working a fully-featured database from the gound up" is not that rare!
I have built a database and setup my Queeries and Reports and setup my securities. What I want to do is make the Form open from a short cut. I can create the short cut with the security privilages but after the proper name and password is entered I want it to open straight into the Form. How do I get my database to do this?
