This is a look at an assignment, who it was originally assigned to (AnalystID), and who actually completed it (AnalystCompleted). Expr 1, counts the number of times the two columns don't match.
If I were to throw this in a report and group by Analyst ID, it would tell me how many times someone else completed an Analysts assignment. If I grouped by AnalystCompleted, it would tell me how many times an analyst has done another person's assignment. In all, by analyst, the amount of assignments done BY others, and amount done FOR others. I do NOT want to create two separate sub reports just to tell me this so that I can use the totals in calculations on a main report. I was attempting to do this on the query level but that doesn't seem possible either. I then thought perhaps a defined Function for SQL SELECT... SUM... FROM... GROUP BY...
I am running in to a brick wall with this. I have an unbound text box with the control source set to =IIF([text42]=0,0,[text42]/[text44])*100 and in continues to return a #name? error.
I am not sure how to get this expression to work. I have even tried to put =[text42]/[text44] and I still get the #name? error.
I have some filtering criteria in a query that is based on some unbound text boxes in a form. These text boxes contain start and end dates. This form is not based on any table or query. All controls are unbound.
The query functions properly initially, however, I am programmatically changing the values of the unbound text boxes in the form that are used by the query. After their values have changed, the query doesn't seem to recognize the change and therefore returns no values.If I manually change the the values in the text boxes and run the query it works fine. However, I would like to avoid doing it this way, if at all possible.
After programmatically changing the values of the unbound text boxes, I tried setting the focus to the text boxes, setting the focus to other controls, refreshing the form, requering the form, requerying the text box, so forth and so on.
Am not getting a value from a form text box when using in the criteria line in my query. Am referencing like [Forms]![FormName]![FormLabelName]. If I copy the data in the form and paste it into the query, it works fine, but if I just reference the form, I get no results.
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".
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'm using a form with a combo box bound to a table (but all other boxes are not bound). When the user selects from the combo box, the other fields on the form populate.
The problem is, there are two fields which are memo fields, but the form is truncating the text. When I type text in the form and save, it truncates, but in the table itself the text is not truncated. However, if I go back to the form and make a change, the truncated text overwrites what's in the table.
Hi, I have a unbound text box in a form. i would like it to display the total value of other text boxes in the same form. The other boxes are bound to a table. please advise
I have a unbound text box on a form. I am using code to complete a search, each time a letter is input into the text box the code runs. My problem is that I am only able to input one letter in the text box. Has anyone any ideas why this is!
Code I am using:
Function FilterForm()
Dim strFil As String Dim strNewRecord As String Dim strSupplier As String Dim strTp As String
Dim db As DAO.Database Dim qdf As DAO.QueryDef
Set db = CurrentDb
If Not QueryExists("qryProductSelect") Then Set qdf = db.CreateQueryDef("qryProductSelect") Else Set qdf = db.QueryDefs("qryProductSelect") End If
If IsNull(Forms!frmCapitalGoods!ctlSubForm.Form!ctlSu bForm.Form!txtFind.Value) Then strFil = " Like '*' " Else strFil = " Like '*" & Forms!frmCapitalGoods!ctlSubForm.Form!ctlSubForm.F orm!txtFind.Value & "*'"
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.
I have a form that has a list of sitting on when you select a sitting I would like to produce list of centres that are registered with that sitting. I would like to do this by having an unbound text box. I need to do it this way for part two.
So I have
SittingID The user can select a sitting from the combo box of sitting ID. I have this code behind the combo box to look up the sitting details:-
I then have a table that holds all the centre that belong to that sitting this table has the Centre ID and the sitting ID I would like the user to select a sitting using the combo box and then the unbox text box populates with:-
CentreName, CentreNumber, VenueName, any idea's how I go about this one. Thanks
I have created a form which is linked to a table (tblKPIs) and all fields from that table are displayed on the form. I have added an unbound text box in which I would like to display a value from a field in a linked table (tblObjectives).
I know this is potenitally simple but cannot seem to work it out. Any help would be appreciated.
I have an unbound text box, that is determined from a users Environ details, and i would like to link this to a subform the subform is made from a cross tab query and basically i only want the subform to show the users details which is in the text box.
happy friday to all! I may just be missing something simple here but not sure what. I have a form with an option group of radio buttons, an unbound label, and an unbound text field. If radio button A is selected, the the label and the text field become visible. no problem with this.
when they become visible, I want to be able to enter a string into the unbound text box, and use that data to populate a query from. I know how to do this also.
No the problem: when the textbox becomes visible I can't type into it?
What i'm trying to do is fill several unbound text boxes on a form.
I have an "Employeetbl" with "Employeename" and a "Projecttbl" with "Projectname". what i want to do is have about 10 text boxes from left to right on my form. Then fill these with all the employee names from my "Employeetbl". Underneath this i will have about 10 text boxes from top to bottom and i'd like to fill these with the project name from the "Projecttbl"
I have an unbound text box. I put a value, run an append query and append the value to the table. I want to know if I can delete the value in the text box automatically when the append query excutes. I am using a macro to run the append query.
I’m working on a form on which I like to place an unbound text box to get a long amount of data. The text boxes in link to a field table having 250-field size. Now, I’d like to be able to use a text box, which will allow me to enter from 800 to 1000 characters. Is that possible in Access 2000?
I am looking for a way to autocomplete in a unbound text, but I did not find any answer. So I am using this code that I used before in excel, but it doesn't work in Access.
Code: The purpose is just to copy the last name of member to last name of spouse if the first 2 characters matches.
Code: If abort Then abort = False: Exit Sub With Form_frm_proto If Nz(.lblSLastName) = Left(Nz(.lblLastName) & Chr(5) & Chr(5), 2) Then
I need to display some of the insruction lines in unbound / bound text box that will gradually moves up.
Example :
"This multiuser client server db is licenced to "ABC & Co.". This sofrware is to reduce cost of production and it increases speed of your production process more...."
These instruction lines may be arojnd 10-15 lines. I need to display it as non-stop moving up text massages on the main form once the data base is opened.
I created a database and released it for my team (frontend/backend setup). however, most of the members on my team are getting #Name? or #Invalid on some dlookup formulas in unbound text boxes. However, on my version, I see the actual data shown.
I tried adding the Microsoft references via the VBA screen, but that only worked for one person.
I am having a little problem with making an audit trail for a form with some unbound text controls on it.
Since .OldValue won't work on unbound text boxes, google suggested that I put the old value in the control's tag property. This is what I came up with:
Code: Dim ctl, tbox As Control Dim strName, strOLD, StrNew, NewTag As String Dim NextOne As Label For Each tbox In Me.Controls If TypeName(tbox) = "TextBox" Then Select Case tbox.Value
[Code] ....
The first loop is supposed to dynamically assign the tag value, with whatever the textbox value is, however it doesn't. I've asterisked out the line i think may be the issue.
