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