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 25 of 43
Search took 0.16 seconds.
Search: Posts made by: Abe Katz
Forum: Using Forms June 4th, 2010, 07:42 PM Posted to microsoft.public.access.forms
Replies: 1
Views: 2,290
Posted By Abe Katz
How to get Email address list from Outlook to Msaccess

Hello,
Is there a way to get the Email address list from Outlook and input to a
Combo control using Ac2003?
Thanks in advance
Forum: Using Forms May 27th, 2010, 06:25 PM Posted to microsoft.public.access.forms
Replies: 2
Views: 464
Posted By Abe Katz
Set Query Criteria thru Function

Thanks for your response,
Can you give me an example how to do this.
Thanks

"PieterLinden via AccessMonster.com" [email protected] wrote in message
news:[email protected]
Abe Katz...
Forum: Using Forms May 26th, 2010, 05:48 PM Posted to microsoft.public.access.forms
Replies: 2
Views: 464
Posted By Abe Katz
Set Query Criteria thru Function

Hi,
I'm setting a query criteria thru a function, i.e. V1="RED": SetCriteria(V1)
(setting global variable) and then I use in the Query Criteria another
function to get the global variable i.e....
Forum: Using Forms May 21st, 2010, 07:20 PM Posted to microsoft.public.access.forms
Replies: 1
Views: 678
Posted By Abe Katz
Windows 7 Sendkeys

My client got a new computer with Windows7. Now I have a problem with the
SendKeys in code.
I'm using {Esc} to erase if the user enters a wrong entry, and {F9} to
refresh the screen when the...
Forum: Using Forms May 17th, 2010, 03:19 PM Posted to microsoft.public.access.forms
Replies: 1
Views: 319
Posted By Abe Katz
TransText Method

Hello All,
I'm using the TransferText method to import a CSV file. It works fine.
The problem is when I change the TableName argument to a attached table, I
get an error message "Numeric Field...
Forum: General Discussion April 27th, 2010, 04:10 PM Posted to microsoft.public.access
Replies: 1
Views: 84
Posted By Abe Katz
Can Grow Property

Hello All,
I have a Invoice Report with a subreport for the details.
I want to keep the numbers of lines on the detail to 20 lines, and if it
exceeds 20 lines it should print on the second page.
Now...
Forum: Using Forms April 8th, 2010, 04:55 PM Posted to microsoft.public.access.forms
Replies: 1
Views: 71
Posted By Abe Katz
List of all Printers

Hello,
How can I list all the printers on my computers into a combo box and to be
able to select one, in Acc2003?
Thanks in advance
Abe
Forum: Using Forms March 19th, 2010, 02:43 PM Posted to microsoft.public.access.forms
Replies: 2
Views: 76
Posted By Abe Katz
Hide System Fileds in table

Hello All,
How can I hide/show the system fields in a table i.e. s_Generation and
s_GUID?
Thanks
Abe
Forum: Using Forms March 14th, 2010, 10:38 PM Posted to microsoft.public.access.forms
Replies: 3
Views: 146
Posted By Abe Katz
TransferText Method

Hi Gina,
Thanks for getting back, I'm using Acc2003.
Abe


"Gina Whipp" wrote in message
...
Abe,

This...
Forum: Using Forms March 12th, 2010, 09:10 PM Posted to microsoft.public.access.forms
Replies: 3
Views: 146
Posted By Abe Katz
TransferText Method

Hello All,
I want to import a text file using the bar | as a delimiter to separate the
fields, and all the fields should come in to the table as text data type.
I cant get it to work. Can you please...
Forum: Using Forms March 4th, 2010, 09:37 PM Posted to microsoft.public.access.forms
Replies: 2
Views: 160
Posted By Abe Katz
Check Control if Visible or hidden

Hello All,
How can I check thru code, if a control on the form is visible or it's
hidden?

Thanks in advance
Abe
Forum: Using Forms January 11th, 2010, 09:04 PM Posted to microsoft.public.access.forms
Replies: 8
Views: 141
Posted By Abe Katz
Cursor position

Hello,
When I tab from one control to another or use docmd.gotoControl the control
gets highlighted automatically.
Is there a way to put the cursor at the end of the control or at the
beginning of...
Forum: General Discussion December 14th, 2009, 03:53 PM Posted to microsoft.public.access
Replies: 7
Views: 69
Posted By Abe Katz
Access 7

Hello,

Where can I find the workgroup administrator in Access 7.

I don't know why Microsoft had to change around everything in Acc7.
If they want to add features, very good, but why make things...
Forum: Using Forms November 11th, 2009, 04:53 PM Posted to microsoft.public.access.forms
Replies: 0
Views: 111
Posted By Abe Katz
Disable Mouse wheel scrolling

Hello,
I would like to have a simple way to disable the mouse wheel scrolling in
Acc2003.
Thank You in advance
Abe
Forum: Using Forms November 9th, 2009, 08:42 PM Posted to microsoft.public.access.forms
Replies: 0
Views: 83
Posted By Abe Katz
How to get each item, Last date it was sold

Hello All,

I need a list from All the Items in the Inventory, the Last Date each item
was sold, and the qty sold on that date.
Doug Steele told me to use a subquery, it works fine with one table but...
Forum: General Discussion November 9th, 2009, 04:34 PM Posted to microsoft.public.access
Replies: 1
Views: 51
Posted By Abe Katz
SubQuery

Hello All,

I need a list from All the Items in the Inventory, the Last Date each item
was sold, and the qty sold on that date.
Doug Steele told me to use a subquery, it works fine with one table but...
Forum: General Discussion October 28th, 2009, 02:30 PM Posted to microsoft.public.access
Replies: 2
Views: 62
Posted By Abe Katz
Email from Access

Hello All,
I'm using the following code to send email with Outlook, it works fine.
wBody is, the user enters any text to put on the body of the email.
wOutput is, the attached word document or a PDF...
Forum: Using Forms October 23rd, 2009, 06:42 PM Posted to microsoft.public.access.forms
Replies: 1
Views: 123
Posted By Abe Katz
Access To Outlook

Hi Everybody,

How can I add a word document or PDF file to the Outlook body using Access?
I know how to attach but I would like to put it on the body.

Thanks
Abe
Forum: Using Forms October 22nd, 2009, 04:25 PM Posted to microsoft.public.access.forms
Replies: 0
Views: 91
Posted By Abe Katz
EMAIL using Outlook

Hello,
I'm using the following code to send email with Outlook, it works fine.
wBody is, the user enters any text to put on the body of the email.
wOutput is, the attached word document or a PDF file...
Forum: Using Forms October 19th, 2009, 08:31 PM Posted to microsoft.public.access.forms
Replies: 3
Views: 102
Posted By Abe Katz
Total Query

Doug,
I need a list from all the Items in the Inventory, the last date each item
was last sold, and the qty sold.
Doug Steele told me to use a subquery, it works fine with one table but when
I have a...
Forum: Using Forms October 19th, 2009, 05:07 PM Posted to microsoft.public.access.forms
Replies: 1
Views: 106
Posted By Abe Katz
SubQuery

Hello All,

I need a list from all the Items in the Inventory, the last date each item
was last sold, and the qty sold.
Doug Steele told me to use a subquery, it works fine with one table but when...
Forum: Using Forms October 16th, 2009, 03:46 PM Posted to microsoft.public.access.forms
Replies: 3
Views: 102
Posted By Abe Katz
Total Query

Hello All,

I need to know, when was the last time (date) we sold an ItemNo and the
total quantity sold.
I created a Total query and in the Total cell, for the Date I entered Max
and for the Qty I...
Forum: Using Forms September 17th, 2009, 05:15 PM Posted to microsoft.public.access.forms
Replies: 1
Views: 52
Posted By Abe Katz
Snaking Columns Report

Hello,

I have a multiple-column report, the multiple-column list is in the sub
report.
The problem is, it will only print as many lines that fit in the sub report,
the rest of the lines gets...
Forum: Using Forms September 3rd, 2009, 03:48 PM Posted to microsoft.public.access.forms
Replies: 2
Views: 89
Posted By Abe Katz
Disable Button on Opening Form

Hello All,

When I open a form I disable one of the buttons like this,
DoCmd.OpenForm "Ship List"
Forms![Ship ListDT]!ctlButton.Enabled = False

But it doesn't work when I open the form with...
Forum: Using Forms August 24th, 2009, 09:30 PM Posted to microsoft.public.access.forms
Replies: 1
Views: 59
Posted By Abe Katz
On Enter Event

Hello All,
On the On Enter event of a control, I have code to save the old data before
a user changes the control. It worked good. But lately I realized that it's
not so accurate all the times.
Is...
Showing results 1 to 25 of 43

 
Forum Jump

All times are GMT +1. The time now is 02:39 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.