I have a text box in a form that is linked to a Table in another database. The Field name is "notes" and the Data Type is "Memo". When I fill in notes in the main form I only get 255 characters. The “memo” setting is supposed to give me thousands of characters. What’s up? Is it due to the linking between the two databases? :confused:
View RepliesI am trying to make use of the OpenForm command to open a form to a record where a textbox matches the value of a text box on another form.
On Form1, I have a textbox called txtRtnRef, and it contains a reference number in a similar format to SWR-9
On Form2, I have a textbox called txtReOrderRef (control source ReOrderRef) which also contains a reference number in the same format (SWR-9)
I am trying to have a button next to the text box on Form1 that has an OnClick Event that opens Form2 to the record containing the same text reference number.I have tried, to no avail, a number of variations of the OpenForm command, the most recent being
Code:
DoCmd.OpenForm "Form2", , , "ReOrderRef = '" & Me.txtRtnRef & "'"
The form opens, but to a blank record?
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 using Access 2007 and 2010. I would like a text box (or label) on a report to autofil using fixed text from a label on a different (closed) form.
View 8 Replies View RelatedI 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 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 have a form where I want a textbox [txtMaxOrdLimit] to be visible only if another text box on the same form [PaNumber] contains the letter D in the string. This is the code I have on the forms On Current property but I'm missing something because textbox [txtMaxOrdLimit] doesn't show on the form at all.
If Me.PaNumber = "*D" Then
Me.txtMaxOrdLimit.Visible = True
Else
Me.txtMaxOrdLimit.Visible = False
End If
So i have made a query which filters the text you type in your text box on a form. This is working great, but then this morning I had some records that contain some blank fields. My query does not show those records even if they contain the same text that I would type in my search form.This is my expression in my query of one column:
Like [Forms]![searchform]![Qprojectomschrijving] & "*"
Dear All:
I have created a form with a checkbox. This checkbox returns a message when checked. Is it possible that when this check box is checked that specific text can appear on ANOTHER text box on the same form? The name of the desired textbox is called "NOTES."
Sorry about using checkbox repeatly!
Any ideas on how to get started?
Thanks in advance,
Dion
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 .
I am very new at Microsoft Access. I have two forms, A and B, that are filled out by two different users. Form A gets filled out first than form B gets filled out. Each has a name box as well as a birthdate box and a few other similar text fields. However, each form also has a few distinctive fields. I was wondering how I could input the common information in Form A to Form B so the user of Form B does not have to spend time retyping the name and birthdates again. In other words, I want to synchronize the similar records between the two forms. I would like the values to appear in a table as well. I would greatly appreciate it if someone could help me with the visual basic code. Thank You.
View 1 Replies View RelatedI currently have two forms: frmE_SAFind and frmE_SAOrder
frmE_SAFind shows results from a query including fields [txtIDPO] and [dtmDate]
Example:
IDPO Date
btnOpnFrm 6543 2/1/05
btnOpnFrm 5681 1/1/05
frmE_SAOrder shows order details including [txtIDPO] and [dtmDate]
I have a open form command button set up on [frmE_SAFind] that opens [frmE_SAOrder]. Is it possible for me to modify its properties so that when the open form command button is clicked, the order details in [frmE_SAOrder] will represent the order that the user is selecting via the btnOpnFrm command?
Example: If I click btnOpnFrm for 6543, [frmE_SAOrder] will show me PO 6543 details.
Hopefully I made myself clear enough to understand. Thanks for your help!
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 have a button that opens a second form and filters that form based on a text box on the first form(which remains open). the problem is that it does not filter the second form unless the second form is already loaded for some reason.
For example if i click on the button it opens the form Unfiltered then i go back to the previous form without closing the first form, click the button again and it is then filtered .
I attached the screen shot of the macro for the button and there are no other events on the second form.
What I'm trying to accomplish is some sort of 'Order Confirmation' (filled with the info i have entered in my order form and sub_form fields) that i can copy and paste as a reply to their email-order.
I have taken 2 failed approaches so far:
1) I used a report to display the info
Private Sub Command103_Click()
DoCmd.OpenReport "Order Confirmed", acViewReport, , "OrderID = " & Me!OrderID
End Sub
This worked fine until the information was copied and pasted into outlook which upon doing so changed the column titles and layout
2) I used another form with a text box to fill with the data entered on the Order form
DoCmd.OpenForm "frm_Order_Confirmation"
[Forms]![frm_Order_Confirmation]![txtConfirmation_Text] = "Ref.:" & " " & [txtCustomer_Order_Reference_Number] & [vbNewLine] & "Item No.:" & " " & [cboProductID].[Column](1)
I got stuck here when trying to reference the data in the sub form... Also each order can have one or more colours and how to allow for this?
I've got a rather complicated problem with Access 97 here, at least it seems cpmplicated to me!
The main form on my database, called frmMain has a subform on it (running from a query) which lists payments or contributions made, I've got that working fine so that the payments shown on the subform change as the user switches through the records.
However, I've got another subform, which runs from a query which totals the payments made by each company, so the user can see at a glance how much each company has paid. In can put the second subform on frmMain, showing only the Total, however the formatting isn't ideal, and I don't like the way it looks when the form is printed.
To remedy this, I've placed a text box on frmMain and I've tried to manually link it through to the contributions total subform, by setting the Control Source to "=[Forms]![frmPreContribTotal subform]![SumOfContribAmount]"
My problem is that, while this does work in that it shows the very first entry i.e. the Sum for the first record in the subform, it doesn't change as the user moves through the records on frmMain.
I know this is quite a long post, and I've probably not made it as straighforward as others, but I'd appreciate any help I can get!
I know how to do this with a combo box. After defining the SQLtext and WClause something like:
with me.cbocombobox
____.rowsource = SQLtext & Wclause
____.requery
end with
How do I (can I?) use the SQL in VBA to populate a text box in a similar manner? I have tried various versions of me.textbox = sqltext & Wclause etc, but to no avail.
Cheers.
:rolleyes: I have a note field in a table for short description of a building parts. Is it posseble to make some standard text in a form with a "values" between the text to choose from?
Like:
This building is from "text field for input"
The roof is made of "a combobox with 4-5 items to choose from".
The standard text with the choosen values should then be sent to a note field at submit.
Like: This building is from 1945
The roof is made of tegl
Greeting
Alrun
I am trying to troubleshoot a form and I am at wits end with it. :eek: I hope someone can help me.
There is a form whose record source is based on a query. When it opens it loads all the records. At the bottom of the form, there is an unbound text box that is used as a filter. The person is suppose to be able to type something in there and then once the cmd button is pressed it filters bases on the value of that text box. That appears to work fine.
The problem is, when the form loads, the unbound text box is locked. It does not allow anyone to type in it.
I checked form properties and also the text box property and it is not locked. I have added code on the getFocus, OnLoad, OnUpdate..ect, to make the properties of that text box unlock it self. I have had no success with that.
I did notice that after the form loads and I hit Design view and then change back to Form view, the text box is unlocked and allows typing. :confused:
Why then does it allow editing, but not on initial load. Any help would be wonderful. If further explanation is necessary, please ask.
Thank you
I wonder if anyone could help me here:
I have my main form that has a row of buttons at the top, some of these buttons have multiple functions so I have some hidden text boxes underneath that appear on the mouse move command, giving the impression of a drop down list for that button.
Just underneath the buttons I have a subform, the problem I have is that the text boxes will not show on top of the subform, they always appear behind it, is there anyway to get them to show on top of the subform ?
I hope this makes sense.
Regards
MattP
Hi,
I have a form that displays fields from a table called "supp", e.g "name", "address 1" etc etc.
i want to if possible when i change the text on the form that is already in "name" field or regardless any text box field on the form, i.e "ab" to "cd" to display on the form that that specific record has been changed by putting the word changed with the current date into the table "supp". also if nothing has been changed that do not put changed and the date.
Thanks
I have created a form and want to turn the text in a header to a vertical read. I have tried all I know even pasting from excel and it just stays horisontal? Any help would be great.
View 2 Replies View RelatedHi
I have a form based on a table. I have two fields A and B.
A is a drop down with values from Table T1. Table T2 has values based on these values from T1.
Now I want to display the value from Table T2 based on what the user has selected in field A.
Like the user is trying to add new records in the form. He selects "ABCD" from drop down in field A. Now Field B should display the value "2" where Table T2 contains the row "ABCD 2".
Can someone throw some light on this..
Thanks
I have two forms where in first form i have options for second form. In first form i have a text box and its value is copied to second form using this code
Code:
=Forms![FirstForm]![Counter]
But when i open second form using button in first form the vba message that counter value is empty. I used vba if code in second form on counter
Code:
if counter.value = 1 then
solo.visible = true
end if
I want to get ip address in a text box on a form?
View 12 Replies View RelatedHello,
I have been struggling to see on a new form data calculated on a different form.
What I mean is that I have calculated a stock balance using a subform where the balance=[QuantityReceived]-NZ([Stock record table Subform].[Form]![SumQtyIssued])
Now, I woud need to see the balance value on an another form with the same Data source query.
I have been trying to assign the control source of the balance as follow but doesn't work: balance=Forms![Stock record sheet]!Balance where [stock record sheet] is the form where the balance is originallly created.
I guess that you can't reuse data calculated in form and should probably store these data in a table or a query. Is there any other sensible way to do this?