RE: [ms_access] Customized Menus

Try using the ALT key as you drag and drop. Thank you Dawn. That worked. Ilona Adelaide, Australia Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ * Your email settings: Individual Email | Traditional * To change settings

RE: [ms_access] Customized Menus...More Help Please

Another dumb question. I have stuffed my ACCESS Built In menus. I un-installed and re-installed Office 2003 and my ACCESS built in menus are still stuffed. Do I need to re-load my Windows XP and then re-install Office? ie rebuild my computer? Sorry I'm such a clutz. I'm at my wits end here. Ilona

RE: [ms_access] Customized Menus...More Help Please

have answers to my other question. Thank you -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of Ilona Wright Sent: Thursday, 28 December 2006 4:20 PM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Customized Menus...More Help Please

[ms_access] Customized Menus

I am using Access 2003 and my file format is Access 2000. I am creating menus and have stuffed up my built-in menus and do not seem to be able to reset them. I guess I will have to re-install ACCESS. I have been using Running Microsoft Access 97 as my reference because I originally started my

RE: [ms_access] Help with form please

I have a situation where I have a form (frmAssets) whose source data is tblAssets. On this form is a bound field called PurchasePrice. There is a button on frmAssets that opens another form called frmDepreciation. The source of frmDepreciation is also tblAssets. frmDepreciation also displays

RE: [ms_access] Button Colour

[mailto:[EMAIL PROTECTED] Behalf Of Ilona Wright Sent: Tuesday, November 07, 2006 5:18 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Button Colour Hi George, I don't mean to be argumentative, but I have a question: I am using Microsoft Office Access 2003 on Windows XP

RE: [ms_access] Button Colour

Hi George, I don't mean to be argumentative, but I have a question: I am using Microsoft Office Access 2003 on Windows XP Professional 5.1.2600 Service Pack 2. In Access help Change the background color of a control or section it basically says: Open form in design view Click control to be

RE: [ms_access] Button Colour

November 2006 9:09 PM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Button Colour Hi Ilona, Check this http://www.lebans.com/cmdbutton.htm hth, George -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of Ilona Wright Sent

RE: [ms_access] Re: Hiding Database Window

, acViewNormal, acEdit docmd.SetWarnings true '/ Enable message warning hth -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of Ilona Wright Sent: Thursday, September 14, 2006 6:23 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Re

RE: [ms_access] Re: Expr?s appearing in Queries

-Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of Ilona Wright Sent: Wednesday, 13 September 2006 1:53 PM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Re: Expr?s appearing in Queries Hi Guys, I am suddenly finding that my query

RE: [ms_access] Re: Hiding Database Window

Hi Guys, Using VBA: How do I inhibit the display of the Database window? How do I suppress the message Existing table will be deleted before query? I seem to be able to achieve one but not the other and I want both to be supressed at the same time. Thank you in advance. Ilona Adelaide, Australia

RE: [ms_access] Re: Expr?s appearing in Queries

Hi Guys, I am suddenly finding that my query fields have all turned into Expressions. I am using ACCESS 2003. I turned on all the options under Name Auto Correct so that I could use the marvelous Dependencies information. Is this what has caused my problem? Is there any way I can automatically

RE: [ms_access] Disabling File Exit

Liveson wrote: I just hope you have achieved what you wanted. Yes I have thank you. I did what Robin suggested and put my closing code in the main switchboard OnClose event procedure. This works really well. I'm pushed for time right now and my system gets installed next week. After that I want

RE: [ms_access] Disabling File Exit

_ From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ilona Wright Sent: Saturday, 15 July, 2006 8:12 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Disabling File Exit Hi Guys, I gather that since I have not had a response regarding the disabling

RE: [ms_access] Re: Disabling File Exit

being that for the database to close, the form has to close so the code will fire. Hope that helps. Regards Robin Also from Adelaide SA --- In ms_access@yahoogroups.com, Ilona Wright [EMAIL PROTECTED] wrote: Hi Guys, I gather that since I have not had a response regarding

RE: [ms_access] Disabling File Exit

Hi Guys, Well I have upgraded from Access 97 to Access 2003. Quite a culture shock for me! I am impressed with how user-friendly Access 2003 is. My question is how do I disable only the File Exit command? I want my user to exit only via a programmed exit button. Thank you in advance Ilona

RE: [ms_access] CurDir help please

Hi John, I am using the CurDir function to return the current path. I am expecting the path of the .mdb using the function, but it returns the ACCESS Default Database Folder. Can you please tell me how to determine the current path? I am using Acces 97. What I am trying to do is establish links

RE: [ms_access] CurDir help please

@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ilona Wright Sent: Saturday, June 17, 2006 8:09 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] CurDir help please Hi John, I am using the CurDir function to return the current path. I am expecting the path of the .mdb using

RE: [ms_access] On No Data Help Please

/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ilona Wright Sent: Tuesday, June 06, 2006 1:47 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] On No Data Help Please Thanks for this John. I'm sorry, but I do not understand why I

RE: [ms_access] Flowcharts

://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ilona Wright Sent: Tuesday, June 06, 2006 9:15 PM To: ms_access@yahoogroups.com Subject: RE: [ms_access] On No Data Help Please Thank you John. That makes sense. As you

RE: [ms_access] On No Data Help Please

: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ilona Wright Sent: Monday, June 05, 2006 7:43 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] On No Data Help Please Hi John, In the On No Data event

RE: [ms_access] On No Data Help Please

, 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 Ilona Wright Sent: Monday, June 05, 2006 7:43 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access

RE: [ms_access] Macro Question

Hi John, I'm sure this is a dumb question but I have to ask, to make sure I am right. If I have a form with underlying code and I make a copy of this form via File SaveAs to a new name in the current database, and then I open the copy and delete all the underlying code, does this affect the

RE: [ms_access] Macro Question

on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ilona Wright Sent: Sunday, June 04, 2006 8:54 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Macro Question Hi John, I'm sure

RE: [ms_access] Filters help please..sorted

Of Ilona Wright Sent: Monday, June 05, 2006 7:01 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Filters help please..sorted Hi John, I had an incorrect variable name in the Where Condition. Should have been DelDate. Interesting that Access did not pick it up. Sorry if I have put

RE: [ms_access] Send ... Rich Text Format Question

Hi John, I have an Access 97 Report with aline drawn between each of the detail records. When I send this using Rich Text Format, the drawn lines disappear. Am I doing something wrong? Is there a way I can overcome this? Thank you in anticipation Ilona Wright Adelaide, Australia [Non-text

RE: [ms_access] Query Help Please

Microsoft Access 2000 SQL Queries 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 Ilona Wright Sent: Saturday, May 13

RE: [ms_access] Default Value/Event Procedure Help

: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ilona Wright Sent: Thursday, May 11, 2006 1:29 PM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Default Value/Event Procedure Help Hi John, I still have problems. What I want to do is run an update query over a table

RE: [ms_access] Access Courses

Hi Celeste, I don't know where you live, but I'd like to suggest you shop around for a really good course and if you can afford it do a course that gives you Microsoft Accreditation (if that is the correct term) at the end of it. In Australia that costs several thousand dollars but if you want

RE: [ms_access] Default Value/Event Procedure Help

Hi there, I have an unbound text box in a form which is to store a user response of Y or N. I have set the default value as N. I want the form to close if the user keys N followed by the Enter key, or if the user presses just the Enter Key. If I press N followed by the Enter key, I can get

RE: [ms_access] Time calculations for flight operations

privately. Ilona Wright Adelaide, Australia -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of Dave Moreau Sent: Monday, 1 May 2006 1:52 AM To: Access Newsgroup (E-mail) Subject: [ms_access] Time calculations for flight operations I have

RE: [ms_access]Help with Report Please

Hi John, How do you prevent a blank page from printing at the end of a Report? Thank you in anticipation Ilona Adelaide, Australia [Non-text portions of this message have been removed] SPONSORED LINKS Microsoft access

RE: [ms_access]Help with Report Please

Queries 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 Ilona Wright Sent: Saturday, April 29, 2006 1:21 PM

RE: [ms_access]MsgBox Error Help Please

Hi John, I need more help please. In my form frmAssets I have 2 controls; [ReplacementValue] and [ReplacementValueDate]. If a Replacement Value is entered I want to force the user to enter a Replacement Value Date. The following piece of code is converted from a macro I created. I did this so

RE: [ms_access]Hidden Tables Question

/ (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 Ilona Wright Sent: Thursday, April 27, 2006 2:22 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access

RE: [ms_access]Autonumber query

on Access 2007, see: http://blogs.msdn.com/access/ -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ilona Wright Sent: Monday, April 24, 2006 4:41 PM To: ms_access@yahoogroups.com Subject: RE: [ms_access]Autonumber query Hi John, I'm glad

RE: [ms_access] help

Try eBay. Ilona Adelaide, Australia -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of aressler714 Sent: Friday, 3 March 2006 5:23 AM To: ms_access@yahoogroups.com Subject: [ms_access] help hello I'm currently in school trying to learn

RE: [ms_access] Help with making forms work together please.

Thank you very much. Ilona Adelaide, Australia -Original Message- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of Krishnadas Rai Sent: Saturday, 25 February 2006 4:59 PM To: ms_access@yahoogroups.com Subject: Re: [ms_access] Help with making forms work

RE: [ms_access] Help with making forms work together please.

cannot get the description to display. I can key in (ie add) a ComputerReg record and it is saved with the correct AssetId, but it does not display (ie does not seem to be retrieved) when I call up the ComputerRegister form for editing. Can you help me please? Thank you very much Ilona Wright

RE: [ms_access] Calcualtion error

Hi John, =Sum(12*([Forms]![Towel specs]![ypile])*[ends]/(([Ycount]/[Type])*840)) Tried that. Still get #Error. Ilona Adelaide, Australia [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ~-- Get Bzzzy! (real tools

RE: [ms_access] Calcualtion error

Hi John, What is in [ctrlnam] ? In the subform [Pile yarn colorwise] footer is the control [TPLD]. This is a Text Box and the Control Source is =Sum([PlbsDz]) [PlbsDz] is also a Text Box on the subform whose Control Source is =12*([Forms]![Towel specs]![ypile])*[ends]/(([Ycount]/[Type])*840)

RE: [ms_access] SQL Statement

Hi John, How can I put the following SQL statement into a string? SELECT DISTINCTROW Assets.CentreID, [CentreTown] [CentreType] AS [Centre Name], Assets.DepartmentID, Assets.AssetDescription, Assets.AssetID, Assets.CtrListId, Assets.Comments, Assets.Model, Assets.ModelNumber,

RE: [ms_access] Re: Row Source Help

exciting. Good luck Ilona Wright Adelaide, Australia [Non-text portions of this message have been removed] Yahoo! Groups Sponsor ~-- Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD

RE: [ms_access] SQL Statement

Hi John, It's not a good idea to keep dynamically building a query unless you can avoid it - it'll cause the code database to bloat over time. Does this mean that Access does not clean up after itself? Ilona [Non-text portions of this message have been removed]

RE: [ms_access] SQL Statement

Hi John, In my whoosho (Australian slang for pretty good) combo box the Row Source Type is the AddAllToList function and the Row Source is SELECT Centres.CentreID, [CentreTown] [CentreType] AS Expr1 FROM Centres ORDER BY [CentreTown] , [CentreType]; I did have it blank, so I believe

RE: [ms_access] SQL Statement

Hi John, I just had a re-think about what I said about compacting my database. I have my data separate from my application software and I would have compacted only the data. Thank you for mentioning the bloating of the database. I guess that means that every object created and deleted in an

RE: [ms_access] Calcualtion error

Dear Shahid, I am attaching the database form in which I am facing the problem. Pls open the form named “Towel specs” Your attachment didn't come through. Maybe it did to the owner of the group. Regarding your field that does not seem to calculate, try double clicking on it to see if it