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 100
Search took 8.85 seconds.
Search: Posts made by: Douglas J. Steele[_3_]
Forum: Using Forms June 7th, 2010, 06:05 PM Posted to microsoft.public.access.forms
Replies: 3
Views: 2,093
Is a vertical datasheet view possible

"John F" wrote in message
...
The standard layout for the datasheet view form is horizontal. Is there a
...
Forum: Using Forms June 7th, 2010, 01:10 PM Posted to microsoft.public.access.forms
Replies: 5
Views: 2,110
Even an error with this code I copied

If by creating a module and adding that line you're talking about putting
the declaration into a second module (i.e. not the module in which the rest
of your code is running), I'd suggest you...
Forum: Using Forms June 6th, 2010, 02:49 PM Posted to microsoft.public.access.forms
Replies: 14
Views: 3,077
this code doesn't work fully

You've still got the #2 everywhere in your code! That should be #intFile.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/djsteele
Co-author: "Access 2010 Solutions", published by...
Forum: Using Forms June 6th, 2010, 02:48 PM Posted to microsoft.public.access.forms
Replies: 5
Views: 2,110
Even an error with this code I copied

Have you declared lngMyEmpID in your code?

I.e. do you have the following statement anywhere?

Dim lngMyEmpID As Long

--
Doug Steele, Microsoft Access...
Forum: Using Forms June 5th, 2010, 09:16 PM Posted to microsoft.public.access.forms
Replies: 14
Views: 3,077
this code doesn't work fully

Just for the sake of completeness, Daniel's reply is correct. Somehow the
required spaces didn't appear in the post.

username = Me!Text23 & vbNullString
If Len(username) = 0 Then
...
Forum: Using Forms June 5th, 2010, 08:44 PM Posted to microsoft.public.access.forms
Replies: 14
Views: 3,077
this code doesn't work fully

Hold on, my one answer was inaccurate! If all you're doing on the second
command button is reading the data from the file, open it for Input, not
Output!

Open "C:\Accounts\Users\" & username &...
Forum: Using Forms June 5th, 2010, 08:38 PM Posted to microsoft.public.access.forms
Replies: 14
Views: 3,077
this code doesn't work fully

"Bob H" wrote in message
...

Update:
I have used this line to create a text file with given information:

Open...
Forum: Using Forms June 4th, 2010, 08:21 PM Posted to microsoft.public.access.forms
Replies: 14
Views: 3,077
this code doesn't work fully

There is no App object in Access.

Private Sub CreateAcc_Click()
Dim intFile As Integer
Dim username As String

username = Me!Text23 & vbNullString
If Len(username) = 0 Then
MsgBox "Enter a...
Forum: General Discussion June 4th, 2010, 07:24 PM Posted to microsoft.public.access
Replies: 3
Views: 266
Exclude most recent month

WHERE ReadmitMonth DateSerial(Year(Date), Month(Date), 1)

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
Co-author: Access 2010 Solutions, published by Wiley
(no e-mails,...
Forum: General Discussion June 4th, 2010, 05:12 PM Posted to microsoft.public.access
Replies: 3
Views: 266
Exclude most recent month

What's stored in ReadmitMonth: a number (1 through 12), text (Jan through
Dec), or something containing month and day (2010/01 through 2010/12)?


--
Doug Steele, Microsoft Access...
Forum: General Discussion June 4th, 2010, 11:12 AM Posted to microsoft.public.access,comp.databases.ms-access
Replies: 4
Views: 2,169
populating an Access table from a text file

I can't think of anyway to import that other than to use VBA.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
Co-author: Access 2010 Solutions, published by Wiley
(no...
Forum: General Discussion June 3rd, 2010, 07:07 PM Posted to microsoft.public.access
Replies: 3
Views: 529
Display a message box "this entry is a duplicate"

Something like:

Private Sub txtShipNum_BeforeUpdate(Cancel As Integer)

If DCount("*", "MyTable", "ShipNum = '" & Me.txtShipNum & "'") 0 Then
Msgbox Me.txtShipNum & " already exists."
...
Forum: General Discussion June 3rd, 2010, 03:42 PM Posted to microsoft.public.access
Replies: 6
Views: 782
Wanting to grab group of files and PkZip them.

Try:

Shell "pkzipc -add ABC.zip filenam.doc", vbHide

If you're trying to include full paths to file names, remember that if there
are spaces in the path, you have to enclose the name in...
Forum: General Discussion June 2nd, 2010, 08:35 PM Posted to microsoft.public.access
Replies: 1
Views: 349
sending email from Access

You're best off using Late Binding so that you don't need to set a reference
to a specific version.

Tony Toews has an introduction to the topic at...
Forum: General Discussion June 2nd, 2010, 07:41 PM Posted to microsoft.public.access
Replies: 2
Views: 421
Form Event

You mean you want to stop the combo box from showing a selected row?

Me!Combo31 = Null

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
Co-author: Access 2010 Solutions,...
Forum: General Discussion June 2nd, 2010, 05:37 PM Posted to microsoft.public.access
Replies: 6
Views: 782
Wanting to grab group of files and PkZip them.

Take a look at what I've got at
http://www.databasejournal.com/features/msaccess/article.php/3835766/Working-with-Compressed-zipped-folders-in-MS-Access.htm

--
Doug Steele, Microsoft Access...
Forum: General Discussion June 2nd, 2010, 02:22 PM Posted to microsoft.public.access
Replies: 27
Views: 4,097
Let's pick a replacement for this (Access) newsgroup

#3. For quite a few years now, Microsoft has been running a number of news
servers with the address msnews.microsoft.com. On those servers, there are a
number of NNTP newsgroups with a high level...
Forum: Using Forms June 1st, 2010, 06:57 PM Posted to microsoft.public.access.forms
Replies: 1
Views: 378
Sorting Combo box items

Base the combo box on a query that has an appropriate ORDER BY clause in it.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
Co-author: Access 2010 Solutions, published by...
Forum: Using Forms June 1st, 2010, 06:56 PM Posted to microsoft.public.access.forms
Replies: 2
Views: 279
BoundColumn property

Since you want the value of the first column to be stored in the table, set
the BoundColumn to 1.

Since you want the value of the second column to be displayed, set the
ColumnWidths property to 0....
Forum: Using Forms June 1st, 2010, 06:53 PM Posted to microsoft.public.access.forms
Replies: 5
Views: 649
Using the second column of a lookup field in row source

No, I don't believe you can refer to the Column collection in a SQL
statement.

One approach would be to create a function that returns the value.

--
Doug Steele, Microsoft Access...
Forum: Using Forms June 1st, 2010, 04:13 PM Posted to microsoft.public.access.forms
Replies: 5
Views: 649
Using the second column of a lookup field in row source

Not really sure what it is you're trying to do.

To refer to the value in the first column of the currently selected row of
list box BoxA, you refer to Me!BoxA.Column(0) (or...
Forum: General Discussion June 1st, 2010, 11:20 AM Posted to microsoft.public.access
Replies: 6
Views: 387
newbie needs examples of creating a recordset and inserting data using it in Access 2007?

You need to ensure that the reference to DAO is set in Word.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
Co-author: Access 2010 Solutions, published by Wiley
(no e-mails,...
Forum: General Discussion June 1st, 2010, 11:19 AM Posted to microsoft.public.access
Replies: 1
Views: 357
BartShell Module has Stopped working. How do I correct this.

Sorry, but this newsgroup is for question about Access, the database product
that's part of Office Professional.

You'll need to find a more appropriate forum in which to ask this question.

--...
Forum: General Discussion June 1st, 2010, 11:17 AM Posted to microsoft.public.access
Replies: 3
Views: 322
Running Access 2007 In Office 2003

Unfortunately, shared libraries are not necessarily specific to Access. In
fact, problems with shared libraries can even be caused by non-Microsoft
products.

In other words, Allen's advise is...
Forum: General Discussion June 1st, 2010, 11:15 AM Posted to microsoft.public.access
Replies: 3
Views: 329
Controlling text fields in access 2002

While the cursor is in a text box, hitting the key combination Shift-F2 will
cause a Zoom box to pop up.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
Co-author: Access...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 11:32 PM.


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