 Up |
|
  |
Author: Jesper FJesper F
Date: Jun 7, 2010 22:00
I have a table where one of the fields contain values such as
26-14-2C-R1-K1
15-13-1C-R3-K6 and so on.
this is a text field
I am trying to find records based on the part: R1-K3, R2-K4, R5-K1
etc.
I am getting weird data type mismatch error when searching with my
query.
For example this works:
SELECT myfield as P FROM myTable
WHERE myfield Is Not Null AND right(myfield,len(myfield)-9) Like 'R1-
K1'
ORDER BY myfield
|
| Show full article (0.99Kb) |
|
| |
2 Comments |
|
|
Author: Mike PainterMike Painter
Date: Jun 7, 2010 20:46
JohnE wrote:
> "Mike Painter" wrote:
>
>> JohnE wrote:
>>> Have a situation in which the printing (on paper) needs to have
>>> recorded the date the printing occurred. This would mainly be a
>>> field on the form that says when the report was printed. It won't
>>> make a difference how many times the report is printed so long as
>>> the date appears in a field. The users use the standard Access 2007
>>> printing methods to print the report so adding a PRINT button on a
>>> form or the report is not acceptable.
>>>
>>> Is is possible to capture A2007's print button? If so, how is it
>>> done? Any samples, examples, or links will be helpful.
>>>
>>> Thanks.... John
>>
>> Back in the old days....
>>
>> I used to pop a message asking if the printing had been a success ...
|
| Show full article (2.22Kb) |
|
| |
no comments
|
|
|
Author: Richard S.Richard S.
Date: Jun 7, 2010 20:36
How do I enable a user to line feed to a new, additional line to be entered
in a form's text box which has a Memo field with Rich Text as its Control
Source? Pressing "Enter" or "Tab" creates a new record in the table, rather
than moving the cursor to a new line for continued entry?
I will appreciate any help or alternative suggestions for a means for a user
to create & edit a formatted text entry.
|
| |
|
2 Comments |
|
|
Author: H. MartinsH. Martins
Date: Jun 1, 2010 12:26
I have a form whose default view is 'continuous form'.
Then when I click a button I need to delete the record where the mouse
is (was just) placed.
How can I find out the record number?
Alternatively any idea is welcome.
Thanks
Henry
|
| |
|
no comments
|
|
|
Author: Frank SitumorangFrank Situmorang
Date: Jun 1, 2010 12:13
Hello,
I have a church membership database. I have the form to input the member
data on whch form I also have a combo box to choose the address.
If there is no address on the combo list, I add the member address in
another form. I can only select it in the member form combo, if I complete
filling the address and then return back to previous address.
Can any body help me, that I do not need to return back in the address input
form? in order to be able to choose it in the member combo form?.
Sorry English is not my language, I can not explain it more clearer, but I
think you can understand what I mean.
Thanks,
Frank
--
Frank Situmorang
|
| |
|
no comments
|
|
|
Author: daviddavid
Date: Jun 1, 2010 12:02
If you want to do this to all the text controls
on the form, you don't have to use the tag
property to tag them:
Dim ctl As Access.Control
For Each ctl In Me.Controls
If ctl.ControlType = acTextBox Then
If IsNull(ctl.Value) Then
ctl.BackStyle = 0 ' Transparent
ctl.BorderStyle = 1
Else
ctl.BackStyle = 1 ' Normal
ctl.BorderStyle = 1
End If
End If
Next ctl
(david)
"Kurt Heisler" gmail.com> wrote in message
news:dd07741c-c033-4bf9-b9a8-79018c5119e8@t34g2000prd.googlegroups.com...> In the on current event of my form, I'm setting the Backstyle and
>...
|
| Show full article (1.45Kb) |
|
no comments
|
|
|
Author: DontKnowDontKnow
Date: Jun 1, 2010 07:53
Hi Guys,
I would like to add my thanks to all of you guys as well !! You guys have
certainly helped me over the years with helping me out with my problems with
Access and certainly I have learnt a lot via your incridible source of
knowledge in this area!!
many thanks to all of you and best of luck in your future endavours!!
Many thnaks ,
Ian from Newcastle Australia!!
cheers!!
"Daniel" wrote:
> Firstly, let me apologize for making this beautiful cross-post. I know it
> bad etiquette, but in this instance I'm hoping no one will truly mind (after
> all MS did it with their announcement......
|
| Show full article (1.44Kb) |
|
no comments
|
|
|
Author: DennisDennis
Date: Jun 1, 2010 05:57
All,
Once again thanks for everyone's help.
God bless and hopefully I will see you in other forums / newgroups.
Dennis
|
| |
|
no comments
|
|
|
Author: alekmalekm
Date: May 14, 2010 12:27
How do I do passing objects and names?
"Marshall Barton" wrote:
> That will work in most situations, but there is no guanantee
> that the active screen object is the form with the check
> box.
>
> You would be better off if you can find a way to use the
> FORM's...
|
| Show full article (0.88Kb) |
|
no comments
|
|
|
|
|
|
Author: alekmalekm
Date: May 14, 2010 12:10
Hi,
if the check box is clicked how can I disallow change of its state based on
certain terms...
Thanx
alekmil
|
| |
|
1 Comment |
|
|
|
