MS_Access_Professionals : Messages : 1-2400 of 77519

Messages: Show Message Summaries (Group by Topic) Sort by Date

#2400 From: "Ray <rharkness@...>" <rharkness@...>
Date: Mon Dec 16, 2002 3:25 pm
Subject: Re: Number field formatting harra1971
Offline
Send Email

Bruce,

I typically do all my formatting of numerical data in the forms and
reports themselves.  It sounds from your post that you are setting
the format in the table.  I'm not sure if those settings are
inherited by the controls on your forms and reports.  Try setting it
in the textbox control and see if you get the desired results.

Ray


--- In MS_Access_Professionals@yahoogroups.com, "pwconcord2000
<belliott@c...>" <belliott@c...> wrote:
>
> Problem with number field. In table design, I specified the Number
> type for a field, set its format to General Number, its field size
to
> Long Integer and decimal places to 2, with lookup set to Text Box.
On
> testing it in form view, I found that after entering a large number
> and moving focus, the box showed no commas or decimals. When I
> returned to the field and entered another number, the results were
> the same.
>
> I then changed the number format to Fixed and left everything else
> unchanged. On testing it in form view, I found that after entering
a
> large number and moving focus, the box showed decimals but no
commas.
> When I returned to the field and entered another number, the
results
> were the same. Whenever I entered non-zero digits after the decimal
> point, they displayed properly as long as focus was in the box, but
> on moving focus 2 zeroes reappeared after the decimal point. The
> pennies were lost no matter what I did.
>
> Finally I changed the number format to Standard and left everything
> else unchanged. On testing it in form view, I had the same results
as
> with the Fixed format except that commas were displayed.
>
> What I want is for the Number type to give me same results as the
> Currency type but without the dollar sign. I've tested a Currency
> field and it works fine. It shows commas and decimals, accepts and
> retains digits after the decimal point.
>
> I am using Access 2002 under Windows 2000 but the database is in
> Access 2000 format.
>
> I hope you can help. Thank you very much. I am new to Access, a
> retread from years with dBase.
>
> Bruce

Reply | Forward | Messages in this Topic (3)

#2399 From: "pwconcord2000 <belliott@...>" <belliott@...>
Date: Mon Dec 16, 2002 3:01 pm
Subject: Number field formatting pwconcord2000
Offline
Send Email

Problem with number field. In table design, I specified the Number
type for a field, set its format to General Number, its field size to
Long Integer and decimal places to 2, with lookup set to Text Box. On
testing it in form view, I found that after entering a large number
and moving focus, the box showed no commas or decimals. When I
returned to the field and entered another number, the results were
the same.

I then changed the number format to Fixed and left everything else
unchanged. On testing it in form view, I found that after entering a
large number and moving focus, the box showed decimals but no commas.
When I returned to the field and entered another number, the results
were the same. Whenever I entered non-zero digits after the decimal
point, they displayed properly as long as focus was in the box, but
on moving focus 2 zeroes reappeared after the decimal point. The
pennies were lost no matter what I did.

Finally I changed the number format to Standard and left everything
else unchanged. On testing it in form view, I had the same results as
with the Fixed format except that commas were displayed.

What I want is for the Number type to give me same results as the
Currency type but without the dollar sign. I've tested a Currency
field and it works fine. It shows commas and decimals, accepts and
retains digits after the decimal point.

I am using Access 2002 under Windows 2000 but the database is in
Access 2000 format.

I hope you can help. Thank you very much. I am new to Access, a
retread from years with dBase.

Bruce

Reply | Forward | Messages in this Topic (3)

#2398 From: "Richard Killey \(Access Developer\)" <msaccess@...>
Date: Mon Dec 16, 2002 2:13 pm
Subject: RE: Unbound forms manxman741
Offline
Send Email

Doug:

No ADO samples. I have stuck with DAO in all my work, and my site is based on actual work done for clients, thus it is all DAO. It should not be very hard to convert to ADO. The concept stays the same.

---------------------
Richard "ManxMan" Killey
MS Access Developer
mailto:msaccess@...
http://www.comeandread.com/access

-----Original Message-----
From: Doug Taylor [mailto:taylords@...]
Sent: December 16, 2002 1:02 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_Access_Professionals] Unbound forms

Richard,

Thank you, I went to your site (still there.) Do you have any examples in ADO?

With our Lords blessings take care,

Doug

-----Original Message-----
From: Richard Killey (Access Developer) [mailto:msaccess@...]
Sent: Sunday, December 15, 2002 6:05 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_Access_Professionals] Unbound forms

Doug: There are various sources on the web, including a series that I have written. See www.comeandread.com/access/tip030.htm --------------------- Richard "ManxMan" Killey MS Access Developer mailto:msaccess@... http://www.comeandread.com/access

Reply | Forward | Messages in this Topic (21)

#2397 From: "imran_sharief30 <imran_sharief30@...>" <imran_sharief30@...>
Date: Mon Dec 16, 2002 11:32 am
Subject: Auto Number imran_sharief30
Offline
Send Email

Hi,

i have created a purchase where i have OrderID as Autonumber and POID
as numbers.  Database does not allow me to have to Autonumber fields
in one table.

How can code POID to generate auto numbers Can anyone help me in this
regard.

Thanks

Shariff

Reply | Forward | Messages in this Topic (11)

#2396 From: Alain Bourdiaudhy <alain.bourdiaudhy@...>
Date: Mon Dec 16, 2002 8:46 am
Subject: listing all the relationships in a database thealien001
Offline
Send Email

Hi all,

I'm pretty new to programming with access... so i hope this is not a very
silly question :)

Is there some table i can query to get a list of all the relationships in a
database ?

Any suggestion is welcome,
Thanks
Alain.
   _____

Alain Bourdiaudhy

* Tel: 03/205.10.35
* Fax: 03/233.86.29
* e-mail: alain.bourdiaudhy@...
<mailto:alain.bourdiaudhy@...>

(Distriplan NV)

"They say time is the fire in which we burn..." -Soran (Star Trek:
Generations).




<FONT SIZE=1 FACE="ARIAL">
********************************************************************
De informatie verzonden via deze e-mail is enkel bestemd voor de geadresseerde.
Ieder gebruik van deze informatie door een ander persoon dan de geadresseerde,
is verboden.
Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze
informatie aan derden is verboden.
IPFP N.V. / Distriplan N.V. garandeert noch de juiste en volledige overbrenging
van de verzonden e-mail, noch de tijdige ontvangst ervan.
IPFP N.V. / Distriplan N.V. heeft het recht om deze professionele e-mail van de
werknemer in te zien.

The information contained in this e-mail is intended solely for the addressee.
Any use of this information by another person is forbidden.
Disclosing, copying, distributing or providing this information to third parties
is forbidden.
IPFP N.V. / Distriplan N.V. does not guarantee either the correct and complete
transmission of an e-mail sent, nor the timely receipt thereof.
IPFP N.V. / Distriplan N.V. has the right to read this professional e-mail of
its employees.
********************************************************************
</FONT>

Hi all,

I'm pretty new to programming with access... so i hope this is not a very silly question :)

Is there some table i can query to get a list of all the relationships in a database ?

Any suggestion is welcome,

Thanks

Alain.

Alain Bourdiaudhy

Tel: 03/205.10.35
Fax: 03/233.86.29
e-mail: alain.bourdiaudhy@...

(Distriplan NV)

“They say time is the fire in which we burn…” -Soran (Star Trek: Generations).







********************************************************************

De informatie verzonden via deze e-mail is enkel bestemd voor de geadresseerde.

Ieder gebruik van deze informatie door een ander persoon dan de geadresseerde, is verboden.

Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is verboden.

IPFP N.V. / Distriplan N.V. garandeert noch de juiste en volledige overbrenging van de verzonden e-mail, noch de tijdige ontvangst ervan.

IPFP N.V. / Distriplan N.V. heeft het recht om deze professionele e-mail van de werknemer in te zien.



The information contained in this e-mail is intended solely for the addressee.

Any use of this information by another person is forbidden.

Disclosing, copying, distributing or providing this information to third parties is forbidden.

IPFP N.V. / Distriplan N.V. does not guarantee either the correct and complete transmission of an e-mail sent, nor the timely receipt thereof.

IPFP N.V. / Distriplan N.V. has the right to read this professional e-mail of its employees.

********************************************************************

Reply | Forward | Messages in this Topic (4)

#2395 From: "Doug Taylor" <taylords@...>
Date: Mon Dec 16, 2002 6:01 am
Subject: RE: Unbound forms thisstinks_alot
Offline
Send Email

Richard,

Thank you, I went to your site (still there.) Do you have any examples in ADO?

With our Lords blessings take care,

Doug

-----Original Message-----
From: Richard Killey (Access Developer) [mailto:msaccess@...]
Sent: Sunday, December 15, 2002 6:05 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_Access_Professionals] Unbound forms

Doug: There are various sources on the web, including a series that I have written. See www.comeandread.com/access/tip030.htm --------------------- Richard "ManxMan" Killey MS Access Developer mailto:msaccess@... http://www.comeandread.com/access >> -----Original Message----- >> From: Doug Taylor [mailto:taylords@...] >> Sent: December 15, 2002 7:16 PM >> To: MSAccessPro >> Subject: [MS_Access_Professionals] Unbound forms >> >> >> Hello again, >> >> I have a question about unbound forms. How do >> I use them for data entry? >> Do I load an array? Can I INSERT the data >> directly with the field data? >> >> Your help is greatly appreciated. >> >> With our Lords blessings, >> >> Doug

To unsubscribe from this group, send an email to: MS_Access_Professionals-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Reply | Forward | Messages in this Topic (21)

#2394 From: "Chris Mackin" <chris@...>
Date: Mon Dec 16, 2002 5:57 am
Subject: RE: Unbound forms denverdataba...
Offline
Send Email

It's pretty straightforward, open a recordset with ADO, add a new record
unless the user is editing an existing record, then assign the values of the
fields = values of the textboxes.  You can then update the recordset (ADO
recordsets, unlike DAO recordsets will update automatically unless the
update is cancelled, but it's a good idea to explicitly save the updates I
think).

That's pretty much it, if you need help with ADO recordsets there's plenty
in the Help files.

Chris Mackin
chris@...
Denver Database Consulting, LLC



-----Original Message-----
From: Doug Taylor [mailto:taylords@...]
Sent: Sunday, December 15, 2002 10:54 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_Access_Professionals] Unbound forms


Thank you Andrew, now I need to figure out the code behind the button.  You
wouldn't have any tips on how to do this with ADO would you?

With our Lords blessings take care,

Doug
-----Original Message-----
From: Haslett, Andrew [mailto:andrew.haslett@...]
Sent: Sunday, December 15, 2002 4:15 PM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: RE: [MS_Access_Professionals] Unbound forms


You need some method of initiating the insert - usually an 'Update' or
'Save' button.

Attached to that button will be the code required to validate entries and
actually create the new records.

Remember that nothing that the user has entered on the form is saved until
you run this code.

Cheers,
Andrew
-----Original Message-----
From: Doug Taylor [mailto:taylords@...]
Sent: Monday, 16 December 2002 10:46 AM
To: MSAccessPro
Subject: [MS_Access_Professionals] Unbound forms


Hello again,

I have a question about unbound forms.  How do I use them for data entry?
Do I load an array?  Can I INSERT the data directly with the field data?

Your help is greatly appreciated.

With our Lords blessings,

Doug


To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


IMPORTANT - PLEASE READ ********************
This email and any files transmitted with it are confidential and may
contain information protected by law from disclosure.
If you have received this message in error, please notify the sender
immediately and delete this email from your system.
No warranty is given that this email or files, if attached to this
email, are free from computer viruses or other defects. They
are provided on the basis the user assumes all responsibility for
loss, damage or consequence resulting directly or indirectly from
their use, whether caused by the negligence of the sender or not.

To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Reply | Forward | Messages in this Topic (21)

#2393 From: "Doug Taylor" <taylords@...>
Date: Mon Dec 16, 2002 5:53 am
Subject: RE: Unbound forms thisstinks_alot
Offline
Send Email

Thank you Andrew, now I need to figure out the code behind the button. You wouldn't have any tips on how to do this with ADO would you?

With our Lords blessings take care,

Doug

-----Original Message-----
From: Haslett, Andrew [mailto:andrew.haslett@...]
Sent: Sunday, December 15, 2002 4:15 PM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: RE: [MS_Access_Professionals] Unbound forms

You need some method of initiating the insert - usually an 'Update' or 'Save' button.

Attached to that button will be the code required to validate entries and actually create the new records.

Remember that nothing that the user has entered on the form is saved until you run this code.

Cheers,
Andrew

-----Original Message-----
From: Doug Taylor [mailto:taylords@...]
Sent: Monday, 16 December 2002 10:46 AM
To: MSAccessPro
Subject: [MS_Access_Professionals] Unbound forms

Hello again, I have a question about unbound forms. How do I use them for data entry? Do I load an array? Can I INSERT the data directly with the field data? Your help is greatly appreciated. With our Lords blessings, Doug
To unsubscribe from this group, send an email to: MS_Access_Professionals-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

To unsubscribe from this group, send an email to: MS_Access_Professionals-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

IMPORTANT - PLEASE READ ********************

This email and any files transmitted with it are confidential and may

contain information protected by law from disclosure.

If you have received this message in error, please notify the sender

immediately and delete this email from your system.

No warranty is given that this email or files, if attached to this

email, are free from computer viruses or other defects. They

are provided on the basis the user assumes all responsibility for

loss, damage or consequence resulting directly or indirectly from

their use, whether caused by the negligence of the sender or not.

Reply | Forward | Messages in this Topic (21)

#2392 From: "shs_as <shs_as@...>" <shs_as@...>
Date: Mon Dec 16, 2002 5:32 am
Subject: thanks a lot - another question shs_as
Offline
Send Email

Hi,
I am thankful and I have another question . I must place database
in local area ( intranet ) and my colleagues want to use and date
enty through the form of access in database . Can I do this ? could u
plz help me how I can ? sorry I am new to access ,I thank u once
again .
  Best regards
   sho

Reply | Forward | Messages in this Topic (1)

#2391 From: "Richard Killey \(Access Developer\)" <msaccess@...>
Date: Mon Dec 16, 2002 2:04 am
Subject: RE: Unbound forms manxman741
Offline
Send Email

Doug:

There are various sources on the web,  including a series
that I have written.  See
www.comeandread.com/access/tip030.htm


---------------------
Richard "ManxMan" Killey
MS Access Developer
mailto:msaccess@...
http://www.comeandread.com/access



>>  -----Original Message-----
>>  From: Doug Taylor [mailto:taylords@...]
>>  Sent: December 15, 2002 7:16 PM
>>  To: MSAccessPro
>>  Subject: [MS_Access_Professionals] Unbound forms
>>
>>
>>  Hello again,
>>
>>  I have a question about unbound forms.  How do
>>  I use them for data entry?
>>  Do I load an array?  Can I INSERT the data
>>  directly with the field data?
>>
>>  Your help is greatly appreciated.
>>
>>  With our Lords blessings,
>>
>>  Doug

Reply | Forward | Messages in this Topic (21)

#2390 From: "Bill Mosca" <wrmosca@...>
Date: Sun Dec 15, 2002 11:57 pm
Subject: RE: Graphical Data wrmosca
Offline
Send Email

Looks like a job for a cross-tab query. I don't know how you are determining if the room is booked or not so you'll have to edit this code, but maybe using a refresh button to requery, you could use the form's AfterUpdate event to loop through the controls and change the color (or in your case colour) to whatever you wanted.

Private Sub Form_AfterUpdate()

Dim ctrl As Control

For Each ctrl In Me.Detail

If ctrl.ControlType = acTextBox Then

'If the box is booked make it red.

If ctrl=true <> 0 Then

ctrl.BackColor = vbRed

Else: ctrl.BackColor = vbGreen

End If

End Sub

Bill

-----Original Message-----
From: paulworkhotel <PAULSMITHHOME@...> [mailto:PAULSMITHHOME@...]
Sent: Sunday, December 15, 2002 2:29 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_Access_Professionals] Graphical Data

I have two fields in a table all i want to do is display a graphical
preview of the data on a form ie a list of dates across the top and
list of rooms down the side, and if a room is booked on a date in the
table a red box or something similar would appear next to the room
thats booked in the table else a green box to show date in question
is free.

eg
1 2 3 4 5 6 7 (Dates)
Room 1 (red box)
Room 2
Room 3
Room 4

My present line of thinking is some how use an excel work sheet and
place on form. or would i just link to excel and if so how would
excel pick up and make sense of the data.

I know what i would like to achieve but not sure the best way to
achieve it or access or excel capable of doing it.

Any thoughts or pointers would be appreciated

Best Regards

Paul

To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Reply | Forward | Messages in this Topic (2)

#2389 From: "Haslett, Andrew" <andrew.haslett@...>
Date: Mon Dec 16, 2002 12:15 am
Subject: RE: Unbound forms ahaslettilc
Offline
Send Email

You need some method of initiating the insert - usually an 'Update' or 'Save' button.

Attached to that button will be the code required to validate entries and actually create the new records.

Remember that nothing that the user has entered on the form is saved until you run this code.

Cheers,
Andrew

-----Original Message-----
From: Doug Taylor [mailto:taylords@...]
Sent: Monday, 16 December 2002 10:46 AM
To: MSAccessPro
Subject: [MS_Access_Professionals] Unbound forms

Hello again, I have a question about unbound forms. How do I use them for data entry? Do I load an array? Can I INSERT the data directly with the field data? Your help is greatly appreciated. With our Lords blessings, Doug
To unsubscribe from this group, send an email to: MS_Access_Professionals-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

IMPORTANT - PLEASE READ ********************

This email and any files transmitted with it are confidential and may

contain information protected by law from disclosure.

If you have received this message in error, please notify the sender

immediately and delete this email from your system.

No warranty is given that this email or files, if attached to this

email, are free from computer viruses or other defects. They

are provided on the basis the user assumes all responsibility for

loss, damage or consequence resulting directly or indirectly from

their use, whether caused by the negligence of the sender or not.

Reply | Forward | Messages in this Topic (21)

#2388 From: "Doug Taylor" <taylords@...>
Date: Mon Dec 16, 2002 12:15 am
Subject: Unbound forms thisstinks_alot
Offline
Send Email

Hello again,

I have a question about unbound forms.  How do I use them for data entry?
Do I load an array?  Can I INSERT the data directly with the field data?

Your help is greatly appreciated.

With our Lords blessings,

Doug

Reply | Forward | Messages in this Topic (21)

#2387 From: "paulworkhotel <PAULSMITHHOME@...>" <PAULSMITHHOME@...>
Date: Sun Dec 15, 2002 10:29 pm
Subject: Graphical Data paulworkhotel
Offline
Send Email

I have two fields in a table all i want to do is display a graphical
preview of the data on a form ie a list of dates across the top and
list of rooms down the side, and if a room is booked on a date in the
table a red box or something similar would appear next to the room
thats booked in the table else a green box to show date in question
is free.

eg
        1   2    3   4    5    6    7 (Dates)
Room 1         (red box)
Room 2
Room 3
Room 4

My present line of thinking is some how use an excel work sheet and
place on form. or would i just link to excel and if so how would
excel pick up and make sense of the data.

I know what i would like to achieve but not sure the best way to
achieve it or access or excel capable of doing it.

Any thoughts or pointers would be appreciated

Best Regards



Paul

Reply | Forward | Messages in this Topic (2)

#2386 From: "Bill Mosca" <wrmosca@...>
Date: Sun Dec 15, 2002 5:03 pm
Subject: RE: Hi all , I'm new question plz wrmosca
Offline
Send Email

Welcome to our group, shs_as.

There are lots of ways to do this, but the simplest way is to make the table the Record Source of the form. Open the form in design view and then open the properties box. You'll see the first line is Record Source. Click on the line and then click on the drop down arrow. It will give you a list of all the tables in the database. Select your table.

Then each textbox can have a field in the table as it's Control Source. Select it the same way you selected the table.

By entering data in the textboxes, it will automatically be entered in the table when you close the form or move to another record by using the record navigators (those arrows at the bottom of the form |< < > >| >*)

Bill

-----Original Message-----
From: shs_as <shs_as@...> [mailto:shs_as@...]
Sent: Sunday, December 15, 2002 3:57 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_Access_Professionals] Hi all , I'm new question plz

Hi everyone ,
I'm new to access and this group aswell and I created a database and
a form too and this form has several box and I related them to
database but i want to add a record to this data base through the
form . How can I do it ?
thank u very much for your help

To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Reply | Forward | Messages in this Topic (2)

#2385 From: "Bill Mosca" <wrmosca@...>
Date: Sun Dec 15, 2002 4:54 pm
Subject: RE: Web Designer in need of assistance wrmosca
Offline
Send Email

Welcome to our group Eric.

To answer your question...yes, you can use Access with a web page front end. Your forms would be ASP pages. I've done this a few times with no problems.

Regards,

Bill Mosca

Founder

-----Original Message-----
From: Eric Honeycutt <icplanetaries@...> [mailto:icplanetaries@...]
Sent: Saturday, December 14, 2002 9:55 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_Access_Professionals] Web Designer in need of assistance

Hello. I am an intermediate-level web designer who is possibly going
to design a site that involves database content. I have no
experience with this and I am really needing some help.
Question, client wants:

Database for daycare substitute project.
1. Create an interactive full year calendar for 25 substitutes that
is web enabled for substitute and provider input w/usernames &
password access.
2. Ability to make reservations for substitutes for fiscal year on-
line.
3.Auto-response to sub. notifying reservation has been made.
4.Possible form "pop-up" or "scroll down" for completion to make
reservation.
5.Searchable by criteria. i.e. dates desired – ed. levels of sub.,
classroom experience.

Is this possible with Acess (XP in my case). Obviously they would
have to have Access installed on the ISP's server but I do not know
if Access capable of what I described. Any thoughts on how I might
go about this if this is doable.

Most sincerely appreciated,

Michael

To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Reply | Forward | Messages in this Topic (2)

#2384 From: "shs_as <shs_as@...>" <shs_as@...>
Date: Sun Dec 15, 2002 11:56 am
Subject: Hi all , I'm new question plz shs_as
Offline
Send Email

Hi everyone ,
I'm new to access and this group aswell and I created a database and
a form too and this form has several box and I related them to
database but i want to add a record to this data base through the
form . How can I do it ?
thank u very much for your help

Reply | Forward | Messages in this Topic (2)

#2383 From: "Eric Honeycutt <icplanetaries@...>" <icplanetaries@...>
Date: Sun Dec 15, 2002 5:55 am
Subject: Web Designer in need of assistance icplanetaries
Offline
Send Email

Hello. I am an intermediate-level web designer who is possibly going
to design a site that involves database content. I have no
experience with this and I am really needing some help.
Question, client wants:

Database for daycare substitute project.
1. Create an interactive full year calendar for 25 substitutes that
is web enabled for substitute and provider input w/usernames &
password access.
2. Ability to make reservations for substitutes for fiscal year on-
line.
3.Auto-response to sub. notifying reservation has been made.
4.Possible form "pop-up" or "scroll down" for completion to make
reservation.
5.Searchable by criteria. i.e.  dates desired � ed. levels of sub.,
classroom experience.

Is this possible with Acess (XP in my case). Obviously they would
have to have Access installed on the ISP's server but I do not know
if Access capable of what I described. Any thoughts on how I might
go about this if this is doable.

Most sincerely appreciated,

Michael

Reply | Forward | Messages in this Topic (2)

#2382 From: "Bill Mosca" <wrmosca@...>
Date: Sat Dec 14, 2002 5:41 pm
Subject: RE: Calculation of Overtime!!!! wrmosca
Offline
Send Email

If you are basing the calculation on one employee at a time, you could use a DLookup() on the employee table to find what department he/she is in. Then use a Select Case statement to determine the rate.

Let's say Office is Dept 1. The ones with 10 hrs are depts. 2, 3 and 4. Security is Dept 5

Dept = DLookup("Dept", "Employees", "EmpID = " & YourEmployeeIDGoesHere

Select Case Dept

Case 1

Rate = (([BasicSalary]/30)/8)*90/60

Case 2,3,4

Rate = (([BasicSalary]/30)/10)*90/60

Case 5

Rate = (([BasicSalary]/30)/12)*90/60

End Select

Bill

-----Original Message-----
From: imran_sharief30 <imran_sharief30@...> [mailto:imran_sharief30@...]
Sent: Saturday, December 14, 2002 7:18 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_Access_Professionals] Calculation of Overtime!!!!

Hi,

Can any one help me for calculation the overtime.

I have calculated rate that is

Rate = (([BasicSalary]/30)/8)*90/60

But i have Problem i have different department and the timing who
generate different Overtime rate. Like Office it is 8 hrs, Some
department have 10 hrs, and at last Security department have 12 hrs
of duty time.

Can anyone help me to solve the this problem.

All the suggestion of the above shall be highly appreciated.

Thanks.

To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Reply | Forward | Messages in this Topic (2)

#2381 From: "imran_sharief30 <imran_sharief30@...>" <imran_sharief30@...>
Date: Sat Dec 14, 2002 3:18 pm
Subject: Calculation of Overtime!!!! imran_sharief30
Offline
Send Email

Hi,

Can any one help me for calculation the overtime.

I have calculated rate that is

Rate = (([BasicSalary]/30)/8)*90/60

But i have Problem i have different department and the timing who
generate different Overtime rate.  Like Office it is 8 hrs, Some
department have 10 hrs, and at last Security department have 12 hrs
of duty time.

Can anyone help me to solve the this problem.

All the suggestion of the above shall be highly appreciated.

Thanks.

Reply | Forward | Messages in this Topic (2)

#2380 From: "Bill Mosca" <wrmosca@...>
Date: Sat Dec 14, 2002 3:33 am
Subject: RE: updating a database wrmosca
Offline
Send Email

This is the reason why you never store the data in the front end. There is no easy way to make changes without risking the loss of data.

Instead of trying to distribute the entire db maybe you can just export the objects that have been changed.

Regards,

Bill Mosca

Founder

-----Original Message-----
From: johnnydora2000 <johnnydora2000@...> [mailto:johnnydora2000@...]
Sent: Friday, December 13, 2002 6:58 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_Access_Professionals] updating a database

I've distributed a database application to different division last
year. I have made changes to the database and would like to
distribute the updated version without loosing the data they have
already entered.

How do I sent the revised database?

To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Reply | Forward | Messages in this Topic (2)

#2379 From: "johnnydora2000 <johnnydora2000@...>" <johnnydora2000@...>
Date: Sat Dec 14, 2002 2:58 am
Subject: updating a database johnnydora2000
Offline
Send Email

I've distributed a database application to different division last
year. I have made changes to the database and would like to
distribute the updated version without loosing the data they have
already entered.

How do I sent the revised database?

Reply | Forward | Messages in this Topic (2)

#2378 From: "psam231 <pankajpatel01@...>" <pankajpatel01@...>
Date: Fri Dec 13, 2002 7:03 pm
Subject: Exporting to Excel psam231
Offline
Send Email

I have an access 97 db, that generates reports, some of which are
about 1000 lines.

Most users are well versed with the use of Excel, its tabs, and its
filters etc.

So I have created my reports as tables in Access and I have been able
to use the "Transferspreadsheet function to create the multiple tabs.

My problem is that I'd like to put some explanatory text at the
bottom of each output sheet.  Is there a way get this done?

I tried using Named Cells, and then linking them that overwrites the
explanatory text.

Reply | Forward | Messages in this Topic (9)

#2377 From: "Ahmad Hassouna" <is2000@...>
Date: Fri Dec 13, 2002 4:25 pm
Subject: Calculate the Total QTY in two tables is2000@...
Send Email

Hi all,

I have create to tables as U will see it in the attached MS Access file with this email...Frist tabel for items, price & QTY...I need in Form "Additem" to calculate all "Quantity in Table items....

Any help apprecite that...

Ahmad

Reply | Forward | Messages in this Topic (1)

#2376 From: Alain Bourdiaudhy <alain.bourdiaudhy@...>
Date: Fri Dec 13, 2002 3:52 pm
Subject: Help with Access "drop constraint" needed thealien001
Offline
Send Email

Hi all,

How can i delete a constraint from an access .mdb file ?
The problem is that i don't know the name to give the relationship, because
i added it using the Relationshipsdialog in MSAccess.

Now i need to remove it, using code.

I found this statement ...
ALTER TABLE <tablename> DROP CONSTRAINT <nameOfConstraint>;
... but i can't figure out what to put in for nameOfConstraint.

Any tips would be greatly appreciated !


Alain Bourdiaudhy
e-mail: alain.bourdiaudhy@...
(Distriplan NV)
"They say time is the fire in which we burn..." -Soran (Star Trek:
Generations).


<FONT SIZE=1 FACE="ARIAL">
********************************************************************
De informatie verzonden via deze e-mail is enkel bestemd voor de geadresseerde.
Ieder gebruik van deze informatie door een ander persoon dan de geadresseerde,
is verboden.
Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze
informatie aan derden is verboden.
IPFP N.V. / Distriplan N.V. garandeert noch de juiste en volledige overbrenging
van de verzonden e-mail, noch de tijdige ontvangst ervan.
IPFP N.V. / Distriplan N.V. heeft het recht om deze professionele e-mail van de
werknemer in te zien.

The information contained in this e-mail is intended solely for the addressee.
Any use of this information by another person is forbidden.
Disclosing, copying, distributing or providing this information to third parties
is forbidden.
IPFP N.V. / Distriplan N.V. does not guarantee either the correct and complete
transmission of an e-mail sent, nor the timely receipt thereof.
IPFP N.V. / Distriplan N.V. has the right to read this professional e-mail of
its employees.
********************************************************************
</FONT>

Reply | Forward | Messages in this Topic (1)

#2375 From: "Bill Mosca" <wrmosca@...>
Date: Fri Dec 13, 2002 1:57 am
Subject: RE: Re: Secured database - help! wrmosca
Offline
Send Email

You can also join the workgroup by using the WRKGADM.EXE. You'll find this utility for Access 2000 in Microsoft Office\Office\1033.

If you have Access 97, it should be in your Start/Programs menu

Bill

-----Original Message-----
From: Ray <rharkness@...> [mailto:rharkness@...]
Sent: Thursday, December 12, 2002 7:57 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_Access_Professionals] Re: Secured database - help!

Annie,

This might be a shot in the dark because I don't know your level of
proficiency with Access-level security. But if, in the process in
instituting Access-Level Security, you created your own .mdw
(workgroup) file to hold the security information, then you can no
longer open the database the ways you were used to (double-clicking
or file->open). You have to create a shortcut to do it for you. The
shortcut needs to have this structure:

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "[Location
of .mdb File" /wrkgrp "[Location of .mdw file]"

Here is an example:
"C:\Program Files\Microsoft
Office\Office\MSACCESS.EXE" "c:\test.mdb" /wrkgrp "c:\Security.mdw"

This string is in the Target portion of the Shortcut.

If you knew this already and are doing this and getting your problem
then disregard this post. But if you aren't doing this, then try it
before you give Bill Duke's suggestion a shot.

Ray

--- In MS_Access_Professionals@yahoogroups.com, "Dukes, Bill"
<bdukes@k...> wrote:
> I had this happen once with a database secured by someone who had
left
> my company. As a last resort after contacting him and pulling a
clean
> copy of his workgroup file that wasn't corrupted, I imported all of
the
> objects from the secured database into a new blank database
structure
> that used the default workgroup. Afterwards I reassigned
permissions
> for every object in the new database and secured it again. It
worked
> since the developer had left open the ability to import and export
> objects.
>
> It's best from my standpoint to use the user level security wizard
and
> make sure you print out the report the wizard provides in case this
> happens in the future.
>
> Good luck!
>
> -----Original Message-----
> From: Bill Mosca [mailto:wrmosca@a...]
> Sent: Wednesday, December 11, 2002 8:15 PM
> To: MS Access Professionals@yahoogroups.com
> Subject: RE: [MS Access Professionals] Secured database - help!
>
>
>       Did you leave Admin in the Admins group and do you have the
> password for Admin? If so, then log in as Admin and put yourself in
the
> Admins group. That should give you all the permissions.
>
>       If not, is there anyone else in the Admins group who can log
in
> and reset your permissions?
>
>       Regards,
>       Bill Mosca
>       Founder
>
>       -----Original Message-----
>       From: Annie Johnson [mailto:eastsacbrewers@y...]
>       Sent: Wednesday, December 11, 2002 4:46 PM
>       To: MS Access Professionals@yahoogroups.com
>       Subject: [MS Access Professionals] Secured database - help!
>
>       Help! I secured my databse and when I tried to re-open it it
> said I didn't have the correct premissions. What do I do?
>       Help - and thanks!
>
>
>
>
>
>       Do you Yahoo!?
>       Yahoo! Mail Plus
> <http://rd.yahoo.com/mail/mailsig/*http://mailplus.yahoo.com> -
> Powerful. Affordable. Sign up now
> <http://rd.yahoo.com/mail/mailsig/*http://mailplus.yahoo.com>
>       To unsubscribe from this group, send an email to:
>       MS Access Professionals-unsubscribe@yahoogroups.com
>
>
>
>       Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/> .
>
>
>       To unsubscribe from this group, send an email to:
>       MS Access Professionals-unsubscribe@yahoogroups.com
>
>
>
>       Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/> .
>
>
>
>
>                     Confidentiality Notice
> This message is being sent by or on behalf of a lawyer. It is
intended exclusively for the individual or entity to which it is
addressed. This communication may contain information that is
proprietary, privileged or confidential or otherwise legally exempt
from disclosure. If you are not the named addressee, you are not
authorized to read, print, retain, copy or disseminate this message
or any part of it. If you have received this message in error,
please notify the sender immediately by e-mail and delete all copies
of the message.

To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Reply | Forward | Messages in this Topic (6)

#2374 From: "Bill Mosca" <wrmosca@...>
Date: Fri Dec 13, 2002 1:48 am
Subject: RE: Secured database - help! wrmosca
Offline
Send Email

There is software available for cracking Access user passwords. This site might have what you need.

http://www.LostPassword.com

Before you use the security wizard again, I strongly suggest you print out and use the article at

http://support.microsoft.com/support/kb/articles/Q165/0/09.asp

The article will take you step by step through securing the database. Getting locked out of your own db is painful.

Oh, and always make a backup of the db with the unsecured default workgroup...just in case.

Bill

-----Original Message-----
From: Annie Johnson [mailto:eastsacbrewers@...]
Sent: Thursday, December 12, 2002 9:45 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_Access_Professionals] Secured database - help!

You're absolutley right about the log on and cryptic password. It is 20 alpha-numeric chartacters long.

"Dukes, Bill" <bdukes@...> wrote:

The last section of the report has a listing called Users: Usually the last user is:

Name : Admin and Access assigns a cryptic password to this user automatically if you do not specify one on your own when you secure the database.

For example it might read:

User: Admin

Password: eboqq0TFUavt

That's your password to log on as the user Admin for that database.

-----Original Message-----
From: Annie Johnson [mailto:eastsacbrewers@...]
Sent: Thursday, December 12, 2002 11:42 AM
To: MS Access Professionals@yahoogroups.com
Subject: RE: [MS Access Professionals] Secured database - help!

I do have the prinited report - just not sure how to use it.

"Dukes, Bill" <bdukes@...> wrote:

I had this happen once with a database secured by someone who had left my company. As a last resort after contacting him and pulling a clean copy of his workgroup file that wasn't corrupted, I imported all of the objects from the secured database into a new blank database structure that used the default workgroup. Afterwards I reassigned permissions for every object in the new database and secured it again. It worked since the developer had left open the ability to import and export objects.

It's best from my standpoint to use the user level security wizard and make sure you print out the report the wizard provides in case this happens in the future.

Good luck!

-----Original Message-----
From: Bill Mosca [mailto:wrmosca@...]
Sent: Wednesday, December 11, 2002 8:15 PM
To: MS Access Professionals@yahoogroups.com
Subject: RE: [MS Access Professionals] Secured database - help!

Did you leave Admin in the Admins group and do you have the password for Admin? If so, then log in as Admin and put yourself in the Admins group. That should give you all the permissions.

If not, is there anyone else in the Admins group who can log in and reset your permissions?

Regards,

Bill Mosca

Founder

-----Original Message-----
From: Annie Johnson [mailto:eastsacbrewers@...]
Sent: Wednesday, December 11, 2002 4:46 PM
To: MS Access Professionals@yahoogroups.com
Subject: [MS Access Professionals] Secured database - help!

Help! I secured my databse and when I tried to re-open it it said I didn't have the correct premissions. What do I do?

Help - and thanks!

Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
To unsubscribe from this group, send an email to:
MS Access Professionals-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

To unsubscribe from this group, send an email to:
MS Access Professionals-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Confidentiality Notice
This message is being sent by or on behalf of a lawyer. It is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message.

To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Reply | Forward | Messages in this Topic (6)

#2373 From: "Bill Mosca" <wrmosca@...>
Date: Fri Dec 13, 2002 1:51 am
Subject: RE: Exporting to Excel wrmosca
Offline
Send Email

By any chance is the datatype being converted by Excel? If it should be text and Excel is reading it as numeric that might be causing the problem.

Bill

-----Original Message-----
From: angelicmanor <amanor@...> [mailto:amanor@...]
Sent: Thursday, December 12, 2002 1:22 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_Access_Professionals] Exporting to Excel

Good afternoon! I hope someone can help me with this because I am
fixing to pull my hair out.

Here's the scenario: 16 caseworkers enter data directly into an
Access database on a laptop computer. They then export the files out
to Excel and transmit those files to a central location via email.
The central location then pulls all of the individual files into one
large file. After that, the central location exports the
new "complete" file back out to Excel and emails to me.

Here's the problem: When the caseworkers export out to Excel the data
is being changed. For example, if code 999 is entered in the
database, it comes out as 368 on the Excel worksheet. If code 888 is
entered, it comes out as 367 on the worksheet. But, (there always
has to be a but doesn't there?) once you put the files back into
Access, the codes show up as they were originally entered. Okay, so
now I have to bring the data into a statistical package called SPSS.
Only, SPSS won't bring Access directly in so I have to export to
Excel. But, if it is bringing in the wrong stuff, then my data is
corrupted.
Has anyone ever experienced something like this? Any ideas? Thanks
in advance.
Angelic Manor

To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Reply | Forward | Messages in this Topic (9)

#2372 From: "Bill Mosca" <wrmosca@...>
Date: Fri Dec 13, 2002 1:30 am
Subject: RE: RE: [Access VBA Central] Upgrading from Access 97 to Access 2000 wrmosca
Offline
Send Email

Just a little comment... "Private db as database" would be better written "Dim db as DAO.Database" even in Access 97. It makes for a smoother upgrade when the time comes.

Bill

-----Original Message-----
From: Chris Mackin [mailto:chris@...]
Sent: Thursday, December 12, 2002 3:41 PM
To: accessvbacentral@yahoogroups.com; MS_Access_Professionals@yahoogroups.com
Cc: ms_access@yahoogroups.com
Subject: [MS_Access_Professionals] RE: [Access VBA Central] Upgrading from Access 97 to Access 2000

Private is indeed supported by Access 2000, the problem is most likely that
you no longer have a reference to DAO in your Access 2000 database, ADO is
the default object library. You can either modify your code to make it ADO
compatible or add in the reference to DAO under Tools -> Refernces in the
VBE Window.

Chris Mackin
chris@...
Denver Database Consulting, LLC

-----Original Message-----
From: Shah, Chintan [mailto:cshah@...]
Sent: Thursday, December 12, 2002 4:32 PM
To: 'MS_Access_Professionals@yahoogroups.com'
Cc: 'accessvbacentral@yahoogroups.com'; 'ms_access@yahoogroups.com'
Subject: [Access VBA Central] Upgrading from Access 97 to Access 2000

Hello All Smart ppl

I am working on a Project named Emp_Project

It was working fine in Access 97 untill I upgraded my Computer to Access
2000

Now I am getting couple of errors like "No Current Record", "Object is Not
Set" eventhough it is defined.

Is anybody ever had that problem or if somebody knows please help me out
Please

My other friend told me that Access 2000 doesn't support "Private" type...

i.e Private db as database

is that true?? I worked on it but NAH...didn't work

So please if somebody knows please help me out

Thanx in Advance..

Chintan M. Shah

(x3269)

*****************************
This communication may contain information that is proprietary, privileged,
confidential or legally exempt from disclosure. If you are not a named
addressee, you are notified that you are not authorized to read, print,
retain, copy or disseminate this communication without the consent of the
sender and that doing so may be unlawful. If you have received this
communication in error, please notify the sender via return e-mail and
delete it from your computer. Thank you. St. Jude Medical, Inc.
*****************************

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

To unsubscribe from this group, send an email to:
accessvbacentral-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Reply | Forward | Messages in this Topic (2)

#2371 From: "Chris Mackin" <chris@...>
Date: Thu Dec 12, 2002 11:40 pm
Subject: RE: [Access VBA Central] Upgrading from Access 97 to Access 2000 denverdataba...
Offline
Send Email

Private is indeed supported by Access 2000, the problem is most likely that
you no longer have a reference to DAO in your Access 2000 database, ADO is
the default object library.  You can either modify your code to make it ADO
compatible or add in the reference to DAO under Tools -> Refernces in the
VBE Window.

Chris Mackin
chris@...
Denver Database Consulting, LLC


-----Original Message-----
From: Shah, Chintan [mailto:cshah@...]
Sent: Thursday, December 12, 2002 4:32 PM
To: 'MS_Access_Professionals@yahoogroups.com'
Cc: 'accessvbacentral@yahoogroups.com'; 'ms_access@yahoogroups.com'
Subject: [Access VBA Central] Upgrading from Access 97 to Access 2000


Hello All Smart ppl

I am working on a Project named Emp_Project

It was working fine in Access 97 untill I upgraded my Computer to Access
2000

Now I am getting couple of errors like  "No Current Record", "Object is Not
Set"  eventhough it is defined.

Is anybody ever had that problem or if somebody knows please help me out
Please



My other friend told me that Access 2000 doesn't support "Private" type...

i.e Private db as database



is that true?? I worked on it but NAH...didn't work



So please if somebody knows please help me out



Thanx in Advance..





Chintan M. Shah

(x3269)





*****************************
This communication may contain information that is proprietary, privileged,
confidential or legally exempt from disclosure.  If you are not a named
addressee, you are notified that you are not authorized to read, print,
retain, copy or disseminate this communication without the consent of the
sender and that doing so may be unlawful. If you have received this
communication in error, please notify the sender via return e-mail and
delete it from your computer. Thank you. St. Jude Medical, Inc.
*****************************


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



To unsubscribe from this group, send an email to:
accessvbacentral-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

Reply | Forward | Messages in this Topic (2)

Yahoo! Groups Tips

Did you know...

Messages

Yahoo! My Yahoo! Mail
	Sign In New User? Sign Up
		Tech - Groups - Help

Yahoo! Groups Tips

Did you know...

Best of Y! Groups

Messages