Search results for query: *

Hi all - I have a table that an enduser imports once a month from excel. It has a field that is a date in 01/01/07 format, but when it imports, it sets this as a text field. Each month the user imports the data, overwriting the existing table, and then runs a form, which runs a parameter...

Hi all - I'm looking for some input on updating a database we have. I didn't build it, and the developer used a lot of macros. I use VBA almost exclusively. I seem to remember hearing at one point that access wasn't going to support macros in an upcoming version - that was some time ago - is...

Hi - I have a user who has upgraded to Word 2003. She creates a ton of documents that she emails out weekly. Previously, she could use the Tools --> Track Changes --> Accept or Reject Changes window, click Accept All, and her document would be ready to mail out. Now, she is finding that...

Hi all - I have a simple access db on the network, that exists primarily to generate a report for our users, and which gets it's data from our AS400. This db contains maybe 4 tables, which are updated by code run from another program. It dumps the info into a txt file, and there are macros...

Anyone know how to get my data labels to word wrap on my chart? The size of the labels doesn't seem to be changeable. What i don't get is that they are word wrapped on some and not on others. I need to get it to wrap more of them so they will fit in my publication. Any ideas? Thanks in advance!

My boss has a new version of Word. He likes the way the compare documents function worked in 2000. It strikes through the deleted text, puts new text in red, and leaves old text in black. His 2003 marks up the document with bubbles on the right that say "deleted" and show the original, and he...

Hi all, I have a form that works perfectly in Word 2000, that does not calculate in word 2003. The field is a simple calculation field containing =Sum(ABOVE) in the expression. It does nothing in word 2003. Is there someone who can help me fix my enduser's setup so that this form will work...

Hi all - I have an excel spreadsheet that has the month as a single number on one worksheet, and I'd like to show the name of that month on another worksheet. This worksheet is automatically populated with a bunch of other stuff using spreadsheet server, and I don't have the option of changing...

Hi, I have a mission critical database that i inherited that has acted strange lately. I have a form based on the following code: SELECT Rights.Department, Tbl_ASR_Main.ASR, Tbl_ASR_Main.UnitID, Rights.Division, Tbl_ASR_Main.Fund, Tbl_ASR_Main.Attachment, Tbl_ASR_Main.CostCntr...

Hi all, I have an excel spreadsheet that calculates an employee's eligibility for vacation cashout. They are eligible for this cashout 6 months from their date of hire. However, this 6 months is calculated by the day of the month. For example, an employee hired on March 15 is eligible on...

Hi all - has anyone had trouble with adobe forms calculating strangely? I have a form with a lot of fields on it, check boxes with values that total in text boxes, and other text boxes that are totals of the totals. What I'm seeing is strange behavior where some of the totals will clear to...

Hi all - i have a report that is used in a distributed application. On one machine running Win2k and access 2k, the title and subtitle in my page header are cut off. This is currently the only user who's reported this happening, and both text boxes are actually at the left edge of the page...

Hi guys - So I have an excel spreadsheet with a simple yes/no listbox. I want another cell to make a calculation based on that selection. If the user selects Yes, for example, I want cell D7 to say "Employee", if the user selects No, I want it to say "Continue" Can anyone help me with this...

Hi, I have a workbook that was created by making a copy of another workbook, and then changing that copy, and saving it with a new file name. When I open this file in excel 2000, and go to edit --> links, it shows the name of the original file, even though there is no data sharing between...

Hi all - I have the following great code which populates a text box on my form with the contents of a folder on my network: 'last updated 1/4/2006 Public Sub Form_Current() Dim ScrObj Dim SearchFld Dim mFileName Dim strRowSource As String Dim MyBid As String Dim BidName As...

Hi, I have a distributed application that users log into. Some of the users have switched to 2003. Some of these users are now getting the error "you do not have exclusive access to the database at this time. If you proceed to make changes you may not be able to save them later" and they are...

Yes, I"m getting the dreaded "the open report action was cancelled" message - and I've searched the forums, and found the threads addressing it, tried out the code, and still get the error - here's my code: Option Compare Database Private Sub Report_Open(Cancel As Integer) On Error GoTo...

Hi all - I've tried a few approaches to this, and it seems I"m almost there, but I'm stuck. I have a report, with the recordsource of a query called Subrecipient. I have a form called RunQuery with an option group that allows the user to check either subrecipient, (first option) or contracts...

Hi, I have the following Query: PARAMETERS [Do you want to see subrecipients?] Bit; SELECT tbl_main.wccontract, tbl_main.title, tbl_main.desc, tbl_main.origgrantawd, tbl_main.amendgrantawd, tbl_main.begdate, tbl_main.orig_enddate, tbl_main.amend_enddate, tbl_main.gcontact...

Hi - I have a parameter query that I want to run from a button on a simple form. The parameter query only takes a yes or no, and then results are returned based on that. The form has an option group called SubRecipYN, where the user selects on of the two items. I need to then pass that...