Search the web
Sign In
New User? Sign Up
ms_access · Help and advice for users of MS access
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want to share photos of your group with the world? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Messages 21702 - 21731 of 21731   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Show Message Summaries   (Group by Topic) Sort by Date ^  
#21702 From: "ruel_cespedes" <ruel_cespedes@...>
Date: Mon Oct 12, 2009 6:27 pm
Subject: DEVELOPER'S TOOL KIT
ruel_cespedes
Offline Offline
Send Email Send Email
 
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

#21703 From: Eugene Fleming <eugenefleming@...>
Date: Tue Oct 13, 2009 1:04 pm
Subject: Re: DEVELOPER'S TOOL KIT
eugenefleming
Offline Offline
Send Email Send Email
 
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]

#21704 From: Eugene Fleming <eugenefleming@...>
Date: Tue Oct 13, 2009 1:14 pm
Subject: Re: DEVELOPER'S TOOL KIT
eugenefleming
Offline Offline
Send Email Send Email
 
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]

#21705 From: "Keith Browning" <kbrowning@...>
Date: Mon Oct 26, 2009 8:06 pm
Subject: Re: DEVELOPER'S TOOL KIT
Keith_Browning
Offline Offline
Send Email Send Email
 
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

#21706 From: "Peter T. Fairchild" <peterfairchild@...>
Date: Mon Oct 26, 2009 8:25 pm
Subject: Re: DEVELOPER'S TOOL KIT
peterlafeuille
Offline Offline
Send Email Send Email
 
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
>
>
>
>
>

#21707 From: irshad khan <irshad_ncs@...>
Date: Tue Oct 27, 2009 12:26 pm
Subject: (No subject)
irshad_ncs
Offline Offline
Send Email Send Email
 
 
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]

#21708 From: "peter_groman" <peter.groman@...>
Date: Tue Oct 27, 2009 2:57 pm
Subject: FULL TIME ENTRY LEVEL WEB/DB APP PROGRAMMER POSITION
peter_groman
Offline Offline
Send Email Send Email
 
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.

#21709 From: "Allen" <amcmilli@...>
Date: Tue Oct 27, 2009 9:41 pm
Subject: Percentile
amcmilli...
Offline Offline
Send Email Send Email
 
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.

#21710 From: "arlette4u_2003" <arlette4u_2003@...>
Date: Sat Oct 31, 2009 5:30 pm
Subject: Search screen in MS Access 2003 - Urgent!!!
arlette4u_2003
Offline Offline
Send Email Send Email
 
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.

#21711 From: "arlette4u_2003" <arlette4u_2003@...>
Date: Sat Oct 31, 2009 5:31 pm
Subject: Blank text boxes on startup in MS Access form - Urgent
arlette4u_2003
Offline Offline
Send Email Send Email
 
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?

#21712 From: "Liveson Tumbulu" <l.tumbulu@...>
Date: Tue Nov 3, 2009 9:48 am
Subject: RE: DEVELOPER'S TOOL KIT
ltumbulu
Offline Offline
Send Email Send Email
 
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]

#21713 From: "rkulez" <rkulez@...>
Date: Tue Nov 10, 2009 2:23 pm
Subject: invisible control
rkulez
Offline Offline
Send Email Send Email
 
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

#21714 From: Tyrone Lumley <tyrone_topheavy@...>
Date: Tue Nov 10, 2009 8:30 pm
Subject: Re: invisible control
tyrone_topheavy
Offline Offline
Send Email Send Email
 
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]

#21715 From: "rkulez" <rkulez@...>
Date: Thu Nov 12, 2009 7:58 am
Subject: Re: invisible control
rkulez
Offline Offline
Send Email Send Email
 
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]
>

#21716 From: "adtmom" <bmann4@...>
Date: Thu Nov 12, 2009 5:34 pm
Subject: Selecting a record by comparing values in a given field
adtmom
Offline Offline
Send Email Send Email
 
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

#21717 From: John Young <youngja@...>
Date: Fri Nov 13, 2009 1:19 am
Subject: Access 2007 report to html
buick27
Offline Offline
Send Email Send Email
 
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

#21718 From: "rkulez" <rkulez@...>
Date: Fri Nov 20, 2009 10:00 am
Subject: workdays
rkulez
Offline Offline
Send Email Send Email
 
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

#21719 From: Jim Wagner <luvmymelody@...>
Date: Fri Nov 20, 2009 1:18 pm
Subject: Re: workdays
luvmymelody
Offline Offline
Send Email Send Email
 
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]

#21720 From: John Gonnello <johnny100g@...>
Date: Sat Nov 21, 2009 12:45 am
Subject: Re: workdays
johnny100g
Offline Offline
Send Email Send Email
 
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]

#21721 From: jefferson ferreira de sousa <jferreira.sousa@...>
Date: Fri Nov 20, 2009 5:20 pm
Subject: Re: workdays
jferreira.sousa
Offline Offline
Send Email Send Email
 
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]

#21722 From: "rkulez" <rkulez@...>
Date: Mon Nov 23, 2009 9:07 am
Subject: Re: workdays
rkulez
Offline Offline
Send Email Send Email
 
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]
>

#21723 From: "Romeo" <jre.phils@...>
Date: Mon Nov 23, 2009 11:15 am
Subject: VBA code for converting figures into words
jre.phils
Offline Offline
Send Email Send Email
 
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

#21724 From: Lonnie Johnson <prodevmg@...>
Date: Mon Nov 23, 2009 12:15 pm
Subject: Re: VBA code for converting figures into words
prodevmg
Offline Offline
Send Email Send Email
 
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]

#21725 From: Roemo Elazegui <jre.phils@...>
Date: Tue Nov 24, 2009 12:33 am
Subject: Re: VBA code for converting figures into words
jre.phils
Offline Offline
Send Email Send Email
 
Lonnie,
 
Thank you so much. Exactly what I need. I owe you a lot.
 
Romeo 




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

#21726 From: "mike" <mikeuhd@...>
Date: Tue Nov 24, 2009 2:18 am
Subject: getting data from multiple list boxes into a table
mikeuhd
Offline Offline
Send Email Send Email
 
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

#21727 From: Jim Wagner <luvmymelody@...>
Date: Tue Nov 24, 2009 8:54 pm
Subject: Re: workdays
luvmymelody
Offline Offline
Send Email Send Email
 
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]

#21728 From: Lonnie Johnson <prodevmg@...>
Date: Wed Nov 25, 2009 2:23 am
Subject: Re: VBA code for converting figures into words
prodevmg
Offline Offline
Send Email Send Email
 
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]

#21729 From: Lonnie Johnson <prodevmg@...>
Date: Wed Nov 25, 2009 2:23 am
Subject: Re: VBA code for converting figures into words
prodevmg
Offline Offline
Send Email Send Email
 
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]

#21730 From: Lonnie Johnson <prodevmg@...>
Date: Wed Nov 25, 2009 2:25 am
Subject: Re: getting data from multiple list boxes into a table
prodevmg
Offline Offline
Send Email Send Email
 
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]

#21731 From: John Young <youngja@...>
Date: Wed Nov 25, 2009 3:53 am
Subject: html from access 2007 report
buick27
Offline Offline
Send Email Send Email
 
Is there an easy way of getting an access report that has graphics to
display as a html page

Joyhn Y

Messages 21702 - 21731 of 21731   Oldest  |  < Older  |  Newer >  |  Newest
Advanced
Add to My Yahoo!      XML What's This?

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help