Hi there, as I am totally new at this, can someone please give me detailed information on how to get Access table or query data to display onto a Dreamweaver page???
Thank you.
KMEscherich
Last Activity: Jun 20 '11, 04:45 PM
Joined: Jun 20 '07
Location:
-
Crystal report parameters to be controlled by Access database table
Hi there, am wondering if there is a way to do the following:
I developed a Crystal report that runs against a Clarity table envrionment. The report runs fine.
I have been asked to run my parameter form - Crystal report against an Access database table. Once the report runs against this Access table, I need to be able to export/convert into a PDF format, then transfer this PDF report into a folder on our shared drive.... -
OnClick Command to run Crystal Reports from Access
Hi there, am wondering if someone can send me sample OnClick code (button on an Access form) that will allow me to run Crystal Reports from an Access form, then after the report has run, have it converted to PDF format, then transferred into a shared network drive.
Not sure if this is something that can be done. Not sure how many buttons this may require. If I need several buttons, that is okay.
Please help.
... -
Select all items from list box or just one
Hi there, does anyone by chance know how to code a list box so the end-user can select either one item in a list box or all items in the list box???
Not sure how to do this and really hope someone can assist me with this.
Thank you VERY much for this.
Example would be:
Animal List Box options:
Cat
Dog
Horse
I would like the end-user to have the option... -
3 List Boxes + Several Check Boxes on a Parameter Form
Hi there, am wondering if someone can tell me how to get 3 list boxes to work in conjunction with a bunch of check-boxes on an independent form and have the results filter the report accordingly.
I have temp tables for each set of code that would pertain to EMPLOYEE / DEPARTMENT / LOCATION. When I run the code when everything is not commented out, the selections that I make go into the temp tables perfectly, but for some reason... -
Auto Executable for PDF file
Hi there, am totally new at creating an executable for a PDF file.
I have created a PDF file and placed it on a CD. Now, I want to be able to have this PDF file automatically open up in any computer when it is inserted in a computer just like when you purchase software, take it home and install it.
I tried something with an .inf extension but it does not retrieve MY PDF file, it just opens the a Windows window. At... -
Website Development
Hi everyone, I am wondering what software is needed to buy in order to have a database driven website. Not sure how many computers to get, how many different types of software is required, what versions of software is needed either, how to get it online, etc.
I have developed a static type website using Dreamweaver and placed in on my FTP site and it works fine, but now that I am attempting to create something that is data driven,... -
the answers tab should have what you need -
Distinct Count in Report
Using Access 2003
Hi there, am wondering if someone can please help me with retrieving DISTINCT COUNT of a type field. I can get a total, which in this example would = 9, but I also need to know Unique Types = 3. I sure hope someone can help me with this. The data will be grouped by DEPT.
DEPT 1
Type 1 / Date . . .
Type 1 / Date . . .
DEPT 2
Type 1 / Date . . .
Type... -
2 Lookup controls on Form
Hi there, am confused. Am wondering if you have a lookup control on the form and it populates the form with the selected Employee Name and all other pertinent data, is there a way to have 2 lookup fields (one for Employee Name, and one for Employee ID) and when you make a selection from the Employee Name lookup control have it populate the form and also the Employee ID control with the correct Employee ID? Am also wondering if you make a selection... -
3 Check Boxes 3 Date Fields
Microsoft Access 2003
Hi there, am stuck with something that I am not sure on how to get done. I am attempting to have 3 check boxes and have 3 date fields. I need to have each date field be populated with an independent date when the end-user clicks on each of the 3 check boxes.
CB_STARTED
STARTED_DATE
CB_COMPLETED
COMPLETED_DATE
CB_CLOSED
CLOSED_DATE
... -
Conditional Count
Access 2003
Hi there, I have a query and a report and am wondering if there is a way to count a field (SRI) in the query or in the report if the condition of less than 7 days exists. I have a column in the query that specifies that if a row or line item is less than 7 days, then place a 1, else give it a 2.
Now, I need to make a count only the fields with a 1 assoicated with it.
Sure hope someone... -
Show the NO answer only
Am stumpped.
I have a query that has Q1, Q2, Q3, Q4. Each one of these have a question associated with it. Each question has the YES or NO option to select from.
Is there a way to see only those answers that have a NO?
You see, I am attempting to create a report and show only those questions where they answered with a NO.
Thank you VERY MUCH for your time and assistance. -
Populate EMP_ID control with selection from EMP_NAME control
Platform = Windows
Program = Access 2003
Hi there, I am stumpped!!
I am attempting to populate a form control as follows:
I have a form that has 2 drop-down boxes. One retrieves the EMP_ID and the 2nd one retrieves the EMP_NAME and EMP_ID.
When I make a selection from the EMP_ID control, the data in the database appears accordingly. When I make a selection from the EMP_NAME... -
Turn book into website
Hi there, am wondering if someone can please tell me what I need to do to accomplish the following:
I am developing a website that encompasses a BOOK. In other words, each chapter in a book will have a different web-page.
I am interested in having a login page where someone will be able to PAY to access all the information contained within the pages of this website.
Am not sure what all the different... -
Retrieve all records or specific records
Using Access 2003
Hi there, can someone please tell me how I can give someone an option of entering 1 or two parameters or get all records???
1) I would like to have an option of selecting Parameter 1( Date = 05/25/2008) and have all records displayed be according the date parameter of 05/25/2008.
2) Another option would be to enter Parameter 1 (date = 05/25/2008) + Parameter 2 (Manager = Donald Duck).... -
I am not sure if this is what you are talking abuot, but when I am in Access I can do the following:
FILE / Get External Data / Import
Files of Type = ODBC
Machine Data Source tab = CLR_SC_ODBC
DBC Name or Address = SCAL-Clarity.kp.org
User Name = 1234
Password = ABCD
After doing this, it shows all the clarity tables.
I would like to be able to specify in a SQL query... -
Import Teradata SQL data into Access database table
Version of Access = 2003
Hi there, is there a way to capture data using TERADATA SQL Assistant and import a portion of this database table into a Microsoft Access database table???
I currently have Teradata SQL Assistant and write SQL to retrieve data from clarity tables. I would like to have a button on a Microsoft Access form that would retrieve data directly from Clarity tables and import into a specific Microsoft... -
Parameter Form
Using Access 2002
Hi there, am wondering if there is a way for me to create a parameter form and have it tied into a specific query so after, let's say 3 parameters have been selected, the report will run according to those selections that have been made.
Thank you VERY MUCH for your assistance.
KEscherich -
Return ALL records
Hi there, am using Access 2002 and am wondering if there is a way to set up a query so that if I don't make a selection for a parameter such as a department code, I would see all records, and if I do make a selection, I would only see records pertaining to that particular Department Code I selected. Am not sure if Access can do this or not.
Thank you VERY MUCH for your assistance.
KEscherich
No activity results to display
Leave a comment: