microsoft.public.access.formscoding
  Home FAQ Contact Sign in
microsoft.public.access.formscoding only
 
Advanced search
June 2010
mo tu we th fr sa su w
 123456 22
78910111213 23
14151617181920 24
21222324252627 25
282930     26
2010
 Jan   Feb   Mar   Apr 
 May   Jun   Jul   Aug 
 Sep   Oct   Nov   Dec 
2010 2008 2007 2006
total
microsoft ... formscoding Profile…
RELATED GROUPS

POPULAR GROUPS

more...

 Up
  puzzling data mismatch error         


Author: Jesper 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
  Re: recording the print date         


Author: Mike 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
  How to enter multiple RTF lines in memo text box         


Author: 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
  Continuous form record number         


Author: H. 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
  Can not choose in combo         


Author: Frank 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
  Re: More efficient code for multiple If...End If statements         


Author: david
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
  RE: A Great Big Thank You!         


Author: DontKnow
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
  Re: Any suggestion for Access forums after June 1?         


Author: Dennis
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
  Re: How do I check the current value of check box not reffering it         


Author: alekm
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
  disallow state change of check box         


Author: alekm
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
1 2 3 4 5 6 7 8 9