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.
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
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.
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?
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;
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.
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
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.
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...
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?
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."
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)
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?
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?
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.
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.
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.
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?
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.
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.
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.