This is a question that you might scratch your head while reading, but what the hell... :-)
Imagine a form with 4 blank textboxes (name, input1, input2, input3). When you add the value in the textboxes, the value in the table changes as you write. Instead I only want the values in the table to be added once an "OK" button has been pressed.
When the button is pressed I want the current date written in a field called 'date' and the inputs from the 4 textboxes added to fields with the same name...
I am trying to extract some values from a PDF (attached) and write them to an Access database. I am unsure of the approach, especially extracting values from the file.
Hello everyone, hopefully you can help before I go crazy. i have been working on this problem now for 3-4 days.
I have two forms (ID-Injury Choice) and (Treatments). In both forms I have the control (InjuryID). What I am trying to do is when I click a button on the ID-Injury Choice form, the InjuryID control value is automatically transferred to the Treatments form.
For the life of me I can figure out this simple act. Any help would be appreciated.
I have a Contacts subform and would like to be able to double click to fill addresses, and details from the previous row...every person in our database even those living at the same address needs thier own record.. and since we only need to fill up to 5 records and review them, double clicking on the first name to fill up the next row with the previous addres phone number ect would be grand.
I am assuming we could fill out the new Full Name and double click on it to get the previous record filled to the new one. Don't really want to work with a query unless needed, but I have a little vba understanding.. how do I code this to make it work?
Often I use Labels as buttons due to the fact I can colour them the way I want, and use the on click event to trigger code. The code below however works for a command button, but not a label button.
DoCmd.OpenForm "frmdatetime" Do While Forms!frmdatetime!OKFlag.Caption = "False" DoEvents Loop
When this code is run by clicking on a command button, it works fine. If run by clicking on a label, frmdatetime opens, but the mouse will not work on either of the 2 open forms unless you go down to the windows task bar, jump onto another window, and back onto frmdatetime. If I remove the loop with the DoEvents in it, then the problem does not occur.
Can anyone enlighten me as to why this behaviour occurs.
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 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.
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.