Re: [ms_access] Job Vacancies Midddle East

Thanks for your e-mail. I'm away on vacation and will be back in the office on 2/4/08. If this is a material related e-mail, please forward the message to MaryAnn Smalley [EMAIL PROTECTED] Thanks :)

Re: Re: [ms_access] how to remove confirmation message

Thanks for your e-mail. I'm away on vacation and will be back in the office on 2/4/08. If this is a material related e-mail, please forward the message to MaryAnn Smalley [EMAIL PROTECTED] Thanks :)

RE: [ms_access] Automate text box with readable date

Try using = Date() =now() includes the current time as well as the date, so that is probably why it isn't working. -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of memairport Sent: Friday, September 15, 2006 12:23 PM To: ms_access@yahoogroups.com

[ms_access] Query Problem

History].TNXCDE_15)=R) AND (([Transaction History].STKID_15)=FG Or ([Transaction History].STKID_15)=WIP)); This query has worked every night for the last 2 years, now all of a sudden it no longer works. As always, any help/advice is greatly appreciated! :) == Mike

RE: [ms_access] Query Problem

Hey John, It doesn't work on anyones machine - same error. -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday, April 24, 2006 8:39 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem Hey John

RE: [ms_access] Query Problem

: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday, April 24, 2006 8:39 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem Hey John, The database doesn't have any modules. I haven't touched the design of this database in probably over

RE: [ms_access] Query Problem

PROTECTED] On Behalf Of Mike Bisson Sent: Monday, April 24, 2006 9:08 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem OK, ran the debug and this is what turned up: MISSING: Microsoft ActiveX Plugin C:\windows\system32\plugin.ocx The database does have forms and reports

RE: [ms_access] Query Problem

- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday, April 24, 2006 9:22 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Query Problem Running now! Thanks a million John. I had done a compact earlier, doesn't that recompile as part

Re: [ms_access] Filter by Form - not working - null/not null only choices

I am out of the office until 2/23/2006. I shall contact you upon my return. Kind regards Mike Bisson Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your

[ms_access] 1,024 Characters Max in a query?

in advance for any help/suggestions :) == Mike Bisson Manager of IT Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com [Non-text portions of this message have been removed] Yahoo! Groups Links * To visit

RE: [ms_access] ComboBox help

to the group so that others can learn as well. -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Friday, February 03, 2006 9:37 PM To: ms_access@yahoogroups.com Subject: RE: [ms_access] ComboBox help Hi All, Hmmm, thought I had

RE: [ms_access] ComboBox help

query runs is when you should refresh/requery the two comboboxes. John -- John V. Ruff - The Eternal Optimist :-) Commit to the Lord whatever you do, and your plans will succeed. Proverbs 16:3 -- Original message -- From: Mike Bisson [EMAIL PROTECTED] That's exactly what

RE: [ms_access] ComboBox help

cannot get the combobox to refresh. The only way I can get it to show the new workorder is to close the form and reopen it. What am I missing??? -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Friday, February 03, 2006 12:02 PM

RE: [ms_access] Pop-Up Windows for notification purposes

Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Wednesday, February 01, 2006 8:13 PM

[ms_access] ComboBox help

to requery that one combobox. As always, thanks in advance :) == Mike Bisson Manager of IT Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com Yahoo! Groups Links * To visit your group on the web, go

[ms_access] Using multiple On-Timer events at variable intervals

times per day. The idea is to have a hidden form load on startup with all of the timer events I need to run. As always - Thanks in advance for any help/suggestions :) == Mike Bisson Manager of IT Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105

RE: [ms_access] Converting a number to hh:mm:ss format

Queries for Mere Mortals http://www.viescas.com/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Saturday, January 28, 2006 11:12 PM To: ms_access@yahoogroups.com Subject: [ms_access] Converting a number to hh:mm:ss format Hi

[ms_access] Converting a number to hh:mm:ss format

:) == Mike Bisson Manager of IT Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * To unsubscribe from this group

RE: [ms_access] Report fields limited to 256 characters???

This message was posted to a newsgroup. Please post replies and questions to the group so that others can learn as well. -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Friday, January 27, 2006 10:40 AM To: ms_access

RE: [ms_access] Report fields limited to 256 characters???

/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Friday, January 27, 2006 2:30 PM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Report fields limited to 256 characters??? OK, where do I insert the UCASE function? -Original

RE: [ms_access] Report fields limited to 256 characters???

] On Behalf Of Mike Bisson Sent: Friday, January 27, 2006 2:30 PM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Report fields limited to 256 characters??? OK, where do I insert the UCASE function? -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf

RE: [ms_access] Report fields limited to 256 characters???

Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Friday, January 27, 2006 3:14 PM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Report fields limited to 256

RE: [ms_access] Formatting for long date with time

:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Tuesday, January 24, 2006 3:12 PM To: ms_access@yahoogroups.com Subject: [ms_access] Formatting for long date with time Hi All, I have the following in an update query: IIf(Time()=#7:00:00 PM#,Date()+1,Date()) What this does is advance the date

RE: [ms_access] Changing a reports record source

, author Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday

RE: [ms_access] Changing a reports record source

Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday, January 23, 2006 3:05 PM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Changing a reports

RE: [ms_access] Changing a reports record source

Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday, January 23, 2006 6:55 PM To: ms_access@yahoogroups.com Subject: RE: [ms_access

RE: [ms_access] Querying Date in Long Date Format

for Mere Mortals http://www.viescas.com/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Friday, January 20, 2006 12:49 PM To: ms_access@yahoogroups.com Subject: [ms_access] Querying Date in Long Date Format Hi All, I have a field

[ms_access] Querying Date in Long Date Format

, but if I move the criteria to a field that is formatted as a short date, it works without a hitch. Any idea's == Mike Bisson Manager of IT Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com Yahoo

RE: [ms_access] Calendar Control

Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Thursday, January 19

RE: [ms_access] Custom Progress Indicator

: Re: [ms_access] Custom Progress Indicator There is an example here of how to create a progress bar. http://www.mvps.org/access/resources/downloads.htm Mike Bisson [EMAIL PROTECTED] wrote: Hi All, I have a small form the pops up that says Processing... on a button control. What I

RE: [ms_access] Calendar Control

Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Wednesday, January 18, 2006 10:37 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Calendar

RE: [ms_access] Calendar Control

Of Mike Bisson Sent: Wednesday, January 18, 2006 10:37 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Calendar Control Well, I thought I had it figured out... Here goes again - I have a form with 2 calendar controls on it 1) is named CalendarStart and 2) is named CalendarStop. What I've

RE: [ms_access] Calendar Control

in the on load event? -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Thursday, January 19, 2006 11:47 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Calendar Control Hi John, Inserted that code, but it's not working

RE: [ms_access] Calendar Control

But the calendars are not displaying the current date when I view the form, they are displaying the date I added the calendars to the form. As usual, any help is greatly appreciated :) -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent

[ms_access] Custom Progress Indicator

to do this? As always, thanks in advance :) == Mike Bisson Manager of IT Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com Yahoo! Groups Links * To visit your group on the web, go to: http

RE: [ms_access] Using * as a literal in a query

Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out Running Microsoft Access 2000 SQL Queries for Mere Mortals http://www.viescas.com/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Monday, January 16

[ms_access] ComboBox refresh

options on the Got_Focus event. This is no problem with my bound combo boxes. What am I missing? == Mike Bisson Manager of IT Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com Yahoo! Groups Links

RE: [ms_access] ComboBox refresh

://www.viescas.com/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Tuesday, January 17, 2006 11:22 AM To: ms_access@yahoogroups.com Subject: [ms_access] ComboBox refresh Hi All, I have a form which contains two combo boxes. The first

[ms_access] Calendar Control

in advance! == Mike Bisson Manager of IT Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access

[ms_access] Calendar Control

Never mind, I figured it out! == Mike Bisson Manager of IT Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED] http://www.carthuplas.com Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com

[ms_access] Using * as a literal in a query

''*'' All I'm getting is an error message stating the query is too complex or it is not formatted properly. As usual, any help would be greatly appreciated! == Mike Bisson Manager of IT Logistics Carthuplas, Inc. V: 207-985-4972 x658 F: 207-985-2105 [EMAIL PROTECTED

RE: [ms_access] Multiple db feed?

I would do a backend database which contains all of the tables and link the multiple Front-ends to the backend. Each front end could have it's own set of forms, queries, etc... -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Lynn Sent: Monday,

RE: [ms_access] Re: Multiple db feed?

:00 PM To: ms_access@yahoogroups.com Subject: [ms_access] Re: Multiple db feed? Thanks! Would that be done similarly to a link up of an Excel Spreadsheet to a DB when using the s/h as a Table? Lynn Bryant Ball Ground, GA --- In ms_access@yahoogroups.com, Mike Bisson [EMAIL PROTECTED] wrote

RE: [ms_access] AutoNumber for Subform

:[EMAIL PROTECTED] On Behalf Of Mike Bisson Sent: Tuesday, November 01, 2005 12:35 PM To: ms_access@yahoogroups.com Subject: RE: [ms_access] AutoNumber for Subform Hi John, Can I use DCOUNT for this on my form? I've created a text box on my form with the following ControlSOurce: =DCount([Skidid

RE: [ms_access] Re: Data duplications

Have you tried running the Find Duplicates query wizard? This should show you any duplicate records in your table. -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Sean Sent: Wednesday, September 14, 2005 8:04 AM To: ms_access@yahoogroups.com

RE: [ms_access] Re: Auto number going from 4 digit to 8 digit

indicator. The autonumber assigns a number to our claim forms that are submitted. I really need to try to get it back to a 4 digit number if possible. Joe --- In ms_access@yahoogroups.com, Mike Bisson [EMAIL PROTECTED] wrote: Does the autonumber serve a purpose for you? You aren't using

Re: [ms_access] Dlookup Blues :(

is GREATLY appreciated! Mike Bisson Manager of IT Logistics Carthuplas, Inc. 207-985-4972 x658 [Non-text portions of this message have been removed] Yahoo! Groups Links Yahoo! Groups Links Yahoo! Groups Links * To visit your group

[ms_access] Calculations between main report and subreport - Possible???

Hi All, Is it possible to perform calculations between a main report and subreport(s)?? Mike Bisson Manager of IT Logistics Carthuplas, Inc. 207-985-4972 x658 [Non-text portions of this message have been removed] Yahoo! Groups Links * To visit your

Re: [ms_access] Calculations between main report and subreport - Possible???

Queries for Mere Mortals http://www.viescas.com/ -Original Message- From: Mike Bisson [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 29, 2005 1:16 PM To: ms_access@yahoogroups.com Subject: [ms_access] Calculations between main report and subreport - Possible??? Hi All