Re: [ms_access] how to refresh all open forms

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 use of Yahoo! Groups is subject to the Yahoo! Terms of Service. May God bless you beyond your imagination! Lonnie Johnson ProDev

Re: [ms_access] Restrict Record in Form

of Service. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Do you Yahoo!? Better first dates. More second dates. Yahoo! Personals

Re: [ms_access] Error Message

/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us

[ms_access] Automatically Sending Mail on Office XP ives message

Ok, I am visiting this age old problem again. We have Office XP on a machine that automatically sends out emails from windows May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us

[ms_access] (RESND): Automatically Sending Mail on Office XP ives message

, vbsendmail and push-the-freakin-button softwares. I thought I saw once where you could do something in the Exchange server to stop this from occuring on a machine. Does anyone have such a solution? May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS

Re: [ms_access] Calcualtion error

Visit your group ms_access on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - May God bless you beyond your imagination! Lonnie Johnson ProDev

[ms_access] Access data to Excel Chart

beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Yahoo! FareChase - Search multiple travel sites in one click. [Non-text portions of this message have been

[ms_access] Record Locking File won't go away

imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Yahoo! Shopping Find Great Deals on Holiday Gifts at Yahoo! Shopping [Non-text portions of this message have

Re: [ms_access] Re: categorizing with age only in reports

this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me

[ms_access] Access Report to PDF File to EMAIL Attachement

Is there a process by which an Access report can be saved to a pdf file then attached to an email without any manaul intervention or use of additional dll files? May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me

[ms_access] Access Report to PDF File to EMAIL Attachement

Is there a process by which an Access report can be saved to a pdf file then attached to an email without any manaul intervention or use of additional dll files? May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me

Re: [ms_access] Use a Form to Automate a Report (Chart)

imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Yahoo! DSL Something to write home about. Just $16.99/mo. or less [Non-text portions of this message have been

Re: [ms_access] MS Access Reports

! Groups is subject to the Yahoo! Terms of Service. - May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us

Re: [ms_access] Custom Progress Indicator

! Groups is subject to the Yahoo! Terms of Service. - May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us

Re: [ms_access] dlookup problems

an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http

Re: [ms_access] Summary query

! Terms of Service. - May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Brings words

Re: [ms_access] SQL Error...

. - May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Yahoo! Mail - Helps protect you from nasty viruses. [Non-text portions

Re: [ms_access] Created database in Access 2000

] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us

[ms_access] Validating user and password against Active Directory

Does anyone have vba code that I can use to validate a username and password against active directory? May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us

Re: [ms_access] Forcing Upper Case in Data Entry for tables

Visit your group ms_access on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - May God bless you beyond your imagination! Lonnie Johnson ProDev

Re: [ms_access] How to return the full path of a file?

an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us

Re: [ms_access] headings in sub forms

ms_access on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional

Re: [ms_access] import data from a .txt file into Access 2002

. ltportellar [EMAIL PROTECTED] wrote: I want to populate an access 2002 table with data from a .txt file. Can it be done? Where can I get info to do this? thank you May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases

Re: [ms_access] Concatenate Result of a query

bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Stay in the know. Pulse on the new Yahoo.com. Check it out. [Non-text portions of this message

Re: [ms_access] Me.Requry form

your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Do you Yahoo!? Get on board. You're invited to try the new Yahoo! Mail. [Non-text portions of this message have

Re: [ms_access] Need VBA equivalent of SQL Query

:[EMAIL PROTECTED] http://www.askdata.net May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Yahoo! Messenger with Voice

Re: [ms_access] Re: Need VBA equivalent of SQL Query

Glad I could help. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Stay in the know. Pulse on the new Yahoo.com. Check it out

Re: [ms_access] help pls

By for the qty field. Then run the query. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Original Message From: muhamed_faisal2000 [EMAIL PROTECTED] To: ms_access

Re: [ms_access]

I just answered in your post that says help pls. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Original Message From: Mohammed Faisal [EMAIL PROTECTED

Re: [ms_access] newbie

Add a new text box. In the control source add this... = DateAdd(d,[DateOfBirthField],Date())/365 The Date() is a system function that returns today's date. You will also need to adjust the decimals on the textbox to your needs. May God bless you beyond your imagination! Lonnie

Re: [ms_access] Form creation

In the first sentence you said the database was read only. Is that the problem? May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Original Message From: Dale [EMAIL

Re: [ms_access] update multiple fields

beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Original Message From: John Scannell [EMAIL PROTECTED] To: ms_access@yahoogroups.com Sent: Sunday, December 31, 2006 2:17:34 PM Subject: [ms_access

Re: [ms_access] Conditional Count in a Totals Query

So grouping by status will not give you the count you need? May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Original Message From: Mike Bisson [EMAIL PROTECTED

Re: [ms_access] NEED HELP

after each record is added then you can sort by that. Hope this was helpful. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Original Message From: hdkhs123 [EMAIL PROTECTED

Re: [ms_access] Report with blank pages

Check your margins. Also check to see if a control or a line has been extended to the right. Sometimes I accidentally take the page out too far as well. Go to the design view and be sure that nothing is extended too far to the right. May God bless you beyond your imagination! Lonnie Johnson

Re: [ms_access] Report with blank pages

Glad you got it fixed. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Original Message From: Clauss Gilbert [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 13

Re: [ms_access] Reports

this helps. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Original Message From: Daemon [EMAIL PROTECTED] To: ms_access@yahoogroups.com Sent: Wednesday, April 18, 2007 5:03

Re: [ms_access] Setting the Form to New Record mode..

The fifth parameter of the OpenForm command tells the form which mode to be in. DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormAdd May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us

Re: [ms_access] Question? Form filter quit

Is the DAO 3.6 checked in your references? May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Original Message From: Dave Moreau [EMAIL PROTECTED] To: ms_access@yahoogroups.com

Re: [ms_access] Created a new record, now how do I programmatically save the data?

increase when you add a new record with the above code. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Original Message From: bryan.leggo [EMAIL PROTECTED] To: ms_access

Re: [ms_access] Pulling data from tables directly into variables

Look at the DLookup Function. MyVariable = DLookup(FieldName,TableName,AnotherField = 'SomeValue') Let me know if you need more help. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us

Re: [ms_access] Pls help me to find a solution for making a query

this helps. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Original Message From: Muhamed Faisal [EMAIL PROTECTED] To: ms_access@yahoogroups.com Sent: Friday, November 30, 2007 4

Re: [ms_access] Pls help me to find a solution for making a query

Glad I could help. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Original Message From: Muhamed Faisal [EMAIL PROTECTED] To: ms_access@yahoogroups.com Sent: Friday

Re: [ms_access] i need help in building a new database system

How much help are you needing? Have you even started? What all do you want it to do? Can you use one of the database wizards? May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us

Re: [ms_access] Query on a substring

Lookup wildcard in the help section. The jest of it is... SELECT MYFIELD FROM MYTABLE WHERE MYFIELD LIKE '*ABC*' This will return such as ABC 1ABC LAABCLA ABCSS May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me

Re: [ms_access] query design

, Column2 From Query1 UNION SELECT Column1, Column2 From Query2 Dogs German Shepard Fruits Apples CarsChevy Homes Duplex May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http

Re: [ms_access] query design

When you say they are not identical, do you mean different data types? Can you actually give us a sample of the real data you are talking about? May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us

Re: [ms_access] query design

be a line between the two tables. For more information look up joins in the help section. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Original Message From: Muhamed Faisal

Re: [ms_access] query design

with the expense record. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Original Message From: Muhamed Faisal [EMAIL PROTECTED] To: ms_access@yahoogroups.com Sent: Monday, December 31

Re: [ms_access] Help New MS Access User

the ListBoxName.Requery method to refresh the listbox. Hope this gets you pointed in the right directions. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Original Message

Re: [ms_access] Fw: Fwd: spliting data

! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us - Original Message From: Muhamed Faisal [EMAIL PROTECTED] To: ms_access@yahoogroups.com Sent: Wednesday, February 27, 2008 11:03:30 PM Subject: [ms_access] Fw: Fwd: spliting data

Re: [ms_access] display value from a dropdown list to a textbox in the form

__ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS

Re: [ms_access] Moving from MS Access to the web

databases on the web? (I wish Access was better for that). Thanks in advance for your help. Reg May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us

Re: [ms_access] query help

Look at MS Access help at the cross tab query. This may be what you are looking for. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Developmentnbsp;of MS Access Databases Visit me at ==gt; http://www.prodev.us nbsp; --- On Sat, 6/14/08, Muhamed Faisal lt

Re: [ms_access] HELP compare data in two tables

On the query tab of the database window click New and then select unmatched query. That will get you started. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us   --- On Mon, 6/30/08

Re: [ms_access] Automatising building of 200 queries

You will need to set the DAO 3.6 reference for this code to work. Replace my Customer table with your table.   Hope this helps...   Public Sub CreateQueries() '*** 'Lonnie Johnson, 7/3/08 'ProDev, www.prodev.us '*** On Error GoTo ErrHandle

Re: [ms_access] Re: Automatising building of 200 queries

np.  Let me know if it works for you. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us   --- On Thu, 7/3/08, Clauss Gilbert [EMAIL PROTECTED] wrote: From: Clauss Gilbert [EMAIL

Re: [ms_access] How to get a field value

Not sure what you mean here. Is AddUserToUserClass a table or query? What do you mean by a sample field?     May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us   --- On Thu, 7/3/08

Re: [ms_access] convert columns to rows

If there are not a lot of columns to convert you could do a union query.   Normal query SELECT May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us   --- On Thu, 7/3/08, Ime Asangansi [EMAIL

Re: [ms_access] How to get a field value

to be the same data type.   You may also be able to do a cross tab query.   May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us   --- On Thu, 7/3/08, Lonnie Johnson [EMAIL PROTECTED] wrote: From: Lonnie

Re: [ms_access] convert columns to rows

to be the same data type.   You may also be able to do a cross tab query. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us   --- On Thu, 7/3/08, Ime Asangansi [EMAIL PROTECTED] wrote: From: Ime

Re: [ms_access] form reference for wildcard parameter question

Does it bring up ANY records? If so, which ones is it not bringing up? You said, But it does not bring in all of the Sonora's. Then it is finding something. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http

Re: [ms_access] Reports on NoData question

I don't get that but try wrapping your cancel command with a SetWarnings command like so...     DoCmd.SetWarnings False     Cancel = True     DoCmd.SetWarnings True   May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me

Re: [ms_access] Correlated query

Open your query in SQL view. Paste that code. Then change it to design view and it will show you how it looks. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at == http://www.prodev.us   --- On Tue, 4/21/09

Re: [ms_access] Need help getting a SUM

Use the Nz function. This will replace any Nulls with a zero. Private Sub B_LostFocus( ) SUM = Nz(A,0) + Nz(B,0) End Sub From: P S discworld2...@yahoo.com To: ms_access@yahoogroups.com Sent: Friday, June 12, 2009 5:36:16 PM Subject: [ms_access] Need help

Re: [ms_access] VBA code for converting figures into words

Here ya go, http://msdn.microsoft.com/en-us/library/aa139962(office.10).aspx#odc_actips_topic10   From: Romeo jre.ph...@yahoo.com To: ms_access@yahoogroups.com Sent: Mon, November 23, 2009 5:15:44 AM Subject: [ms_access] VBA code for converting figures into

Re: [ms_access] VBA code for converting figures into words

No problem. Glad I could help. From: Roemo Elazegui jre.ph...@yahoo.com 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

Re: [ms_access] VBA code for converting figures into words

No problem. Glad I could help. From: Roemo Elazegui jre.ph...@yahoo.com 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

Re: [ms_access] Help with calculate dates

It is not simple but can be done. Here is a link with some examples. http://www.tek-tips.com/viewthread.cfm?qid=1555813   From: jefferson jferreira.so...@yahoo.com.br To: ms_access@yahoogroups.com Sent: Wed, February 24, 2010 7:07:10 PM Subject: [ms_access]

Re: [ms_access] can not see the items of drop down combo box?

Is the column width set to zero? From: rkulez rku...@yahoo.com To: ms_access@yahoogroups.com Sent: Sat, April 10, 2010 11:54:26 AM Subject: [ms_access] can not see the items of drop down combo box?   Hi all members, I am using access 2003. In my database

Re: [ms_access] Export query to Excel using variable file name plus query name plus current date

Hello Vickie. If there is only one record in the table you could do something like this. TheFileName = DLookup(FieldWithPath,TableName) \ QueryName\ TheDate .xls From: Vickie vfifi...@austin.rr.com To: ms_access@yahoogroups.com Sent: Sat, April 24, 2010

[ms_access] Query criteria by upper of lower case

Just curious, Is there a way to search or match a string that is just upper case or mixed case? I have a filed that has these two values and the customer actually wants to be able search for just one of the two. The two values are... 2010 ACTUALS 2010 Actuals [Non-text portions of

Re: [ms_access] Query criteria by upper of lower case

On 11 July 2010 23:51, Lonnie Johnson prode...@yahoo.com wrote: Just curious, Is there a way to search or match a string that is just upper case or mixed case? I have a filed that has these two values and the customer actually wants to be able search for just one of the two. The two values