I have today setup an Access database for work as we were using Excel but it has become far too hard to manage.
We receive a list of properties which are empty every month in an Excel spreadsheet. I've managed to import my first set (March) successfully into Access. The idea is that we'll supplement Access with investigation notes etc having one access record per property (each property has its own unique ref. number).
However, next month (April) I'm going to receive a new list of empty properties which will include some from the previous month and some new ones.
I want to import this into Access but tell Access:
- Not to import ones which are duplicated (as there will already be case notes on file). I presume it'll be able to check the unique reference number;
- Insert non-duplicated entries (i.e. any new properties which have come on);
However, I also need to be able to identify those which are no longer empty and mark them as non-empty BUT not delete them (as we need the records on file).
That means that running a report in April will give me the same number of empty properties as the Excel spreadsheet.
Is there a way to do this (not manually as we're talking about 2,000 records per month!) or is it going to become too complicated for Access?
I need to some advise on which is the best course of action.
I have a MS database with an SQL back end as a client server application.
Now the next step is to give stand alone versions (with a mdb back end) to off-site laptop users, to make updates or entries when not connected to the office network. Hwr upon returning to the office or when connected on-line through a VPN connection, I would like the databases to synchronise.
I tried exploring the replication options in access but that doesn't seem to work.
What advise and or softwar tips could one offer me.
(ps .net web application is not an option yet as this means a complete revamp of the program, with no .net knowledge available yet)
I want to synchronise the data in the Sales subform so that, when a different record is clicked, the data in the subfrmSales2 changes.
IE, when a user clicks on OrderID1 in the Sales subform, then the data for OrderID1 shows in subfrmSales2. And when a user clicks on OrderID315 in the Sales subform, then the data for OrderID315 shows in subfrmSales2.
Scenario - I have one main form containing all the customer details. From this I can open several other forms, containing various other information about the services that they have applied for, and the stage of their application.
Some of these forms also have forms that can be opened from within them, so there can be at times three tiers of forms.
When I add a new customer on the main form, I then open the second form, add more info, then choose from another selection of forms. So at this stage there are 3 forms open. The final form contains a command button to run a report.
However to get the report to work, I have to shut down the last two forms and re-open them, even if I refresh the data on all of the forms.
Is there any way I can create a command button on the final form that will synchronise the data on all of the forms that are open and make the report work first time? Is there a way of doing this using Macros?
Hi I am trying to find the best way to synchronise several different versions of the one database, two of which are used by remote users so i can't really set one database on a central server, I am trying to come up with an as automated a process as possible as it will need to be done on a regular basis, has anyone any ideas??
it is a microsoft access 97 database
I will be updating it to a newer version as soon as possible
I have a database which I have replicated and I am trying to synchronise the replicated copy with the design master - both at the moment are stored on the same network share.
Whenever I try to sync from the replicated copy I get an error message saying the "search key was not found" and the database won't sync.
:o:confused: I'm desperately searching for a way to synchronise different copies of the same access 2003 database i created. I have tried brief case synchronisation, and I have also tried the replication manager that comes with access but they both haven't been much help. My experience with them leads me to believe that they both work best with a LAN or internet connection. I'm seeking a solution that will work without a LAN or internet connection. Something that will copy my tables and other required objects to a folder that i can copy and move to another pc where another copy of the database resides. It should then import the same tables and objects and hence synchronise the copy of the database. I recently saw a visual foxpro database that has the kind of synchronisation solution i'm looking for. I think it works this way;it exports all the tables and necessary objects to a folder that it creates allowing you to copy or move this folder via portable storage device to another computer. It then synchronises by importing the tables and other objects from this folder into the database resident on that computer. I think there might be a way to do this using macro's or VBA but alas my knowledge of these areas of access is very weak. Is there a way to recreate this functionality in access 2003 using VBA code?
I have a main form with combo box used for selection criteria. On the same form is a datasheet subform which show the records according to combo box criteria. I have also managed to insert (All) into the combo box to show all records but when I click "All" nothing happens. It does work for all other criteria in the combo box.
I attach the mdb so you can see what I have done so far. Can anyone help me on the matter. Thanks
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.
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 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.