A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 21 of 21
Search took 0.38 seconds.
Search: Posts made by: Anatoly Kurilin
Forum: Using Forms May 15th, 2010, 06:52 AM Posted to microsoft.public.access.forms
Replies: 11
Views: 865
Posted By Anatoly Kurilin
Continuous Forms Question

No, it does not!

"BruceM via AccessMonster.com" [email protected] wrote in message
news:[email protected]
So you're saying that in your most recent example if the user makes an
entry
of...
Forum: Using Forms May 14th, 2010, 09:33 PM Posted to microsoft.public.access.forms
Replies: 11
Views: 865
Posted By Anatoly Kurilin
Continuous Forms Question

As a matter of fact, I limited the length of the entry as an example of any
cancelled action. And I don't want to remove the entry - user has to see
what he/she entered. All I want is to make the...
Forum: Using Forms May 14th, 2010, 08:44 PM Posted to microsoft.public.access.forms
Replies: 11
Views: 865
Posted By Anatoly Kurilin
Continuous Forms Question

To make the investigation easier, I've changed the code but of no avail ...


Private Sub txtMasterField_BeforeUpdate(Cancel As Integer)

If Len(txtMasterField.Value) 10 Then
...
Forum: Using Forms May 14th, 2010, 07:27 PM Posted to microsoft.public.access.forms
Replies: 11
Views: 865
Posted By Anatoly Kurilin
Continuous Forms Question

Private Sub txtMasterField_BeforeUpdate(Cancel As Integer)
If gCustomerInitials(txtMasterField.Value, True) = "" Then
Cancel = True
End If
End Sub


"BruceM via AccessMonster.com"...
Forum: Using Forms May 14th, 2010, 06:40 PM Posted to microsoft.public.access.forms
Replies: 11
Views: 865
Posted By Anatoly Kurilin
Continuous Forms Question

I'm talking about the control's Before Update event.

"BruceM via AccessMonster.com" [email protected] wrote in message
news:[email protected]
Details needed. You mention a message, an Escape...
Forum: Using Forms May 14th, 2010, 07:25 AM Posted to microsoft.public.access.forms
Replies: 11
Views: 865
Posted By Anatoly Kurilin
Continuous Forms Question

Hi, I have two similar subforms connected to two different tables. Each
subform has a textbox control. I have to check its contents in the event
BeforeUpdate. So, when a NEW RECORD is created, the...
Forum: Using Forms April 20th, 2010, 06:54 AM Posted to microsoft.public.access.forms
Replies: 1
Views: 368
Posted By Anatoly Kurilin
SendKeys & Windows 7 Problem

Hi, I have problems with executing Access 2000 command "SendKeys ... " in
Windows 7 environment. I get message "Run-time error '70'. Permission
denied".
Is there any way to overcome that?

Thanks...
Forum: General Discussion February 9th, 2010, 05:44 AM Posted to microsoft.public.access
Replies: 8
Views: 159
Posted By Anatoly Kurilin
OLE Object Data Type Question

I've experimented on several computers using Access 2000 and XP but the
results were the same - "Package".

"Arvin Meyer [MVP]" wrote in message...
Forum: General Discussion February 8th, 2010, 05:50 AM Posted to microsoft.public.access
Replies: 8
Views: 159
Posted By Anatoly Kurilin
OLE Object Data Type Question

No they do not open properly. I even created a new OLE Object field but of
no avail.

"Arvin Meyer [MVP]" wrote in message
...
...
Forum: General Discussion February 7th, 2010, 08:22 PM Posted to microsoft.public.access
Replies: 8
Views: 159
Posted By Anatoly Kurilin
OLE Object Data Type Question

Thank you, Arvin, I followed your instruntions and now the file types .JPG
and JPEG open with Window Paint but nonetheless links to these files
continue to instert as Package.

"Arvin Meyer [MVP]"...
Forum: General Discussion February 7th, 2010, 06:34 PM Posted to microsoft.public.access
Replies: 8
Views: 159
Posted By Anatoly Kurilin
OLE Object Data Type Question

Dear Arvin, thank you very much for the tip but please tell how to register
OLE for JPG file types.

"Arvin Meyer [MVP]" wrote in message...
Forum: Using Forms February 7th, 2010, 05:08 PM Posted to microsoft.public.access.forms
Replies: 0
Views: 134
Posted By Anatoly Kurilin
OLE Object Field Question

Hi, a friend of mine supports a very simple Access 2000 database for keeping
tracks of his .JPG file. The database has a table with several field, and
one of them is of OLE Object data typy. He...
Forum: General Discussion February 7th, 2010, 05:06 PM Posted to microsoft.public.access
Replies: 8
Views: 159
Posted By Anatoly Kurilin
OLE Object Data Type Question

Hi, a friend of mine supports a very simple Access 2000 database for keeping
tracks of his .JPG file. The database has a table with several field, and
one of them is of OLE Object data typy. He...
Forum: Using Forms December 26th, 2009, 04:57 PM Posted to microsoft.public.access.forms
Replies: 2
Views: 72
Posted By Anatoly Kurilin
Two Qustions

Hi, the Format (MiTime, "Short Time") command works fine in code and returns
the string "09:35" when the time is 9:35 AM. But then used in forms or in
queries it returns "9:35". Is there any way to...
Forum: Using Forms October 1st, 2009, 12:46 PM Posted to microsoft.public.access.forms
Replies: 3
Views: 89
Posted By Anatoly Kurilin
Round Function Problem

Dear Allen, thanks for the tip. Is it possible to make Microsoft Excel and
Access Round functions to return the same rounded number?

AK



"Allen Browne" wrote in...
Forum: Using Forms October 1st, 2009, 11:13 AM Posted to microsoft.public.access.forms
Replies: 3
Views: 89
Posted By Anatoly Kurilin
Round Function Problem

Hi, the function Round in Microsoft Access returns 66.22 = Round(66.225, 2),
but the same function in Microsoft Excel returns 66.23. I'm really
embarrassed! What number is correct?



Thank in...
Forum: General Discussion April 27th, 2009, 10:15 AM Posted to microsoft.public.access
Replies: 2
Views: 115
Posted By Anatoly Kurilin
How to get rid of a workgroup .mdw file

Hi, some time ago I protected my database with a workgroup file .mdw. Now I
realied that I don't nead it anymore so that everyone could get access to
it.
Please help me how to get rid of that...
Forum: Using Forms December 12th, 2008, 09:34 PM Posted to microsoft.public.access.forms
Replies: 3
Views: 82
Posted By Anatoly Kurilin
Conditional Formating Question

Yes, it works, thanks!
"Chegu Tom" wrote in message ...
Use the Expression option and the expression is isnull(controlname)

If...
Forum: Using Forms December 12th, 2008, 07:00 PM Posted to microsoft.public.access.forms
Replies: 3
Views: 82
Posted By Anatoly Kurilin
Conditional Formating Question

Hi, what should I put in a text box "equal to" if I want a condition work
when the control value is equal to NULL?

Thanks in advance,
AK
Forum: Setting Up & Running Reports December 7th, 2008, 06:21 PM Posted to microsoft.public.access.reports
Replies: 1
Views: 45
Posted By Anatoly Kurilin
Setting a printer

Hi, I need to select a printer for reports when I start an Access 2000
application without changing Windows Default printer and print dialog box.
Actually, it's not a problem to select the printer....
Forum: General Discussion May 29th, 2006, 07:56 AM Posted to microsoft.public.access
Replies: 1
Views: 42
Posted By Anatoly Kurilin
Redirecting VB references in code

Hi, I got an ActiveX contol and a reference to its .dll library.
What's the right way to redirect that reference in code when the .dll
library moves to another directory?

AK
Showing results 1 to 21 of 21

 
Forum Jump

All times are GMT +1. The time now is 04:35 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.