I have an Access File that I would like to distribute to people who do not have
MS Access on there computer.  Does anyone know what is required?  What are the
issues?  What are the obstacles to be aware of?

Thanks!

Ruel

Sir,
 

--- On Mon, 10/12/09, ruel_cespedes <ruel_cespedes@...> wrote:


From: ruel_cespedes <ruel_cespedes@...>
Subject: [ms_access] DEVELOPER'S TOOL KIT
To: ms_access@yahoogroups.com
Date: Monday, October 12, 2009, 12:27 PM


 



I have an Access File that I would like to distribute to people who do not have
MS Access on there computer. Does anyone know what is required? What are the
issues? What are the obstacles to be aware of?

Thanks!

Ruel



















[Non-text portions of this message have been removed]

Sir,
   I do not know if it is true of MS ACCESS, but some programs have what is
called a "runtime" module that will allow a program to be run but not created of
the user-receiver's system.  For example, Microsoft has a free MS Power Point
viewer that lets the user view the Power Point presentations but is not capable
of making new presentations. There was a similar program for the old Emerald Bay
database -- much like the DOS dBASE III.  I have never really gone looking for
and MS ACCESS runtime module. I too would very much like to have one.
   A database runtime module might or might not allow users to add data to an
existing database.
 
Gene Fleming

--- On Mon, 10/12/09, ruel_cespedes <ruel_cespedes@...> wrote:


From: ruel_cespedes <ruel_cespedes@...>
Subject: [ms_access] DEVELOPER'S TOOL KIT
To: ms_access@yahoogroups.com
Date: Monday, October 12, 2009, 12:27 PM


 



I have an Access File that I would like to distribute to people who do not have
MS Access on there computer. Does anyone know what is required? What are the
issues? What are the obstacles to be aware of?

Thanks!

Ruel



















[Non-text portions of this message have been removed]

Access 2000, Developers edition, was supplied with a runtime module and a
licence to install this with databases on other computers.
I'n not aware that there are any for later versions of Access.

Keith


----- Original Message -----
From: "Eugene Fleming" <eugenefleming@...>
To: <ms_access@yahoogroups.com>
Sent: Wednesday, October 14, 2009 2:14 AM
Subject: Re: [ms_access] DEVELOPER'S TOOL KIT


Sir,
I do not know if it is true of MS ACCESS, but some programs have what is
called a "runtime" module that will allow a program to be run but not
created of the user-receiver's system. For example, Microsoft has a free MS
Power Point viewer that lets the user view the Power Point presentations but
is not capable of making new presentations. There was a similar program for
the old Emerald Bay database -- much like the DOS dBASE III. I have never
really gone looking for and MS ACCESS runtime module. I too would very much
like to have one.
A database runtime module might or might not allow users to add data to an
existing database.

Gene Fleming

--- On Mon, 10/12/09, ruel_cespedes <ruel_cespedes@...> wrote:


From: ruel_cespedes <ruel_cespedes@...>
Subject: [ms_access] DEVELOPER'S TOOL KIT
To: ms_access@yahoogroups.com
Date: Monday, October 12, 2009, 12:27 PM






I have an Access File that I would like to distribute to people who do not
have MS Access on there computer. Does anyone know what is required? What
are the issues? What are the obstacles to be aware of?

Thanks!

Ruel



















[Non-text portions of this message have been removed]



------------------------------------

Yahoo! Groups Links

What you are talking about in Access is the distributed file, an MDE.
This file can be given to someone that does not have access and they can
run the database. That means they can enter data, delete data, modify
data but they cannot change the structure in any way.

You do this from Tools, Database Utilities, Make MDE file. When that
file is made, you can give it anyone and it works like the run time you
are referring to.

Kind regards,

Peter

--
Peter T. Fairchild
Consultant en Informatique

peterfairchild@...
  +41-(0)79-715-9155 Portable
  +41-(0)21-800-4044 Office

"Form and Function are one"  Frank Lloyd Wright 1867 - 1959



Eugene Fleming wrote:
> Sir,
>    I do not know if it is true of MS ACCESS, but some programs have what is
called a "runtime" module that will allow a program to be run but not created of
the user-receiver's system.  For example, Microsoft has a free MS Power Point
viewer that lets the user view the Power Point presentations but is not capable
of making new presentations. There was a similar program for the old Emerald Bay
database -- much like the DOS dBASE III.  I have never really gone looking for
and MS ACCESS runtime module. I too would very much like to have one.
>    A database runtime module might or might not allow users to add data to an
existing database.
>
> Gene Fleming
>
> --- On Mon, 10/12/09, ruel_cespedes <ruel_cespedes@...> wrote:
>
>
> From: ruel_cespedes <ruel_cespedes@...>
> Subject: [ms_access] DEVELOPER'S TOOL KIT
> To: ms_access@yahoogroups.com
> Date: Monday, October 12, 2009, 12:27 PM
>
>
>
>
>
>
> I have an Access File that I would like to distribute to people who do not
have MS Access on there computer. Does anyone know what is required? What are
the issues? What are the obstacles to be aware of?
>
> Thanks!
>
> Ruel
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
>

 
Runtime Access2007 is available on web.
 
Search the net.
 
Regards
Irshad


       __________________________________________________________________
The new Internet Explorer® 8 - Faster, safer, easier.  Optimized for Yahoo!  Get
it Now for Free! at http://downloads.yahoo.com/ca/internetexplorer/

[Non-text portions of this message have been removed]

FULL TIME ENTRY LEVEL WEB/DB APP PROGRAMMER POSITION

*************************************************************
*** Please send all replies and resumes to JOBS@... ***
*************************************************************
****  No recruiters, contractors, or Telecommuters  !!!  ****
*************************************************************


	 FULL TIME
	 ENTRY LEVEL
	 NO VISAS
	 NO CONTRACTORS
	 NO TELECOMMUTERS



Required Qualifications include but are not limited to:

• MUST BE LEGALLY ABLE TO WORK IN THE US WITHOUT VISA SPONSORSHIP
• Experience writing SQL Queries.
• MS Access 2002 – 2007.
• Proficient in Classic ASP, ASP.NET, HTML

Preferred Qualifications

• VBScript, JavaScript VBA, VB.NET, HTML, and AJAX.
• Basic skills for installing, troubleshooting and configuring PC Hardware and
Software.
• Understanding of TCP/IP configuration, subnetting and routing.
• Understanding of SOHO routers and VPN configurations.
• Prior experience with Versioning (preferably SubVersion).
• Prior experience with Active Directory.
• Associates degree, Bachelors Degree or equivalent experience.

Benefits include dental, medical, disability, prescription, life, vision, casual
dress, paid holidays, free parking, and paid time off.


*************************************************************
*** Please send all replies and resumes to JOBS@... ***
*************************************************************
****  No recruiters, contractors, or Telecommuters  !!!  ****
*************************************************************


If you are interested in applying for this poition, please provide us with the
following information to help evaluate your candidacy:


	 A copy of your resume.


	 This is a full-time, salaried, ON-SITE ENTRY LEVEL position.  Telecommuters,
Remote workers and Contract workers will NOT be accepted. Are you looking for a
full time on-site position?


 	 Are you legally eligible for employment in the USA without requiring Visa
sponsorship either now or in the future?


	 The budgeted salary for this position is 40k/year. Does this fall within your
salary requirements range?


	 The salary history for your last 3 positions held  (per year)


	 Your current salary requirements  (per year)


	 If you currently support any websites, please list them, along with your % of
involvement in its development & support.


	 How many years of experience do you have as a web developer?


	 How many years of experience do you have as a database developer?


	 Please indicate your level of ability to effectively communicate in both a
written and oral manner.


	 Please indicate your level of skill debugging applications and programs.


	 Please indicate your level of experience with writing SQL queries


	 Please indicate your level of experience with SQL server installation and
administration


	 Please indicate your level of experience with MS Access database design


	 Please indicate your level of experience programming in classic ASP


	 Please indicate your level of experience programming in ASP.NET


	 Please indicate your level of experience programming in JavaScript


	 Please indicate your level of experience programming in AJAX


	 Please indicate your level of experience with TCP/IP subnetting and routing


	 Please indicate your level of experience with Active Directory


	 If you are not local to the Arlington TX area, would you be willing to
relocate?


	 Please offer any additional information, including any additional applications
experience or URLs of your previous work that you feel is important for a
potential employer to know about you.



*************************************************************
*** Please send all replies and resumes to JOBS@... ***
*************************************************************
****  No recruiters, contractors, or remote workers !!!  ****
*************************************************************


jobs@...


*We are an Equal Opportunity Employer, committed to workforce diversity. M/F/D/V
encouraged to apply. Qualified applicants will receive consideration without
regard to age, race, color, religion, sex, sexual orientation, disability, or
national origin. Applicants encouraged to confidentially self-identify when
applying. Employment contingent upon successful completion of background
investigation. Drug-free work environment. No recruiters or agencies without a
previously signed contract. Only candidates whose profiles closely match
requirements will be contacted during this search. Relocation costs not covered
by employer. Must be eligible to work in this country. No phone calls please.

Is there a way in a query to pull the worsheet function percentile?  I am
working with a table of salary data and just need the 25th, 50th and 75th
percentile by job code.

I have seen this done in VBA.  I'm wondering if it can be done in a query.

Hello folks,
I want to create a search form in MS Access 2003 where the user enters a ID in a
unbound text box. There is a search button provided. Once the screen loads, i
need to have all the fields empty. Once the user clicks on the search button,
the form should have the results. Based on the search i m doing, i actually need
the results to appear in a table form.
Please help me.

I have a search screen in MS Access 2003, with a unbound text box to put in the
parameter to search. I need to have all the text boxes in the columnar display
blank on startup. How do it do this?

Peter



I'm not sure if what you wrote is really true. I think an MDE file will
still need MS Access to be installed on the computer for the MDE to run.
However, with Office 2007 you can download free Access Runtime module which
can convert your access application to some kind of a standalone program
i.e. can run on a machine which doesn't have Access installed. Or am I
missing something here?



Regards



Liveson



From: ms_access@yahoogroups.com [mailto:ms_access@yahoogroups.com] On Behalf
Of Peter T. Fairchild
Sent: Monday, 26 October, 2009 22:25
To: ms_access@yahoogroups.com
Subject: Re: [ms_access] DEVELOPER'S TOOL KIT





What you are talking about in Access is the distributed file, an MDE.
This file can be given to someone that does not have access and they can
run the database. That means they can enter data, delete data, modify
data but they cannot change the structure in any way.

You do this from Tools, Database Utilities, Make MDE file. When that
file is made, you can give it anyone and it works like the run time you
are referring to.

Kind regards,

Peter

--
Peter T. Fairchild
Consultant en Informatique

peterfairchild@... <mailto:peterfairchild%40bluewin.ch>
+41-(0)79-715-9155 Portable
+41-(0)21-800-4044 Office

"Form and Function are one" Frank Lloyd Wright 1867 - 1959

Eugene Fleming wrote:
> Sir,
> I do not know if it is true of MS ACCESS, but some programs have what is
called a "runtime" module that will allow a program to be run but not
created of the user-receiver's system. For example, Microsoft has a free MS
Power Point viewer that lets the user view the Power Point presentations but
is not capable of making new presentations. There was a similar program for
the old Emerald Bay database -- much like the DOS dBASE III. I have never
really gone looking for and MS ACCESS runtime module. I too would very much
like to have one.
> A database runtime module might or might not allow users to add data to an
existing database.
>
> Gene Fleming
>
> --- On Mon, 10/12/09, ruel_cespedes <ruel_cespedes@...
<mailto:ruel_cespedes%40yahoo.com> > wrote:
>
>
> From: ruel_cespedes <ruel_cespedes@...
<mailto:ruel_cespedes%40yahoo.com> >
> Subject: [ms_access] DEVELOPER'S TOOL KIT
> To: ms_access@yahoogroups.com <mailto:ms_access%40yahoogroups.com>
> Date: Monday, October 12, 2009, 12:27 PM
>
>
>
>
>
>
> I have an Access File that I would like to distribute to people who do not
have MS Access on there computer. Does anyone know what is required? What
are the issues? What are the obstacles to be aware of?
>
> Thanks!
>
> Ruel
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
>





[Non-text portions of this message have been removed]

Dear group members,
I have a form with two controls named ctrl_1 and ctrl_2.
1) I wish ctrl_2 will be invisible when the form is loaded(opened?)
2) I wish when ctrl_1 takes the value "10" ctrl_2 become visible.
3) I wish when I want to make a new record (when I click new record button) and
see the form again ctrl_2 become invisible.
I have accomplished the first and second tasks but couldn't the third one.
Can you please give an advice?
Best wishes to all..
Ruhi

Look into the on_current property, and the visible property.
Psuedo code to foolow:

Control_1 on_current

If me.value = 10 then
   control_2.visible = true
End If

End sub

In the on open event of the form, set control_2s visible property to false,
also.

In the on click event of the add new record button, set control_2s visible
property to false, also.


HTH

--- On Tue, 11/10/09, rkulez <rkulez@...> wrote:

From: rkulez <rkulez@...>
Subject: [ms_access] invisible control
To: ms_access@yahoogroups.com
Date: Tuesday, November 10, 2009, 6:23 AM







 









       Dear group members,

I have a form with two controls named ctrl_1 and ctrl_2.

1) I wish ctrl_2 will be invisible when the form is loaded(opened? )

2) I wish when ctrl_1 takes the value "10" ctrl_2 become visible.

3) I wish when I want to make a new record (when I click new record button) and
see the form again ctrl_2 become invisible.

I have accomplished the first and second tasks but couldn't the third one.

Can you please give an advice?

Best wishes to all..

Ruhi

























[Non-text portions of this message have been removed]

Thanks, my problem is solved.
Best wishes.
Ruhi

--- In ms_access@yahoogroups.com, Tyrone Lumley <tyrone_topheavy@...> wrote:
>
> Look into the on_current property, and the visible property.
> Psuedo code to foolow:
>
> Control_1 on_current
>
> If me.value = 10 then
>    control_2.visible = true
> End If
>
> End sub
>
> In the on open event of the form, set control_2s visible property to false,
also.
>
> In the on click event of the add new record button, set control_2s visible
property to false, also.
>
>
> HTH
>
> --- On Tue, 11/10/09, rkulez <rkulez@...> wrote:
>
> From: rkulez <rkulez@...>
> Subject: [ms_access] invisible control
> To: ms_access@yahoogroups.com
> Date: Tuesday, November 10, 2009, 6:23 AM
>
>
>
>
>
>
>
>  
>
>
>
>
>
>
>
>
>
>       Dear group members,
>
> I have a form with two controls named ctrl_1 and ctrl_2.
>
> 1) I wish ctrl_2 will be invisible when the form is loaded(opened? )
>
> 2) I wish when ctrl_1 takes the value "10" ctrl_2 become visible.
>
> 3) I wish when I want to make a new record (when I click new record button)
and see the form again ctrl_2 become invisible.
>
> I have accomplished the first and second tasks but couldn't the third one.
>
> Can you please give an advice?
>
> Best wishes to all..
>
> Ruhi
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

Here's the problem: I am the transportation coordinator for a Senior Center and
do the scheduling using an Access 2007 database that I have designed. Fields in
the main Rides table include the date, the time the passenger needs to be picked
up (pickuptime), and the driver for that ride. Each date has multiple rides,
multiple passengers, and multiple drivers. I am trying to design a report that
will generate a cover sheet for each driver that includes the driver, the date,
and the time of the first pickup for which the driver is responsible. Getting
the date and the driver is easy, but to get the first pickup time, I need a way
of picking out the earliest time for a given driver. Help?!

Barbara Mann
Transportation Coordinator
Yellow Springs Senior Center

I have an access 2007 report that includes photos and I want to
export it to a html file ...

the available options (unless I have missed something) will let me
export text field
part to html as individual table format but I can not get the photos
exported ...

Is there an easy solution to this...??

JohnY

Dear friends,
I have two date fields in my form. When I write a date in the first field I wish
the second date will be 4 workdays more(excluding only sundays). There is
workday function in excel but I couldn't find such a function or code in access.
Can anyone help? Thanks in advance.
Ruhi Kulez

I have two controls on a form. This gives me the dates for the week

the top has the following in the control source
=DateAdd("d",-Weekday(Date())+2,Date())

the bottom field has the following in the control source
=Date()


the proper way to determine the weekday is
DatePart("w",[txtMydate]))

Based on a txtMydate field to get a date you can use
=IIf(IsNull([txtMydate]),"",DatePart("w",[txtMydate]))


Jim Wagner
________________________________





________________________________
From: rkulez <rkulez@...>
To: ms_access@yahoogroups.com
Sent: Fri, November 20, 2009 3:00:49 AM
Subject: [ms_access] workdays


Dear friends,
I have two date fields in my form. When I write a date in the first field I wish
the second date will be 4 workdays more(excluding only sundays). There is
workday function in excel but I couldn't find such a function or code in access.
Can anyone help? Thanks in advance.
Ruhi Kulez







[Non-text portions of this message have been removed]

Write an update query to update the seconf date

--- On Fri, 11/20/09, rkulez <rkulez@...> wrote:


From: rkulez <rkulez@...>
Subject: [ms_access] workdays
To: ms_access@yahoogroups.com
Date: Friday, November 20, 2009, 2:00 AM


 



Dear friends,
I have two date fields in my form. When I write a date in the first field I wish
the second date will be 4 workdays more(excluding only sundays). There is
workday function in excel but I couldn't find such a function or code in access.
Can anyone help? Thanks in advance.
Ruhi Kulez








[Non-text portions of this message have been removed]

Hi Jim, I didn´t understand how to use it, could you send me an exemplo.
 
Jefferson

--- Em sex, 20/11/09, Jim Wagner <luvmymelody@...> escreveu:


De: Jim Wagner <luvmymelody@...>
Assunto: Re: [ms_access] workdays
Para: ms_access@yahoogroups.com
Data: Sexta-feira, 20 de Novembro de 2009, 13:18


 



I have two controls on a form. This gives me the dates for the week

the top has the following in the control source
=DateAdd("d" ,-Weekday( Date())+2, Date())

the bottom field has the following in the control source
=Date()

the proper way to determine the weekday is
DatePart("w" ,[txtMydate] ))

Based on a txtMydate field to get a date you can use
=IIf(IsNull( [txtMydate] ),"",DatePart( "w",[txtMydate] ))

Jim Wagner
____________ _________ _________ __

____________ _________ _________ __
From: rkulez <rkulez@yahoo. com>
To: ms_access@yahoogrou ps.com
Sent: Fri, November 20, 2009 3:00:49 AM
Subject: [ms_access] workdays

Dear friends,
I have two date fields in my form. When I write a date in the first field I wish
the second date will be 4 workdays more(excluding only sundays). There is
workday function in excel but I couldn't find such a function or code in access.
Can anyone help? Thanks in advance.
Ruhi Kulez

[Non-text portions of this message have been removed]









      
________________________________________________________________________________\
____
Veja quais sĂŁo os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com

[Non-text portions of this message have been removed]

Dear Jim and Jefferson,
It seems there is something wrong with the formula. Up to my limited knowledge
this formula means "add the number of the day to the date and add 2 on it" .
First of all your formula has a minus sign before weekday and this leads the
result to be an early date. I have removed it and when I test it gives wrong
results without excluding "sundays". For example when the date is 1st of Dec.
the later date seems 6 th of Dec which is Sunday. If the date is 2nd of Dec then
the later date seems 8 th of Dec. excluding monday. I think something is missing
with the formula.
Very best wishes.
Ruhi

--- In ms_access@yahoogroups.com, jefferson ferreira de sousa
<jferreira.sousa@...> wrote:
>
> Hi Jim, I didn´t understand how to use it, could you send me an exemplo.
>  
> Jefferson
>
> --- Em sex, 20/11/09, Jim Wagner <luvmymelody@...> escreveu:
>
>
> De: Jim Wagner <luvmymelody@...>
> Assunto: Re: [ms_access] workdays
> Para: ms_access@yahoogroups.com
> Data: Sexta-feira, 20 de Novembro de 2009, 13:18
>
>
>  
>
>
>
> I have two controls on a form. This gives me the dates for the week
>
> the top has the following in the control source
> =DateAdd("d" ,-Weekday( Date())+2, Date())
>
> the bottom field has the following in the control source
> =Date()
>
> the proper way to determine the weekday is
> DatePart("w" ,[txtMydate] ))
>
> Based on a txtMydate field to get a date you can use
> =IIf(IsNull( [txtMydate] ),"",DatePart( "w",[txtMydate] ))
>
> Jim Wagner
> ____________ _________ _________ __
>
> ____________ _________ _________ __
> From: rkulez <rkulez@yahoo. com>
> To: ms_access@yahoogrou ps.com
> Sent: Fri, November 20, 2009 3:00:49 AM
> Subject: [ms_access] workdays
>
> Dear friends,
> I have two date fields in my form. When I write a date in the first field I
wish the second date will be 4 workdays more(excluding only sundays). There is
workday function in excel but I couldn't find such a function or code in access.
Can anyone help? Thanks in advance.
> Ruhi Kulez
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
>
>
>      
________________________________________________________________________________\
____
> Veja quais sĂŁo os assuntos do momento no Yahoo! +Buscados
> http://br.maisbuscados.yahoo.com
>
> [Non-text portions of this message have been removed]
>

Hi,

I have two fields one for "Amount in figures" and the other one "Amount in
words". What I need is that after update of "Amount in Figures" the codes will
give auto the "Amount in words". Example: $150.10 should convert to  One Hundred
Fifty 10/100. Thanking you all in advance.

Desperately Yours,

Romeo

Here ya go,

http://msdn.microsoft.com/en-us/library/aa139962(office.10).aspx#odc_actips_topi\
c10

 



________________________________
From: Romeo <jre.phils@...>
To: ms_access@yahoogroups.com
Sent: Mon, November 23, 2009 5:15:44 AM
Subject: [ms_access] VBA code for converting figures into words

 
Hi,

I have two fields one for "Amount in figures" and the other one "Amount in
words". What I need is that after update of "Amount in Figures" the codes will
give auto the "Amount in words". Example: $150.10 should convert to One Hundred
Fifty 10/100. Thanking you all in advance.

Desperately Yours,

Romeo







[Non-text portions of this message have been removed]

Lonnie,
 
Thank you so much. Exactly what I need. I owe you a lot.
 
Romeo 




[Non-text portions of this message have been removed]

Hi Friends
I have 5 multi select list boxes, lstBox1 thru lstBox5. the user can select 1 or
more Items from each list boxes. i need to populate all the selected items into
a table. please help

Thanks
Mike

Sorry for not getting back to you.

add a text box on a form name it txtMydate
make the default value =Date()
add a second text box and add to the control source
=IIf(IsNull([txtMydate]),"",DatePart("w",[txtMydate]))

add a third text box and add the following to the control source
=WeekdayName(DatePart("w",[txtMydate]))

Jim Wagner
________________________________





________________________________
From: jefferson ferreira de sousa <jferreira.sousa@...>
To: ms_access@yahoogroups.com
Sent: Fri, November 20, 2009 10:20:36 AM
Subject: Re: [ms_access] workdays


Hi Jim, I didn´t understand how to use it, could you send me an exemplo.

Jefferson

--- Em sex, 20/11/09, Jim Wagner <luvmymelody@ yahoo.com> escreveu:

De: Jim Wagner <luvmymelody@ yahoo.com>
Assunto: Re: [ms_access] workdays
Para: ms_access@yahoogrou ps.com
Data: Sexta-feira, 20 de Novembro de 2009, 13:18



I have two controls on a form. This gives me the dates for the week

the top has the following in the control source
=DateAdd("d" ,-Weekday( Date())+2, Date())

the bottom field has the following in the control source
=Date()

the proper way to determine the weekday is
DatePart("w" ,[txtMydate] ))

Based on a txtMydate field to get a date you can use
=IIf(IsNull( [txtMydate] ),"",DatePart( "w",[txtMydate] ))

Jim Wagner
____________ _________ _________ __

____________ _________ _________ __
From: rkulez <rkulez@yahoo. com>
To: ms_access@yahoogrou ps.com
Sent: Fri, November 20, 2009 3:00:49 AM
Subject: [ms_access] workdays

Dear friends,
I have two date fields in my form. When I write a date in the first field I wish
the second date will be 4 workdays more(excluding only sundays). There is
workday function in excel but I couldn't find such a function or code in access.
Can anyone help? Thanks in advance.
Ruhi Kulez

[Non-text portions of this message have been removed]

____________ _________ _________ _________ _________ _________ _
Veja quais sĂŁo os assuntos do momento no Yahoo! +Buscados
http://br.maisbusca dos.yahoo. com

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]

No problem. Glad I could help.




________________________________
From: Roemo Elazegui <jre.phils@...>
To: ms_access@yahoogroups.com
Sent: Mon, November 23, 2009 6:33:12 PM
Subject: Re: [ms_access] VBA code for converting figures into words

 
Lonnie,
 
Thank you so much. Exactly what I need. I owe you a lot.
 
Romeo 

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]

No problem. Glad I could help.




________________________________
From: Roemo Elazegui <jre.phils@...>
To: ms_access@yahoogroups.com
Sent: Mon, November 23, 2009 6:33:12 PM
Subject: Re: [ms_access] VBA code for converting figures into words

 
Lonnie,
 
Thank you so much. Exactly what I need. I owe you a lot.
 
Romeo 

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]

Give us an example of how the data should be stored.




________________________________
From: mike <mikeuhd@...>
To: ms_access@yahoogroups.com
Sent: Mon, November 23, 2009 8:18:56 PM
Subject: [ms_access] getting data from multiple list boxes into a table

 
Hi Friends
I have 5 multi select list boxes, lstBox1 thru lstBox5. the user can select 1 or
more Items from each list boxes. i need to populate all the selected items into
a table. please help

Thanks
Mike







[Non-text portions of this message have been removed]

Is there an easy way of getting an access report that has graphics to
display as a html page

Joyhn Y