Sponsored Links:
Related Messages:
Differences In Two Tables
Hi everybody It is my first post here :) I have a simple (I hope :) ) question. I have two tables in my database. Tables are simple and the structure is the same Tables contain some different and some the same records I want to create a new table (or Raport maybe) which contains differences (different records which are not in both tables) How can it be done in the easy way? Sorry for such stupid question but I have tried to find this forum for similar issue with the easy solution but no luck. Thx for the reading :)
View Replies !
View Related
Differences Between Two Tables
I have a Table named WorkUnit1234567-01-01-07. We'll say the info on this table is from 1 January. I will then have a Table named WorkUnit1234567-02-01-07. We'll say the info on this table is from 1 February. Both of these tables will have the same fields. What I would like to do is compare Table WorkUnit1234567-01-01-07 with WorkUnit1234567-02-01-07 and only show the differences between the first table and the last table. Any ides on how to accomplish this?
View Replies !
View Related
Show Differences Between Tables
G'day, I am using ACCESS to compare roles for users on our SAP system before and after a QAS refresh. I have two tables, one listing roles before and one listing roles after the refresh, how do I have to relate these two tables and what type of query should I run to present me with a list of roles that appear in one table and not the other, since I have two tables there may be roles in table a that arent in table b, as well as roles in table b that arent in table a. I need to see both these. I also dont want to see any roles that appear in both tables. any help? Russ
View Replies !
View Related
Matching Name Differences
Hi. I am in the process of loading nursing license numbers into my database. The spreadsheet that I am importing from does not use the exact same names as the ones in my database, i.e. Smith, Deb in my database is Smith, Debora in the spreadsheet and I can't figure out the code or procedure to use to tell the database that these names are actually for the same record. Is it possible to do this and if so, how? Thank you! KellyJo
View Replies !
View Related
Differences Between UK VAT & US Tax Systems And DB Design
I'm building a number of systems that I'm trying to make compatible in the USA and UK I have sorted all The Date And Currency Formats so the system Can Now work Completely With Both.But At present The Systems Designed To Work With The UK VAT System Would anybody be able to give me some guidance with what I would need to make the tax system Correct for the USA As Well As The UK.Many thanks in advanceMick
View Replies !
View Related
Comparing 2 Fields--Looking For Differences
Hello, I have 2 fields that are supposed to have the same information for each record. I got the information from different sources, which is the reason for having 2 fields. I wanted to make sure that the information was accurate. Turns out, that some of it isn't accurate--all the fields don't match. Here's a little example of what I have: |___TITLE___|___ISSN 1___|___ISSN 2___| |__TITLE 1__|__12345678__|__12345678__| |__Title 2__|__22224444__|__23224322__| |__Title 3__|__98765432__|__98765432__| As you can see, the ISSN numbers for Title 1 and 3 match. There's no problem there. I want a query that would list all those like Title 2, where the ISSN numbers don't match. Then I'd have a list of all of the problem Titles, and I could look up the real ISSN numbers. Thanks -Siena
View Replies !
View Related
Why Those Permission Differences Btw Access Files ??
Hi accessors, I have 1 permissions related Q. If I create msaccess db by calling the app through its icon, i get a db with following permission items : Administrators(compNameAdministrators) System user(compNameuser) but if I create it through rightclick> new> ms_office_access_application, I get a db with: Administrators(compNameAdministrators) Everyone System user(compNameuser) Users(compNameUsers) VS Developers(compNameVS Developers) Why /the hell/ those differences btw the same kind of files ? :mad: greets
View Replies !
View Related
Identify Differences Between Table And Spreadsheet
Here is the problem I have a tblOrders that has 1800 records with 31 fields primary key tblOrder which is a number. Periodically users export data from SAP into a spreadsheet, which are changes to the original data but may not contain the exact same fields as the master tblOrders. The data in this spread sheet identifies changes and may contain aprox half of the fields that are contained in the master tblOrders. The field names however (in the spreadsheet) will be of the same type as in tblOrders. What I would like to do is identify differences between the tblOrders records and the records in the spreadsheet, and then update the tblOrders to show the changes. how would you proceed? Maybe create a new table by importing the excel spreadsheet into access and then somehow querying the differences and updating the master. If anyone has done anything like this b4 please could you update me... Cheers in advance.
View Replies !
View Related
Query Differences In Access 2000 & 2003 Using Vba
Hi, I'm just wondering if there is any differences in writing queries in vba in different versions of access. i'm developing a search function in access 2000, but it doesn't seem to be working. however, the same code in access 2003 works fine. Here's an extract of the code when the search button is clicked (I'm getting table information, attribute/field information and condition they're specifying from the user. The result is then displayed in a subform): Private Sub cmdFind_Click() Dim searchSQL As String Me.cmbTable.SetFocus searchSQL = "select * from ENGINEERS INNER JOIN TEL_CABLING ON ENGINEERS.EngID = TEL_CABLING.EngID where " & Me.cmbTable.Text & "." Me.cmbAttribute.SetFocus searchSQL = searchSQL & Me.cmbAttribute.Text Me.txtCondition.SetFocus searchSQL = searchSQL & Me.txtCondition.Text Me.subfrmTest.Form.RecordSource = searchSQL Me.subfrmTest.Form.Requery End Sub The part in red is the part that is highlighted whenever i run it in access 2000. The error message is: " You entered an experession that has an invalid reference to the property RecordSource " Can anyone tell my why it's like that and how i can fix it to work for access 2000? Thanks I've also enclosed a picture of the form, so you can get a feel of what it looks like. Kathy
View Replies !
View Related
Update Query Using 3 Tables: Source, Joining, Destination Tables
I have some experience doing 'Update Query' using two different tables but I'm having a hard time doing an 'Update Query' using 3 tables. I have my source table TP05XY with the fields 'Mark' 'Date' 'UTM_Edig' and 'UTM_Ndig'. Mark and Date are my primary keys (they together uniquely ID each record). I have my Observations table with the fields 'Mark' 'Date' and 'Obs_ID'. The last table is Locations with 'Obs_ID' 'UTM_E' and 'UTM_N'. I want to update my fields UTM_E and UTM_N from UTM_Edig and UTM_Ndig. However, to do so, I have to go from my TP05XY table, through Observations table to update Locations table. Table TP05XY is joined to Observations through 'Mark' and 'Date' and Observations table is linked to Locations through 'Obs_ID' field. I have tried a few options without success ... anyone knows how to do it? Thanks, Josée
View Replies !
View Related
Moving Data From 2 Related Tables To 2 New Tables As An Archive
I have a form displaying the 11 fields of the parent/primary table using a selection from a combo box. I am using queries and vba code modules respective to form, combo box and command buttons. I have initial code that uses the two fields from the combo box selection to append same to a new parent/primary archive table. I now want to add to the append SQL the remaining fields to the parent/primary archive table. When I add the second sql string for the remaining fields to the same procedure and execute I keep getting 'null in primary key'. If I copy the primary record and paste same into the archive table it works. Private Sub Command26_Click() On Error GoTo Err_Archive_Primary_Click Dim strSQL As String Dim strSQL2 As String strSQL = "INSERT INTO ARC_289325045 ([Survey Point ID], [Survey Area Detail], [Date On Site]) " & _ "VALUES ('" & Me.cboAreaDetailDate.Column(0) & "','" & Me.cboAreaDetailDate.Column(1) & "'," & _ "#" & Me.cboAreaDetailDate.Column(2) & "#)" CurrentDb.Execute strSQL, dbFailOnError 'strSQL2 = "INSERT INTO ARC_289325045 (RecordID, UnitID, UserName, [TimeStamp], [Survey Point - Area], Measurement, NewArea, [EXIT Form] ) " & _ '"SELECT FORM_ID_289325045.RecordID, FORM_ID_289325045.UnitID, FORM_ID_289325045.UserName, FORM_ID_289325045.TimeStamp, FORM_ID_289325045.[Survey Point - Area], FORM_ID_289325045.Measurement, FORM_ID_289325045.NewArea, FORM_ID_289325045.[EXIT Form] " & _ '"FROM FORM_ID_289325045" 'CurrentDb.Execute strSQL2, dbFailOnError Exit_Archive_Primary_Click: Exit Sub Err_Archive_Primary_Click: MsgBox Err.Description Resume Exit_Archive_Primary_Click End Sub The next step is to do the same for the child table and append related records to the child archive table.
View Replies !
View Related
Moving Data From 2 Related Tables To 2 New Tables As An Archive
I have a form displaying the 11 fields of the parent/primary table using a selection from a combo box. I am using queries and vba code modules respective to form, combo box and command buttons. I have initial code that uses the two fields from the combo box selection to append same to a new parent/primary archive table. I now want to add to the append SQL the remaining fields to the parent/primary archive table. When I add the second sql string for the remaining fields to the same procedure and execute I keep getting 'null in primary key'. If I copy the primary record and paste same into the archive table it works. Private Sub Command26_Click() On Error GoTo Err_Archive_Primary_Click Dim strSQL As String Dim strSQL2 As String strSQL = "INSERT INTO ARC_289325045 ([Survey Point ID], [Survey Area Detail], [Date On Site]) " & _ "VALUES ('" & Me.cboAreaDetailDate.Column(0) & "','" & Me.cboAreaDetailDate.Column(1) & "'," & _ "#" & Me.cboAreaDetailDate.Column(2) & "#)" CurrentDb.Execute strSQL, dbFailOnError 'strSQL2 = "INSERT INTO ARC_289325045 (RecordID, UnitID, UserName, [TimeStamp], [Survey Point - Area], Measurement, NewArea, [EXIT Form] ) " & _ '"SELECT FORM_ID_289325045.RecordID, FORM_ID_289325045.UnitID, FORM_ID_289325045.UserName, FORM_ID_289325045.TimeStamp, FORM_ID_289325045.[Survey Point - Area], FORM_ID_289325045.Measurement, FORM_ID_289325045.NewArea, FORM_ID_289325045.[EXIT Form] " & _ '"FROM FORM_ID_289325045" 'CurrentDb.Execute strSQL2, dbFailOnError Exit_Archive_Primary_Click: Exit Sub Err_Archive_Primary_Click: MsgBox Err.Description Resume Exit_Archive_Primary_Click End Sub The next step is to do the same for the child table and append related records to the child archive table. Edit/Delete Message Reply With Quote Quick reply to this message JJKramer View Public Profile Send a private message to JJKramer Find all posts by JJKramer Add JJKramer to Your Buddy List Sponsored Links
View Replies !
View Related
Split Db: Data Being Stored In FE Tables, Not BE Tables
I have created an Access 2000 Db, and have gone through the motions of splitting the Db via the Splitting Tool. Since I have done this split, I have added forms, queries, and reports to the Front End. I have left the Back end table structures alone. This is where my problem comes into play. To enter data into the Db, I use the forms. After splitting the Db, I assumed that the data would be stored in the tables in the BE. An issue had just presented itself and I went into the BE table structure to add a field to a couple of the tables, and when I opened the BE table in the datasheet view, I noticed that there were no records. I then became curious because when I run my reports and queries, the information is present. So I opened the FE tables and what do you know, all the data I have input since the split is housed in the FE tables. I already attempted to Update the Table Links, but that did not solve the problem, and the data is still in the FE. Can someone, anyone please help or offer some suggestions on how to resolve this dilemna. Thank you in advance, DtF
View Replies !
View Related
|
TRACKER
