Write Several Records At Once
Apr 17, 2005
Hi there.
I have a contact table, and a mailing list table
Each contact can belong to one or more mailing lists. Hence a created a intermediate table to join the contact and mailing list tables, containing contactID and mailinglistID.
The problem is that when I want to register a contact in several mailing list, I need to be able to do it in one time :
For example, selecting the contact in a combobox, then affecting him to mailing lists by making multiple selection in a drop box or ticking checkboxes.
For example, I want contact 1 to belong to mailing list 3,6 and 8, wich would result in the jonction table in 3 records
1-3
1-6
1-8
without having to repeat 3 times the same operation for each mailing list.
Thanks for your help
(I m using access 97)
View Replies
ADVERTISEMENT
Jun 7, 2007
Hello All,
If I want to select a row from subform A and a row from subform b and click a button and have the keys stored in another table what would be the best way to do that?
Thanks.
View 13 Replies
View Related
Dec 19, 2012
I am trying to write a query that will return records from multiple tables. I currently get an error suggesting I create a subquery or else I get far too many records.
The query is EditAttendanceQuery (I left it in a bit of a state). The fields I need are shown in the query. The records I need are based on the Edit AttendanceQuery (Form). I can get the records I need without the CourseNumber and Section, but it all goes downhill when I include them.
View 14 Replies
View Related
Apr 28, 2014
I have a query with many fields. One of them is the combination of two fields and is called "Components Reference". What I try to do is, every time this query is updated, the records of only this field "Components Reference" to be written to the field of another table which also takes records from an another query. I wish I was clear enough.
View 13 Replies
View Related
Jun 27, 2013
I am the first to admit I struggle with looping through records.
I am trying to loop through a table and collect external income data and write it to a new table.
My issue may be the way the table is laid out. ???
The attached pictures show the tables. The tblExtInc is where the data are. I am trying to create a table that looks like tblExtIncYr that shows each year and separate entries by item.
How would I loop through tblExtInc and grab ex:$2000 every year for upto 100 years but only get the $1000 for year 6,7,8 only?
View 2 Replies
View Related
Aug 14, 2013
I have a list box whose data is inserted in a table named as "test0" ,now in a macro of vba i want to select all the items in the list box and create there pdf files in a folder at my desired location. So far i have managed to create a pdf file of single item ,but i want to select multiple items at once ,
Code:
SELECT test0.ID, test0.item FROM test0 WHERE (((test0.item)=[ItemNumber]));
So, in this query itemNumber are multiple and i want to create there pdf files at once ..just on a click of one button ?
View 2 Replies
View Related
Feb 9, 2015
I have two tables
1) has email address, and Store ID
2) has multiple records per store
I need to write a procedure to send a separate email to each store that contains the records found in table 2 ( excel format).
View 3 Replies
View Related
Jun 12, 2006
i need to update some textbox value when insert some value at another textbox.. like when i add 3 at 1st textbox, 2nd text box will calculate it auto matically wit this formula, 2ndtextbox = 1sttextbox - 1 ...
so where should i type ? query? how? default value? if need to wrte code, which 1 i need to write it? after update? before update?
TQ
View 1 Replies
View Related
Sep 16, 2005
on my laptop, i have an access front end with tables linking to sql server personal edition.
i open a linked table, edit a field, and i get a write conflict error message 'this record has been changed by another user since you edited it', and the save record button is not enabled
i have many linked tables, but this is the only table that gives me this error. i have deleted the table in sql server, and made a new table, and started the link process again, but still the write conflict.
also, as i dont know if this is related.
when i get tothe screen to link the tables, i see 2 table names prefixed with a "~", however, when i go into sql server, i cannot see any tables prefixed with a "~"
any responses would be most appreciative, as my project has effectively stopped until i can resolve this.
View 1 Replies
View Related
Oct 17, 2005
Hi
I have a small database written in access 2000 which has be compiled as a mdb, this resides on a file server and can be run from a number of workstations on the network .
It has been running ok for 2 years until a couple of weeks ago, on one particular pc the database opens and you can do reports etc view exist data as normal ,but you cannot write to a table ( these are contained in a second table only data base )
if you run the program on any other pc workstaion it works fine as it has for 2 years on this problimatic PC.
it must be something on the particular pc , we have reinstalled Access 2000 to no advail
Any Ideas on this
Regards
Sam
View 2 Replies
View Related
Jun 29, 2006
What is the best way to go about doing a 2.0 version of a database? When I wrote ours I was a newbie. Not that I am an expert now or anything but things could definately use an upgrade!!!
I need to clean up the forms, etc. Do I just dump all the tables in from the old one and start over?
I also want to completely revamp a couple of things. How would I make sure that all the purchase order numbers (auto number field) still matched?
Thanks for any ideas!
View 2 Replies
View Related
Jan 24, 2005
users are using a hand held scan gun to enter data into a field. if the barcode is 12 characters long, I only want the 1st 7 to be written to the table.
I was thinking a validation rule using TRIM or LEN but can't seem to get it to work.
Any ideas?
Thanks
View 7 Replies
View Related
Oct 23, 2006
Hi all,
Is it possible for one field on a form to write to 2 tables?
e.g. i type in field "Owner" on my form which is sourced to "Owner" in table A but i would also like it to populate "Owner" in Table B.
Hope that makes sense.
Thanks
Mark
View 1 Replies
View Related
Jan 30, 2008
When does form data get written to a table?
I want to use the value from a textbox as openargs for another form. If I don't do a write to the table with SQL, then I get a NULL error on the getOpenArgs on the form. If I do do a write, then I get multiple occurrances of the record.
Thanks,
Mike
View 3 Replies
View Related
Aug 7, 2007
Hello, I need help writing a formula in a query
I have a database where I need to be able to pull different prices according to type.
For example, if it is a SH then I will need it to pull a certain price of an item under the SH level
if it is a DD, then I will need to pull a price of the item under the DD level
How can I write this formula in my query as an expression or do I need to write it as SQL dlookup.
If it is the dlookup, how do I write that.
Help!!!
View 1 Replies
View Related
Jun 27, 2005
Hi,
I am keep on getting Write Conflict whenever I check a check box called chkHCE. There are over 3000 records and it's happening for every records. I would understand if it's happening once in a while but it's happening for every records.
Please suggest. I attached the error print shot. The data souce is a qry but updatable query. The query has two tables tie together. I never had any problems. Can anyone share their idea Please ???
Thanks
Code behind the chkHCE
Private Sub chkHCE_Click()
If Me.chkHCE.Value = True Then
Me.HCEInitialPrepared.Enabled = True
Me.HCECompletionDate.Enabled = True
Me.HCEType.Enabled = True
Else
Me.HCEInitialPrepared.Enabled = False
Me.HCECompletionDate.Enabled = False
Me.HCEType.Enabled = False
End If
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Me.CWSubform.Requery
Me.PlanWeight.Value = Me.PlanWeightCalc.Value
End Sub
View 2 Replies
View Related
May 8, 2006
I am getting the following error: Write Conflict--This record has been changed by another user since you started editing it....
I think i know why, but I am sot sure what to do about it.
I have a main form with a sub form, each is based on a stored procedure with only one table in it (not the same table) and only one parameter.
When I make a change to anythign in the subform I update the main form's "last changed date" field then when I hit save on the main form I get the error.
How do I resolve this?
I am using Access 2002 SP 3 with an .ADP not .MDB and MS SQL Server 2000.
View 1 Replies
View Related
Jan 8, 2004
Hello All,
I've created a query that resets a table entry called "Drum" to null if I change the record "Cable". This process works, except I get the following error when I do so:
" Write Conflict
This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made.
Copying the changes to the clipboard will let you look at the values the other user entered, and then paste your changes back in if you decide to make changes.
[Save Record] [Copy to Clipboard] [Drop Changes] "
I have set warnings to false but this still comes up.
Does this mean something is wrong with my method of updating the table? If not, is there any way I can stop the warning coming up?
Thanks to anyone who helps,
Bakerboy
View 4 Replies
View Related
Apr 18, 2007
I am new to using sql statement in my codes. I need help in writing a sql statement using one sql statement (sql_1) in another (sql_2)? In the sql statements below, I am trying to replace "query2" with the sql statement (sql 1). Please help
sql 1: SELECT tbl_HourTypeMaping.CustomerCode_HTMP, tbl_HourTypeMaping.HourTypeCode
FROM tbl_HourTypeMaping
WHERE (((tbl_HourTypeMaping.CustomerCode_HTMP)="htmp_default"));
sql 2: INSERT INTO tbl_HourTypeMaping ( CustomerCode_HTMP, HourTypeCode )
SELECT Query2.CustomerCode_HTMP, tbl_HourType.HourTypeCode
FROM tbl_HourType LEFT JOIN Query2 ON tbl_HourType.HourTypeCode = Query2.HourTypeCode
WHERE (((Query2.CustomerCode_HTMP) Is Null));
View 2 Replies
View Related
Feb 26, 2008
I having been going mad for a week trying to write a query, please help me.
I am trying to get the MaxServicedate for each Product (PIDFK) for every Location (LID), but then I also need the MaxServicedate regardless of Product use, for each Location that is smaller than the previosly obtained MaxServicedate.
I hope that makes sense.
I have tried this query
----------------------------------------------
SELECT T.LID,
T.PIDFK,
T.MaxOfServicedate,
Max(tblTakings.Servicedate) AS NextMax,
T.Installdate
FROM
(SELECT tblLocations.LID,
tblTakingsProductMM.PIDFK,
Max(tblTakings.Servicedate) AS MaxOfServicedate,
tblLocations.Installdate
FROM (tblLocations INNER JOIN tblTakings ON tblLocations.LID = tblTakings.FKLID)
INNER JOIN tblTakingsProductMM ON tblTakings.TID = tblTakingsProductMM.TIDFK
GROUP BY tblLocations.LID, tblTakingsProductMM.PIDFK, tblLocations.Installdate) AS T
LEFT JOIN tblTakings ON T.LID = tblTakings.FKLID
WHERE (((tblTakings.Servicedate)<[T].[MaxOfServicedate]))
GROUP BY T.LID,
T.PIDFK,
T.MaxOfServicedate,
T.Installdate
ORDER BY T.LID,
T.PIDFK
-------------------------------------
But I am missing some records!!
The subquery gives me all 90 records with the MaxServicedate for each PIDFK in each LID
The main query is missing the records that dont have a service date previous to the MaxServicedate in the subquery!
Any help appreciated.
Thanks
View 10 Replies
View Related
May 17, 2005
Hi,
I've had a customer request to have a larger area to type into a memo field. I've removed the memo field from the form and have added a button to bring up a form with just the memo field on it. A problem has arose from this that now when closing out of the form I get a write conflict error. I've never seen this before and there is only me logged into the database. How can I stop this from occuring?
Thanks
View 2 Replies
View Related
Feb 22, 2007
Not being good at codes.
What I attemping to do is edit a email address, upon entering that field.
As of now I right click in the field and then edit the email address.
any ideas
View 2 Replies
View Related
Mar 7, 2008
I am an estimator for an industrial and commercial insulation contractor. I have compiled an enormous amount of data over the years but I am still figuring all of my estimates by hand.
For instance, I might need to figure that a 3 pipe will be insulated with 2 thick fiberglass pipe covering. This pipe is outside, so it will need to be jacketed with .016 thick aluminum secured every 4 with sheet metal screws.
The 90 and 45 degree elbows need to be insulated with preformed fiberglass elbows and jacketed with preformed aluminum elbow covers. Every 15 feet there will be a pipe support. This line is a schedule 40 steel pipe and it has valves on it and each valve has a flange at both ends so the insulation for the valves will have to be big enough to fit over the flanges. Where the 3 pipe might require 2 of insulation, a 1 pipe might only require 1-1/2 of insulation. Each size and thickness has its own production figures. This is the same with prices for the types of insulation and jacketing.
I have compiled all of this information into tables. Where before I had to get out my books and look each up, no I go to my tables, find the amount per day, and calculated that by the number of items. I can look up each type of insulation for each type of fitting or valve and I can calculate how much time all of this will take. I can also look up to see what size covering will fit on a 3 flanged valve. I have another table that will tell me how many square feet of jacketing the pipe, fittings and valves will require. I have prices for all of the associated materials.
The same happens when I try to figure equipment or ductwork. We deal with many kinds of insulation and just as many jacketing and finishes.
I bought Access 2007 and have brought my tables in. I want to have a spreadsheet or form that will allow me to link this information together and make the proper calculations. I want to be able to change the pipe sizes or materials from a list and have the calculations adjusted accordingly.
Again, I have all of the figures; I just don't know exactly how to go about getting all of this linked together in one place. I have only dabbled in computer code writing and I really don't know very much about it. That is why I picked Access because I figured it would have about everything in it that I need. I know the layout of the form I need, I just dont know where to go from there.
Any guidance would be appreciated.
View 3 Replies
View Related
Aug 12, 2005
I have a form (frmTraveler) in which a user is given a selection of levels for a type of trip from a drop down box (TripLevel). Basically, if a user picks level A, then I would like a value to be written to the corresponding record in another table (tblHotel). The PK is an autonumber (TravelID) and the tables have a one to many relationship. Hope that's enough information for some tips! :)
View 1 Replies
View Related
Jan 31, 2005
I searched this one and found that someone else had posted the same problem 2 years ago, but since no one replied to that one... I'm still stumped.
I have a set of subforms, each on a separate tab of the main form and pulling from the same table. I have code triggered on after update so that changes to a control on subform A will make changes to several controls on subform B (specifically, disabling the control and deleting any value). When I switch to subform B, I get a message saying:
"Write Conflict: this record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made. Save record, copy to clipboard, drop changes"
Please help!
View 7 Replies
View Related
Mar 3, 2005
Hi all,
I have followed the advice on this page of 'how to update stock levels automatically' in access.
http://support.microsoft.com/default.aspx?scid=kb;en-us;252813
I implemented this in the Northwind database and everything was fine. I implemented this in my database (which is very similar to the northwind in structure!) and receive this error:
"WRITE CONFLICT
This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made. Copying the changes to the clipboard will let you look at the values the other user entered and then paste your changes back in if you decide to make changes."
I have no idea how this is happening. Can anyone throw some light on this? Any advice will be greatly appreciated.
Regards
View 2 Replies
View Related
