Just say I want to summarise in a text box the options given in three option groups.
For instance I have chosen A then B and then C and then in a text box I want to put ABC.
Do I need to set up a query to do this? or do I need to write some code?
I have a feeling the answer to this will be quite simple, but I can't find a way...
I have a table which lists events, with the number of expected attendees and the actual number of attendees. There's a field called "Programme" in each event record, which has one of 9 values (i.e. there are 9 possible types of event, e.g. "Fire Training", "Health & Safety Briefing", etc.).
I need Access to present this data with the Programmes listed down the first column as row headings ("Fire Training", "H&S", etc), then have two additional columns, one for expected attendees and one for actual attendees on each programme. That is, I want to know, for each Programme how many people have booked and how many people actually attended.
Thanks in advance for your help.
Gary
I have a simple database with three fields, (Name, year, cost). I want to create a query that will output (eg) Jims total costs for 2005 and 2004 (seperate totals on same query). Any ideas on how i can do this?
View 6 Replies View Relatedhow can i disable a textfield or two in a form when the textbox is unchecked also how do i add a default value for it while the textbox itself is disabled, can i get away with it by adding a default value on the textbox?
View 14 Replies View RelatedI have imported a link table into access.
The Year field I wish to search on is Text.
I have entered a wildcard before the year i.e *2003 within the criteria, but still cannot read the number.
Can anyone suggest anything?
what code do I need to put behind my txt fields on my form so that it automatically writes to the relevant table?
Also, how do i program an unbound txt field on a form to link to a field in a table?
many thanks in advance, Steve
I have many rows of information i am entering in access. I want to setup this spreadsheet to look at previous rows of information so when I fill one field it will automatically fill some of the other fields in the same row with the information from the rows above.
if this is not possible then I want to create a dictionary of information so if information is typed in one of the fields it will automatically populate some of the other fields on the same row.
Hi all,
I have been given the task of cleaning up an old db. One thing I'd like to do is combine 3 text fields into 1 new field.
In the old db there was a form that included 3 memo text boxes, when the first one was full the user then started using the second and then the third. The relating Table fields are message, overflow message & overflow message extended.
I'd like to combine the fields into 1 and then design a new form to suit so that the memo text in the new db goes into 1 field only.
I have many rows of information i am entering in access.
I want to setup this spreadsheet to look at previous rows of information so when I fill one field it will automatically fill some of the other fields in the same row with the information from the rows above.
sorry cannot explain very well
if this is not possible then I want to create a dictionary of information so if information is typed in one of the fields it will automatically populate some of the other fields on the same row
Hi people,
I have a report that is linked to a data entry form. Is there a way to not show certain labels and text boxes if a text box on the form has the value "N/A"?
Something like:
Private Sub Report_Open(Cancel As Integer)
If txtFireType = "N/A" Then
txtFireType.Visable = False
End If
End Sub
This doesn't seem to work by the way!
Really appreciate all of your help.
Can anyone tell me how to count (sum) text fields. My current query will search for:
1) Name
2) Ticket Number (ww*, beginning of one type of ticket)
And it works fine except that after running the query I have to manually add up how many of the ww tickets each person wrote. Is there a way to make it change the ww* tickets to a number, like 1, so that it can be added up or to add up by the persons name how many tickets they wrote. I'm using Access 2000.
Thanks
Hi people,
I have a report that is linked to a data entry form. Is there a way to not show certain labels and text boxes if a text box on the form has the value "N/A"?
Something like:
Private Sub Report_Open(Cancel As Integer)
If txtFireType = "N/A" Then
txtFireType.Visable = False
End If
End Sub
This doesn't seem to work by the way!
Really appreciate all of your help.
Hi All,
I have a field with a bunch of records. All is formatted the following:
CAN-2007-US-00001
CAN-2007-US-00002
CAN-2007-US-00003
CAN-2008-US-00001
CAN-2008-US-00002
CAN-2008-US-00003
and so on and so forth. Is there a way Acess can break the fields out? I want 1 field with CAN, 1 field with the year, 1 field with US, and 1 field with the number (4 different fields broken by the hyphen).
I can do text to column in excel before I import, but just wondering if it can be done in Access. Thanks in advance, guys...
Caliboi
I have text boxes that combine two fields into one, for example the control source is =IIf(IsNull([BuckC])=True And IsNull([BoostC])=True,"",[BuckC] & " , " & [BoostC]) . For simple its just =[Buckc] + ": "+[BoostC]. I am trying to set a condition that if one of them exceeds a certain number the background color will change to yellow. I know how to do this if its only for one field but I am wondering if it is possible to do it with multiple fields?
View 9 Replies View RelatedIs it possible to use <enters> in text or varchar fields??
In this way users can easily switch to the next line instead of typing everything all together
How do I handle " in text fields - I have a few customers names like "Zoom" - who insist the name is with " in it.
This buggers up queries and filters etc - becuase of the confusion the " creates.
How do i solve this?
Hi
Is there a way of changing the case of text that has been entered in a table?
Want a form to display capitalised names, say, no matter how they were entered. Know that they can be displayed in all caps using >.
Thanks
We use two different systems in our office that have notebook facilities. One of them stores only a limited number of characters in the note field per record and as such, some notes actually span several records.
The other system stores the whole note in one record.
We want to transfer all the notes from the first system (1 note over several records) to the second system (1 whole note in 1 record).
I have a table with the notes from the first sytem which looks something like
Note1 - Line1 - Text
Note1 - Line2 - Text
Note2 - Line1 - Text
Note3 - Line1 - Text
Note3 - Line2 - Text
Note3 - Line3 - Text
What I want to do is, for each note, combine the separate lines into one record.
I have been able to do this in Excel with some formulas (see attachment) but am wondering if it is possible to do this in an Access Query (i.e. GroupBy the note number and have a calculated field combining the individual lines of the note, or something similar)?
In a form I can easily combine and display the content of two text fields in a third text field with the formula =[field1] & [field2]. Very well. Now I would like to combine and display only the first letter of each of the two text fields. This I would expect to go somewhat like this =(letter,1,1[field1]) & (letter,1,1[field2]). How is the correct formula?
View 4 Replies View RelatedHi
I new to VBA and having a few problems with a database I'm working on.
I have a form that contains customer details. The are two sections one for the Registered Office Address and one for the Trading Office Address. I want to be able to allow the user to auto fill the Trading Office Address fields if the Trading Office is the same as the Registered Office.
I'm not sure how the event code should look. I was just going to add a button that will copy the text from the Registered Office Address fields and add them to the Trading Office Address fields. I've tried a couple of other groups but the replies just contain use this code....
TOName = ROName
TOAddress = ROAddress
etc... for all your fields.
I need a little bit more info on how the event code should look.
Any suggestions on the best code to use would be greatly appreciated.
Kind Regards
David
Hi All,
How do update two different tables (fields) from one text box from a form?
Thanks
Hi All
Been having trouble setting up a combo box in a form that displays data from the same line in the table into a text box.
I am trying this with a memo field without any luck. I am using a 2 column query for the combo box, the first column contains the name and the second contains the requirements (memo).
I have put in the after update code:
Private Sub CustName_AfterUpdate()
Me!CustReq = Me![CustName].Column(2)
End Sub
Can anyone please shed light on what I'm doing wrong?
Thanks
I am trying to auto populate a text box when i click on the button to add a new record. This is the code for the addnewsequence button.
Private Sub addnewsequence_Click()
On Error GoTo Err_addnewsequence_Click
DoCmd.GoToRecord , , acNewRec
Exit_addnewsequence_Click:
Exit Sub
Err_addnewsequence_Click:
MsgBox Err.Description
Resume Exit_addnewsequence_Click
End Sub
In this form is a text box called degree name that is link from the table degree. It autopopulates with the degree upon the sequence form first opening button clears the text box when i click add new sequence
any help greatly appreciated...
Thank you
I'm trying to build a query that will count items in a text field.
How do I do this. I know the statement should read something like this - SELECT COUNT([fieldname]) FROM [tablename] WHERE [fieldname]=yes;
Is this statement correct and where do I place it? Does it go in that specific column. Any help would be greatly appreciated.
Thank you in advance for your assistance.
Hi,
I am trying to combine 2 text fields into a new field (concatenate) so that I can use it as the primary field.
Can anyone pls help.
Text fields name:
Password
confirmpassword
Trying to achieve:
on "After update" event for Confirm password a code needs to find if both Passoword and confirmpassword are having the exact character (Case sensitive).
Below code doesn't recognize the Case. It allows as long as both words are same:
Dim StrString1, strString2 As String
StrString1 = Password
srtString2 = ConfirmPassword
[Code].....