Creating Doc From Access
Oct 9, 2006
Hi,
I have created an Access Form wherein i take the user input in various text boxs and text areas.
Now plz help me to find out how to create Microsoft Word Document automatically from the information which the user has submitted.
I have provided a button named submit which when clicked will submit the information into the Access Database and using that data i want to create a Word Document into a particular format.
What is the way in which this could be achieved?
Please help me out to find a solution to this problem.
Thanking you,
with regards,
Kapil
View Replies
ADVERTISEMENT
Apr 25, 2006
Hello everyone!
I heard from a number of people that this is the place to come for Microsoft Access related help.
So here is my question and I hope someone can help me understand access a little bit better.
I am trying to create a database for a job I am doing. THere are 700+ convenience stores that we (4 inspectors) inspect every three months.
We have been told to do an ADA compliance survey when we visit these stores.
The ADA checklist that we have is about 78 questions and my manager wants me to create an ADA database for this information.
So I am in need of help on how to create a database that allows me to input the answers of this ADA checklist for each store inspected.
I then would like to be able to pull all that information into a report that I could say of the 700+ stores, 50% passed all questions, 25% passed only questions 1-??, etc. etc.
I can upload the two files: The ADA checklist and our Store list if anyone would like to help me out!
Thanks Much!
View 9 Replies
View Related
May 11, 2006
hello :)
how can i create a view in access? is it possible using any of the wizards or can i even use the sql coding feature??
is it possible to grant views to users???
View 2 Replies
View Related
Apr 2, 2008
Iam new to access and having problems create database tables and their relationships, from the following details without duplication.
Tape Identification Numberà unique tape identity
Date -à the date the backup is done .
Backup type à either Daily or weekly or monthly or Full System or Yearly or Special
Duration à either automatic or Manual
Technician name à Person performing the Backup
Comment à comments about the Tape’s history
Location à tape is either located onsite or offsite.
Number of use à Number of times the tape has been used
Restoration à tapes restoration Details, either yes/no
Requirements
1.perform backup everyday
2.Perform restoration everyday
3.Search for tape from offsite storage
a.Tape should be located offsite
b.If it was used for daily backup, it should be at least 60 days old from current date.
c.If it was used for Weekly backup, it should be at least 6 months old.
d.If it was used for any other backup type, do not use.
** the database should provide history
View 1 Replies
View Related
Nov 4, 2004
I am working with some chemical compounds in a database I am building. I grabbed an html file off the web on a listing of chemical compounds...converted it to ascii and imported it into ACCESS. Rather than write a Perl routine I was wondering if anyone out there had some sql code that might handle it. The first 3 records look like this and are contained in one field. I am trying to break this guy into 4 fields.
0001 Acetaldehyde 75-07-0 AB1925000
0002 Acetic acid 64-19-7 AF1225000
003 Acetic annhydride 108-24-7 AK1925000
The fields would be named in order as:
GUIDE 002
CHEMICAL_NAME Acetic acid
CAS_NO 64-19-7
RTECS_NO AF1225000
The first two fields are left justified but the number fields are rather zigzagged throughout.
Anyone have a cure for this beast?
I thank you in advance.
the raven man.
View 8 Replies
View Related
Mar 1, 2012
at the moment we have been given this problem where we have to incoporate a Dmax function into the following code
IDnumber = Left(Firstname, 3) + Left(Lastname, 2)
from this code the ID number creates something that looks like this
gembl
however i need a four digit number after this ID, for every different ID i need the numbers to increase by one the following code was given to us to do in Got Focus but this did not work
IDnumber = Left(Firstname, 3) + Left(Lastname, 2) + Trim(Str(DMax("right(IDnumber,4)","Customer tbl")+1))
View 3 Replies
View Related
May 26, 2005
All..
I have an access 2003 application I have front end and back end separately. When I click "Make MDE File" from tools menu, nothing happens.
When checked the Windows Task manager(Windows 2000), CPU usage is 100% and MS ACCESS is not responding. There are no messages.
Anyone experienced this problem ?
Thanks
Bosch
View 3 Replies
View Related
Sep 1, 2005
Hi guys, i need help with a sample database, and wondered if anyone could tell me the entities and how to calculate the prices etc. If anyone could attempt starting the database off for me it would be appreciated too!!
Here is the spec!!!
You are required to produce and document a design that meets the requirements of the McDuffs Burgers scenario:
The corporate office of McDuffs Burgers has asked you to design a database to help track its restaurants and managers. The database is to help the management show the total annual sales of each restaurant and the performance of each manager, as measured by the totals annual sales of all restaurants for that particular manager. Each restaurant is supervised by a single manager, but a manager is also responsible for several restaurants. The company stores typical personnel data (name, salary, and so on.) for each manager as well as basic data for each restaurant such as the telephone and address of each restaurant, its size in square metres, and total annual sales for the last fiscal year. The company would also like objective ways to measure the performance of a manager such as the total revenue for which they are responsible, the average annual revenue per restaurant, the average annual revenue per square foot, etc.
The database should also track the orders that are placed by individual restaurants to the corporate office for various food supplies. Each order is associated with a specific restaurant, and of course, a single restaurant will place multiple orders during the course of a year. The company uses a standard set of product numbers, product descriptions, and associated prices that applies to all restaurants. Each order can specify several products, and a single product may appear in several orders. The database should be capable of computing the total cost for each order.
Deliverables
1. Entity definition for each entity.
2. Entity Relationship Diagram, which must show entities, relationships and membership.
3. Relationship definition for each relationship.
4. Relations (This must include for each relation the primary and foreign keys).
5. Data Dictionary.
Furthermore:
You are required to implement the design (produced in the first part of the assessment - McDuffs Burgers - Database Design), by designing and creating queries, forms, reports and any supporting code. Revisions may be made to the design in the implementation process.
You should note the management of McDuffs Burgers has little experience of database systems and wish to be advised on the information the system can produce.
They require example reports demonstrating the capabilities of the system to:
- Aid the day to day operation of the business.
- Provide appropriate management information.
You must also implement an appropriate user interface to the database easy to use.
View 5 Replies
View Related
Aug 7, 2006
Does anybody know how to schedule in access like sql. Like a "job" in sql server?
View 14 Replies
View Related
Aug 8, 2006
I am trying to make a DAP for data input into a table.
I used the wizard and it has the fields I want, I can scroll through them and view the entries, but they are not editable.
I read about changing the Page DataEntry property to True, but I still cannot select any of the editboxes on the DAP and now the DAP just shows blank non-selectable editboxes.
I decided to create a dummy table to work with to test creating a DAP, my dummy table looks like this:
Group Name Number Text
1 Bill 3 pink
1 Adam 5 green
2 Charlie 7 blue
I ran the wizard on the above table and again I can scroll through but not select any of the fields, and with DataEntry set to True I still cannot select/edit the textboxes.
Is there something else I need to do to be able to make an input form?
Once I get that sorted out I have a followup question: The dummy table above is where the input data goes, but on the input form I would like if possible to get the Group and Name from a different table using drop-lists. The real table has over 5000 names split into groups of about 30-50 so picking a group first would help find a name in the list which will eventually be input to the table above.
Hope that all makes sense, and thanks in advance for any help!
View 1 Replies
View Related
Dec 7, 2007
I have MSAccess 2003 running on WindowsXP. I have multiple users sharing a single database. When more than one user opens the same database, a copy of the database is being created?? I don't know if this is a standard trait of Acccess or something else. Any explinations would be helpfull.
Thanks
Bob
View 2 Replies
View Related
Mar 24, 2008
I converted an MS Access 2000 DB to 2003 with no problems. I am able to open it up in Access 2003 now either by double clicking it or from Acccess - file open. I then created an MDE file in Access 2003, but when I tried to open it up I got a message saying
This database is in an unrecognized format.
The database may have been created with a LATER version of Microsoft Office Access than the one you are using. Upgrade your version of Microsoft Office Access to the current one, then open this database.
I noticed a service pack will get rid of this errror. My question is if I distribute the MDE will the user get the same error if they don't have the service pack installed on their PC? Will my installation of the service pack fix the errror and allow anyone to use the file without getting the message.
Thanks
View 2 Replies
View Related
May 9, 2006
Hi all,
I write a program which is querying some data from a MS-Access database.
The problem here is, that the tablenames contain characters like "/" or "-" and I
do not want to change these names, because I think that the database
structure will be damaged.
To solve this problem I thought of creating a view to the table. I tried creating
this with a SQL statement, but that did not work.
Is there any other possibilty to create a view on a MS-Access table?
Regards,
Stefan
View 2 Replies
View Related
Feb 5, 2008
Hi,
I am trying to create a series of MS access tables from within a SQL 2000 DTS package. The names of the tables reflect the date range of the data within them. Creating the "Create table ddmmyy ...." statement isn't a problem (full code below), but doesn't run as it creates a Jet error - "Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. Does anyone know if what I'm trying to do is possible.
Before anyone suggests it, yes I have posted this on SQL server forums.
declare @TheName char (8)
,@Cmd char (500)
select @TheName = (select max(LastRunDate) from NSP_Analysis_Dates)
select @Cmd = 'CREATE TABLE `NSP_Analysis_' + @TheName + '` (`TYPE` VarChar (200) NULL, `VENDOR_NO` VarChar (10) NULL, `VENDOR_NAME` VarChar (50) NULL, `AMOUNT_CLAIMED` Currency NULL, `REGION` VarChar (100) NULL, `CLUSTER` VarChar (100) NULL, `PLANT_CODE` VarChar (15) NULL, `PLANT_NAME` VarChar (50) NULL, `DATE_OF_SERVICE` DateTime NULL, `STATUS` VarChar (200) NULL, `TICKET_NO` VarChar (20) NULL, `NOTES` VarChar (255) NULL, `DATE_ENTERED` DateTime NULL, `AuthorisedByName` VarChar (50) NULL)'
sp_executesql @Cmd
View 1 Replies
View Related
May 29, 2006
I made a form a few years ago using Excel but it has become a major headache for anyone who wants to edit/update the content.
It's my responsibility to figure out how to fix this, but I don't really have any experience in form-creation! I'm not even sure what software to use... I've done some searching, and right now I'm thinking Access might have the tools that I need to help me complete this project (although I have no experience with the software at all right now).
I'm looking for some help on getting started.. so I will describe the project, and hopefully someone can answer a few of my questions.
This form has 3 sections: input, Q&A, and the summary. The input section is handled by the company before presenting the Q&A to a client. In the Q&A portion the client's name, company, and other personal information are pulled from the input section and placed mid-sentence in the questions. This is a personal touch we would like to keep when re-creating the form.
The Q&A portion also includes radio buttons, checkboxes, dropdown lists and input fields where the client can type out their answers sometimes. Here is an example of what the first 2 pages may look like:
PAGE 1: Question 1:
Do you have a clearly defined purpose for your plan?
http://img425.imageshack.us/img425/3589/radio9sx.jpg If YES record the purpose below:
_______________________________________________
http://img425.imageshack.us/img425/3589/radio9sx.jpg If NO, choose a sample purpose from the drop-down box
to help get you started:
http://img200.imageshack.us/img200/7386/dropdown1vu.jpg
PAGE 2: Question 2:
What selection critera did you use to select your service provider?
http://img71.imageshack.us/img71/2890/checked4na.jpg Investment options provided
http://img200.imageshack.us/img200/5539/unchecked5rr.jpg Cost of service
http://img200.imageshack.us/img200/5539/unchecked5rr.jpg Support tools proved
http://img71.imageshack.us/img71/2890/checked4na.jpg Quality of service
Enter any other reasons below:
_______________________________________________
One page per question.
The SUMMARY page will take client's answers and compact them into something more readable. The answers are listed one after another (no limit per page as with the questions). Also, the answers are to be displayed in sentence format. For example.. if a client checks off 3 items from a 5 item list, those three items should be listed in a sentence separated by commas. Here is an example summarizing the first 2 pages above:
Summary of Answers
1. Do you have a clearly defined purpose for your plan?
A. YES. (description of plan previously entered by client)
2. What selection critera did you use to select your service provider?
A. Investment options provided, and quality of service. Also (other resaons, provided by client)
This demonstrates the type of control that I need over the information. I managed to get Excel to do all these things.. but, like I said it is too complex to edit/update without accidently screwing things up. So lastly and most importantly... the final version of the form needs to be easy to edit!
So... does it look like Access the right program for the job? Maybe there are other programs out there that I should be looking at (something by Adobe maybe?)
But if you think Access can handle the job then do you have any tips to help me along my way? I'm not looking for specific step-by step instructions to help me build this of course.. I will figure most of it out by trial and error. But are there some major things I should be looking out for? Like, do I have to set up a particular kind of database, or use a particular kind of template? Is inserting the client's name mid-sentence a particularly difficult thing to do?
Any help to get started on this is much appreciated. THANKS.
Thanks so much.
art.
View 3 Replies
View Related
Sep 30, 2004
I have written a piece of code in Access that creates a Excel work book. The work book is populated with the various data and then made visible to the user.
Everything is working perfectly apart from one minor problem.
When creating a new workbook excel automatically puts 3 worksheets in... If the code creates 1 or 2 sheets of data I want it too delete the sheet that is blank. This is easy to do although it always prompts the user for confirmation.
How do I delete a worksheet without the prompt?
I have hunted everywhere for the answer and can't find it anywhere, any help would be great.
Example of code:
Dim XL As Excel.Application
Dim WkBook As Excel.Workbook
Dim WkSheet As Excel.Worksheet
Set XL = CreateObject("Excel.Application")
Set WkBook = XL.Workbooks.Add
Set WkSheet = WkBook.Worksheets(1)
WkSheet.Delete
View 1 Replies
View Related
Jan 1, 2005
I am having trouble getting ASP code to create a new column in an Access database.
This is what is currently coded, but does not work. Something tells me that the code should be Create instead of Alter, but not sure what the correct terms would be. I need the code to automatically create this column called PCName with the listed properties in the table called member. Any help would be greatly appreciated.
re.Open "Alter Table in member Add Column " & PCName & " varchar(50) default None",conn2
sql = "Update member Set " & PCName & " = 'None'"
View 1 Replies
View Related
Feb 22, 2005
Hello all
I got a chance to make some extra money outside of my usual job.
I am creating a billing system for a plumbing business. It's pretty easy and shouldn't take me long to do. The only thing is I'm not sure what to charge.
Anybody have any idea?
Thanks in advance
View 3 Replies
View Related
May 17, 2005
I'm not too hot at creating a database in Access, so I was wondering if there was anyone out their prepared to help me construct one.
This database is designed to search for property from various locations and from various price ranges, you can also pick the type of property, the amount of bedrooms and have the result in descending or ascending order.
For location just use: Location 1, Location 2, Location 3, and Any
Price Ranges use: 30,000, 50,000, 70,000, 90,000, and 110,000
Type of property please use: houses, flats, and bungalows
Bedrooms use: 1, 2, 3, 4 or 5+
Fill in any data you wish, I think this needs to have a query setup?
Thanks for your help
Chris Green
View 3 Replies
View Related
Apr 7, 2008
Hi All,
I am having real problems creating a Excel from Access. I have rea lots of threads, but none seem to address this problem.
OK, so I have windows XP, Access 2003 and Excel all running quite happily on my PC, when I copy Access databases with the verb ".Excel" in it, I can access it and update/extend as needed.
However, I have just created a new piece of VBA code in a new database and the ".Excel" extensions are not present.....
So I have
Sub openReport()
Dim myXL As Excel.Worksheet
Set myXL = createXlWorksheet
.........
End Sub
Public Function createXlWorksheet() As Excel.Worksheet
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
Set xlApp = CreateObject("Excel.Application")
Set xlBook = xlApp.Workbooks.Add
Set xlSheet = xlBook.Worksheets.Add
Set createXlWorksheet = xlSheet
Set xlSheet = Nothing
Set xlBook = Nothing
Set xlApp = Nothing
End Function
And in some databases this works correcttly, but this one database,when I type the string "Dim myXL As.Ex" I do not get the "Excel" operator presented, it is just not in the list of object functions..... any ideas?? it's sending me mad!!!!
Thanks
View 2 Replies
View Related
Aug 8, 2006
I am trying to make a DAP for data input into a table.
I used the wizard and it has the fields I want, I can scroll through them and view the entries, but they are not editable.
I read about changing the Page DataEntry property to True, but I still cannot select any of the editboxes on the DAP and now the DAP just shows blank non-selectable editboxes.
I decided to create a dummy table to work with to test creating a DAP, my dummy table looks like this:
Code:Group Name Number Text1 Bill 3 pink1 Adam 5 green2 Charlie 7 blue
I ran the wizard on the above table and again I can scroll through but not select any of the fields, and with DataEntry set to True I still cannot select/edit the textboxes.
Is there something else I need to do to be able to make an input form?
Once I get that sorted out I have a followup question: The dummy table above is where the input data goes, but on the input form I would like if possible to get the Group and Name from a different table using drop-lists. The real table has over 5000 names split into groups of about 30-50 so picking a group first would help find a name in the list which will eventually be input to the table above.
Hope that all makes sense, and thanks in advance for any help!
View 1 Replies
View Related
Jul 21, 2007
I'm experimenting in MS Access VBA reading from one MS Access application to another as visible in the code below. My problem is that I'm reading a recordset from an Access file and want to take that recordset (rec) to create a table in the current databank. If I run an cmd.commandtext "make table query" it runs the query across the connection and places the table in the remote database (as expected). Can I take the recordset and create a local table using ADODB command or is there a better approach. (I should note that the remote MS Access file does not have an .mdb suffix) Thanks in advance.
Sub get_indbyind()
Dim strInputfile As String
Dim dlgOpen As FileDialog
Dim bob As String
bob = Application.CurrentDb.Name
' select connection
Set dlgOpen = Application.FileDialog(msoFileDialogOpen)
With dlgOpen
.AllowMultiSelect = False
.Show
End With
strInputfile = dlgOpen.SelectedItems.Item(1)
' make connection
Dim cnn As ADODB.Connection
Set cnn = New ADODB.Connection
Dim strcnn As String
strcnn = "Provider=Microsoft.jet.OLEDB.4.0; Data Source=" & strInputfile
cnn.Open strcnn
' MsgBox "connection made"
' create recordset
Dim rec As ADODB.Recordset
Set rec = New ADODB.Recordset
rec.Open "SELECT * FROM SATransfers;", cnn
Dim n As Long
Dim i As Long
Do While Not rec.EOF
Debug.Print rec.Fields(0).Value; rec.Fields(1).Value; rec.Fields(2).Value; rec.Fields(3).Value
rec.MoveNext
Loop
' create table from connection cnn
Dim cmd As ADODB.Command
Set cmd = New ADODB.Command
Dim rs As New ADODB.Recordset
cmd.ActiveConnection = cnn
cmd.CommandText = "SELECT SATransfers * INTO tmp1 FROM SATransfers;"
Set rs = cmd.Execute
cnn.Close
Set cnn = Nothing
Set cmd = Nothing
End Sub
View 2 Replies
View Related
Aug 30, 2015
I am new to Access and somewhat OK with Excel.I am working at a government institution, agriculture sector. We have field staff of ~150 doing different field ranges ~350. Some officers are assign to more than one field BUT no field is assign to more than one officer. (these fields belongs to different Districts, number of fields in each district is not the same)
we have four different programs namely new cultivation program (NPP), productivity improvement of existing lands (PIP), farmer capacity building (HRM) and post harvest handling (PHP). Each program has its activities lets say NPP1, NPP2, PIP1, PIP2,PIP3 etc. for an example NPP1 is land inspection, NPP2 is donating planting materials. these activities are predefined and sequential. (planting materials can not be donate without land inspection)
Officers send their progress to progress monitoring unit monthly which includes progress of each program and each activity progress for that month. My objective is to track, analyse, visualize officers progress.
These are the questions I have,As I am OK with Excel and NOT good with Access do you think I should use access for this due to any special advantage only access can give me.can I visualize data with Access?
View 2 Replies
View Related
Dec 18, 2007
I am not sure where to post this question. I remember finding a forum just for Microsoft Access 2007 questions, but I couldn't find it again... Indifferent
Anyway, I have created a database, and have been testing it with my application. I have some data in this database. I was wondering if there was a way in Microsoft Access 2007 to create an empty copy of the database for release. In other words, I would like to create a copy of the database with all of the tables and columns, but without the data (rows) that I had entered as part of using my testing database...
Does anyone know if I can do this?
If anyone knows where this Access 2007 forum is, or resources that might answer my question, please let me know, as I would greatly appreciate that.
Thanks Again,
View 1 Replies
View Related
Feb 17, 2008
Welcome,
i am making a database project for manufacturing purpose. I have made tables in MS Access and connected them with MySQL (ODBC). I have created data access pages for employee to access data to database. I have copied these page to my locale appache server and it works as a web page.
I could(employee) insert data from a web page to MySQL tables, but now I want to make some reports and templates(made in Access!) be accesible from web page for managers. Graphs made in access too.
I will look like this: User will log in on a web site, when he log in as a manager there will be available reports and graphs(data from MySQL) that I made in Access.
Data Access pages made in MS access <2007 work perfectly, can I make the same thing with reports, graphs, templates? I mean save them as a dynamic web page with links to databace?
Thanks for help.
Paul Zegadło, Poland.
View 2 Replies
View Related
Mar 6, 2008
Hi i hope someome can help. I am importing a data into a table, records are being rejected as they should due to validation rules. However access is not creating a table of rejected records. What am i doing wrong.
Thanks for any help
View 4 Replies
View Related
