Is there a way to publish a dbase to the web through Frontpage or is it a tough
thing to accomplish? I wanted to publish a simple survey that updates an
underlying dbase but have never been able to do it despite having pretty good
luck building dbases.
Dave
-Original Message-
-Original Message-
From: Dave Moreau
Sent: Sunday, June 05, 2005 2:40 PM
To: '[EMAIL PROTECTED]'
Subject: How do you account for various screen resolutions?
Is there a way to take an application that was designed for 800x600 and have it
resolve to a 1024 x768 screen resolution
2000
SQL Queries for Mere Mortals
http://www.viescas.com/
-Original Message-
From: ms_access@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Dave Moreau
Sent: Sunday, June 05, 2005 2:41 PM
To: ms_access@yahoogroups.com
Subject: [ms_access] FW: How do you account for various
I get an error when using this wizard to set up buttons:
Invalid use of Null
Any idea what is going on here. It will not allow me to set up buttons to open
forms or accomplish other functions.
Thanks
Dave
This e-mail and any attachments may be confidential or legally privileged. If
I believe, and could be incorrect, that older versions of Access will not show
.jpg files of any sort...only .bmp files. If they have an older version than
the one you created them in this may be a problem. I am a little better than
annovce user so take this info for what it is worth.
Dave
Why doesn't Can Grow and Can Shrink work when adjusting the properties of a
field that is a memo? The report is truncating the text in the memo field for
unknown reasons. I have made sure there are no other fields in the way...only
the next record in the dbase should print under it once it
,
and your plans will succeed. Proverbs 16:3
_
From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Dave Moreau
Sent: Saturday, October 29, 2005 9:59 AM
To: ms_access@yahoogroups.com
Subject: [ms_access] Airline Schedules dbase
Airline Schedules Dbase:
I am working
P.S. Thank you for the first reply...how rude of me not to say so.
dave
-Original Message-
From: ms_access@yahoogroups.com on behalf of Dave Moreau
Sent: Sat 11/5/2005 5:10 PM
To: ms_access@yahoogroups.com
Cc:
Subject: RE: [ms_access
Great idea as I use the bypass key for light security in a small office of
access users.
http://www.databasedev.co.uk/disable_shift_bypass.html
http://www.databasedev.co.uk/disable_shift_bypass.html
This e-mail and any attachments may be confidential or legally privileged. If
you
Does anyone here know Access experts located in the Memphis area. My skills
continue to improve but are beyond the point of most training programs locally.
I try to do self-directed study but am not very good yet at interpreting some
of the instructions.
I'd like to have a mentor (paid of
There are student versions at student process available through your school.
In some cases as much as 50% off. Check with your school's bookstore. Even if
you are taking classes over the internet and not near your campus, I feel sure
your school's bookstore will sell these products to you at
www.datapigtechnologies.com
-Original Message-
From: ms_access@yahoogroups.com on behalf of jaysugi
Sent: Sat 3/18/2006 5:59 AM
To: ms_access@yahoogroups.com
Cc:
Subject: [ms_access] database sample (library)
Also a video demo at www.datapigtechnologies.com under the Access section.
The web site below is good too.
I have always appreciated that people will assist with their expertise.
Dave
-Original Message-
From: ms_access@yahoogroups.com on behalf of Crosier, Dawn
Found the solution...had to load the jpg filters from the MS Office
installation program.
All is well now.
Dave
-Original Message-
From: Dave Moreau
Sent: Friday, March 24, 2006 3:28 PM
To: 'ms_access@yahoogroups.com'
Subject: Unable to show jpg files
I seem to be unable to show
What is the correct way to update a date field back to null with an update
query? I can not figure out what to put in the update line for
Dave
This e-mail and any attachments may be confidential or legally privileged. If
you receive this message in error or are not the intended recipient,
, Dave Moreau [EMAIL PROTECTED] wrote:
What is the correct way to update a date field back to null with
an update query? I can not figure out what to put in the update
line for
Dave
Gary E. Daniels
Cornerstone Appraisal Company
500 Selkirk Drive
Schaumburg, IL. 60194
847 882-5892 Fax
: Re: [ms_access] Re: Update query
I think you just type Is Null or IsNull.
Gary
At 04:14 AM 3/29/2006 +, you wrote:
have you tried (open and closing quotes)
--- In ms_access@yahoogroups.com, Dave Moreau [EMAIL PROTECTED] wrote:
What is the correct way to update a date field back to null
Sent: Tuesday, March 28, 2006 10:37 PM
To: ms_access@yahoogroups.com
Subject: Re: [ms_access] Re: Update query
I think you just type Is Null or IsNull.
Gary
At 04:14 AM 3/29/2006 +, you wrote:
have you tried (open and closing quotes)
--- In ms_access@yahoogroups.com, Dave Moreau [EMAIL
What is wrong with this code...trying to set up a selection Combo Box for a
form. I keep getting an error stating it is missing an operator?
Thanks!
Private Sub qWorkOrderNumber_AfterUpdate()
Dim MyWorkOrder As DAO.Recordset
Set MyWorkOrder = Me.RecordsetClone
MyWorkOrder.FindFirst
://www.viescas.com/
(Paris, France)
For the inside scoop on Access 2007, see:
http://blogs.msdn.com/access/
-Original Message-
From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Dave Moreau
Sent: Friday, April 14, 2006 9:26 PM
To: Access Newsgroup (E-mail)
Subject
for Mere Mortals
http://www.viescas.com/
(Paris, France)
For the inside scoop on Access 2007, see:
http://blogs.msdn.com/access/
-Original Message-
From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Dave Moreau
Sent: Sunday, April 30, 2006 6:22 PM
To: Access Newsgroup (E
One last questionI have tried to do this...is there a way to break down from hours into 15 minute increments?
Dave
-Original Message-
From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of Dave Moreau
Sent: Monday, May 01, 2006 8:23 AM
To: ms_access@yahoogroups.com
Is there a way to convert text fields to time formats as they should have been
in the first place?
Current fields are text based and have data such as 2200 or 0400 (all military
time without any colon or formatting other than text) and I need to convert
them to a time based format such as
Folks
Can you help me out with this calendar control?
I would like to have the calendar default to the current month and date when it
comes up on the form. Is there a way to include code that will allow this to
occur? It always comes up showing the month I installed it April and the date
That worked as well as placing code to put the dates in the text box on loading
of the form.
Thanks!
Dave
-Original Message-
From: ms_access@yahoogroups.com on behalf of Dawn Crosier
Sent: Fri 9/15/2006 1:24 PM
To: ms_access@yahoogroups.com
Cc:
How do I change this query to a half an hour or even a 15 minute increment
rather than 1 hour.
By Hour: Hour([MEMTime])
Group by
It is taking the MEMTime field (a time field only) and grouping the number of
flights during each hour.
I get:
06:00 58
07:00 81
08:00 29
09:00 10
Can anyone help with this...or is it already so messed up that it is not making
any sense?
Thanks!
Dave
-Original Message-
From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of Dave Moreau
Sent: Wednesday, January 24, 2007 10:32 AM
To: Access Groups (E-mail)
Subject
Not at all..I missed your answer as it went to my spam filter...just found
it this evening thank you! Apologies for missing itI'll give it a try
tomorrow.
Thank you !
Dave Moreau
From: ms_access@yahoogroups.com on behalf of Eddie Van
Sent: Tue 3/6
-by (hour/4)
Dick
--- In [EMAIL PROTECTED] mailto:ms_access%40yahoogroups.com ps.com, Dave
Moreau [EMAIL PROTECTED] wrote:
Never heard back from anyone on this one? Any ideas out there?
This works for hourly reports...just want to break it down further.
-Original Message-
From: Dave
a bit, but it should be
a good guide as to how this can be implemented
-
Pete
_
From: ms_access@yahoogroups.com mailto:ms_access%40yahoogroups.com
[mailto:ms_access@yahoogroups.com mailto:ms_access%40yahoogroups.com ] On
Behalf
Of Dave Moreau
Sent: Thursday, March 15, 2007 4:25 PM
%40yahoogroups.com
ms_access%40yahoogroups.com,
Dave
Moreau davem@ wrote:
Never heard back from anyone on this one? Any ideas out there?
This works for hourly reports...just want to break it down
further.
-Original Message-
From: Dave Moreau
Sent: Wednesday, January
My form filter quit working this week and I am not sure why. The only
change was from Windows 2000 to Windows XP. I have checked all
references and did not see one missingany ideas? Here is the code.
Private Sub qWorkOrderNumber_AfterUpdate()
Dim MyWorkOrder As DAO.Recordset
Set
://www.prodev.us http://www.prodev.us/
- Original Message
From: Dave Moreau [EMAIL PROTECTED] mailto:davem%40mscaa.com
To: ms_access@yahoogroups.com mailto:ms_access%40yahoogroups.com
Sent: Thursday, July 5, 2007 9:23:34 AM
Subject: [ms_access] Question? Form filter quit
My form filter quit working
to check for a link that had not been
checked at all.
Thanks again!
Dave
Airport Ops
From: Dave Moreau
Sent: Sunday, July 08, 2007 11:08 PM
To: Dave Moreau
Subject: FW: **SPAM**Re: [ms_access] Question? Form filter quit
From
the query itself is truncating the memo field - thus the report is
not fed all of the data.
Thanks!
Dave Moreau
= = = = = = = = = = = = = = = = = = = = =
This e-mail and any attachments may be confidential or legally privileged.
[Non-text portions of this message have been removed]
Of Dave Moreau
Sent: Friday, August 24, 2007 7:07 AM
To: ms_access@yahoogroups.com
Subject: [ms_access] Memo Field truncated in query result
Why would a memo field be trunacted in a memo field when running a
query/report?
The query does not pull all of the text in from the tableall
changed it to a straight
query, I got the entire contents of the field.
Rich
From: ms_access@yahoogroups.com mailto:ms_access%40yahoogroups.com
[mailto:ms_access@yahoogroups.com mailto:ms_access%40yahoogroups.com ]
On
Behalf Of Dave Moreau
Sent: Friday, August 24, 2007
I removed the count field in the query and still have the truncated memo
field
From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On
Behalf Of Dave Moreau
Sent: Friday, August 24, 2007 2:25 PM
To: ms_access@yahoogroups.com
Subject: RE: [ms_access] Memo
%40yahoogroups.com ]
On
Behalf Of Dave Moreau
Sent: Friday, August 24, 2007 3:13 PM
To: ms_access@yahoogroups.com mailto:ms_access%40yahoogroups.com
Subject: RE: [ms_access] Memo Field truncated in query result
Dawn:
Still having a tough time getting that field not to truncate. I tried
taking that field out
@yahoogroups.com mailto:ms_access%40yahoogroups.com
[mailto:ms_access@yahoogroups.com mailto:ms_access%40yahoogroups.com ]
On Behalf
Of Dave Moreau
Sent: Friday, August 24, 2007 9:54 PM
To: ms_access@yahoogroups.com mailto:ms_access%40yahoogroups.com
Subject: RE: [ms_access] Memo Field truncated
%40yahoogroups.com
[mailto:ms_access@yahoogroups.com mailto:ms_access%40yahoogroups.com ]
On Behalf
Of Dave Moreau
Sent: Friday, August 24, 2007 10:40 PM
To: ms_access@yahoogroups.com mailto:ms_access%40yahoogroups.com
Subject: RE: [ms_access] Memo Field truncated in query result
John...I took
Check your tables format for that field rather the the form's format for
that field???
From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On
Behalf Of CapitalLease
Sent: Friday, October 19, 2007 7:46 AM
To: ms_access@yahoogroups.com
Subject: [ms_access]
,my source query or table name,status = 'R' )
_
From: ms_access@yahoogroups.com mailto:ms_access%40yahoogroups.com
[mailto:ms_access@yahoogroups.com mailto:ms_access%40yahoogroups.com ] On
Behalf
Of Dave Moreau
Sent: Wednesday, October 24, 2007 10:56 AM
To: ms_access@yahoogroups.com
txt3
End Function
_
From: ms_access@yahoogroups.com mailto:ms_access%40yahoogroups.com
[mailto:ms_access@yahoogroups.com mailto:ms_access%40yahoogroups.com ] On
Behalf
Of Dave Moreau
Sent: Wednesday, October 24, 2007 11:05 AM
To: ms_access@yahoogroups.com mailto:ms_access%40yahoogroups.com
I have a dbase for entering airport information. I would like to create
a way to auto fill forms based on the condition of the airfield. This
will be used during snow storms and quick updates are critical. For
most entries we can simply accomplish them manually. Weather changes
and updates
=([Effective Date]at[effective time])
This formula is in a concatenated text box. I would like the time to
show as military time instead of local time. The field in the table and
the query is formatted to military time and when the query runs on its
own it shows military time.
I have four fields. I need to convert Zulu (Greenwich Mean Time) to
Local Memphis Time.
Two Date fields:
Effective Date (Format 07/26/08)
End Date(Format 07/27/08)
and two time fields
Start time (Format 23:00) In Zulu Time
End time(Format 07:00) In Zulu Time
47 matches
Mail list logo