I have a form (frm_riskcalc3) which its data source is a table called: tbl_targets, on the 'frm_riskcalc3' form are; 15 unbound label text Fields and 15 unbound number value fields that are pre-set with data, I need to find a way to allow these fields to be updated without changing what their values were before.
[URL]
My problem has now moved on to a form issue which means no one has been able to answer is in the queries section of the forum as there is no way around it using queries so i hope you can help. All information is available on this thread. Thanks, Sci http://www.access-programmers.co.uk/forums/showthread.php?t=100376
View 3 Replies View RelatedI have a query which performs a calculation calculating totals of many fields linked by BikeID This is not updatable due to the calculated field. Now i want to join this query to the BikeDetails table to create a form. So this means that i would have all the data from the table which i can update and the calculated field which i cant. But when i join the two tables/query all the data becomes non updatable.
Thanks
Sci
I have a Form Display Data in my Access Database, which is working really well. However, users was asking if there is a way we can make Font Color Could/would change if The text in A field or Any field in my display form contained the word "SAD or MAD". Is there code for such thing in display form?..
View 3 Replies View RelatedOk ive been having this sort of problem for a while. Ive been trying to display updatable and non updatable data in a datasheet form. The problem is that i couldnt update any of the details with a calculated field in the table. Therefore i have put the calculated field in a subform thanks to someone on the forums request(sorry i cant remember who it was). After referencing the subforms text box i can display the correct information in form view however i cannot display in in datasheet view without expanding the subform [+] for the form to do the calculation. I need the form to go through all records once it opens unless anyone has a better solution. Hope sumone can help,
Thanks Sci
I have a form where I would like to validate (restrict) choices in subsequent fields.
Example
Combobox choices are Air, Fire, Water, Earth, Space
In the form I have 4 fields = Material1, Material2, Material3, Material4. (all in same record on my table)
Basically I need the validation to not allow duplicates across the 4 fields.
something like....
[Material1] <> [Material2] or [Material3]or [Material4]
I am not sure of the proper syntax for the validation field in the Form Properties. Or if I am even putting it in the right place.
Hi all,
Not sure where to start on this one!
First I have a main form “FormA” formA has a subform “FormB” in a datasheet format. I have one of the fields in “FormB” Double-Click Event procedure as follows:
Private Sub Results1_DblClick(Cancel As Integer)
Me.Refresh
Dim stDocName As String
Dim stLinkCriteria As String
If panel = 5 Then
stDocName = "Subform5"
ElseIf panel = 8 Then
stDocName = "Subform8"
ElseIf panel = "DOT" Then
stDocName = "Subform5"
ElseIf panel = "Breath" Then
stDocName = "SubformBA"
ElseIf panel = "Hair" Then
stDocName = "Subform5"
Else
stDocName = "Subform10"
End If
stLinkCriteria = "[DSID]= " & Me![DSID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
End Sub
This then pops-up a “FormC” (Subform5, Subform8, Subform10, or SubformBA) linked to a specific record from “FormB”. FormC has a drop down field that will allow you to select “Negative or Positive”, and then when FormC is closed, FormB is updated.
This has been working fine for the past 4 months. NO PROBLEMS!!!!
NOW, for no apparent reason when FormC pops-up and I try to click the drop down field; it just BEEPS at me (Almost like the field has locked the user out), then when I close FormC, I get and error: “Recordset is not updatable”. On the FormC (SubformBA), I get no error on close, but I get the word “#error” in the field on FormB.
Has this happen to anyone? Can someone help I have exhausted all thoughts.
Thanks-a-million, ENVIVA
I have 4 fields that are unbound on a form. img1 img2 img3 img4..When these are entered they are all combined and autofill another unbound textbox = imagename.. what i would like to do is from this unbound textbox 'imagename' ..i would like to populate a textbox that IS bound called FileName
[Event Procedure]
Private Sub imagename_Click()
Me.imagename = Me.FileName
End Sub
I have one table containing name of restaurant with its address etc. Then i created another table to list out the restaurant workers names and details. Just as an example,
Table:Restaurant
Restaurant name
Address line 1
Address line 2
Restaurant #
Website
Table:StaffContact
Staff Role
Name
speciality
email
phone
I have the main form that has all the restaurant details only. And i have another form containing the Staff information. Please note the two table have a relation and it works well.
Now to make it user friendly(basically easier for the lazy ones), I dragged the staff contact form on to my main form and displayed it as a datasheet(basically a sub form).
Now, my boss does not want users to add/delete on this sub form(datasheet). So,he wants me to create buttons to open new record of staff for each restaurant(new form)
My issue is with opening a new record to enter a new person to the staff list and give them a role as well in form view.The new form has
So i ran a Macro, with open form with Where condition
Code:
[Staffcontact]![Rest Name]=[Forms]![MainForm]![RestaurantName]
But, it does not work .
My problem is that I want to copy the value of a text-field of form frmSnippet into another text field of form frmChange. But this is not possible, Access tells me that it can't find the form frmChange. But it's there, I checked the name.
My code looks like this:
Const cstrForm As String = "frmChange"
Dim strNr As String
If CurrentProject.AllForms(cstrForm).IsLoaded Then
DoCmd.Close acForm, cstrForm
End If
DoCmd.OpenForm cstrForm, WindowMode:=acDialog
txtSAPNr.SetFocus
Forms!frmChange![txtSAPNr] = Me![txtSAPNr]
Why I get the runtime error 2450?
You often see (particularly on websites) a form field with greyed out text displayed in it, that disappears when typed over - so for example you could have name/address or whatever is supposed to be typed into that field showing.
I'm not looking for default text typed over or anything - a purely visual effect not stored in the tables.
There are two forms invoolved in thi
pfrm_AddClientPrimary
pfrm_AddClientDuplicateCheck
On a command button in pfrm_AddClientDuplicateCheck I have the following code.
Code:
Private Sub cmdAddNewClient_Click()
DoCmd.OpenForm "pfrm_AddClientPrimary"
DoCmd.Close acForm, "pfrm_AddClientDuplicateCheck"
End Sub
This works great
On the onOpen event of the pfrm_AddClientPrimary form I have this code
Code:
Private Sub Form_Open(Cancel As Integer)
Me.FirstName = Forms!pfrm_AddClientDuplicateCheck!txtFirstName
Me.LastName = Forms!pfrm_AddClientDuplicateCheck!txtLastName
Me.SocialInsureanceNumber = Forms!pfrm_AddClientDuplicateCheck!txtSOcialInsureanceNumber
Me.FirstName.SetFocus
End Sub
This fails on the first line with this error
Run-time error 2147352567 (80020009)
You can't assign a value to this object
I am aware of the incorrect spelling of Me.SocialInsureanceNumber this is the way it is in the db.
I am relatively new to using MS Access 2010. Some fields which i have set up as Memo fields to take report comments. Is there anyway to make the size of the memo field box variable to fit in with the text in the form when viewing in htis mode?
View 1 Replies View RelatedIs there a way to setup the format on fields to only allow text inputs, no numbers wanted. I know I can do this at the table level but is some cases numbers are ok. So I want to code it so I can control when numbers are ok and when there not.
View 1 Replies View RelatedI am using Access 2007. Second, I am using two tables, Inventory and Service Request. Inventory is a list all the Inventory, with has things like location (building & room number), type (desktop, laptop, etc.) and access tag number. Service Request also has Access Tag Number (should link back to Inventory) & date of reported/resolved problem and description of problem/solution.
On my form for Service Request, I have the access tag number as a fill text box, when you double click on that text box, it runs a Query that asks for the 1) Building, 2) Room Number & 3) Type . . . Query currently opens in a the spread sheet view that shows those three things but also the Access Tag Number associated to them.
I would like that Access Tag Number to just return into the field that was double click to start the query.
Is this possible? If so what am I missing?
I have a form consisting of a list box and some fields belonging to a single record. When the user highlights a row in the list box then the fields show the details of that record. Now the whole process is Read only. But I wish to put a toggle switch on the form so that the detail fields of the record become updateable. I have tried the following constructs but I could not make those fields updateable.
Code:
Me.AllowEdits = True
Me.DataEntry = True
Me.fld1.Enabled = True
Me.fld2.Locked = True
I have a form with a button that pops up a datasheet with a number of records. I need the dbl click event to populate a hidden text field with the id of the item that was double clicked.
Ive found the double click even and can get the double click to close the window, but i need to populate the text field as well.
i want to search a phone number in contact information table with column names - number, name, address, dob, gender, f-name, m-name etc and show them in a form with each field in separate text boxes in access 2010.
View 4 Replies View RelatedI have a table that holds the SQL texts for ca. 1000 Select queries (mostly minor variants that are used to programmatically swap out RowSource strings for combo boxes). I'd like to have a quick and easy way to open/review/modify these queries.
One strategy would be to display the SQL strings in a field on a Datasheet form, then use an onClick event on a text box linked to the SQL-holding field (or perhaps an onClick event tied to an unbound text box on the form) to open the associated query. That would allow me to view the SQL of the query that I want to open, allow me to quickly scroll through the list of stored SQL texts, and give me options for sorting or limiting the SQL-texts displayed in the datasheet form.
But, I can't seem to get the onClick event to work. The problem seems to be that I can't figure out how to pass the SQL string contained in the field to a function that will use that string to open the query .
I have been assigned a task to create a database to keep track of bridge inspections. I have several records for each bridge and would like some guidance on setting up the tables. When a new inspection is submitted, I wish to enter it into a field that updates the table with a new line for the entry and moves the previous records down in the table. I am not an Access expert but am comfortable enough to follow instructions if anyone has any to offer - or if this can be done.
Many thanks in advance to anyone that can offer any direction (or to tell me I'm living in a fantasy).
My database has Main form and a Sub form. On main form i place one unbound text box named investigations. In subform of which datasheet there is a column named TestCode. I want unbound text box (Investigations) to display row values which selected in a column (TestCode) of subform.for example:Investigation field should display "CBC,HB,ALP".
View 5 Replies View RelatedI am trying to search on EmployeeID field and populate corresponding data like EmployeeName, EmployeePay in other text boxes in the same box .
In my Unbound Form I have three unbound Text Boxes and one Command button:
txtEmpID
txtEmpName
txtEmpPay
cmdFind
In my table EMPLOYEE i have three fields
EmpID -- Autonumber
EmpName -- Text
EmpPay -- Text
I've created a data entry form w/ 7 fields.... [f1], [f2], [f3], [f4], [f5], [f6] are bound to a table. While [f7] is unbound and has Nz function.
Now, the value of [f7] is the summation of [f1] to [f5], i want that what ever value is generated by [f7] will be stored on [f6] in both forms and table...
I'm scanning serial numbers in a field, but the results always start with an S...like S123456789 , S107432567 etc.. how can I eliminate the S and make this field numeric?Access 2007 being used.
View 4 Replies View RelatedI have field in my form and the entry is required. The data type is date. I need to keep the date type as date. My problem is if the date is not available, the user has to enter "Nor Available". Is there any way I can achieve this? What are the other option available to me? The reason is this record will be exported to a pdf form which requires the Date or the text "Not Available" in the specified pdf field.
View 2 Replies View RelatedWhy is it that whenever I link a blank text field from my contacts database that it shows the first contact in my table? and how can i change that?
View 2 Replies View Related