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 0.60 seconds.
Search: Posts made by: John J.
Forum: General Discussion March 11th, 2009, 09:30 PM Posted to microsoft.public.access
Replies: 6
Views: 57
Posted By John J.
Struggling

Did you try Forms in stead of Form?

Forms.OrderEntryForm.Customer

John

"gvaughn" schreef in bericht...
Forum: General Discussion March 11th, 2009, 07:40 PM Posted to microsoft.public.access
Replies: 6
Views: 57
Posted By John J.
Struggling

See if this helps: http://www.mvps.org/access/forms/frm0028.htm

John

"gvaughn" schreef in bericht
...
I...
Forum: General Discussion March 11th, 2009, 06:59 PM Posted to microsoft.public.access
Replies: 2
Views: 44
Posted By John J.
Macro security

I noticed that in A2002 the macro security option was removed by letting
Access follow these settings from IE. In A2003 the macro security settings
are back.

One of my clients uses A2003 and this...
Forum: General Discussion March 9th, 2009, 04:57 AM Posted to microsoft.public.access
Replies: 5
Views: 52
Posted By John J.
Zoom while in design mode

Thanks for the reactions. The magnifier works fine.
John

"John J." schreef in bericht
...
I'm developing a form with some tiny buttons. Is it...
Forum: General Discussion March 8th, 2009, 09:23 PM Posted to microsoft.public.access
Replies: 5
Views: 52
Posted By John J.
Zoom while in design mode

I'm developing a form with some tiny buttons. Is it possible to zoom into
the form while in design mode?
Thanks,
John
Forum: General Discussion March 8th, 2009, 05:02 AM Posted to microsoft.public.access
Replies: 4
Views: 62
Posted By John J.
Upgrade or wait

Thanks Bob, Tom,
I found some...
Forum: General Discussion March 8th, 2009, 04:52 AM Posted to microsoft.public.access
Replies: 8
Views: 73
Posted By John J.
Advice about error handling function

I falsely derived that from my test. I thought that "????????.*" would
exclude for instance 2 letter filenames, but it doesn't.
Thanks,
John

"Douglas J. Steele" ...
Forum: General Discussion March 7th, 2009, 10:26 PM Posted to microsoft.public.access
Replies: 8
Views: 73
Posted By John J.
Advice about error handling function

Thanks for the pointer. That's safer.

One detail is that:
Do While Len(strFile) = 8
will make the function stop if a file is found that has less than 8
characters, while I need the function to...
Forum: General Discussion March 7th, 2009, 10:03 PM Posted to microsoft.public.access
Replies: 8
Views: 73
Posted By John J.
Advice about error handling function

One other thing I noticed:
strBUfolder = strBUfolder & "????????.*"
wil make the first dir call to search for a file with 8 characters.
But strFile = Dir will continue searching without that...
Forum: General Discussion March 7th, 2009, 09:41 PM Posted to microsoft.public.access
Replies: 8
Views: 73
Posted By John J.
Advice about error handling function

Thanks Tom.

The files are longer than 8 characters but I can adopt the idea with a few
more ?'s.

I notice that the dateserial doesn't blow up when strFile is not a valid
date (for instance...
Forum: General Discussion March 7th, 2009, 08:16 PM Posted to microsoft.public.access
Replies: 3
Views: 48
Posted By John J.
Access 2007: sort by hyperlink?

They can be sorted, at least in A2003.
John

"Arvin Meyer MVP" schreef in bericht
...
Hyperlinks cannot be indexed or sorted.
...
Forum: General Discussion March 7th, 2009, 08:03 PM Posted to microsoft.public.access
Replies: 8
Views: 73
Posted By John J.
Advice about error handling function

I've written the function below which deletes backupfiles (of which the name
starts with yearmonthday) older than 30 days in a specified folder. Though
it works, I'm not sure about the err_handler....
Forum: General Discussion March 7th, 2009, 06:17 PM Posted to microsoft.public.access
Replies: 4
Views: 62
Posted By John J.
Upgrade or wait

I'm using Access 2003 and I am thinking about upgrading to 2007 (first to
test if my apps work in A2007 and later to migrate my apps). I've read
several comments of users who aren't so happy with...
Forum: General Discussion March 5th, 2009, 10:34 PM Posted to microsoft.public.access
Replies: 12
Views: 96
Posted By John J.
Determine folder access rights

It is relevant. When the user has no access rights he should get a message
that that is the problem. When the export went wrong and no files exists in
a folder the user has access to, the user...
Forum: General Discussion March 4th, 2009, 05:24 AM Posted to microsoft.public.access
Replies: 12
Views: 96
Posted By John J.
Determine folder access rights

I do check that. But it could be that the file actually doesn't exists, for
instance because the third party export to the folders went wrong. How would
I know the difference?
John

"Bob Quintal"...
Forum: General Discussion March 3rd, 2009, 08:41 PM Posted to microsoft.public.access
Replies: 12
Views: 96
Posted By John J.
Determine folder access rights

Thanks Gina. I'll check it out.
John

"Gina Whipp" schreef in bericht
...
John,

I have not seen anything that checks the...
Forum: General Discussion March 3rd, 2009, 06:30 PM Posted to microsoft.public.access
Replies: 12
Views: 96
Posted By John J.
Determine folder access rights

I have an app that imports Excel files from different read-only folders (one
folder per department). Some users have read access to every folder, some
only for one. Users have their own app. In the...
Forum: General Discussion March 2nd, 2009, 03:01 PM Posted to microsoft.public.access
Replies: 12
Views: 96
Posted By John J.
Determine folder access rights

Before starting a procedure I need to know if the user has at least READ
permissions on a certain folder. I found several ideas on Google but none of
them are suitable. The point is that I don't...
Forum: General Discussion March 1st, 2009, 03:46 PM Posted to microsoft.public.access
Replies: 6
Views: 43
Posted By John J.
Query criteria based on other field's value

Thanks all. I accidentally tested on the wrong table. Finally:

Not Like [OtherFieldFromSameTable] & "*"

does the job.

John


"John J." schreef in bericht
Forum: General Discussion March 1st, 2009, 03:01 PM Posted to microsoft.public.access
Replies: 6
Views: 43
Posted By John J.
Query criteria based on other field's value

The following criteria in a query works: Not Like "testvalue*"

Now, I would like to substitute testvalue for the value of another field
from the same table, something like:
Not Like...
Forum: General Discussion February 28th, 2009, 08:02 PM Posted to microsoft.public.access
Replies: 8
Views: 86
Posted By John J.
Function to delete a folder and its content

Yes! it works.
Thanks so much.
John

"H. Druss" schreef in bericht
...

"John J." wrote in message
...
Forum: General Discussion February 28th, 2009, 03:43 PM Posted to microsoft.public.access
Replies: 8
Views: 86
Posted By John J.
Function to delete a folder and its content

Sorry, but I should have mentioned that it should run in VBA.
John

"TedMi" schreef in bericht
...
rmdir FolderName /S
-TedMi

...
Forum: General Discussion February 28th, 2009, 03:37 PM Posted to microsoft.public.access
Replies: 3
Views: 93
Posted By John J.
DateAdd in calculated field

Great! thanks.

I did not know that in a DateSerial declaration subtracting a month from
january this year would result in december the previous year. So while the
code shows...
Forum: General Discussion February 28th, 2009, 01:21 PM Posted to microsoft.public.access
Replies: 8
Views: 86
Posted By John J.
Function to delete a folder and its content

Thanks. But with this code only files in the main folder gets deleted.
The main folder itself, subfolders and subfolder files aren't deleted.
John

"H. Druss" schreef in bericht...
Forum: General Discussion February 28th, 2009, 11:44 AM Posted to microsoft.public.access
Replies: 8
Views: 86
Posted By John J.
Function to delete a folder and its content

Thanks, but it doesn't work. Deleting a folder with the kill statement
doesn't work (error: file cannot be found). The Help file says I should use
rmdir.
John

"Arvin Meyer [MVP]"...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 11:40 AM.


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