Help With Data Access

Nov 2, 2006

Hi
Pretty new to access so hope these aren't daft questions!

I've got a table of documents, linked to 2 different tables which relate whether the document is a trial document (yes/no) and what cancer site it refers to (a list of 10 options). I need to be able to give users via a form the initial option of choosing to list a set of documents based on whether they are in a trial or not and also filtered by cancer site.

I've got stuck with trying to do this. I've been able to provide a form with a subtable that shows a list of documents by cancer type (by using a combo box), but I don't know how to further filter the list so that users can also filter by trial status.

Also another silly question - Within my table design for the documents, i use the old trick of setting up cancerid field to show the actual cancer name, not the number. However when I try this for trialid, which is a tickbox, it displays -1 or 0 not a yes/no option.

any help would be great. Thanks Jon

View Replies


ADVERTISEMENT

Modules & VBA :: Copy Data In Sheet1 Using Sheet 2 And Access Table Data?

Aug 5, 2014

I am using Excel/VBA as a frontend and Access backend. The sheet2 stores the queue name and Queue number. We have to update the sheet1 from column L to column O by looking for the values from the Access table for the date selected from the comboboxes. Now In sheet 2 , it says Queue number and in actual in access table it is the combination of Type & Type1 & Type2. So we have to look for Type & Type1 & Type2 in the table and find out total Batches ,Total Envelopes,Total documents and total pages and then store the values in the ExcelSheet1 from column L to column O.

The following formulas will be used in the select statment:

Total Batches = count(BatchNo) for date selected
Total Envelopes=sum(Envelopes) for date selected
Total Documents=sum(Cases) for date selected
Total Pages=sum(Pages) for date selected

View 14 Replies View Related

Can't Use Data Access Pages To Enter Data

Apr 14, 2012

I am trying to set up some data access pages as data entry into a table with access 2000. I can see the records in both the data access forms and the HTML forms, but cannot create new records into the table. I have tried to change the property to DataEntry etc... but nothing seems to work.

View 2 Replies View Related

Data Access Pages - Need An Access Client?

Oct 10, 2005

I've made an adp (access project ) file. I want to permit some users to look in the data but i'm not certain they have access installed, can i give them read-only rights by placing a data-access page in a network map? Can they use the functionality of a data-access page without having access installed?

View 1 Replies View Related

Imort Data From Access To Access

Mar 13, 2008

i have identical access databases with different data .I d like to unify the to one .How can i import only DATA from one to other

View 3 Replies View Related

General :: Access Data Export Into Excel As Data Linked To Excel

Oct 21, 2012

how i can export the data from Access to excel using Access VBA for the specified sheet using data linkage with access database. Like we used to do it manually in excel as external data from access.Like we have some codes for linking excel file to database mentioned below;

DoCmd.TransferSpreadsheet acLink, , "region", "F:DB PracticeBook1.xlsx", False, "region"

Can we have something like this to link database table in excel file automatically.So that the excel size won't be that big and also it saves processing time.

View 5 Replies View Related

Tables :: Access 2003 Table Data Import Into Access 2007 Table

Apr 26, 2015

i have a database in access 2003 when i open it with access 2003 it shows data in table but when i open same table in access 2007 it shows only header rows , no data

how can i see this data into access 2007 or excel 2007.i want to link these table data with excel 2007 or access 2007 but with above problem i can't do it

View 1 Replies View Related

Forms :: How To Copy Ms Access Forms Field Data Into Ms Access Table

Dec 29, 2014

I have a table and a form. I need to input data in the form and click on a button to add this data into the existing table.

This is part of a bigger application which will be compiled and given away for use.

tblProduct
id = autonumber
name = text
InHand = integer
Price = float
frmNew
txtname = textbox
txtInhand = textbox
txtPrice = textbox.

I need to coy frmNew.txtname into tblProduct.name and so forth.

View 9 Replies View Related

Tables :: Data Lost In Access 2000 Tables With Access 2010

Oct 9, 2012

We have an Access 2000 backend database resides in a network server drive while users connect to the backend tables with a mde file on their computers. All users have Access 2010 and the mde file was converted from the 2000 frontend with Access 2010.

The database have been running for a few weeks but recently users have been complaining about record lost on the backend table.We have also experienced one incident of data corruption where the main table could not be opened. After Compact & Repair, the table could be opened but a few records were showing xxxxx on all the fields and we have to delete and re-enter these records.Would they relate to using 2010 mde converted from 2000 frontend when the backend is still in 2000? I am a little nervous about converting both the frontend and backend to 2010 since I have heard various issues on the new version.

View 1 Replies View Related

Data Access Pages

May 13, 2005

Hello Experts..

I am new to Access. I have Access 2003.
When I try to create a data access page using Wizard, I am getting the following message.

'The wizard is unable to create your data access page'

When I click on Database and select Refresh, I get the other msg

"Microsoft office access is unable to connect to the data source specified in the connection string of this page"..

I am very badly stuck here..Please help.

Thanks in advance...
Arun.

View 1 Replies View Related

Data Access Pages Again..

May 13, 2005

I am getting very frustrated(and surprised) to see there was no answers to my question regarding Data Access Pages yet. I searched the web and manuals and help in Access, but no luck yet...
Can anyone tell me if Data Access Pages really works? I just came to know about it while developing MS Access application...I just thot it will be cool to go web with less effort...

Thanks very much...

------------------------------------------------------------------------
Hello Experts..

I am new to Access. I have Access 2003.
When I try to create a data access page using Wizard, I am getting the following message.

'The wizard is unable to create your data access page'

When I click on Database and select Refresh, I get the other msg

"Microsoft office access is unable to connect to the data source specified in the connection string of this page"..

I am very badly stuck here..Please help.

Thanks in advance...
Arun.

View 7 Replies View Related

SSL And Data Access Pages

Aug 9, 2005

I'm setting up data access pages that will be accessed over the internet. Because of this I want to make sure that everything is secure. I am using IIS 5.0 (Windows XP) as the web server. I used the three-tier authentication approach discussed in the microsoft article here (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/deploydap.asp) So I'm pretty sure that the authentication is secure. But what about the communication between the browser and MSDE during databinding? Is that secure?

Wanting to make sure I set up a SSL certificate which secures the page and set the Remote Server in the connection settings in the data access pages to "https://domain.com". Does this secure the comminication between browser and the server?

Thanks in advance

View 1 Replies View Related

Data Access Page

Oct 2, 2005

Is it good to use (to make) Data Access Page to access the database (and put it on the web ) ?? :confused:

View 1 Replies View Related

OLE In Data Access Page

Oct 19, 2005

I have a photo (jpg format) which store OLE field in a table. But, I would like to display it in a Data Access Page. But, I have being prompt the following error: "You tried to drop an OLE or long binary column onto your data access page. There is no HTML control which binds correctly to this column type."

Do anyone know how to overcome this problem?

View 1 Replies View Related

Data Taken From Access To Excel

Nov 16, 2005

I have a database that works as a sales system. From a table in the database I run a query that calculates the totals for that day.
i.e.

Date……….Dept 1…..Dep2
07/11/05…...£10………£10

What I need is:
1.You click a button
2.It copies the date and finds it in the excel spreadsheet as the sheet will already have a field called date.
3.It will then copy the Dept 1 figure and Dept 2 figure into the spreadsheet where the date matches (in a certain column)

Can this be done?

Kindest Regards

Danian

View 3 Replies View Related

Data Access Pages

Dec 6, 2005

If I build an access database that uses data access pages, are all users required to have a copy of the MS Access software, or does the database run strictly off of the browser?

View 1 Replies View Related

Pulling Data From SQL To Access DB

Jan 23, 2006

Ok, so I am creating an Access Database to track the progress of our collections staff. I need to pull data from a remote SQL database and filter it so that the appropriate records are appended to the appropriate tables in teh Access DB. Any ideas?

View 3 Replies View Related

Access Thinks Data Is On C But It Is Actually On D

Feb 13, 2006

Hi,

after some effort i now have 2 databases set up that i use all the time to mail merge data into word documents. it is a much better system than i used previously and works great.

only annoyance i have is this. either because i have recently re-installed windows, or because i copy the documents and databases back and forward between my laptop and desktop computer, which use different drive letters for the main drives (i'm not sure which of these actions caused the problem), i now find that when i open any of my mail merge documents in word they open a dialogue box and are looking for the database on

C:userDocumentsFilesdatabase

when they should be looking on

D:userDocumentsFilesdatabase

how can i tell access to search on a different hard drive. i've searched and searched through the options but i cant find it. i had a similar problem once with word looking for all my docs on the wrong drive letter and i fixed that, but i can't fix it in access.

any help much appreciated.

thanks

View 2 Replies View Related

Data Access Web PAge

Apr 12, 2006

Hi,

Can anyone tell me how I can get my data input web page to load with a new fresh input page. At present, each time a user opens the form, it displays the last record that was input previously.

When using a form, the record properties can be changed so that when the form is opened, it displays a new blank record to fill in. I cannot find any properties in the web page design view that allow it to be set to startup with a new blank page rather than the last record that was entered.

Any suggestion?

Thanks

View 1 Replies View Related

Data Access Page Help

Jul 31, 2006

Hi,

So i have made a Data Access page using the wizard from a table called Employees
I want the Access page to have some sort of search button so that they can quickly find an employee, rather than scrolling through all 100 records.

How can i do this?

Thanks Brian

View 2 Replies View Related

Data Access Page Help

Jan 15, 2007

Hey guys,

I'm somewhat new to MS Access. I'm trying to allow a user to update, add/delete records through a data access page. I am able to view the query, navigate through the results, but I am not able to make any changes. I get a pop up message saying the record set I am using is read-only. As far as I know, my table is fully editable. Anyone have input on this issue?

View 5 Replies View Related

Moving Data In Access

Jan 28, 2007

Hi
:) I am creating a program in VB.NET with an access 2003 database. This program will be in 2 physical locations. This is a program that sells tickets. At the end of the day I need to be able to get that days sales data off the remote location and update the main location with that information. This will be sales totals only. The user will plug in a thumb drive to move the data from one machine to the other. Due to the physical layout and other considerations this is the best option. The only action I want the user to have to do is to place the thumb drive in the USB port and hit the “down load” button. Then on the main location the user should be able to just plug in the thumb drive and hit up load. The database needs to be updated with the data from the remote location. What is the best way to do this?
Thanks in advance.

View 1 Replies View Related

Transferring Data To An Access DB

Jul 16, 2007

Does anyone know if it is possible to transfer data from an old MSDos database into an Access 2003 one?

If so any idea how you would go about doing this?

Thanks in advance.

View 14 Replies View Related

Importing Data Into Access

Aug 29, 2007

how to import text file row by row into access?

pls help me out......

View 1 Replies View Related

Data Access Page

Sep 1, 2007

Hi All,

I have created a Data Access(DAP) Page to append the sales order received on phone. The Data Access Page is linked to query which has autonumber field to store the Sales Order. I have a textbox on DAP for Sales Order No. The autonumber generated in Table is different from autonumber generated on DAP. I want same the autonumber on page and in table.


Thanks for time.

S Acharya

View 3 Replies View Related

Data Access Page

Oct 3, 2007

Hello Everyone,

Can you allow the users to update and edit the data access page and actually change the data in the database? Or is it just a view only? If possible I need the user to be able to update the database through the data access page.

Is this possible?

Any ideas would be helpful.....

Thanks

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved