Maybe you could use this function Public Function WorkDays(ByVal dtmStart As Date, dtmEnd As Date) As Long Dim lngWork As Long Do While dtmStart <= dtmEnd If...
11215
Coday Family
codayfamily
Aug 1, 2003 1:49 pm
It's easier to count ... From: ms_access@yahoogroups.com Date: Thursday, July 31, 2003 23:33:45 To: ms_access@yahoogroups.com Subject: RE: [ms_access]...
11216
Beth Moffitt
bethmoffitt2
Aug 1, 2003 2:03 pm
But then how do you know when to stop counting? ;) Beth ... From: Coday Family [mailto:coday@...] Sent: Friday, August 01, 2003 8:52 AM To:...
11217
blue_my_mind
Aug 1, 2003 5:56 pm
I have a report that is grouped by [Category]. At each change in [Category] I force a new page using the sorting/grouping box. I also have a page header set...
11218
Beth Moffitt
bethmoffitt2
Aug 1, 2003 6:11 pm
Coghan, Strictly brainstorming here... Can you try something on the Category header on the On Format event like: If groupheader0.visible = true then ...
11219
blue_my_mind
Aug 1, 2003 7:03 pm
... If groupheader0.visible = true then ... No, that wouldn't do exactly what I needed. I tried the hascontinued property, but I think that only works if the...
11220
Dave R.
resorts03226
Aug 2, 2003 1:59 am
... From: John Henry [mailto:johnhenry@...] Sent: Thursday, July 31, 2003 11:52 PM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Access...
11221
administrator@...
resorts03226
Aug 2, 2003 3:53 am
Just testing. Sorry. My email went south for the summer. [Non-text portions of this message have been removed]...
11222
raysgoogle
Aug 3, 2003 1:10 am
Here's what I want to do. In broken database dialect speak, For ID in qrySaleableItems SELECT QTY from qrySaleableItems and Write QTY to tblSalesRecord...
11223
Yeo, Eng Ann ...
ctct5pg
Aug 4, 2003 4:20 am
Hi, What is the VBA code in access 2000 that show the file open box? I am trying to create a import sequence in access 2000 where the user will select a file...
11224
Haslett, Andrew
ahaslettilc
Aug 4, 2003 4:42 am
http://www.mvps.org/access/api/api0001.htm <http://www.mvps.org/access/api/api0001.htm> ... From: Yeo, Eng Ann CAR [mailto:eng.ann.yeo@...] Sent:...
11225
Dave Moreau
airportpalm
Aug 4, 2003 12:53 pm
Tried this but nothing seems to be happening? When should I see the graphic and does it have a limit on size? I have an airport dbase that I would like to...
11226
Dave Moreau
airportpalm
Aug 4, 2003 12:58 pm
Figured out the problem....the splash screen only shows if I open the file and Access from the file name. If I am already in Access the splash screen will not...
11227
George Oro
georgeoro
Aug 4, 2003 1:13 pm
Hi Dave, This is my approach on my splash screen: Step 1: Create a .bmp (Without Image or Dark Gray Color same as Access Window Background) and name it the...
11228
Brett Collings
zkbac
Aug 4, 2003 11:55 pm
... Sorry, I thought I'd already answered the question Dave. - Firstly, the "splash screen" is not the BMP in the same directory as your database file. That...
11229
Dave Moreau
airportpalm
Aug 5, 2003 11:16 am
Yes sir you did...not sure why the second note went out. Thank you for your reply and the form solution will work great. Thanks again! Dave ... From: Brett...
11230
steveislip4
steveislip
Aug 5, 2003 12:36 pm
I’m trying to detect if a form is open from another form and close it . I’ve set up an isloaded function . Dim stDocName2 As String stDocName2 =...
11231
jebor1
Aug 5, 2003 1:48 pm
Steve, Your function IsLoaded expects the form to be passed. Passing an entire form only to find out whether it is open or not, is not really necessary. Just...
11232
George Oro
georgeoro
Aug 5, 2003 2:25 pm
Hi Guys, What is the best way to secure my table from importing or linking from other db where all my users & passwords are kept? I want all the changes must...
11233
George Oro
georgeoro
Aug 5, 2003 2:25 pm
Hi Guys, Is there any way to achieve this issue? For Instance: I have 3 Text Boxes where to be assigned the path and file name of the images which I browse to...
11234
steveislip4
steveislip
Aug 5, 2003 2:30 pm
Jeroen Thanx that worked a treat steve ... [Non-text portions of this message have been removed]...
11235
Sandra Maroney
samaroney
Aug 6, 2003 2:40 am
I am getting a !Num as the value in one of my queries. I have two fields that divide by one another. When one of the fields has a value of 0 and the other...
11236
John Fejsa
jfejsa
Aug 6, 2003 3:32 am
Force the null divisor value to become 1 as in Nz(Me!Text, 1), the second part converts null value to your specified value, in this case 1. If you convert Null...
11237
Lum Pooi Yeng
py-lum@...
Aug 6, 2003 3:40 am
Hi, Could someone teach me how to compress MDB file from coding. I have a database file call Master.MDB and another file call User.MDB I want to compress...
11238
Sam Maroney
samaroney
Aug 6, 2003 3:51 am
I didn't know you could do that with the Nz function -- forcing the value to a specified value. What I ended up doing is using an IIF statement, and that...
11239
John Fejsa
jfejsa
Aug 6, 2003 4:09 am
NOTE: IIF statement is extremely slow when compared to Nz function. If speed is of importance, I would convert to Nz function, otherwise, the great thing about...
11240
jebor1
Aug 6, 2003 6:06 am
Maybe this is what you mean: Public Sub DBCompact(strDataBase As String) Dim strCompDB As String 'Determine name for compacted file strCompDB =...
11241
Lum Pooi Yeng
py-lum@...
Aug 6, 2003 7:01 am
Hi, Jobor Thanks for your help. I have to compact it to another file name first then replace it back to initial file name. am I correct? Thanks again. ... ...
11242
jebor1
Aug 6, 2003 7:09 am
Correct. You would have to rename the compacted file afterwards: Kill strDataBase Name strCompDB As strDataBase Jeroen ... back to ... & "_Comp.mdb" ... want ...
11243
Lum Pooi Yeng
py-lum@...
Aug 6, 2003 7:31 am
Thanks. ... From: "jebor1" <jbor1@...> To: <ms_access@yahoogroups.com> Sent: Wednesday, August 06, 2003 3:09 PM Subject: [ms_access] Re: How To Compress...
