Search results
-
W
Form Record Refresh
I didn't know that. See, you learn something new every day. Thanks for the tip Colin. Wayne -
W
Form Record Refresh
You could use this to return to the same record: It will return the user back to the same record. I thought using the Me. Requery was needed because he said his form was based on a query. -
W
Form Record Refresh
When they tick the Answer Box "Yes", you could have this code in the After Update event: Me.Requery That would give the user the latest data anytime they answer a call. And when he finishes entering his data, you could put the same code in the after update event of the last field in that... -
W
Formatting Currency in a non-numeric Text field
To format as currency, try Format(Me.yourfieldname.Value, "$##,##0.0") -
W
bound combo box, cleared content run time error 3162
Is the combo box bound to a field on a table? And is it a combo box on the table or a text field? -
W
need text in footer stay in place when detail section height is variable
Put your text in the Page Footer section of the report, and it will always be in the same place on each page. -
W
date restrictions on all forms
You said that the field TxtCloseDate is in a form. Please note that Arnel's solution is to look up that date in the underlying table, and not the form. You can only look up a field in a form that is currently open.- Wayne
- Post #5
- Forum: Modules & VBA
-
W
Deep South Deep Freeze
Hi Doc, I live in Canada, and we get that kind of weather for most of the winter, but being in the "Great White North", we are used to it (don't like it much, but used to it nonetheless).And we have the snow and ice removal equipment to deal with it. I used to travel in the States a lot, and...- Wayne
- Post #33
- Forum: The Watercooler
-
W
Trying to use an IIf statement to join to fields
Is this IIf statement in a calculated field in a query, or a control source of another field on a form? Also, what field type are the position and attendance fields? Text or number? -
W
Form Scrolling
i am playing with Sonic8's sample to try and make it work, and if I can get it to work (i use Access 2016 - his sample is for 2007), I will post it back later today. Mark's suggestion with conditional formatting of the back color for a null appointment field is good, and you could use this code... -
W
how to capture customer's signature on quote form
Colin, The code to produce the work order (Based on a Click Event on a Command Button). The WHERE clause is in the SQL Select Query of the report to open the work order for the current record: If Len(Dir("filepath" & [Forms]![frmOrders]![OrderNumber] & " " &... -
W
how to capture customer's signature on quote form
For me - I use a Surface Pro, because it does run Access, but it is expensive (I paid over $1,000.00 for it), and it is no bigger than an iPad. But for my two other techs on the road (they use their phones or iPads), I create a work order report, output it to pdf, and email it to them (all... -
W
how to capture customer's signature on quote form
i also have to get my customer's signatures, but I didn't want to bloat the database with saved signatures. I output the work order to pdf format, and have the customer sign it on my tablet, I then save a link to the document in a field on a subform on each order form. Simple, but it works well...