Tech Support Guy Forums - Business Applications

Access passing data from report to subreport

esmerelda — Sat, 21 Nov 2009 01:17:23 GMT

I am trying to get some values from a report into the subreport. Although I receive no errors the values are Null in the subreport. Any assistance on where I am going wrong would be appreciated.

In the main report I have the following. The MsgBox print out correctly and the report displays the txtSelectedMonth and txtSelectedYear correctly (the values of x and y are set in Report_Open):
Private Sub ReportHeader_Format()
Me.txtSelectedMonth = x
Me.txtSelectedYear = y
MsgBox "In main_ReportHeader Month = " & x & "Year = " & y

End Sub

In the Subreport I have the following, both xx and yy are Null in the Msgbox print :
Private Sub Report_Open()
xx = Parent![txtSelectedMonth]
yy = Parent![txtSelectedYear]

MsgBox "In report open of Subreport Month = " & xx & "Year = " & yy

End Sub

I have also tried the assignments:
xx = Reports![My main report]!txtSelectedMonth
yy = Reports![My main report]!txtSelectedYear

They also still have xx and yy as Null in the msgbox printout.

Any suggestions greatly appreciated!

Margins in Microsoft Word 2003

kb1003 — Fri, 20 Nov 2009 20:45:18 GMT

I have Windows XP and Microsoft Word 2003. I am trying to print a greeting card for the first time. The card size unfolded is 7 1/2 by 11. Once folded it wll be 71/2 by 5 1/2. When I choose print, I get the message "The margins of section 1 are outside the printable area of the page". I don't understand what section 1 is. I've moved the margins and I still get the same error.

Thank you for your help,
Kaye

Access 2007 #Name? error

ElmerFudd — Fri, 20 Nov 2009 19:08:49 GMT

I am updating a simple database of Contractor info on a one table database.

I needed to add an E-mail address to each of the Contractor records.

From Form View, I selected Design View, then I copied the "Fax Number" label and text box, then pasted them.

I changed the Name and Control Source and deleted the input mask and it worked fine. (A new column called "E-Mail Address" shows up in the table and works with the input form)

I needed to add a 2nd e-mail address for each record and repeated what I had just done, only starting with the E-Mail Address Label and Text box.

"E-mail Address 2" shows up in the table, but I get #Name? in the form. "E-mail Address 2" does not show up in the drop-down for the control source, as "E-mail Address" did before, so I had to type it in.

Any suggestions??? (I haven't used Access in 10+ years and am clueless)

Thanks

hide unhide excel

scouse13 — Fri, 20 Nov 2009 17:12:47 GMT

with regards activex checkboxes in excel, i know you can hide or unhide the said boxes by going to properties and changing the visable section from true to false, can this also be done by using code so if a visable checkbox on the worksheet is ticked this will then display other hidden checkboxes
your help is appreciated
thanks

Excel 2007 Hyperlink Macro

firzhugh — Fri, 20 Nov 2009 16:49:59 GMT

Hi, I have got an Excel spreadsheet which has incident numbers in column A. For each of these incidents I need to put in hyperlinks which are very very similar. The first part of the hyperlink is the address to the database and the second part is the Incident number itself. I'm trying to create a macro which automates the process of putting in the hyperlink plus the incident number in. Can this be done?

Solved: Show dates on report heading

Brian62 — Fri, 20 Nov 2009 16:19:07 GMT

I am creating a report that needs to show the beginning and ending dates to show up on the report.

Example: The report shows dates between 1/01/08 through 11/12/09 (multiple records)

The report heading would need to show: Annual Report Jan 2008 thru Oct 2009

Is there a way that I can use the dates on the report from a query to give me what I need?

Sorting and addition of data in rows, Excel

westcap — Fri, 20 Nov 2009 16:09:28 GMT

I'm new to macros. Is there anyone who can sort information in an infinite number of columns and an infinite number of rows by information contained in each row? Some rows will contain only one column and others will have several columns.
Additionally, after the sort, I would like to total the number of like rows and insert that total in column "A" in the front of the rows, deleting all but one of the like rows. Also, there is data in parentheses that I would like to add together, per row and insert the sum in column "B" at the front of the row.
I have attached before and after files.
Thanks for any help. I have spent a lot of time trying to figure this out, but I'm not savvy enough to do it. And if I didn't explain this well enough, I'll try to clarify. Westcap

Attached Files

Sort Example.xls (9.0 KB)

Excel 2003 crashes

p_lark — Fri, 20 Nov 2009 10:34:32 GMT

I have a problem with Excel 2003.
If I make linking between another worksheets in a workbook or when I try to link from other worksheets in formula does application excel.exe to crash.
see sample ( formula in cell =+':\Document_2009\FII_Financ\2009\PDC\[calculation_pdc_2009.xls]Oct'!$BW$8)
The error messages on my computer is following:
Faulting application excel.exe, version 11.0.8316.0,
stamp 4ace3b8f, faulting module excel.exe, version 11.0.8316.0,
stamp 4ace3b8f, ,fDebug: 0, Offset: 001cb5c9
(PC DELL OPTIFLEX 170 - Windows XP ver.2002, SP3 Intel Pentium 4, 2,8GHz - Microsoft Office Excel 2003 11.8316.8221 SP3 (Microsoft Office Standard Edition 2003) )
Why can I do to resolve this problem?
Thank you for your help.
Paul

Microsoft Excel error.

timestop — Fri, 20 Nov 2009 09:21:01 GMT

Hi i encounter an error message while right clicking the tab in microsoft excel file and select "copy or move". Attached are the error message. I tried to reinstall the excel software but still could not work. I also tried on other computer and it gives the same error. Anyone could advise?

Attached Thumbnails

Excel show hide details

shillguy — Fri, 20 Nov 2009 06:42:41 GMT

In my Excel 2003, the side column where 1,2,3, etc are mentioned, and the top row where A,B,C,etc are mentioned has disappeared. How do I make it reappear. Thanks in advance.

Notepad not opening properly

bleedom — Fri, 20 Nov 2009 05:22:52 GMT

Windows XP
When I go to accessories-notepad and open notepad it goes directly to
the system tray. Then I have to right click go to maximize to open it and then it comes up. I was going thru a tutorial on HTML and created a file
in notepad and then saved it with a HTM extension. I then renamed the
file back to a txt extension to edit it. after I renamed it back to HTM I could
not open the txt file. That is when the problem started.

open office help

noodles71 — Fri, 20 Nov 2009 00:37:16 GMT

hi all,im trying to put text next to a picture in openoffice. 1.i somehow managed to put a picture on the right side of the page,with text on the left(all good)
now i want to reverse the next picture,so picture is on the left,text on right
etc etc.the problem im having,is that office wont let me put text at the middle of the picture.when i write something it appears either above the pic or below it,and i cant figure out what i did in step 1.
any suggestions?
thankyou in advance

2007 Outlook date error in "sent" email and calendar

signchick — Fri, 20 Nov 2009 00:17:50 GMT

I have Windows XP and am using Office 2007. A week ago my Outlook calendar started showing the wrong date. Today is showing as 11/13/09 and it's 11/19/09. My inbox is grouping my email in "Next week" (It should list it as "today"). All todays outgoing email is dated 11/13/09 on the receiver's end (so my clients don't think they've received it because their email program is filing it under 11/13/09. All incoming email has the right date on it. My sent file has the wrong date. This is bizarre! Please somebody help me.....

worksheet protection

scouse13 — Thu, 19 Nov 2009 21:15:21 GMT

is there a way using vba, that if a worksheet is protected,macro's,formula's and checkboxes(both form and activex still work.
my problem is two columns allow data entry and the others either have data in that i don't want changed or contain formula's which perform , an action on another cell, the same applies to the checkboxes which when returning a true value alter the colour of adjoining cells

Creating a scheduling tool in Access 2007

morne.lippiatt — Thu, 19 Nov 2009 20:26:42 GMT

Hi,

I am running Microsoft Access 2007 on Windows 7. I want to create a scheduling tool in MS Access 2007 but I am at a loss for the table structure. I have a bunch of trainers and want to be able to log their availability and then schedule them for work but have the database tell me when they are already scheduled or not available.

I am an intermediate user of Access so understand most of the tools. I have tried having tables with the master dates, and dates available and dates scheduled and have used update and delete queries that run on a macro to update and alert schedules but this seems like a needlessly complex way of structuring it and not very flexible.

Perhaps a DBA out there could give me a few pointers on the best table, query, macro combination that would be easy to scale up or down. Preferably something that does not require VBA coding (or if it must, very simple coding).

Thanks in advance

Sincerely

Morne:D

ICS File not opening up in OUTLOOK 2003

Darora — Thu, 19 Nov 2009 20:13:08 GMT

When I try to open .ics file in Outlook 2003, I get this error
"
This error can appear if you have attempted to save a recurring Lunar appointment in iCalendar format.To avoid this error, set the appointment option to Gregorian instead of Lunar.More information about this error message online
"

The .ics file content are:
BEGIN:VCALENDAR
VERSION:2.0
METHOD:PUBLISH
BEGIN:VEVENT
UID:calendar:47:changed:0:0
SUMMARY:Test Event
DTSTAMP;20091118
DTSTART;20091118
DTEND;20091118
RRULE;Nov 18
END:VEVENT
END:VCALENDAR

I have seen similar post in this thread but there was no solution.
http://forums.techguy.org/business-a...s-problem.html ( I cannot disable my antivirus)

Also, at https://developer.atlassian.com/jira/browse/JCAL-41
But I tried the suggested but in vain.

Please help...I am stuck with this issue for few days now.

Thanks

Excel Macro -> Worksheet_Change Event

computerman29642 — Thu, 19 Nov 2009 19:40:42 GMT

Is it possible to have two different codes under the Worksheet_Change Event?

Incremental Backup Software

Krigaren — Thu, 19 Nov 2009 19:24:47 GMT

Not sure if this is the right forum section but here goes :)

The backup system currently in place where I work is sub-par and I'd like to implement amongst other things a daily incremental backup onto removable media taken offsite, preferably onto DVD-RAM, and archived onto DVD-R when the disc is full.

The problem I'm having is finding the right software to use. Giving how some files, for example the telephone enquiry database, are going to be modified every day we are soon going to end up with many different file versions on the disk. I'm looking for a program that will affix the file names with the date of backup, or at the very least organise them into dated folders that can be filename searched (filenames intact).

Does anyone know of any software that provides this kind of function? I could even do the disc burning seperately, but I need a program that will flag any files modified since the last backup, and add the date somehow.

Solved: Adobe Standard 7.0 I/O error when trying to save

socialk — Thu, 19 Nov 2009 19:23:49 GMT

I have a Dell GX280 with 1gb of memory running windows XP, sp3 machine with Adobe Acrobat 7.0 installed. There are some large PDF files that we are trying to add pages to. These files have existed for a while and the problems only started with this specific computer while other computers with the same os/software have no issue. Upon a save attempt an error message saying, �The document could not be saved. A file I/O error occurred.� displays. The file is then corrupt and cannot be opened period.

Linking forms in Access

bblakel1 — Thu, 19 Nov 2009 17:13:23 GMT

Hello,

I am new here and this is my first post so let me know if I am doing anything incorrectly. I have an Access DB, and I am trying to create a button on one Form that will pull up another Form and display the associated FK. Here is the VB code I have so far, but I know it is missing something. It has been a long time since I have done any VB and I was not great at it then. Any help would be much appreciated.

Private Sub Command21_Click()
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "the form I want to retrieve"

stLinkCriteria = "employeeID" = " & Me![employeeID]"
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.GoToRecord , , acGoTo, (this is were I get lost)

End Sub

Excel 2007 -How do I get cell data to populate email?

desantisj — Thu, 19 Nov 2009 17:12:52 GMT

Hi:
I have a couple of questions regarding the below code and the attached spreadsheet. What do I have to do to make this macro execute at the time indicated in col m of the spreadsheet? The dates are going to be different for each row.
Also how do I get cell data [a4] [h4] [g4] [m4] [n4] to populate from the worksheet into the email?

Sub Mail_small_Text_Outlook()
'Working in Office 2000-2007
Dim OutApp As Object
Dim OutMail As Object
Dim strbody As String
Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon
Set OutMail = OutApp.CreateItem(0)
strbody = "Andean Funding Closing Document has not been recieved" & vbNewLine & vbNewLine & _
"Andean Tracking Number: [a4]" & vbNewLine & _
"Requested Amount: [h4]" & vbNewLine & _
"Case Number: [g4]" & vbNewLine & _
"Closure Document Due NLT Date: [m4]" & vbNewLine & _
"Staff Coordinator: [n4]" & vbNewLine & _
"Please contact OGL immediately to correct this situation" & vbNewLine & vbNewLine & vbNewLine & vbNewLine & vbNewLine & _
"Judy De Santis" & vbNewLine & _
"Office of Global Enforcement" & vbNewLine & _
"Latin America Caribbean Section" & vbNewLine & _
"Office: 202-307-4609" & vbNewLine & _
"Cell: 202-345-9257" & vbNewLine & _
"Fax: 202-307-8459" & vbNewLine & _
"E-mail: desantisj@msn.com"

On Error Resume Next
With OutMail
.To = desantisj@msn.com
.CC = ""
.BCC = ""
.Subject = "Andean Funding Closing Document Required"
.Body = strbody
'You can add a file like this
'.Attachments.Add ("C:\test.txt")
.Send 'or use .Display
End With
On Error GoTo 0
Set OutMail = Nothing
Set OutApp = Nothing
End Sub

Attached Files

AF_Tracking_Spreadsheet_Test.xlsx (14.8 KB)

Solved: I Need Help with making a formula that involves words.

cnebb1981 — Thu, 19 Nov 2009 17:07:32 GMT

Hi, I'm curious if there is a way to make a formula in Excel that will produce a certain word in a cell, like "Yes" or "No" if a value in another cell is a certain number. For example if H7 = 0 then I7 = "No", but if its any other number then it will = "Yes". Thanks for any help.

microsoft office trial

shoobi1 — Thu, 19 Nov 2009 16:51:36 GMT

Hi guys, i am trying to download the trial for Microsoft office right, but after it does all the downloading(with the little time bar that takes FOREVER to get to 100%!) and then it just disappeared. Nothing else happened. Now, I am assuming, with my limited knowledge, that something must have indeed been downloaded onto my little laptop but can't find Microsoft Office.

Should I, or should I not, be panicking. :confused:

Also, if all seems to be ok, where can i get an actual downoad of the trial? The microsoft website says it's for US residents only :mad:

Solved: Data search

mrl — Thu, 19 Nov 2009 16:43:54 GMT

Hello,
I have a spread sheet that has in column A, a list of days that start on 1-Jan -99 and go to 31-Dec-2009. (over 4 thousand rows). The cells are formatted “dd-mmm-yy (14-Mar-01). If I want to see a particular month, I have to know ahead of time what cell it starts in to use the “goto” command. Say, I want to see all of Oct-01. Right now, I have to know that it starts in cell A 647, and use the “goto” command. I tried to use the advance filter, but it will only display one row, not the whole month. I’ll attach a sample of the spread sheet.

Mike

Attached Files

Job History.xlsx (160.2 KB)

Outlook 2007 � can�t create new email from another program

RideJunkie — Thu, 19 Nov 2009 16:32:38 GMT

Ever since I got Office 2007, I�m not able to create a new email message from another program.
For example, if I select a file in Explore and click �E-mail this file�, nothing happens. It used to automatically pop up a new Outlook email message. This happens in another program as well. I can create new emails fine while in Outlook. Microsoft Exchange Server is set up as the default email type, which was the first thing we checked when this problem started. Not sure if this issue is with Outlook 2007 or Windows XP.
Hopefully this is enough info. Thanks in advance.

Fixed cell reference

tbeatham — Thu, 19 Nov 2009 16:28:06 GMT

Can anyone tell me how I can fix a cell reference in Excel so that the formula doesn't change when I move things about. The dollar sign does not seem to work.

I have a spreadsheet that has 2 workbooks, the first work book has a number of coumns across the page i.e. 10 weeks which is being used to give a 10 week average. I then run a macro each week that deletes the first column, and moves all the remaining columns along one so that I can then enter the details in the end column for the most recent weeks information. It is this end column I want to refer to in the other workbook to pick up a figure and use in another formula but unfotrunately every time I run the macro the referencing in the other workbook changes to pick up the original figure. i.e. the column reference moves with the running of the macro.

I have tried using the dollar sign to fix the cell refrence but this is not having any effect.

Would be really grateful if someone could help me as this will save me a whole load of work having to re-key information.

Cheers :)

Microsoft Word 2007 help

bullcreel — Thu, 19 Nov 2009 16:08:40 GMT

I have a 9 chapter document that I have numbered accordingly. Each chapter is numbered with chapter number followed by page number. For ex. 1-1, 2-1, 3-1, 3-2, etc. My problem is that all chapters numbering sequence is correct except for chapter 2. Every page in that chapter stays at page 2-1 (in the footer). Can you please help me fix this problem.

Solved: Reading a wdb file

marillet — Thu, 19 Nov 2009 14:59:23 GMT

I have been sent a wdb file - from someone using MS Works I guess - which I cannot read.

Can anyone suggest a means of conversion to a format which I could read in word or excel - I do have a copy of Office 2003, but not with Access ?

Thanks
Jack

Solved: Simple Copy & PasteSpecial Process

gerry125 — Thu, 19 Nov 2009 14:45:27 GMT

I'm trying to write a macro in Excel (Vista) to look in column "H" of one sheet and find all instances of an entry "20" and then select that row of data in columns a:g and copy it below the last line of data in a second sheet.

Should be very easy - but I'm getting nowhere. So for any help I will be very grateful.

Gerry125:confused::confused:

Solved: Excel - Calculating Availability in minutes

Lomak — Thu, 19 Nov 2009 14:43:17 GMT

I have a spread sheet that holds all the data for the services we support.
We need to report on availability/downtime of our service.

Each service has different supported hours i.e Mon-Fri 0800-1800 , some may include bank holidays some include saturdays.

I need the spreadsheet to add the 100% possible availablity of the service (in minutes) for that month - i.e October = 31 days , 9 week end days no bank holidays (UK) = 60 Minutes x 24 hours (= minutes in 1 day) * (31-9). so 100% availability = 31680 minutes...

So basically i need to populate columns 'G' and 'I'

I have added a calendar to the spreadsheet that calcualte where the holidays are...

To be honest I think I am confusing myself here and I need someone elses view perspective - all ideas welcome !

Please help!

Kind Regards

Phil.

Attached Files

Availability Days.xls (126.5 KB)

Blinking text

Kemicaze — Thu, 19 Nov 2009 13:31:00 GMT

Hi All!

I have several users who are experiencing problem with flashing text.
The text is flashing in word, pdf and several other programs. It's almost like there is a problem with the drawing/updating of the screens.

All the users experiencing the problems have:
XP-SP3
AxApta accounting program
AutoCAD
ProE
Mdoc
Office 2003

The flashing comes and goes, and there seem to be no pattern. It's more or less impossible to read text and work. There's no suspicious programs running, nor is the computer useing large amount of CPU or RAM during the flashes.

Any1 have any idea of what could be causing this behaviour, or a solution to the problem?

I am at wits end as to what could be causing the problem and look forward to a speedy reply.

--
Thanks in advance.

Morten G. Jensen
Kemicaze

Excel Macro to lookup reference and copy data

RobAndrews — Thu, 19 Nov 2009 11:16:33 GMT

Hi,

I'm looking to set up a macro to do the following:

Open up a workbook called Works Order Register
Find my Works Order on the register by matching the WOnumber (I8) and Contractor name (C1735) from Works Order workbook.
Once found copy various data e.g cell I1735, I1737 etc across to columns D, E etc on the register against the corresponding row found in the previous step.

I've got parts working ok, but not the whole thing together.

Thanks for help.

Delete rows based on criteria - without looping

Moll45 — Thu, 19 Nov 2009 10:36:35 GMT

Good morning,

I have a spreadsheet that itemises 1000's of transactions from different customers. It grows by the day - I have a macro that deletes the records I don't want to see based on the Customer name (delete row if <> to "ABC CO." etc.). What I would like to know is is there a way of doing this without looping through every line as it's taking longer to run every day.

Hope my explanation is sufficient.

Many thanks in advance.

Moll

Email filtering in Outlook 2007

badigard — Thu, 19 Nov 2009 07:53:38 GMT

Hi,
I am trying to create a rule which filters emails between TO and CC for the same group.
for example:
The group name is QA_GROUP.
All emails that have QA_GROUP in CC will be deleted, and those who have QA_GROUP in TO will remain in my inbox.

Anyone has an idea how to do it?

Thank You.

Office Update Failed

MajorModeler — Thu, 19 Nov 2009 03:45:20 GMT

Running Windows 7, home premium version.
Trying to install Microsoft 2007 Office Suite Service Pack 1 (SP1). - about 200mb
Got install failure with code 80200010 - Windows Update encountered an unknown error
I have tried twice to install this update, and failed both times.

Suggestions?

Excel Graphs Parabola

DavidPatterson — Thu, 19 Nov 2009 02:43:27 GMT

Can i enter in formation into excel it graphs a curved line and the gives me the function or equation of that curved line.

MS Outlook 03 - operation failed.

mordy — Thu, 19 Nov 2009 02:19:21 GMT

So I am not getting a error in MS Outlook 03...
Famous error - "the operation failed"
Search on google revels several things - one which solves the problem temporarily.

The e-mail is generated with Quickbooks enterprise 2009. The first e-mail goes through fine. Every other one fails. UNTIL, you open the task manager and kill outlook.exe. Then it repeats. First e-mail through, every other one fails.

It seems like outlook is not closing properly after sending an e-mail through QB.

Client says at her home computer with same versions it works with no hitch.

Aside from writing a script that checks if quickbooks is open and closes it and having it run every 30 seconds, so I have any other way to fix this?

TIA
Mordy.

Excel color palette randomly changes

ap526 — Wed, 18 Nov 2009 23:46:26 GMT

When I open certain files, and any time I open a new file, the color palette in Excel displays different colors than the default palette. It doesn't work to reset the palette.

If I open a file with the weird color palette while one with the regular color palette is open, it changes both to the weird color palette.

If it happens the other way around, and I open one with the regular color palette after the one with the weird color palette is open, nothing changes, and in fact the weird color palette will change back to normal and I can save the file and everything is good.

I have a blank Excel file I named "Default Color Palette" so that I can do this every time I open a file with the weird colors, but a lot of files seem to be affected and I use a lot of color coding and conditional formatting.

Does anyone have an idea why this could be happening?

Attached Thumbnails

Outlook does not display new mail

MajorModeler — Wed, 18 Nov 2009 21:53:34 GMT

Running Outlook 2007 under Windows 7, home premium version.
Outlook appears to download new mail just fine - status bar updates as expected and message counter in the lower bar of the window counts down and the byte counter counts up as expected.
When download is completed, no new emails show up in the inbox. or any other folder.
Suggestions?
Thanks

Solved: Excel Macro -> Delete Multiple Rows

computerman29642 — Wed, 18 Nov 2009 21:46:08 GMT

I am trying to find a way to find a specific text within a worksheet, select that cell and the 9 rows under that row, and delete the 10 rows.

Solved: Using the F5 key to fill blanks

Akuller — Wed, 18 Nov 2009 19:39:33 GMT

Hi,

Awhile ago I spoke with someone helping me fill blank cells with data from one row up. The instructions had to do with highlighting the column, hitting F5, choosing special, then blanks...after that I forgot the rest.

Can anyone pick this up & let me know?

Thanks!

Solved: Outlook Permissions

PCDesign — Wed, 18 Nov 2009 19:32:18 GMT

I have been backing up the Outlook folder that contains the .pst files for Outlook to our File Server. Just had a computer crash and had to reload everything. The old Outlook was 2003. When I reloaded the computer I put 2007 on it. I have tried copying the old .pst file, importing the .pst and it keeps coming up with "File access denied. You do not have permission required to open the file". I even loaded 2003 onto another computer and tried to access this backup file with the same result. I am the adminstrator and have the highest permissions. I have even tried it under the user's permissions of the person's computer that crashed.

Scripting around limitations using Access and Infopath 2007

dhsmithii — Wed, 18 Nov 2009 19:19:45 GMT

Hi, Shot in the dark but wondering if anyone could help. At work I have self-made technical/educational issue tracking system.

Users fill in some information using two InfoPath Forms I set up. They then submit the data to an Access database and generates an email to my account.

Unfortunately, I need fields larger that 255 characters (some employess need to write notes within the form longer than the limitations). Currently, I have set up multiple text fields to mimic the appearance of the memo type data (i.e. 4 separate text boxes that allow up to 255 character being submitted to 4 table fields in access).

Any ideas how I can change the infrastructure to allow me to submit larger field types like Memo? Do you have any suggestions on any other "free" programs to utilize to get the same general results?

Thanks!!!

Access Query using Between statement

TumTee Tum — Wed, 18 Nov 2009 19:03:49 GMT

Hi
I have used the Between statement in a query where the attached form provides 2 numbers. My problem now is that the form will provide a single numeric value(say 46). My query needs to use this value with a + or - fixed integer. (Say +/-8)I have tried to modify the Between statement with no success.
Can anyone help please?
Alan

excel checkboxes

scouse13 — Wed, 18 Nov 2009 18:54:15 GMT

thanks for the reply zack

regarding the previous thread

what i have done is set up a few darts games to play on the laptop, a different game on different worksheets, what i would like to use the checkboxes for is when selected and the command button pressed that activates the worksheet chosen

i have 8 checkboxes the first 4 are for players 1 - 4
the last 4 are for the four different games that can be played, what i would like to happen is if the first checkbox is selected( 1 player )
and the first of the games checkboxes is chosen then when the command button is pressed that worksheet is activated
obviously the code needs to be set for all possibilities

i.e 1 player game 1
2 players game 1
3 players game 1
1 player game 2 etc etc

hopefully this explains what i am trying to achieve

many thanks
scouse13

Cannot uninstall or repair Office 2000

cstallard — Wed, 18 Nov 2009 18:48:33 GMT

I allowed PCMover to move apps to my new computer last year. Big mistake! Now I cannot run Office 2000, uninstall Office 2000, repair Office 2000, or reinstall Office 2000. In every case I get the same sequence of error messages: the first asks for the installation source (I have the original CD and I offer it that), then the second rejects the source, saying "The installation source for this product is not available. Verify that the source exists and that you can access it."

I tried running Revo, but it calls upon the Windows uninstaller, so I get the same first error message. In Moderate mode Revo finds more than 25,000 related registry entries to remove; I cannot possibly examine them all, and I'm absolutely sure something else will get hosed if I remove them all.

What can I do? I need to use Word 2000 to test some new documentation software.

--C

Excel 2007 Macro to Send Reminder Email

desantisj — Wed, 18 Nov 2009 18:15:11 GMT

Hi:
I am very new to Excel 2007 and macros. I have a spreadsheet that I am trying to get to send an email reminder to the point of contact [ col b ] 5 days prior to the closure document due NLT date [ col m ]. I am looking for assistance in writing a macro which will accomplish this if it is possible. I have attached the spreadsheet that I referenced.
Your assistance would be greatly appreciated.
Thanks in advance.

desantisj

Attached Files

AF_Tracking_Spreadsheet_Test.xlsx (14.7 KB)

Armenian font in Microsoft Word

kartho — Wed, 18 Nov 2009 18:09:38 GMT

I have Windows XP/Microsoft Word 2003 and want to print a few words in the Armenian language. I thought I would have to download and install a font but at armeniapedia.org (http://www.armeniapedia.org/index.ph...Armenian_Fonts) I read that Windows comes with "Unicode" fonts installed from factory, all you need to do is enable the Armenian keyboard and start typing. So through Word help I searched for "enable Armenian keyboard" and found "About creating a Georgian or Armenian document". I followed the 2-step process:
Step 1: Enable the language for editing in Microsoft Office (did that OK, I think)
Step 2: Install the keyboard layout for Georgian or Armenian. Problem is that Armenian is not listed in the languages to choose from.
Am I going about this the wrong way? Since I only need to print a few words this one time I'd rather not have to download anything new to my computer if possible. How can I enable an Armenian font with what I have? Thank you to anyone who can help.

Big problems with Microsoft Word - won't go away even after reninstalling

OM2 — Wed, 18 Nov 2009 17:49:40 GMT

Microsoft Word has stopped working on my machine :(

I've tried everything - nothing works

It just won't respond
If I have a page full of text, then the mouse will stop responding and I can't use the mouse to place the cursor

EVERY time I shut it down, it completely crashes

I've tried installing SP2 - no result

I've uninstalled completely and have reinstalled - same problem :(
This has now got be completely baffled

I'm 99.999% sure my machine is free of viruses

THOUGH, one new thing is happening, when Windows starts, it reports that it has blocked some services from starting - I've no idea why!! I haven't done anything relating to this! Could this be the problem? I've checked and there's loooads of services that have been stopped??

What can I do...?

Any help would be really appreciated

Thanks

OM

Solved: Excel macro find next available number

RobAndrews — Wed, 18 Nov 2009 17:30:00 GMT

Hi all, apologies if this is in the wrong location or already answered elsewhere. I have limited knowledge in writing macros from scratch and after searching for guides for a while I thought it best to ask here. Please point me in the direction of advice if already stated elsewhere.

I'm looking to write a macro that does the following

Opens workbook B
Looks for first blank cell in range B5:B5000
Returns value (copy & paste into workbook A Cell E5) in column A directly left of first blank cell
Copies data from workbook A cell F5 into the blank cell
Saves workbook B and closes

Thanks very much for any help.