RSS MAD

table lock prevents delete query from running

Hi, I am working on a simple data entry continuous form. The user will enter howver many data records as necessary into this form, then run a macro by pressing a button on the form; the macro does the following: 1. closes the form 2. appends the data in the table tied to the continuous form to a master table 3. deletes the information in the table tied to the continous form The problem I am having is when I run this macro from the form using a command button, it fails while attempting to run the delete query. The error message is: "The database engine could not lock table 'MyTableName' because it is already in use by another person or process." However, if I run the macro from the "Macros" window in the Objects pane, it runs as intended with no errors. Funny thing is, though I've not much experience with Access, I've set up forms like this one before that worked fine--so it's probably something stupid and simple that I'm doing wrong. Anyway, any help on this matter is greatly appreciated.

S tsetial

Horizontally Banded Chart Background. - on Stock charts

I have 3 series of data, Hi/Lo/Avg that I am plotting using a Stock type chart with 3 data points. I want to use a Horizontally Banded Background to indicate the desired range. I have read and tested Jon P's excellent article on Horizontailly Banded Chart Background, and tested it successfull on a line chart. However when I test it on the 3 var Stock chart it does not work. Can anyone give me a suggestion for a way to do what I want with either my stock type of chart or an alternative way to show what I want to indicate. Thanks from American Samoa JDB

NG TEST

Excel Solver in VB

I am trying to run this piece of code but I am getting nothing but the first constraint in the Solver. I'd be happy is someone could help me with this. Thanks.. Public Sub DualSolver(K, M, N) 'Activate the DLP sheet Sheets("DLP").Activate 'Reset the solver SolverReset 'Objective Function SolverOk SetCell:=Range("B4"), MaxMinVal:=1, ValueOf:="0", ByChange:="Range(Cells(2, 2), Cells(2, M + N + 1)),Range(Cells(1,M+N+6),Cells(K,M+N+6))" 'Constraints SolverAdd CellRef:=Cells(K + 1, M + N + 6), Relation:=2, FormulaText:="1" SolverAdd CellRef:=Range(Cells(6, 2), Cells(6, M + N + 1)), Relation:=2, FormulaText:="Range(Cells(8, 2), Cells(8, M + N + 1))" 'Solver Options SolverOptions MaxTime:=100, Iterations:=10000, Precision:=0.000001, AssumeLinear _ :=True, StepThru:=False, Estimates:=1, Derivatives:=1, SearchOption:=1, _ IntTolerance:=5, Scaling:=False, Convergence:=0.0001, AssumeNonNeg:=True ActiveWorkbook.Worksheets("DLP").Cells(100, 100).Formula = 1 / 0 'Solve SolverSolve UserFinish:=True 'Finish and discard SolverFinish KeepFinal:=2 End Sub

FILLIN field - how to set up syntax correctly to complete task

Hello, everyone ... I am using MS Word 2003. I have a merge letter where I have 3 places where I want to be able to "fillin" certain info. I inserted the "Fillin" field into the merge letter, but I can't seem to figure out the correct syntax, i.e. { FILLIN ["Prompt"] [Switches] }. Here's the three fillin text choices I use for this letter: 1) his/her 2) refusal of the breath test/submission to the breath test which allegedly disclosed a blood alcohol level in excess of .08% 3) Mr./Ms. I tried typing { FILLIN "Please enter gender pronoun" \d "his" }, but it doesn't work. In MS Office 2002, you could actually get the merge to stop, type in the text you needed, and then proceed, but it apparently has changed for MS Word 2003? I need to be able to choose between the two options listed in 1-3. Any ideas? I'm new to the more advanced fields in merge letters. Have a nice day.

WLM 8.5.1302.1018 freezes while signing in

Hi All, This seems to be a common problem but the common solution isn't working out for me. I have WLM 8.5.1302.1018 installed on Windows XP SP2. Recently, when I try to log in the messenger windows hangs. When I open the task manager window I see two processes named Windows Live Messenger and one of them is eating up 50% of the CPU. I have tried the suggested fixes that were mentioned before, which are: -removing the MSNMessenger folder from the registry. -installing and uninstalling this version and older versions. -Removing any cached data. None of the above has worked for me. I can log in from my Mac book with MSN messenger for Mac. Any info would be much appreciated. -joseph

Document won't print - goes to save as

I'm really frustrated. I'm a long time user of Word 2003. I have a 30 page document I'm working on. I have saved it several times as I work. Now I want to print it. When I try to print, it automatically goes to "Save as" and won't allow me to print. I tried emailing the document to myself at a different email address and printing from there. That won't work either. Can anyone help? Thanks much! Steve

Re: Mail Notification

> Uncheck ³do not apply to other messages that meet this criteria² Place this[color=blue] > at the top of your Rules list.[/color] This was the part that I was missing. Thank you so much! I had the rule listed toward the bottom and now it works! No one else mentioned the placement of the rule! Thanks!

the modificaiton is now allowed because the selection is locked

The MS Word 2003 document in question is shared among several users over an internal network. I working with another user in a different office and both of us are using comments alot on the work that is done on this document. Initially, we worked on RTFs because that is the format of the documents we receive. However, the comments were being assigned bizarre dates so it was difficult to know the sequence of when they were made (and the rtfs would unexpectedly crash, with resultant loss of work). This was reported to our contractors and my pupil was told that rtfs are pretty unstable, particularly in a Metaframe 2003 environment. So now we save the rtfs as word docs before we start work on them. I am having trouble with inserting comments in that sometimes I start typing and nothing appears and sometimes it is difficult to get back into a comment to continue or edit it. On one occasion I couldn't get my cursor back into the comment and when I clicked on the comment in the reviewing pane the existing typing would disappear but if I scrolled the reviewing pane the typing reappeared. If I clicked in the comment the cursor would not appear there and the existing typing disappeared again. Right clicking on the comment marker did not bring up an option of 'edit comment'. Eventually I got back into the comment but as I typed new info at the beginning of the existing typing, the new typing was also repeated at the end of the existing typing. Any feedback would be greatly appreciated. Sorry to be so long winded. many thanks DD

RE: Java Virtual Machine

how do i download -- 00 "HWRU-CE - Michel" wrote: [color=blue] > Several Websites tell me that I need to download java > Virtual Machine. Choosing the download option results in > the following message: > > We're sorry, you cannot view this page because it > requires the Microsoft Java Virtual Machine (MSJVM). Your > machine does not have the MSJVM installed. For more > information please visit www.microsoft.com/java. > > Who helps me out of this circle? > > Thanks in advance > > Michel > >[/color]

I need helping backing up contacts, mail and calendar from Office

I am upgrading from Office 2003 to Office 2007. Hooray! The problem is, it is not an upgrade version, it is a completely new version. So before I install 2007, I need to uninstall 2003, right? My problem is, Office 2007 will be here 5/12/08. I need to backup my contacts, mail, and calendar, so that I can import it back into 2007. The problem is that there are so many options of ways to export it and import it, I have no idea which one to choose. I don't want to choose the wrong one. It would be a disaster if I lost the calendar and my emails. Is there another way? How can I back the stuff up? Thank you for your help! Tyler

Access 2007 locking in multiuser mode on LAN with Vista

I have an access 2007 FE on Vista laptops, sharing a BE on Vista Desktop over LAN. With 2003 on XP it worked fine simply sharing the file. It works fine 1 at a time. It locks up when the second user attempts to share. If the first exits the application the second can then continue. Other file sharing works fine. I enabled record locking - edited record. Any other ideas would be very welcome.

Word 2000 Product Key not working

Hello Experts, My hard drive crashed and I'm trying to reinstall my copy of Word 2000. Unfortunately, the 25-digit product key on the back of my jewel case isn't working. What can I do to fix this?? I need to handle work files in Word this week! I thought this happened to me the last time I had to reinstall, and there was a way to retrieve my product key from the registry. Unfortunately, I can't find the right registry key or forgot what to look for. Thanks so much!! -- bostnboy06 ------------------------------------------------------------------------ bostnboy06's Profile: http://forums.techarena.in/member.php?userid=48946 View this thread: http://forums.techarena.in/showthread.php?t=966114 http://forums.techarena.in

Preventing Overflow/Continuation of Footnotes

Is it possible to force MS Word 2003 to restrict a footnote's text to the page on which the citation occurs? Thanks very much, MJG

Re: Custom Dictionary not available

Unfortunately there isn't much more to advise you *of* - it sounds like you've done all there is and done it as right as you could:-( The problem with custom dictionaries is something which has been brought to the attention of MacBU but as yet there is no fix. It is reportedly something which is random & hard to reproduce. Until they are able to isolate a cause it's virtually impossible to formulate a cure. One suggestion that has been made in this group is to navigate to the dictionary file in Finder & drag it to the Word icon in the Dock. This seems to provide relief for some, but whether it's permanent I don't know. Those to whom it's been suggested haven't bothered to report back (AFAIK). Regards |:>) Bob Jones [MVP] Office:Mac On 5/11/08 7:09 PM, in article 1c3fc77a-0c7f-4e1a-bcd0-b0bc035ba0da@p39g2000prm.googlegroups.com, "The.Zollers@gmail.com" wrote: [color=blue] > On Mar 26, 4:11 pm, John McGhie wrote:[color=green] >> You have set a "Language" on your custom dictionary, and that is not the >> language your text is in. >> >> Set your Custom Dictionary to "No Language". >> >> If that doesn't cure it, come back: there is a bug that corrupts the custom >> dictionaries, and we need to get serious with it. >> >> Cheers >> >> On 27/03/08 6:18 AM, in article ee962ee...@webcrossing.caR9absDaxw, >> >> "drawbridg...@officeformac.com" wrote:[color=darkred] >>> Version: 2008 >>> Operating System: Mac OS X 10.5 (Leopard) >>> Processor: intel[/color] >>[color=darkred] >>> When I open Word 2008 it says custom dictionary not available or full and >>> will >>> not let me correct or add words. Please advise[/color] >> >> -- >> Don't wait for your answer, click here:http://www.word.mvps.org/ >> >> Please reply in the group. Please do NOT email me unless I ask you to. >> >> John McGhie, Consultant Technical Writer >> McGhie Information Engineering Pty Ltdhttp://jgmcghie.fastmail.com.au/ >> Sydney, Australia. S33°53'34.20 E151°14'54.50 >> +61 4 1209 1410, mailto:j...@mcghie.name[/color] > > I have the same problem mentioned above. Using an Intel macbook with > Leopard and Office 2008. I have created a custom dictionary being sure > to set it to "no language." It works fine, adding words and > remembering them until I quit word. When I start the program again > once more I get the message: "The custom dictionary "New Custom > Dictionary" is not available." I then go into the preferences once > again and "New Custom Dictionary" is selected, it shows there is "no > language" connected to it and when I then close the preferences again > I get the "not available" warning. The "New Custom Dictionary" file is > still there and can be accessed. I have now deleted the custom > dictionary and created a new one several times using different names > for the file and also linking it to a specific language but the > results are the same. I have also followed the indications given in on > www.word.mvps.org but this has no results either and really does not > address this particular problem. Please advise. Thank you.[/color]

Data from Access

Hi Bruce, An easy way to automatically update an Excel sheet from a database, is to build a data table in Excel. Use Data -> Import External Data -> New Database Query (if the data does not fit into a worksheet, you can use a pivot table) Then right-click on any cell containing the imported data and choose Data Range Properties from the context menu. There you will find several options for refreshing the data, including Refresh Data on File Open. Note that you can also name the imported data range from this dialog. The name you set here will automatically expand when new data is imported. Ed Ferrero www.edferrero.com [color=blue] > Hi, all! > > Have a 2003 workbook that is used to print forms. On Sheet 1 is the form > and 3 combo boxes used to select values. The data for the combo boxes > comes > from Sheet 2. > > User wants to automatically update the combo box list data from an Access > database, so they gave it to me (the one who uses Access the most). I > have > created a table in Access to create and store the info, but have been > unable > to successfully update Sheet 2. When I use transferspreadsheet method in > Access (with "Sheet2$" as the range), it erases the data in Sheet 2 but > adds > the new data following where the old data ended. This makes the 3 named > ranges on Sheet 2 contain blanks. > > Figure I'm not using the correct approach here. Can someone (1) suggest > the > best way to do this and (2) point me to some documentation that tells me > how. > > Can really use the help...this is due Tuesday morning. > > Thanks, > Bruce[/color]

Re: "Connecting to Printer, Press ESC to Cancel" Message-> Freezes

MS Word is text reflow software, not page layout based. It uses the current printer driver to determine the capabilities it offers to the user and the way it creates page layout and automatic page breaks, the minimum margin settings, graphics print method and font availability and download requirements from the printer currently listed in the Print dialog. If you're not installing a local printer driver (even for a printer that is on the network), then you may want to choose the optional install MS Office Document Image Writer (always local) as the Word default choice. The insufficient memory message can come from several causes, including an overflow of a 64K information table or an environmental variable pointing to a non local or not writable location, or an add-in that interferes. ================== <<"GoofBoy" wrote in message news:29EA94B2-3C46-4079-A903-7A07D874E209@microsoft.com... Same issue here, your suggestion didn't help. Still goes out to try and connect to the printer, I use a laptop and I have a network with a Canon PIXMA iP4000 printer connected to a desktop Vista Machine. I print to this printer when in the office, I tried your suggestion, no luck. Same issue occurs when I am on the road - please don't tell me I have to delete the printer when not in the office - crappy 'solution'. "I also get There is insufficient memory or disk space. Word cannot display the requested font." When opening some client documents after several seconds of not responding. The is over a Gig of free RAM and tons of free disk space, this is a bad/incorrect error message. I am a software developer so we can get as technical as you like. Please tell me how I can disable this constant polling of the default printer - very, very, very annoying and buggy. << -- Bob Buckland ?:-) MS Office System Products MVP *Courtesy is not expensive and can pay big dividends*

Sending e-mail

On Sun, 11 May 2008 16:03:00 -0700, carlos1 wrote: [color=blue] > I'm not able to send new e-mail. I can reply an e-mail or forward an e-mail. > I have tried to make a reply e-mail new by changing the subject but it will > not be sent. It is just stored in the outbox just as the new ones are. What > is the problem?[/color] No error message? No clue! -- Norman ~Oh Lord, why have you come ~To Konnyu, with the Lion and the Drum

Can i Enlarge a cell by Double Clicking?

What i want to do is double click on a calendar date(Monday May 12th) and have a new sheet pop up. Its for budget purposes. Be able to click on a date and then have all my finances pull up for that date is this possible?

Get Auto Refresh Text from Excel

Hello. I would like to know if it is possible to make publisher insert text on a table, that I have on Excel. I would require that publisher changed the text when I changed it on excel. Linked Object doesn’t apply very well because parts of the sheet are not to be imported and in some cases some cells of the publisher table will only have one letter. Tks 4 the help in advance.

Why does this code fail?

Hi, I'm getting: Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH)) I believe I do something wrng with the 2. parameter of onkey :( using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Xml.Linq; using Excel = Microsoft.Office.Interop.Excel; using Office = Microsoft.Office.Core; namespace ExcelAddIn1 { public partial class ThisAddIn { delegate void testDelegate(); testDelegate t1; private void ThisAddIn_Startup(object sender, System.EventArgs e) { t1 = this.test; this.Application.OnKey("^G", t1); //Excel.Range r = this.Application.ActiveCell.DirectDependents; } private void ThisAddIn_Shutdown(object sender, System.EventArgs e) { } public void test() { this.Application.ActiveCell.Value2 = "5"; } #region VSTO generated code /// /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// private void InternalStartup() { this.Startup += new System.EventHandler(ThisAddIn_Startup); this.Shutdown += new System.EventHandler(ThisAddIn_Shutdown); } #endregion } }

forms and sub forms help

I have a form with a sub form on it the sub form is in Datasheet view this is a 1 to many arrangement. The 1 being the main form and the many being the sub form. The sub form is the one in Datasheet view. Normally the line for the new entry of a records is at the bottom of the Datasheet view form and all the items listed/found for this main item are at the top of the sub form. Is it possible to revers this eg flip the form up side down and have the line for the new entry at the top of the list/form and then list all the listed or found items from there down?

page breaks in Word 2007

I've just upgraded to Microsoft Office Professional 2007 and am in the process of converting my Word 2003 documents to Word 2007. The problem I'm having is when I insert a page or section break (in a 2003 doc that is being worked in the Compatability mode) the text I want to have placed on the next page or in the next section does not move the way it should. What do I need to do so I don't have to keep inserting keystrokes to move the text?