I'm trying to show a count of filtered records on a form. The Filter is number of days from the system date which I've already built into a query. I'm trying to get the record count for each day out up to the tenth day and show the counts on a form. Is this prossible? and how is it done?
View RepliesI have a Form in which there is a textbox. I would like the name (caption) of the Form (that shows in the tab at the top of the form) to be named/updated to whatever is entered into the textbox.
View 9 Replies View RelatedMy form is in datasheet mode.
One of the textbox is called txtHours
When I access the form the column caption is "txtHours" !
As you can expect it looks ugly.
So to get a decent caption like "Hours" I am forced to set my textbox name to "Hours" !
As you can expect it goes against my coding standard to do that.
Beside I want the caption of some textboxes to include some non-standard letters such as `é' è' '!' ' ' etc. and if I put those in the textbox name it ruins the visual basic code !
I have a caption that changes dynamically using VBA. How do I insert a carrige return between two strings which will make up the caption.
I appreciate any help.
G'day all
I want to create a form that will be the layout of my storage warehouse. I actualy have a layout on paper but was thinking of doing it on a form for the users to have a better view. The location of the inside warehouse have 60 location or Bin. The outside one has 80 Bins.
This will need 2 query. 1 for the inside Bins and 1 for the outside Bins. They are both the same query except for the caption of each command button.
What will be the beast way to create the query as to the criteria is to read from thee caption of the command button.
If the caption is 50 then give me everything in 50.
Hope this make since.
Thanks you so much.
JP
I am building a form and part of the code is:
Code:
Private Sub Form_Load()
lblSalary.Caption = "Enter Salary"
txtSalary.Value = "5000.00"
cmdIncrease.Caption = "Increase Salary"
End Sub
The problem I am having is that I dont understand why the cmdIncrease button does not display "Increase Salary" when the form loads. The button is there but it is blank. The lblSalary button displays "Enter Salary" with no issues.... and I do not have "Enter Salary" in the caption property window... only in the coding window but it still works.
I have a form, the view of which is continuous forms.
It has information on the left of the screen which the user is expected to manually match to information on the right, based on the suggestion of the underlying query (based on table a and table b)
E.g.
Client A $200 <button> Mr Smith $200.00
Client B $100 <button> Mr Smith $100.01
There is a button "match me" which when clicked runs an update query.
My query is how do I change the caption on the "match me" button to say "matched" just for the one that is clicked? Because it is a continuous form, if I use Command1.Caption = "Matched" or Me!Command1.Caption = "Matched" it changes it for all the buttons on the form.
Many thanks.
Is there a way to get a string from a field and use it to set the caption value for a command button at run time?
View 2 Replies View RelatedI have a form with up to 100 buttons generated based on a number of conditions. I am trying to pass the caption of a button to a sub so that I can open the correct forms. When a button is clicked how can I read it's caption. Me.caption is reading the form caption.
View 7 Replies View RelatedI have a subform on a form which I load up after the user enters a value in the main form by using the sourceobject property of the subform, the problem i have is that after reloading the main form and the user entering another value, the textbox.value of a control on the subform will sometimes not show the correct value. I am aware that textbox.value doesn't change until the after update event, however this particular textbox is just showing information that has just been queried from the database.
View 1 Replies View RelatedI have 2 table as follow.
Productmaster
-Productname
-Opening date
Transaction
-Productname (linked with master productname)
-qtyin
-qtyout
I am working on Form transaction1 linked with table(transaction) on which I have combobox therein I have name of Products which are coming from PRODUCTMASTER.PRODUCTNAME. everything going well all data commiting accurately in Transaction table.
Now, What I want when I select comboxbox value i.e. productname then sum of qtyin+qtyout from table(transaction) should come into textbox(total) as according to the productname selected
I have a report on which I have a combo box showing text value as open issues and closed issues. What I want to do is on the report in a text box show count of open issues and closed issues separately.
View 1 Replies View RelatedI have a form, which is bound to a table, with an unbound textbox.
I am trying to get the number of months an employee has/had worked.
In the table are two dates, Company Start Date, and Resignation Date.
There are three scenarios in which I need to calculate the months:No Resignation Date
A Resignation Date in the future
A Resignation Date in the Past
See attached PDF
The Employees are under a one-year contract which ends the day before the one-year anniversary.
I originally tried using DateDiff in the Control Source, but the IIF seamed too limited for my needs.
Code:
If [Resignation Date] = "" Then
If Month([Nichii Gakkan Start]) = Month(Date) Then
If Day([Nichii Gakkan Start]) < Day(Date) Then
MIS = DateDiff("m", [Nichii Gakkan Start], Date) - 1
[Code] ....
MIS = The name of the textbox in question.
Would this work: Having a command button that opens another database. Cheers
View 1 Replies View RelatedSELECT qryHoursReq.VolunteerId, qryHoursReq.Name, qryHoursReq.Program, Sum(qryHoursReq.Total_Time) AS SumOfTotal_Time, qryHoursReq.S_date
FROM qryHoursReq
GROUP BY qryHoursReq.VolunteerId, qryHoursReq.Name, qryHoursReq.Program, qryHoursReq.S_date
HAVING (((qryHoursReq.S_date) Between [startdate] And [enddate]));
This is my query
I'm trying to get a count of distinct volunteerID in an unbound textbox on report.
If I use =Count(*) I get 2 when I put in date parameters and it groups by program
This is kind of correct, but, these 2 are the same person, she had different days she participated.
What code can I use for only get a count of 1
FOrgot to mention, when I use the DCount with numerous examples, I get #Error
I have generated a report in acviewreport, after viewing the details I want to save the report as a pdf file with the client name, invoice number and date. In the report design view I added a cmd button and successfully coded it. However, it saves the report WITH the cmd button showing. I don't want this button saved. Is it possible to remove the button from the report AFTER I have clicked it?
View 4 Replies View Relatedhttp://www.heathrowminicab.com/xxx.JPGI have a blank form.. with 2 controls..Textbox - name is 'text'Button - name is 'button'my user will type in something like this..pictures/db1/db1.jpgall i want is that when they press the button.. the url 'http://www.mysite.com/"is added to the data in the textbox and the url is opened.. this of course will allow my user to test whether the image they are referring to exists..can this be done.. if so what code do i need to add to my controls.
View 1 Replies View RelatedI have a form which adds in details of components
Sometimes I will need to add a number of components
What I would like to do is add a new line of the textboxes below the orginal when a button is pressed.
In my head I see it working in a similar visual sense to adding multiple attachments
Basically I want to type the ID(key) of a record table in a unbound text box and then by pressing a command button to be able to bring up that record (in form view). I do not want to use a combo-box.
So what do i write as VB code in the Private Sub mybutton_Click()
Table name is [ACTION_ID], ID field name is [ACT_ID] & text box name is [TEXT_BOX]
Basically I want to type the ID(key) of a record table in a unbound text box and then by pressing a command button to be able to bring up that record (in form view). I do not want to use a combo-box.
So what do i write as VB code in the Private Sub mybutton_Click()
Table name is [ACTION_ID], ID field name is [ACT_ID] & text box name is [TEXT_BOX]
My subform when i click the New record button on the subform i want it to disable a text box that is on the main form.
Me.Pensioners.Form!quicksearch.Enabled = False
where Pensioners is the name of the Parent Form. Thhis isnt working for one reason or another. Please advise.
In my form, when a button (cmdContactedToday) is clicked, a text field to the left (txtDateContacted) is updated with today's date.
However, before this happens, I want the the current date in txtDateContacted to get stored in another (hidden) text field (txtPreviousDate)
Then when another (undo) button (cmdUndoDate) is clicked, the date in txtDateContacted should get replaced with the date in txtPreviousDate.
I've made it as simple to understand as I could.
I have a button that when I press it it goes to new screen where I can add new data in, and then save it.I have 10 texboxes in this form, how can I when press the button to add data let it on 3 texboxes show info eg. 4321MAG01- and when I am on the new form I can change or add to it. eg 4321MAG01-123
View 6 Replies View RelatedI have a textbox with about 400 characters, I also have 5 textboxes next to it. I want to click a button and I want to transfer the characters to the other textboxes 208 characters at a time.
View 3 Replies View RelatedI'm trying to have a button in a form that, when clicked, will time stamp a text box already formatted for time. But once the text box is filled with a time, the button then disables itself for that record.
If I switch to another record where the text box is empty, the button will enable itself without closing the form, but obviously re-disable itself if I go to a record the text box is filled.
I'm sure I could use conditional formatting for it, but I don't think I'm going about it the right way. I already got a basic button built to timestamp.
I have a mainform with a combobox and a button. What i want is when i click on the combobox and then on the button I want that the textbox in the subform automatically fill in.
The mainform name is FrmTakenInvoerenEnToewijzenAanEenMonteur,
The combobox name is Keuzelijst1,
The subform name is SubTakenInvoeren,
And the textbox name is txtOpdrachtnr.
I tried this code in on button click:
Me.SubTakenInvoeren.txtOpdrachtnr = Me.Keuzelijst1
But that doesn't work.