Track Updates In A Dataset

Mar 21, 2013

I have a table into which users insert records through a user form, I need to track the updates made in a record in a data set and i have a user log in function, it needs to tell me who updated last and what did they update.

View Replies


ADVERTISEMENT

Removing Duplicates From Dataset

Dec 12, 2011

I have data that I want to combine. However the separate data sets have some duplicates.

Let's say it is Customer Num field.

What I am saying is I am trying to combine the data sets to make a table with Customer Num and Customer Name.

I want to eliminate the duplicates. What is the best way to do this? Is there a feature in Access for this?

View 5 Replies View Related

Import Only Part Of An Oracle Dataset

Jan 18, 2008

Using ODBC, is it possible to import only part of an Oracle dataset into Access 2007? If so, how would I do that? I have an Oracle table with 6 1/2 million records, but I onoly want to see the first 500,000 records.

If anyone can advise on how to do this, I would sure appreciate it.

Thank you!

View 3 Replies View Related

Modules & VBA :: Edit Dataset Works And Add A New One

Aug 4, 2013

I have an edit button in my form which activates VBA, collects all data from the fields and edit the dataset. Everything work fine except the case that next to the edit access adds a new record as well with exactly the same data.

This is my code :

Dim db As Database
Dim rs As Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset("select * from tbllocations where locationid = " & cdkey)

[code]...

I checked every parameter and it seems everything is OK which surely is the base for the correct edit of the dataset. locationid is the key of the table.

View 3 Replies View Related

Queries :: Dataset - Cumulative Sum For A Month

Nov 27, 2013

I have a dataset like this

ABCDEFG
1.AccDateStartIntWLMV
2.SSAAB15028815/02/88Month1.25101000
3.SSAAB18028818/02/88Month020980
4.SSAAB25028825/02/88Month1.2510970
5.SSAAB29028829/02/88Month010960
6.SSXXB15028815/02/88Start 1.25101000
7.SSXXB18028818/02/88Month020980
8.SSXXB25028825/02/88Month2.2510970
9.SSXXB29028829/02/88Month010960

I used to to apply this logic in XL to do my job A-F = XL Columns & 1-9 XL Rows

ifA2=A1, E2+E1, E2

This is to have a cumulative figure for a month. Just bcoz the data is growing in large numbers, we were advised to use access for which I don't know how to perform this calculation.

View 1 Replies View Related

Query To Add Empty Records To Dataset?

Jul 31, 2014

I have a dataset showing sales by salesperson for each product. I'd like to summarize this data in a table that looks like this:

Note that some salespeople don't sell certain products and that these records show up with "0". My problem is that, in my actual dataset, if a salesperson doesn't sell a product, that records doesn't exist at all. Is there any way to append empty "0" records to my dataset? See attached for an Access file.

DatasetProblem.accdb

View 5 Replies View Related

Queries :: Dataset - Group By Query Without Summing

Jan 15, 2015

I have a a dataset that has recorded encounters with a number of Banded (identified) animals. It is currently setup so that each encounter is its own row; with all the information, including "Band_Num" repeated, but "Encounter_Date" being unique. I wanted to query the table and get it to display the results as "Band_Num" on a row, followed by x columns for with each unique "Encounter_Date" represented. I thought a "Group By" function would work, but that requires a sum, which is not useful.

Complicating this is the fact that not every individual is seen a set number of times, so Animal 1 might be seen 3 different dates, but Animal 2 only on 1 date.

View 4 Replies View Related

Forms :: Uneditable Dataset In A Subordinate Form?

Jul 16, 2014

I've got a form with a combo box where I choose an employee and according to that employee's attributes are shown. Some of the attributes are stored in the same table with employee names, some of it is connected by foreign key to other tables. This form is not editable, information only. I've got a button "Edit employee" which opens another form intended to edit the information. I put text fields there by dragging the fields from tables. And so, for some reason, the only editable fields in that form are those connected by foreign key to the main table, but the main table fields are all not editable and error "not in dataset" comes up.

View 5 Replies View Related

General :: Random Selection From Large Dataset

Jun 25, 2013

I pulled a report from this website my company uses and it has around 7,000 orders and a corresponding employee to each record. Since each employee has around 20-50 orders, I was wondering if there was a VBA code or different Access tool to randomly select only 2 orders from each employee, thus reducing the data set from 7,000 to a more manageable number?

View 5 Replies View Related

How To Show Field Content In A Label - ID Of Dataset

May 24, 2012

I want to display the ID of a dataset in a form but I don't want the user to be able to edit it. Therefore I want to display the id in a label and not a textbox or combo etc.

I can't see a way of how to do this though. Is this possible, or am I going about it the wrong way?

View 3 Replies View Related

Queries :: How To Handle Empty Dataset As Form Recordsource

May 7, 2013

In Access 2010, I'm writing VBA code that assigns an ADO dataset as the recordsource for a form. The query itself varies and is constructed from a search term typed in a textbox by the user. The code below works perfectly until the dataset is empty, when no records satisfied the WHERE criteria. In that case, there is a very long pause (presumably a timeout?) and I eventually get the error message "ODBC call failed." I tried to get around this by testing the number of records in the dataset (see toward the end) before assigning it, but it makes no difference in the behavior, so I'm thinking the actual assignment isn't the issue ... something else is.

If it matters, the "FROM qry_beneficial_owners" in this case is predefined query local to my Access db. That query is based on a linked view from a SQL server.

Code:
Public Sub RunSearch(SearchTerm As String)
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim sql As String
Dim cols As String
cols = "[acct], [acctname], [planid]"

[Code] ....

View 1 Replies View Related

Queries :: Allow Edits To Check Box On Subform In Dataset View

Jun 25, 2015

I have a simple form that has a subform with its datasource being a query that is a multi-table select (complex joins)... the subform is set to allow dataentry, edits, etc. I have a checkbox that displays a value from the query (0, -1). Is there a way I can enable this checkbox to write back to one of the tables? Temp table to hold the contents of the query?

View 8 Replies View Related

Forms :: Quick Print Printing Previous Dataset

Jun 6, 2013

I'm having an odd problem with a form. We noticed this since migrating it from adp to accdb.

It's a form with two subforms in datasheet view, that contain data on a certain employee, which is selected on the main form.

If you use print preview before printing, it all prints out fine. However, if you use quick print, it does something weird. If you Pull up Employee A, then Employee B, and do a quick print, it will print the data for Employee A in subform 1, and the data for Employee B in subform 2. It displays correctly on the screen though, and the 2nd time you quick print, it comes out right.

View 1 Replies View Related

Forms :: Dataset Based On A Table - Order Of Added Records

Aug 9, 2013

I have a form with a dataset based on a table. (there are a number of buttons on the form with code so it's important I don't delete the form and start again with a new one)

The data displays correctly but the order is wrong. It displays the last record added as the first record when viewed in form view.

I want to reverse this order, how do i go about it? It seems very simple but I've yet to find a solution.

I also don't want to base it on a query because of the code mentioned earlier.

View 4 Replies View Related

General :: Create Dataset With Ability To Search Through Macro Form?

Feb 23, 2013

i orginally thought i should do this in excel but i think when the dataset becomes larger and i want to eventually get it on the web - i thought its access i need?

i have created a mini dataset as an exmaple of what im trying to explain..i have in first column the objects, and columns after this are the elements needed to make the object (i have just labelled the element titles a b c etc - there will be LOTS of elements once i get the dataset created). so if i had a red blue green cream elements - a search would bring back both lights and lamps that i am able to make.

object A B C D E F G H
lights red blue green cream
lamp red blue green cream
garage red blue green cream yellow brown purple pink
house orange white green blue red black
garden orange white green blue red
garden house orange white green blue red

is there a way of creating a search lookup to this kind of information? a form which you type the criteria in and it brings back what you can make? if i was one element away from an object could I use a wildcard function to say, if you had black you could make a house?? etc

View 3 Replies View Related

General :: Combo Charts - Graph Showing Certain Dataset As Column And Average For That Set

Aug 10, 2015

Is it all possible to create the equivalent of a combo chart in Excel in Access?

What I need is a graph showing a certain dataset as columns but also a line showing the average for that set.

As an example lets take an exercise programme in a school, each child performs a series of exercises every week and data is recorded, to monitor their fitness progression.

Lets say I wanted to show a graph of one particular exercise, with the class students listed along the x axis, and then show the class average for that exercise dataset as a line on the same graph.

View 3 Replies View Related

Modules & VBA :: Splitting Dataset Sorted On Two Fields Based On Change In Value In One Field

Feb 6, 2014

I am new to MS Access, and am not sure if what I want to do is even possible. It is my understanding that comparing subsequent cells within a field in a database cannot be done- so I thought I'd see if there is a way to go around it.

I have a dataset for pedestrian activity, with over 3 million rows and 40 columns - too big for excel to handle.

I need to sort the entire dataset by 2 fields, following which I need to search down the field containing my pedestrian ids (numbered 1, 2, 3... till approx 10000), and when my ped id changes from one to the next, I need to check the value in a field showing the ped location, and if that matches with the ped's previous location, I need to copy out a cell corresponding to the previous cell's time stamp. If it doesn't match, I need to copy out another time stamp from another field.

View 1 Replies View Related

Queries :: Run Query Multiple Times (different Data Parameter) To Generate Single Dataset

Mar 30, 2015

I have a reasonably complex query (3 subqueries into 1 main query) which gathers data from various tables into a single dataset based on a specified date.

I now need to generate a similar dataset but across a range of dates (a month) for reporting purposes. However, I can't just adapt the query and change the parameter from a "=#<Date>#" format to a "Between #<Date1># And #<Date2>#" format

The reason being, each date has to be treated individually and has to be queried as a standalone. It's to do with the type of data I have (one-to-many relationships between tables)

So what I really need to do is run the same query multiple times, for each date in scope, then stitch all of those datasets together into one 'giant' one.

How to do that in SQL (effectively, have one query produce the dates in scope, then join that onto the other query, passing each date as the parameter - I don't even think that's possible to be honest)

The other option I can think of is to use VBA to loop through the dates in scope, then use a QueryDef object to set the parameter and read the records for each date into a Recordset object. But then I have the problem of stitching all the Recordsets together, without looping through all the fields and rows each time.

View 3 Replies View Related

Help Me With Updates!!!

Jan 17, 2005

Sorry for my English, but i try to description my problem.

I have one form and i want all fields to have the privelage for update
without only the field of s/n ( Key of table ) ???

Any ideas!!! ( I am noob in access and VB )
Help me plz.

Thanks

View 2 Replies View Related

Updates

Jan 4, 2006

* I have a form that has a list box at the bottom of the form and all the fields (text boxes) displayed above.
* As I select a record in the List Box it shows that record in the text boxes above and allows the user to edit that specific record.
* I went one step futher and created drop down boxes out of the TextBoxes, which now reference a lookup table.
* Although the users have a drop down box they can still enter a new entry.

My problem is that I want the lookup table to be updated with any new entrys that do not exist in the lookup table. I had this working at one point but cannot remember how or what I did.

Any thoughts?

Thanks in advance



View 3 Replies View Related

Track Changes

May 30, 2006

Hallo Everyone,

I am working with the database that consists of more than 15 tables with more than 50000 records and the problem is that more than 10 people use the database. So in this case I am not sure whether who has the changed the data in it.

So for this reason i need to create a logfile to determine what are all the changes made in the data in the database with the user who uses that.
(I need to create a history and save it.)

is that possible in MS ACCESS? if so can anyone tell me some suggestion


aravind.s

View 3 Replies View Related

Am I On The Right Track?

Apr 14, 2005

Hi! I am new to Access and am trying to create a database for my customers that tells me what product/service they avail of and the status of their payments.

My tables are

Customer Info
CustomerID
LastName
FirstName
Address
ContactNo

Products (A,B,C) ( A customer can only purchase one product)
CustomerID
ProductID


PaymentSchedule (Annual, Quarterly, Monthly)
CustomerID
PaymentSchedule

Annual Product Fees
Product
Fee

Quarterly Product Fees
Product
TotalFee
QuarterlyFee

Monthly Product Fees
Product
TotalFee
Downpayment
MonthlyFee

Am I doing ok so far? I wasn't sure How to make my tables since the amount payable is dependent on both the product type and the payment schedule. Any suggestions?

View 3 Replies View Related

General :: Bound Form With Search Box - Select Record In Dataset And Display In Form

Aug 19, 2014

I have a bound form which is from tblEmployee, I'd like to have a dataset below (like a splitform but not a split as they have limits) so when i search in the box it gives me say all the smiths - i select for example david smith and it displays his information in the form objects above so they can be edited?

View 1 Replies View Related

Database Updates

Mar 27, 2006

Back at you guys with hopefully one more question (btw the command button code worked perfectly thanks)

Another thing my database has to be setup for is updates, Roughly 30 people will be using this database and to have them re-copy and paste the new database releases is out of the questions.

Does anyone have experience setting up code that automatically checks the version of the database created and if it differs downloads/installs the new version and the restarts the database so the associate will then be working in the current version?

I am looking to be pointed in the right direction to get this figured out, thanks.

View 3 Replies View Related

Automatic Updates

Oct 23, 2006

Hi there,I know very little about Access but been asked to find out if this is possible:On a database we have a date field for when subscription is due, is there any way that if a DirectDebit method of payment has been chosen, when the date of renewal is, access will automatically update the year to the next one?Thank you very muchCathy

View 1 Replies View Related

Updates To DB Not Saving

Jul 2, 2007

Hi

Have a bit of an odd problem with the DB im using at work. I have 1 DB on a shared drive that is accessed by 4 of us from our desktop PC's (password protected via 1 password that we all use - no separate logins).

The problem comes that we make changes to the data, exit via an exit button that uses a save all macro (that all works fine), however when we go back into to DB there are some times that the changes made have been lost and the data has reverted back to the previous version. There doesn't seem to be any specific pattern to this, it happens at random times and to random people.

Does anyone know what may be causing this, or anyway that i can prevent it happening?

much appreciated.

View 1 Replies View Related







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