Windows Support Forum

Works 7.0 Database Date Function in filter?

Q: Works 7.0 Database Date Function in filter?

I'm wondering whether I can filter by date.

My case: I want to make a database filter that only shows coupons that haven't expired yet and also haven't been used yet. I can deal with the used part, but I need a formula type thing that lets me only show coupons whose expiration dates > today's date.

Is this possible? Or would I need access?

Relevancy 100%
Preferred Solution: Works 7.0 Database Date Function in filter?

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link (This link will automatically start a download of Reimage that you can save to your computer.)

A: Works 7.0 Database Date Function in filter?

Field Name e.g. "Expiry".

Comparison ; is greater than or equal to.

Compare to ; INT(NOW())

In Formula View,


Relevancy 87.72%


On the windows search function, there is an option to search for the modified date. Is there a way to search for creation date like windows 98 had?


A:Windows Search Function. Is there a way to add Creation Date as a filter?

Under "Search Options", when you check the Date box, you can choose "files Modified", "files Created" or "files Last Accessed" from the drop-down list box that appears:
Relevancy 82.13%

Please can anyone tell me how I can place the current date in a report generated by Works 7.0 database programme?

A:Works 7.0 Database report current date

"&d" or "&n" (no quotes) in the Header or Footer. Prefix with "&l" or "&r" if you don't want it centred.

Relevancy 61.92%

I need to add an autofilter for expiration dates in the next 7 days:I have the basic part but don't know how to program the criteria to check if date expires in the next 7 days. The cell it is evaluating is date format and sometimes the date is blank so I don't know if I need to take that into account:ActiveSheet.Range("$A$6:$ET$1000").AutoFilter Field:=19, Criteria1:=???????
Relevancy 61.92%

I m having a similar problem to Chris Chu - http forums techguy org web-email -need-help-have-wireless-but html I just upgraded from Qwest DSL Mbps with an Actiontec GT modem to the Mbps service with the Actiontec Q modem set up with just the default options works, Q1000 WLAN WAN - router Solved: works function ActionTec Qwest doesn't, I m having Solved: WLAN works, WAN doesn't, router function works - Qwest ActionTec Q1000 a very peculiar problem I can see the Q s GUI control panel and browse the Internet from a computer connected via wi-fi However a computer connected viaEthernet doesn t see the web or even the Q control center A ping from the Ethernet-connected machine times out However the Ethernet-connected machine CAN see the other machines connected to the Q - I played an MP file from one of the other machines So the router function for the LAN is working but the Q doesn t respond to a ping or let me see the external Net or even browse to the Q s GUI panel I ve tried this with just one machine connected directly via Cat and none of the other Ethernet ports on the Q used I ve done that from two different PCs using different Cat cables and trying different ports on the Q I ve also tried it going through a D-Link switch with the same results from different PCs All of these connections worked with the GT and the Mbps service but not with the Q We even tried replacing the Q with the same results Firmware versions were QAQ - L on the first Q and QAQ - L on the second one Qwest tech support hasn t solved it but suggested quot contact your PC manufacturer quot I m stumped Any ideas I rebooted my main PC in Safe Mode with Networking and still could not ping the Q Following is the HiJackThis log Logfile of Trend Micro HijackThis v Scan saved at PM on Platform Unknown Windows WinNT MSIE Internet Explorer v Boot mode Normal Running processes C Windows system Dwm exe C Windows Explorer EXE C Program Files Microsoft Windows Feedback Panel WFPASIEve exe C Windows system taskhost exe C Program Files LogMeIn x LogMeInSystray exe C Windows System rundll exe C Program Files LogMeIn x LMIGuardian exe C Program Files Microsoft Security Essentials msseces exe C Windows System dinotify exe C Program Files Common Files Java Java Update jusched exe C Program Files Qwest Desktop QwestTouchPointAgent exe C Users Public Documents Programs Kana Reminder exe C Program Files Replay AV ReplayAV exe C Program Files Gomez GomezPEER bin GomezPEER exe C PROGRA Gomez GOMEZP jre bin java exe C Windows system conhost exe C Windows system taskeng exe C Program Files Secunia PSI psi exe C Program Files Common Files InstallShield UpdateService ISUSPM exe C Program Files Siber Systems AI RoboForm robotaskbaricon exe C Program Files AWS WeatherBug Weather exe C Program Files Stardock Impulse Now ImpulseNow exe C Program Files Pidgin pidgin exe C Windows System RunDll exe C Windows system SearchFilterHost exe C Program Files Trend Micro HijackThis HijackThis exe R - HKCU Software Microsoft Internet Explorer Main Default Page URL http ie redirect hp com svs rdr TYPE amp tp iehome amp locale EN US amp c amp bd PAVILION amp pf desktop R - HKCU Software Microsoft Internet Explorer Main Default Search URL http ie redirect hp com svs rdr TYPE amp tp iesearch amp locale EN US amp c amp bd PAVILION amp pf desktop R - HKCU Software Microsoft Internet Explorer Main Search Bar http search live com sphome aspx R - HKCU Software Microsoft Internet Explorer Main Search Page http search live com R - HKCU Software Microsoft Internet Explorer Main Start Page http go microsoft com fwlink LinkId R - HKLM Software Microsoft Internet Explorer Main Default Page URL http go microsoft com fwlink LinkId R - HKLM Software Microsoft Internet Explorer Main Default Search URL http go microsoft com fwlink LinkId R - HKLM Software Microsoft Internet Explorer Main Search Bar http ie redirect hp com svs rdr TYPE amp tp iesearch amp locale EN US amp c amp bd PAVILION amp pf desktop R - HKLM Softwa... Read more

A:Solved: WLAN works, WAN doesn't, router function works - Qwest ActionTec Q1000
Relevancy 61.06%

I have used XL to create a database of events. The first column is dates, and is formatted accordingly. I want to filter the list so that it does not show records having a date earlier than today's date (whatever that may be).

Could some kind person tell me how to achieve this ?
Relevancy 61.06%


I have a form with a listbox on it which displays all the data in one of my tables. I also have a combo box which displays a list of dates (short date) from the table.

I'm trying to query the table based the combobox to get all the records that came after that date.

However, at the moment, when i enter a date, and the list is requeried, the data is not correct.

For example, there is data for everyday (from 12/10/2010 to 26/10/2010) so if i select 12/10/2010 from the combo box, id expect to see records from 13/10 to 26/10.

what i actually get is some records starting at 24/10.

If i change the query so that it looks for records before the selected date, nothing is returned.
Any suggestions as to whats going on?

Relevancy 61.06%


I'm working with MS Access and I have created a button on a report with an on-click event procedure that brings up the built-in pop-up sort function. Here is a link to an image that shows what I am talking about. What I want to do now is to activate the "sort" function on that pop-up box so that I can have both "filter" and "sort" capability.

Here is the code attached to the button.


Private Sub MR_Asso_Click()
DoCmd.RunCommand acCmdFilterMenu
End Sub


How should I change the above code so that I can have both "filter" and "sort"?

Thanks in advance.

Relevancy 60.63%

I would like an option where users can enter various different word into a range (say 15 cells, though they may only use only one or a few of them) These words will then be search for in 2 columns of text. I would also like that the "raw" data would be filtered when the search is completed to only show content that had the searched words.I have found conditional formatting that allows me to search for one word, and a marco to filter on the searched content. However I can not seem to find a way to search for multiple words/phrases at the same time. Again bearing in mind that 1 user may only have 1 word to search for, another may have 5 and another 10.I am using Excel 2010message edited by Elderine

A:Create a multiple wordsearch and filter function in Excel

Could you post the macro or a link to the macro that you say can filter on the searched content? If it already does some of what you need it to do, it may just need some enhancement, such as looping through the list of words in the search range, etc.It would also help if we had some more details, such as:- Where is the list of search strings? e.g. Sheet1!A1:A15, etc.- What columns contain the text to be searched?- Will the text to be searched contain the only the search string or will "partial searches" be required? e.g. Search string = brown dogText to be searched = I have a brown dog- Where do you want the output? e.g. on the same sheet in a different range or on a different sheet, etc.?Please include any other details that you think are important, keeping mind that we can't see your worksheet from where we are sitting. The more detail you provide, the better.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
Relevancy 59.77%

Hi my first post here but I on database function this Excel help need some help regarding a spreadsheet that I m designing for my company to Excel function help on this database make things more user friendly and efficient I ve uploaded the dummy file What I want is IF quot column H quot is a negative figure I want quot column K quot to present as quot X quot otherwise quot quot this Excel function help on this database is easy AND When quot column H quot is negative I want excel to find the corresponding positive figure amp that has the same quot column E quot figure and present this positive figure in quot column K quot also as X quot If you take a look at my dummy file what my instructions mean is must have quot X quot in quot column K quot AND because quot column E quot of is quot quot I want excel to find the other quot quot which has the positive figure of and mark quot column K quot with a quot X quot So I want and and quot quot with quot quot to match with a quot X quot I ve been trying out IF AND OR functions still can t get it to work nbsp

Relevancy 59.77%

Hi All

I need a criteria within a query to return the last 12mths data from a date field, it must return 12 mths data from the most recent date in the database not from todays date.
All help is appreciated
Cheers Brian

Relevancy 59.34%

I have an access report that I would like users to be able to enter a start and end date. The report will be filtered to display data that falls between the two dates.

I have already created a form with date fields. I'm having a hard time figuring out how to use the form to filter the report. I also would like the report to display all data if teh user decides not to enter any dates.

How can this be done?

Any help will be greatly appreciated.

A:Solved: Access 2007/Filter Report By Date Range

There are many ways to do it, but I would set the filter in the OpenReport method when the report is launched, and provide logic to either set the start and end dates to extreme values (like 1/1/1904 thru 1/1/2999), which programming purists would tell you to never do, or not set the filter at all if the user doesn't enter a date.

In the code for the button that launches the report:

dtStart = Nz(Me.StartDate,#1/1/1904#)
dtEnd = Nz(Me.EndDate,#1/1/2999#)
DoCmd.OpenReport "Report1", acViewReport, "", "[MyDate]>=#" & dtStart & "# And [MyDate]<= #" _
& dtEnd & "#", acNormal

--- OR ---

If Isnull(Me.StartDate) or Isnull(Me.EndDate) then
DoCmd.OpenReport "Report1", acViewReport, "", , acNormal
DoCmd.OpenReport "Report1", acViewReport, "", "[MyDate]>=#" & Me.StartDate & "# And [MyDate]<= #" & Me.EndDate & "#", acNormal
End If

The tricky part is getting tripped up by not including the #, designating a date literal.

Relevancy 59.34%

Hello all,

I have a my employees monthly tracking report in excel worksheet and I have to do some advance filter on each date (1 to 31 except Sundays). I am doing these steps manullay:-

1) Do Advance filter (I’ve done some VBA work). For example I filter data by date 1st, so that my code filter data by date one and remove duplicates from column “f” as well.

2) Copy the filtered data.

3) Paste it on a new sheet.

I want to do this Via VBA.. or any suitable way.. please help… I am attaching my sheet as well from which you can understand my code and update it according to my need..

A:Copy each advance filtered data (filter by date 1 to 31) to new sheet

Hi, welcome to the forum,
I'll take a look and see if I understand what you are asking.
Relevancy 59.34%

I am using Office 2007. I want to use a formula to auto calc data from other fields.

I have a sheet with results from races. The sheet has the following fields:

I am looking for a formula or function that will select the "1st" from the finished field, filter the grade to select a single grade (eg 4th), select a single track, select a single distance and then return the average of all the winning times that meet those other criteria.

Is there an excel function that will do this and if so could someone help me with an example of the formula to be used...........many thanks

Relevancy 59.34%

Hi I m looking for some help I think the code for this capability is Javascript I submits function database? Javascript that to m only coming out of my Javascript function that submits to database? noob-ness lately with codes So bare with me I m using a CMS called Pligg It s hard Javascript function that submits to database? to orientate people towards a new site So I thought I d just add a function to my current Conduit com toolbar I d like my users to be able to click a button and it submit the URL of the current page to my Pligg database OnlyWire do this and StumbleUpon Digg etc do it within the page content too And I run a forum so I know well software can submit forms lol So I don t see any reason why I shouldn t be able to do it too If someone could Javascript function that submits to database? teach me how to do this or make this object for me I m rich now I can afford to compensate with Euro Please help The Internet is about dreams I want to build mine nbsp

Relevancy 59.34%

I have no way in fixing this problem spent all night hrs n hrs no results pls. Windows 8.1 Dell Laptop database is out of date?
Relevancy 58.48%

I am creating a couple of access forms/databases for a client of mine and my issue is this:
On one of the forms my client needs to put in sale amount, license fees, delivery fees, taxes, minus any downpayment for car sales. I have the form and the database done except for the math function to do the computations. Is there any way to do this in access 03?

Thanks in advance for any help!!

Relevancy 58.05%

Hi all. I'm new in here. I am currently working on access97, and am having hard time trying to have Access97 automatically add current date/time to database, that way the operator wouldn't have to add date every time. How can I do this simple trick? I've searched in Access97's help assistant and that paperclip didn't meet my specific need. Thanks for your help in advance.

Relevancy 58.05%


My AVG Free Edition 7.1.362.267.12.7/155 11/01/2005 10:30:00 PM says my internal virus database is out of date and it's been like that for about a week. I've upated my AVG and it is set to update daily anyways. I have even tried uninstalling AVG and re-installing it but it still happens. Is my computer protected? Does anyone know how I can fix this problem?


A:avg internal virus database out of date and can't update

Have you tried to manually install the updates? Read this for more info:,27796,backpage=,sv=

Relevancy 57.19%

Is there a way to automatically enter today's date in a cell on an excel spreadsheet using a formula and then to have that date not change? For instance, I want to have the date something is assigned to enter automatically but then to remain the same and not change depending on the day.


A:Excel date function

Originally posted by Barbeela:
Is there a way to automatically enter today's date in a cell on an excel spreadsheet using a formula and then to have that date not change? For instance, I want to have the date something is assigned to enter automatically but then to remain the same and not change depending on the day.

Thanks! Click to expand...

Stole this from Paddy,

1) Hit alt + F11 to get to the vb editor
2) go insert | module
3) paste in the following:

Function DateAndTime()
DateAndTime = Now
End Function

4) use it in a formula of the sort:


which will produce a date & time stamp that records when a1 recieves a value.
Relevancy 57.19%

Ok, here is the deal, I am looking to set up a table somewhere, that when a monday rolls around, the formula/macro copies and pastes mondays date to a cell and clears contents on others. I know how to make a simple macro that does this, but it would require me to hit it. is there a way to automate the macro to trigger on mondays when opened???

Thanks again for any help you give....

Relevancy 57.19%

How do I code to return weekday and date in VBA? For instance I want it to return

Sunday, 1/23/11:

Thanks, Joe

A:Solved: VBA date function

I got it! Here it is:

Format(Date, "dddd") & ", " & Date & ": "
Relevancy 57.19%

I have a spreadsheet with a date field - I need to copy parts of the sheet to another worksheet. When I copy the dates they are inexplicably changed - Formatting has been meticulously checked. The most common change is that the month remains the same, the date is one day less than the original, and year is four years earlier. So 01/18/06 becomes 01/17/02 - happens in every date format. Over and over. Also, in the pick from list option for cell, there is a choice 2- 14. I don't know what this means or why it's there. Does it have something to do with my problem?(Moderator edit: post moved to more appropriate forum. jgweed)

A:Excel Date Function

Hi gretel
Are these two worksheets from different systems?
Sounds strange but in excel click Tools>Options>Calculations tab.
Under "work options' you'll see a "1904" date system.
If the sheet you're copying from and the sheet you're pasting to were built using the two different calander settings, that is your 1462 day difference.
Typicly the 1904 date system is used with a mac but it can also happen on windows systems if the systems that made the two sheets used different calander dating. Did I explain that clearly enough?
Rather then using paste, try paste special using one of the options that will popup instead.
Relevancy 57.19%

Can someone please tell me how to get excel to return the day of the week from the date in an adjacent cell.


Relevancy 57.19%

I was wondering if the date function for Javascript returns the date based on the client computer. If it does what if the client's computer has a wrong date set. Thanks.

A:Javascript date function

JavaScript is clientside itself, therefor if the visitor has their date set wrong it will appear wrong on the webpage. Alternatively you could use server side scripting, but that will read the time from the server which will be incorrect for people in different time zones. Hope that clears something up
Relevancy 57.19%

I am developing a simple spreadsheet in Excel, where I have two columns, one with certain dates and the opposite column with values relating to the dates.

As the values are already filled in, I don't want them to appear on the spreadsheet until the date arrives.

Any help appreciated, thanks

A:DATE function in Excel

Copy the data and paste in into a separate worksheet in the same spreasheet (Insert-Worksheet)
Then delete the data from the main spreadsheet.

Use a simple formula in the position where you want the data to appear, to only show the data if the date field is > 0

If the date is in A1 in sheet1, the data in A1 in sheet2 and the displayed data in A2 in sheet1 the the formula in sheet1 A2 is:

Relevancy 56.33%

WORKS SPREADSHEET QUESTION I m trying to figure out a way to use it to catalog my collection of RPM records but am stumped Basically I Works Database want to be able to sort them by record company or title or artist each data field think that s what its called -- I m totally unfamiliar with spreadsheets would contain at minimum something like this but would have room to expand a field if needed to get more data into it re a disc or the performer s DISC TITLE quot Espagnol Waltz quot Performed Works Database By Works Database Samuel Siegel Instrument Mandolin with Piano accompaniment Recorded Probably May Company Victor Talking Machine Company Label Master Take If known Comments Disc title is announced as quot Waltz Espagnol Mandolin Solo by Mister Samuel Siegel quot On some disc s the master take field may have to letters amp numbers in it But I cant get enough column width to type the info into A thru K amp have came to a stop nbsp

Relevancy 56.33%

I am working on a database for our Ambulance Company. One of the fields I am having trouble with is writing a formula to calculate response times when time enters another day.

Example, we use military time therefrore, 23:59:00 would be 11:59 pm. If we run the call till 00:10:00 ( 12:10 AM) the formula I have written ( = Arrival Time - Responding Time) gives me an invalid time because it doesn't recoginize I have gone past the current day into the next day.

Please help me figure out how to formulate this field.

Thank You.

Brett F. Murphy,
Paramedic Supervisor

Warsaw - Lincoln Ambulance District

A:Works Database


Working With Overtime Hours In Excel will show you how to write the formula in Excel.

It should work in in Works, but am unsure, as I do not use Works.
Relevancy 56.33%

Can anyone tell me how to set the print area in "Database"? I want to print a form which shows lots of names down the first column, and then has a blank "Signature " column next to it, but with horizontal gridlines to take their signatures.

When I look on "Print Preview" it only shows the "Names" column, and I can't get it to print a column next to it. If I remember corectly, there is a facility in Excel for this, but I can't find it in the Database application.

Any help would be appreciated.


Relevancy 56.33%

How can I export records in database to print mailing labels? or get the database to print them?

A:Works database

don't have works anymore (like a looong time ago) but since it's an Office-Lite product hopefully there's some similarities

maybe try the help feature for:
mail merge

in the database and word processing software (it's likely the same help file, so it may not matter)

here's the detailed FAQ page and
here's one about works 3 and creating labels

sounds fairly similar to the office procedures

good luck
Relevancy 56.33%

First time try. MS 98, Works database, MS Word file with a zillion names,addresses,ph#s,ect. I copy a name in Word, try to paste into a cell in d/b, I get "<picture>" in the cell, not the info I copied. Ive read the help files in Works, the archives in here. Any help will be greatly appreciated. Thank You. Andy

Relevancy 56.33%

Hi, i am trying to figure out a starting date based on a 360 day year, or 30 day months. I have the following information: End date, and the number of days that I need to go back to calculate the start date. For example: End Date = 9/14/08; Number of days to go back = 180. So the start date that i am looking to return is 3/14/08 (not 3/18/08), which can be verified using the =Days360() function. thank you in advance!

A:Need help in Excel with date function on a 360 day year

Relevancy 56.33%

Hey guys and gals!

Here's the scenario. I am currently designing a database to track equipment inspections along with the dates the inspections are performed.

I want to create a query to look at the inspection dates entered for equipment, and then list the records if the last inspection date entered, is older than 6 months.

Right now, I'm using


which lists all the inspection dates for each equipment if the dates are older than 6 months.

Can ya help?

Mucho Thanks!

Relevancy 56.33%

Excel 2007 - I have a date in a cell like this 20091125. It is text, it's a date but without the dashes or slashes to separate the year, month, day.
How do I convert it to 2009-11-25 date? Is there a function that reads it without the dashes yet recognizes it as a date?

Relevancy 56.33%

All I received a solution from from user Pass function Date value to quot jimmy The Hand Pass Date value from user to function quot which enables me to update the source of the linking file on an everday basis My question was related to a new linked source excel sheet everyday for my master target excel sheet and the naming convention for the source is quot mmddyy source xls quot so Pass Date value from user to function for th Pass Date value from user to function July - source xls th July - source xls -------------------------------------------------------------------------------------------------- The Solution Code was Private Sub Workbook Open Dim Rng As Range c As Range NewDate As String Dim WS As Worksheet Pos As Long Set WS ThisWorkbook Sheets quot Sheet quot Set Rng WS Range quot C quot WS Range quot C quot amp WS Rows Count End xlUp NewDate Format CStr Date quot mmddyy quot For Each c In Rng Cells Pos InStr LCase c Formula quot source xls sheet quot If Pos gt Then c Formula Replace c Formula Mid c Formula Pos - NewDate End If Next End Sub -------------------------------------------------------------------------------------------------- Is it possible for me to have a text box - where the user inputs a date and can I pass the date to the function above This way i dont need to worry about weekends and public holidays and gives the user the flexibility to run the script for a previous day also and not just the current Thanks in advance for your help Regards J nbsp

A:Pass Date value from user to function

Change the line NewDate = Format(CStr(Date), "mmddyy") to

NewDate = inputbox("Enter Date in MMDDYY format")

Another better option in my opinion is to designate an unused cell on the sheet to hold the date that the code will use. When the macro is run it would read from that cell to determine the date to use when updating the links.

Relevancy 55.9%

When I try to format a Feils, the program crashes. Downloaded KB933828, but it won't load. PaintShop Pro says it isn't a "valid MSP file".

Someone suggested that Works 9 works better on a Vista Home Premium machine.

Is that true?

Relevancy 55.9%

I'm using Works 2000 V.5 on 98SE. Want to retain grid lines when printing Also would like to create a custom form- none of the examples are useful.

A:Works 2000 database

I have that version, there's doesn't seem to be that option. As an alternative, try selecting the records and applying left -- right -- top -- bottom borders (via Format -- Border).

EDIT: my mistake ; File -- Page Setup -- Other Options.

By "custom form", do you mean an input form, like Access? Don't know, will look it up.

Relevancy 55.9%

For some obscure reason I cannot open some (not all) of my works db files.

I have downloaded the patch (KB933828), which is supposed to fix it but although it downloads ok, I can't seem to open the patch!

Can anybody help please?

Thx. Simon

Relevancy 55.9%

i have the latest version of works and am having a problem with it.

when using the left scroll gets "stuck" therefore not allowing me access to several of the fields on the left side of the document

i have played around with it and can't seem to get around it

can anyone help?
Relevancy 55.9%

We are trying to help out a friend here, and hoping someone can point us in the right direction.

We need to create a database, preferably a works database, because that's the program both of us have. What we need to do is collect statistics at the end of the day, and save all the results to one database. At the end of the year, we need to be able to go back in and total all occurrences of a particular statistic and combinations of certain statistics together.

I am TOTALLY GREEN in this area...can anyone help?? All suggestions are greatly appreciated....if more info is needed, please let me know!



A:Will a works database work?

Works will only "work" if it has an actual database like Access to enter your data into. You can set up one database and enter the data there directly. If you are on a network you can share the database and have forms set up for data entry. If you are in different locations you could use some kind of program like PCAnywhere and the remote person could dial in and do data entry on the database. There are way too many options so you might want to give us soem kind of idea on what your setup is and how to accomplish it.
Relevancy 55.9%

I have been tryin to sort records in WORKS 4.5 for 4 years now and it always sorts ALL the records. I have tried the highlight trick and even put blank records where I want to stop the sort. Does not work.

Can someone tell me how to sort, say, the 15 records in the middle of my database and not affect the other?


Relevancy 55.9%

Hi, I want to create a database of Asteroids with extensive information in one or more fields but I can't figure out how to expand the fields to allow this. On my dinosaur Tandy the database I had would create records just like index cards. I loved it. Any idea what I need to do? I've already tried the help and clicking everywhere.

Thank you.
Relevancy 55.9%

Been using Works for years and have never had this happen before. If I make a change in the database and try to SAVE, the program just closes, no error message. I re-open and the changes obviously have reverted to original state. I have run AdAWare, Spybot, AVG is up to date and runs nightly and am clean. I reinstalled MSWorks (just over the old program) and thought it was fixed, but now it is doing it again. Very frustrating Yes, I do get the message about more than 500 fonts, but since I have XP, I have been told that this is not critical anymore. Any ideas or suggestions? ... Millie in KY

Relevancy 55.9%

I have an address Works printing... Database book in the MS Works database which I use for mailing Christmas cards Using the quot older quot versions of Works it was very easy to set up the printing of envelopes in a batch process then just stuff in the Christmas cards amp lick the stamps I don t remember what the older version number was that enabled envelope printing as I have since sold my older computer Now that I have upgraded to a newer version of MS Works Ver I find that I cannot figure out how to print envelopes from the same database which I have imported to this PC Not only that but there is no Works Database printing... option in all the tabs for quot envelopes quot as there is in the earlier versions of Works My question is is there some work around or secret that I am missing here or has MS screwed up again and left that option out in the newer versions BTW my wife s laptop has version of MS Works and there is no envelope printing in that one either nbsp
Relevancy 55.9%

Does anyone know how many record entries (not fields) are possible in a MWDB file? I was working on an inventory list when suddenly the database would not accept any more entries. I didn't know if the was a limit. Is there any database that has no limit as to entries?

A:Microsoft Works Database

I know microsoft access 2003 used to be a file size limit of 2GB - so would not expect works to be bigger (although, not yet found the spec)

Whats the filesize you currently have?
Relevancy 55.9%

I have some Microsoft Works Database files I'd like to continue using, although MS Works has long disappeared. Does anyone know of a conversion technique/program to make these DB files usable with Microsoft Office. Seems like a step backward to not allow some kind of conversion for these files. I really liked Works DB.
Thanks in advance for any suggestions.

A:Update for Works Database

What version of Works was used to create these files and what version of Office are you using now.
Relevancy 55.9%

Hello At first I thought this was simple and it probably is but I just cant find a workable solution here I have a data entry form that I set the quot Data Entry quot option to quot Yes quot to allow multiple users to enter data through the form simultaneously This worked great Except for the Date field The form has a () Question Access 2003 Date Function field that would auto populate the current days date minimizing the time it took the data entry folks to do there job I used the tried and true Date function in the fields controls default value It worked grate as well right up until I turned Data Entry to Yes at which time the field on the form instead of autopopulation today s date now shows quot Name quot and the users are forced to delete that and type in the date manualy Seems like it should be simple solution to get the Date function workin in a quot Data Entry quot form anyone have a clue as to what that is nbsp

Relevancy 55.9%

I'm trying to write a function to return the last saved date from a given workbook. I understand the basic function to return this information from the active workbook, example below.

Function LASTSAVED()
LASTSAVED = ThisWorkbook. _
BuiltinDocumentProperties("Last Save Time")
End Function

What I want to do is to be able to return the last saved time for a given workbook within a different workbook.

Example I'm using VLOOKUP to pull in various order information and would like to show when the source from the table array was last saved.

Thank you in advance for your help.

Relevancy 55.9%

Hi I have 5 columns of data with the following column headings


I want to create a new query based on this table with an addional column headed "nextmatdate". This field picks the next date on from the currentmonth date.

Here are a couple of rows and the results I would like to achieve:

eg 1
matdateband1: 01/01/2012
nextmatdate: 01/01/2013

eg 2
matdateband1: 01/01/2012
nextmatdate: null

eg 3
matdateband1: 01/05/2012
nextmatdate: 01/05/2012

Hope this makes sense!!
Thanks for looking

A:Access function to find the earliest date in a row

tillyw, welcome to the forum.
What you want to do is not straightforward, because Null is not later than the CurrentMonth.
So it is going to take a complicated IIf() statement as the column heading, you could try this as a heading
nextmatdate: iif([matdateband1]>[currentmonth] or isnull([matdateband1]),[matdateband1])

This is only the first part of the calculation, but it will test if the Null gives you an error of "Improper Use Of Null".
If it doesn't we can add the other parts of the calculation

If it doesn't work it might take a VBA Module to do it.
Relevancy 55.9%

Hello, I was hoping someone could help me write a function in Excel. I have 2 columns as seen below. What I am trying to do is in a 3rd column have a function that looks at each ref number and returns the earliest date associated with each. For example, for ref. number 2 there are two date 6/22 and 6/23. I would want it to populate a new column with the earlier of the two dates. And the same for ref number 3,4,5 and so on. Is this possible. Thank you for your help.

Ref Num Date
2 6/22/2007
2 6/23/2007
3 5/22/2007
3 6/12/2007
5 5/24/2007
5 7/2/2007
6 5/23/2007
6 7/2/2007
9 6/26/2007
9 6/26/2007
9 6/26/2007
9 6/26/2007
10 6/14/2007
10 6/25/2007
11 5/29/2007
11 6/25/2007
12 6/21/2007
12 6/21/2007
12 6/21/2007

Relevancy 55.9%

Hi all Have started up a new machine and upgraded from Access to and transferred our database over We have just over records in the contact table which we update daily with the current date as various repeat contacts are made The relevant field is set to Long date Every evening we have a Word file that completes a mail merge to a database query that pulls records with the current date That query obtains its data from the contacts table Or at least function the =Date() query Access in Using 2003 it used to Since the change something has gone wrong and I Using the =Date() function in Access 2003 query cannot sort out what The query will not let me use the Date function in the criteria row As a test I set up a dummy database with a simple table and a single query In the query grid I added Date in the criteria row and low and behold it worked So obviously there is a problem in the original table Now I am lost Does anyone have any pointers please BigAl nbsp

A:Using the =Date() function in Access 2003 query

That is odd I have just answered another poster with date problems.
can you open your New table and check the Actual dates in the field ensuring that you expand it>
Does it have the "Time" in the field with the date, you may have to change the Date/Time format to Short or long time to see it?
Has the Date field always been "Long" date rather than Short date?
Also try in the Query in a new Column
Format([Your Date Field],"dd/mm/yyyy") and put the date() criteria in that column instead.
I have just checked it and it works whereas Long date with a time element won't.
Relevancy 55.04%

I want to create a new database using 'MS Works' 6.0 under Windows XP Home. I follow the 'Wizard's' instructions to launch "Create new blank data-
base" but I get no 'dialog box' from which to enter my new parameters. It just
gives me the last database I was observing. The 'wizard' tells me this is where I can make settings to configur my database to my needs, but it's not there. Am I doing something wrong, or is it a software problem?

A:MS Works has no 'Create Database' dialog box

I have MS Works 5 on one computer and MS works 7 on another, but they are both very similiar in the way they work. If you launch the MS Works Task Launcher and chose Works Database and then click on Start a blank database the box will come up for you to put in Field one -then add Field two, etc. (If a box comes up offering to show you what do to, just close it.) There are some differences between v. 5 & 7 when doing a mail merge, but that was not your question.
Relevancy 55.04%

Hi, hopefully this is the proper forum,but if not, perhaps an administrator would move it to the correct one. Anyhow, I've sent a MSWorks database file to an associate & he doesn't have works on his system, therefore has been unable to open it.(wdb extension) Can anyone provide me with the info of a possible download "viewer" that would enable him to open & print it?
Thanks in advance, Ben

Relevancy 55.04%

I have a databace in works database .wdb and need it to be a ms access .mbd file how can i do this seemingly simple task please?

A:convert works database to ms access?;en-us;q197894
Relevancy 55.04%

I am working with the Microsoft Works Database program that comes with Windows XP. I am listing a number of books, their isbn's and their prices. I evidently punched a wrong button because now every time I enter a new book the price from the previous entry is automatically entered for the new book. For example, if the price for the previous book was 19.99 that is automatically entered as the price for the next book.

It's not a big problem, because I can override it by simply entering the correct price, but still it's annoying. Anyone know how I can undo this default price setting?



A:Problem with Microsoft Works Database

Look in the Options of the program.
Relevancy 55.04%

Hi All,

Right now my "database" is a Word merge file that I use to insert merge fields in all my word documents, it's a bit archaic and slow, plus, there is no way to integrate with Outlook 2003. I tried Act! 2005, and its slow and clunky and wont work for my needs. I want to still be able to use all of my Word documents and all of the merge fields in them as well as update the database from Outlook, send emails to a sorted list, etc. Any suggestions?

Thanks, Roger.

A:Need database that works with Outlook and Word

To Roger:
Do You Have MS Office Suite installed on your computer? If so chances you have Msaccess, and i suggest you use access for your database. If msaccess is not installed get your office suite cd out and install the software. There is a learning curve, but give it a go and post your questions with the version of access your using and chances are someone will help.
Hope this helps, Flixx.
Relevancy 55.04%

Hi, I have a large list of items in a database that are numbered using a numbering row.They are then filtered to match certain criteria.So now the number row is no longer consecutive.What I want to do is make a new number row that tells me the occurence of each record happening.For instance,if my database stats at number 3 then the next number is 7,i want to have 7 -3 to give four.Basically,I want to know the distance between each record.If I could use a formula for the whole number row that would take a record and minus it from another?Thanks JIM

A:microsoft works database question

Help me please
Relevancy 55.04%

How can I get my MS Works database files to be able to be transferred to another program such as Open Office or Office? I have a lot of collected information in many files that I can't share with anyone else who doesn't have Works. The Office Database is far too complicated for me and much more powerful than I need for my own use.

A:Microsoft Works Database files

Did you TRY exporting?

A typical choice for database conversions is to export -> CSV format and then work with that
to create the imports. Hint: Export only one TABLE at a time.
Relevancy 55.04%

I recently installed Works 6.0. I have just composed a database document containing two columns of information. But when I print it, only the first column gets printed. I'm not aware of having done anything to cause the program to print less than all of the document. I have fooled around with the Select buttons and various other buttons but to no avail.

A:Works won't print all database columns

grandpaw7, you dumbell. You have the column too wide. If you bring the right hand margin of the column over to the left enough, you'll be in good shape.
Signed, grandpaw7

TO grandpaw 7: Well, I'll be dadburned if you're not right! But the dumbells are those guys who didn't program Works 6.0 to tell me the problem, but instead just decided not to print the column if it was too wide.
Signed: grandpaw7

Relevancy 55.04%

Use XP OS and Works Got the following error message when I tried to open my document which I d been working on all day It is my time sheet and now I can t open it and I ve lost ALL my billing for October I ll donate Works message MS error database big bucks if someone can help Microsoft paid support MS Works database error message is a joke This has been a problem with earlier versions according MS Works database error message to my Google search but was supposed to be fixed with the version - but obviously MS Works database error message it s still an issue Here s the error message There was a serious error loading the data Your document appears to be damaged Works will stop loading the document with what was read when the error occurred Please try loading a recent backup copy of this document My backup won t open either so I m really screwed I m serious about the donation Please help me get this file opened Thanks in advance for your help nbsp

Relevancy 55.04%

Can anyone please let me know where I can get for free an easy to setup download counter(a counter that counts how many times a certain files been downloaded), which also uses Access Database(s). Or, brendandonhu, if you don't mind, could you make one for me and post the source??? You'll need the following to connect to an access DB:
Set oConn = Server.CreateObject("ADODB.Connection")
sConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=\\premfs7\sites\premium2\membername\database\YourDB.mdb;" & _
"Persist Security Info=False"



Relevancy 55.04%

Hey there Hope someone can help me out having a very perplexing problem that is happening in Microsoft Works with a database that my work has been using over the years without any problems The only way to explain it is that when you work on the database one day the next day some of the information disappears in the report view mode no one is deleting it The columns A to F seem to go missing Now A-F are the ones containing the data I need I dont know if makes any difference if I were to put that missing information back into those cells into columns from H onwards How can I get those missing A-F columns back Works problem Microsoft database Does anyone have any idea why they go missing periodically Just recently after a hardware upgrade this has started to happen I know that the version we are using of Works is Would upgrading the software help this problem Would appreciate anyones input greatly nbsp
Relevancy 55.04%

I have completed my database. I put one column in alphabetical order, and proceed to another, the column I just alphabetized goes back the way it was. They won't all stay alphabetical. What's the deal? Help?

A:works suite 2003 database

This happens in Excel too, putting a column in alphabetical order is assumed to mean that you want all the rows to still contain the original values.

In Excel, you can highlight the data in the column and this sorts only that column - Then move on to the next column, etc.

If that doesn't work in Works, you may want to
sort the first column,
cut and paste the remaining columns into separate worksheets (one column, one worksheet) and
then sort them,
then copy them all back...
Relevancy 55.04%

Does anyone know of an app that will open the above, apart from works! and preferably free?

A:Works Database File Viewer

For anyone whose interested/had the same problem it seems that there is no such thing as a "viewer" the best option though I've yet to try it is to save the file as a .csv and open it with open office. If you just want to view the data and copy and paste what you want it can also be saved as a text file - this is all assuming you or someone has access to Ms Works, as a last resort you can open the .wdb file with notepad or wordpad though its a lot more messy to access what you want. - hope this helps.
Relevancy 55.04%

Hello won't update and Time/Date messed function scanners up I posted this a couple of days ago but I don't see it anywhere I followed all the necessary steps and just did a fresh Highjack log I'd appreciate some feedback about whether you see anything suspicious Logfile of HijackThis v Scan saved at PM on Platform Windows XP SP WinNT MSIE Internet Explorer Time/Date function messed up and scanners won't update v Running processes C WINDOWS System smss exe C WINDOWS system winlogon exe C WINDOWS system services exe C WINDOWS system lsass exe C WINDOWS system svchost exe C WINDOWS System svchost exe C WINDOWS Explorer EXE C WINDOWS system ctfmon exe C Program Files Internet Explorer IEXPLORE EXE C HJT HijackThis exe R - HKCU Software Microsoft Internet Explorer Main Start Page http www google ca R - HKLM Software Microsoft Internet Explorer Main Default Page URL http go microsoft com fwlink LinkId R - HKLM Software Microsoft Internet Explorer Main Default Search URL http go microsoft com fwlink LinkId R - HKLM Software Microsoft Internet Explorer Main Search Page http go microsoft com fwlink LinkId R - HKLM Software Microsoft Internet Explorer Main Start Page http go microsoft com fwlink LinkId R - HKCU Software Microsoft Windows CurrentVersion Internet Settings ProxyServer proxy O - BHO Adobe PDF Reader Link Helper - E F-C D - D -B D- B D BE B - C Program Files Adobe Acrobat ActiveX AcroIEHelper dll O - BHO no name - - F - D - - D F - C PROGRA SPYBOT SDHelper dll O - BHO SSVHelper Class - BB-D F - C-B EB-D DAF D D - C Program Files Java jre bin ssv dll O - HKLM Run SiSUSBRG C WINDOWS SiSUSBrg exe O - HKLM Run Cmaudio RunDll cmicnfg cpl CMICtrlWnd O - HKLM Run SunJavaUpdateSched C Program Files Java jre bin jusched exe O - HKLM Run REGSHAVE C Program Files REGSHAVE REGSHAVE EXE AUTORUN O - HKLM Run avgnt quot C Program Files AntiVir PersonalEdition Classic avgnt exe quot min O - HKLM Run iTunesHelper quot C Program Files iTunes iTunesHelper exe quot O - HKCU Run MSMSGS quot C Program Files Messenger msmsgs exe quot background O - HKCU Run MsnMsgr quot C Program Files MSN Messenger MsnMsgr Exe quot background O - HKCU Run ctfmon exe C WINDOWS system ctfmon exe O - Global Startup Adobe Reader Speed Launch lnk C Program Files Adobe Acrobat Reader reader sl exe O - Global Startup hpoddt exe lnk O - Extra context menu item amp Search - http edits mywebsearch com toolbar p ZNxmk DTCA O - Extra context menu item E amp xport to Microsoft Excel - res C PROGRA MICROS OFFICE EXCEL EXE O - Extra button no name - B E C - FCB- CF-AAA - C - C Program Files Java jre bin ssv dll O - Extra 'Tools' menuitem Sun Java Console - B E C - FCB- CF-AAA - C - C Program Files Java jre bin ssv dll O - Extra button no name - d f - f - d - - c a - windir bdoscandel exe file missing O - Extra 'Tools' menuitem Uninstall BitDefender Online Scanner v - d f - f - d - - c a - windir bdoscandel exe file missing O - Extra button Research - B - CC- C -B BE- C C A - C PROGRA MICROS OFFICE REFIEBAR DLL O - Extra button no name - e e dd -d - - b -f ba - windir Network Diagnostic xpnetdiag exe file missing O - Extra 'Tools' menuitem xpsp res dll - - e e dd -d - - b -f ba - windir Network Diagnostic xpnetdiag exe file missing O - Extra button Messenger - FB F -F - d -BB E- C F - C Program Files Messenger msmsgs exe O - Extra 'Tools' menuitem Windows Messenger - FB F -F - d -BB E- C F - C Program Files Messenger msmsgs exe O - Options group INTERNATIONAL International O - DPF D DDB -BDF - B- E E-D F EE BDSCANONLINE Control - http download bitdefender com reso an oscan cab O - DPF ED - B- DA -BF -BE C EC Windows Live Safety Center Base Module - http cdn scan safety live com reso scbase cab O - DPF B-B - D-A D -FCFDF E C WUWebControl Class - http update microsoft com windowsu O - DPF B BFD- E - -B AF- A B EA WScanCtl Class - http www ca com securityadvisor v fo webscan cab O - DPF B -A - E - -D E TLIEFlashObj Class - https rtc webresponse one microso TLIEFlash CAB O - DPF A ... Read more

A:Time/Date function messed up and scanners won't update

n/m I see you are being helped in another thread. Please continue posting there.
Relevancy 54.61%

Creating a To Do list, I would like to insert a non-volatile date as the date this task was assigned. 1/23/06 would be fine. Can I do that using a function? I checked - didn't solve my specific need, but I did learn there the concept of "volatile". Thanks.

A:Solved: Excel 2000 - non-volitile date function sought

Answering my own question --

Google search on [excel and "non-volitile date"] returned a single hit and answer in another forum(?) Quoted here, but abridged:
[posted on: May 30, 2003 1:02 PM by kevlinbert]
The easist way to enter a non-volitile date is with a quick macro:

Alt F11 to open the vBasic editor
Double click on the Workbook item in left hand window, then paste the following into the window on the right hand side:

Sub Todays_Date()
ActiveCell.Value = Now()
End Sub

Close the editor and return to Excel, then chose Tools/macro/macros... and 'Options' to give it a shortcut.

This will paste the current date (and time) into the active cell."

Then to format to 1/23/06, highlight the column, right click, format cells, category date,
type 3/14/98.
Relevancy 54.61%

After a major crash I lost all of the Works Suite and had to reinstall it. Now the database crashes everytime I try to use it. Norton intercepts the crash and gives me this message:
Everything else in the Suite works fine.
I need some help.
Thank you

Relevancy 54.61%

hello all, i have one doubt. will LIMIT clause works with MS-ACCESS database? if it works the please explain how it will works....
i tried a lot by giving LIMIT clause in SELECT statement but every time it will give error. and when i remove that LIMIT part it will work fine.

pleeeeeease some body knows pagination in PHP with MS-ACCESS database support? please provide me that code,, plz.....
Relevancy 54.61%

Working on a Database program, and misspelled name of a field -- Cmopany instead of Company -- and cannot find a way to correct this without having to cut and paste everything already in this Database to a new one!

Is there a way to correct spelling errors in a Field Name, and if so, how is it done?

A:Works DataBase 6.0 ... How Do you change Field Names

Howdy. If I understand you correctly, select the table, then right-click and choose Design View. On the left is the name of each field. Change it there. When you try closing it, it will ask if you want to save changes. Obviously, Yes.
Relevancy 54.61%

Since installing Windows 10, I need to print a DVD database that I created on Microsoft Works Suite 2005. The error message I receive is "no default printer" or some such wording. The default printer IS set, and printing from any other site or app works fine. The laptop is a Lenovo, and the printer is Kodak. However, I do not see that the problem is in either of those, since it prints other things. When I look at compatibility for Windows 10, it reads that the Works 2005 is compatible. Please help, as frustration abounds. Thanks.
Relevancy 54.61%

I was just dragged into the st century not sure I like it at all Win was near values to 9 database ms to from copy spreadsheet works trying - death so I purchased a new computer with Vista bit but that's another story I have used MSWks for years and know my way around it Having a problem with MSWks - have a bank deposit system set up using a database for deposits with reports created that print my ms works 9 - trying to copy values from database to spreadsheet deposit slips and a deposit summary With MSWks I was able to copy values from my deposit database to a spreadsheet that was designed to act like a mini calculator - copied list of checks from deposit and used formula to total then copied total and pasted it back to database In MSWks if I try to copy values from deposit DATABASE and paste to a SPREADSHEET it arrives as a graphic instead of a numeric value so my formula that forces the spreadsheet to be a mini-calculator will not work Is ms works 9 - trying to copy values from database to spreadsheet there any way to defeat the quot paste as graphic quot It was really a timesaver for me I did try to install MSWks on Vista machine and was successful But ran into a lot of problems with both programs on my computer Decided to forget about the recording function and tough it out with MSWks Thanks tbach
Relevancy 54.61%

Hey all. My dad is having an issue with his computer that I've been unable to figure out, whether by my own means or just by searching. He is running Microsoft Works 6.0 on Windows Vista 32bit Home Edition, and is having some trouble printing from Works Database, which he uses quite a lot.

Whenever he tries to print something from Database (or go into print preview) he gets the following error:

The printer driver is missing or not valid.

Run the Windows Setup program to install the printer software again.
Naturally I have uninstalled and reinstalled the printer several times, but to no avail. Also an important note: This issue ONLY happens with Works Database, and not with any other product (Microsoft or otherwise).

If anyone has any suggestions it would be greatly appreciated

A:Microsoft Works Database printing issue

I have been doing more research and I'm starting to think that there is just a compatibility issue. I'm still wondering if anyone knows how to make this work with Vista.

If anyone has any suggestions on a program that is an alternative to Microsoft Database, that would also be pretty helpful. It's the only program my dad uses from the Works Suite.

Thanks again...
Relevancy 53.32%

Hi all - running WLM on my clone fine new initially - Database then on vanishes works WLM machine Windows Netbook using accounts - all perfect Needed a clone on my Windows Desktop machine with exact WLM Database clone on new machine initially works fine - then vanishes Database Navigation and Folder Tree for same accounts as a final message destination setting my Netbook to quot Leave messages on server quot for mobile usage So Installed WLM on Desktop fine Copied cloned Database from Netbook over to AppData Local Microsoft Windows Live Mail Worked immediately like a charm all folders and messages in exact WLM Database clone on new machine initially works fine - then vanishes same folder tree and accounts passwords WLM Database clone on new machine initially works fine - then vanishes to input manually one OK Hurray However after - shut down start-ups of WLM the entire folder tree collapsed into a basic tree consisting of just basic INBOX DRAFT SENT Unwanted Mail Deleted for each account showing no messages although all cloned data was still resident on disc in its correct above location No way to retrieve nor show any messages nor the intended navigational structure - vanished although data was in its original location Uninstalled WLM delete clone Database did the whole operation over again and hey presto everything back OK After - shutdowns startups of WLM the navigation Folder Tree collapsed back into basic -line account blocks not showing any messages although all of them still reside in AppData Local Microsoft Windows Live Mail What is this How can initially everything run fine as intended and then vapourise Driving me mad as I did the exercise times now Also any reboot makes the initially nicely working folder tree AND messages visually disappear Anyone a clue why initially everything works as intended -- and then deconstructs and disappears Driving me bonkers - as I need this structure it is there and then after - uses vanishes Looking forward to your suggestions - Sam The Netherlands

A:WLM Database clone on new machine initially works fine - then vanishes

Hi Sam, welcome to Seven Forums.
It could be down to how your mail accounts are set-up.
I sign-in to WLM 2012 on both my pc's with the same Microsoft account but only use my Gmail account. If I read a message on my Desktop it will not be available on my Laptop as Gmail archives messages when accessed by POP.
Do you use POP or IMAP ???
Relevancy 53.32%

In Explorer, is there any way to do a search for files CREATED on a specific date or within a range of dates? I've found the search filter using "Date modified" but not "Data created".

The old XP "Search companion" did it, but that's no longer available in Windows 7, as far as I know.

A:Q: "Date created" Search filter?

Try typing DATE CREATED: in the Explorer search box.You should be able to select the date (or a range of dates) from a mini-calendar that appears.
Relevancy 52.89%

I have a fill-able PDF created in Adobe Acrobat Pro. I set it to expire at the end of the year. However, all the end user has to do is to download the file and save it with another name and the expiration no longer works. They can use it indefinitely. Only if the user does not rename the file does the file expire correctly. I need the file to expire as this is a constantly updated/revised PDF and its important that my customers have the most current version. Is there a way to fix this either with Adobe or a third party app?

I have not been able to find any information online or from Adobe as to why this happens.
Relevancy 52.46%

I update my lenovo Z - to windows and the F Function Key Airplane Mode doesn't work In past I F7 doesn't Len... in Function airplane works Key mode had installed Windows but my original S O was by factory default and when I update it to Win the funtionality of this F Funtion key I did not F7 Function Key airplane mode doesn't works in Len... care But now when I recently update it to W I remember that this F Fn key doesn't works nbsp I was looking for an inmediate solution by web and nbsp I tried with diferent options and nothing nbsp I used this optionshttp support lenovo com us en downloads ds http support lenovo com us en downloads ds http support lenovo com us en downloads ds nbsp I attach a couple of pictures about system properties where is posible to see some diferences between W and W https drive google com open F7 Function Key airplane mode doesn't works in Len... id B b F7 Function Key airplane mode doesn't works in Len... I sivs WGt R NpdmxGek nbsp I can nbsp see special devices called like nbsp Lenovo Pointing DeviceLenovo Virtual Keyboard DeviceDDP UMDF driver nbsp and more that in Win is imposible to nbsp see installed nbsp I need to solve this problem and if is nbsp posible that someone help me nbsp Thanks in advanced
Relevancy 52.03%

I am pretty new to this stuff so bear with me I think my wife downloaded something that she is not owning up to it Here is my log and I appreciate any help you could give me Logfile of Trend Micro HijackThis My Can Not And Help! Function, The Ctr-alt-del Run Load, Mouse Cursor Works From Desktop I Does v Scan saved at PM on Platform Windows XP SP WinNT MSIE Internet Explorer v Boot mode NormalRunning processes C WINDOWS System smss exeC WINDOWS system winlogon exeC WINDOWS system services exeC WINDOWS system lsass exeC WINDOWS system svchost exeC WINDOWS System svchost exeC Program Files Common Files Symantec Shared ccSetMgr exeC Program Files Common Files Symantec Shared ccEvtMgr exeC WINDOWS system spoolsv exeC PROGRA Grisoft AVG avgamsvr exeC PROGRA Grisoft AVG avgupsvc exeC WINDOWS system basfipm exeC Program Files Symantec AntiVirus DefWatch exeC Program Files Common Files Microsoft Shared VS DEBUG MDM EXEC WINDOWS system HPZipm My Desktop Does Not Load, Mouse Cursor Works And I Can Run From The Ctr-alt-del Function, Help! exeC Program Files Symantec AntiVirus SavRoam exeC WINDOWS system svchost exeC Program Files Symantec AntiVirus Rtvscan exeC Program Files Viewpoint Common ViewpointService exeC Program Files Canon CAL CALMAIN exeC Program Files Common Files Symantec Shared Security Center SymWSC exeC WINDOWS system wuauclt exeC WINDOWS system taskmgr exeC Program Files Viewpoint Viewpoint Manager ViewMgr exeC HIJACK HijackThis exeR - HKCU Software Microsoft Internet Explorer Main Default Page URL http www dell com R - HKLM Software Microsoft Internet Explorer Main Default Page URL http go microsoft com fwlink LinkId R - HKLM Software Microsoft Internet Explorer Main Default Search URL http go microsoft com fwlink LinkId R - HKLM Software Microsoft Internet Explorer Main Search Page http go microsoft com fwlink LinkId R - HKLM Software Microsoft Internet Explorer Main Start Page http go microsoft com fwlink LinkId O - BHO amp Yahoo Toolbar Helper - D -C F - efb- B - ECA - C Program Files Yahoo Companion Installs cpn yt dllO - BHO AcroIEHlprObj Class - E F-C D - D -B D- B D BE B - C Program Files Adobe Acrobat Acrobat ActiveX AcroIEHelper dllO - BHO SSVHelper Class - BB-D F - C-B EB-D DAF D D - C Program Files Java jre bin ssv dllO - BHO AcroIEToolbarHelper Class - AE CD -E - f- - EE - C Program Files Adobe Acrobat Acrobat AcroIEFavClient dllO - Toolbar Adobe PDF - -D C - - FA - E EAAC - C Program Files Adobe Acrobat Acrobat AcroIEFavClient dllO - Toolbar Yahoo Toolbar - EF BD -C FB- D - F- D F - C Program Files Yahoo Companion Installs cpn yt dllO - HKLM Run IgfxTray C WINDOWS system igfxtray exeO - HKLM Run HotKeysCmds C WINDOWS system hkcmd exeO - HKLM Run SunJavaUpdateSched C Program Files Java jre bin jusched exeO - HKLM Run QuickTime Task quot C Program Files QuickTime qttask exe quot -atboottimeO - HKLM Run TkBellExe quot C Program Files Common Files Real Update OB realsched exe quot -osbootO - HKLM Run REGSHAVE C Program Files REGSHAVE REGSHAVE EXE AUTORUNO - HKLM Run ccApp quot C Program Files Common Files Symantec Shared ccApp exe quot O - HKLM Run vptray C PROGRA SYMANT VPTray exeO - HKLM Run ISUSPM Startup C PROGRA COMMON INSTAL UPDATE ISUSPM exe -startupO - HKLM Run HP Software Update C Program Files HP HP Software Update HPWuSchd exeO - HKLM Run AVG CC C PROGRA Grisoft AVG avgcc exe STARTUPO - HKLM Run QUICKCARE C Program Files Qwest QuickCare bin sprtcmd exe P QUICKCAREO - HKLM Run KernelFaultCheck systemroot system dumprep -kO - HKCU Run ctfmon exe C WINDOWS system ctfmon exeO - HKCU Run MSMSGS quot C Program Files Messenger msmsgs exe quot backgroundO - HKCU Run MsnMsgr quot C Program Files MSN Messenger MsnMsgr Exe quot backgroundO - HKUS S- - - Run AVG Run C PROGRA Grisoft AVG avgw exe RUNONCE User 'LOCAL SERVICE' O - HKUS S- - - Run AVG Run C PROGRA Grisoft AVG avgw exe RUNONCE User 'NETWORK SERVICE' O - HKUS S- - - Run AVG Run C PROGRA Grisoft AVG avgw exe RUNONCE User 'SYSTEM' O - HKUS DEFAU... Read more

A:My Desktop Does Not Load, Mouse Cursor Works And I Can Run From The Ctr-alt-del Function, Help!

I'd appreciate any help, here is a new Hijack this log since I posted my first one. This log was taken after I had completed All the prerequisites for posting a log on this site.ThanksLogfile of Trend Micro HijackThis v2.0.2Scan saved at 7:03:41 PM, on 8/21/2007Platform: Windows XP SP2 (WinNT 5.01.2600)MSIE: Internet Explorer v7.00 (7.00.6000.16512)Boot mode: NormalRunning processes:C:\WINDOWS\System32\smss.exeC:\WINDOWS\system32\winlogon.exeC:\WINDOWS\system32\services.exeC:\WINDOWS\system32\lsass.exeC:\WINDOWS\system32\svchost.exeC:\WINDOWS\System32\svchost.exeC:\Program Files\Sygate\SPF\smc.exeC:\Program Files\Common Files\Symantec Shared\ccSetMgr.exeC:\Program Files\Common Files\Symantec Shared\ccEvtMgr.exeC:\WINDOWS\system32\spoolsv.exeC:\Program Files\Lavasoft\Ad-Aware 2007\aawservice.exeC:\PROGRA~1\Grisoft\AVG7\avgamsvr.exeC:\PROGRA~1\Grisoft\AVG7\avgupsvc.exeC:\WINDOWS\system32\basfipm.exeC:\Program Files\Symantec AntiVirus\DefWatch.exeC:\Program Files\Common Files\Microsoft Shared\VS7DEBUG\MDM.EXEC:\WINDOWS\system32\HPZipm12.exeC:\Program Files\Symantec AntiVirus\SavRoam.exeC:\WINDOWS\system32\svchost.exeC:\Program Files\Symantec AntiVirus\Rtvscan.exeC:\Program Files\Viewpoint\Common\ViewpointService.exeC:\Program Files\Canon\CAL\CALMAIN.exeC:\Program Files\Common Files\Symantec Shared\Security Center\SymWSC.exeC:\WINDOWS\system32\wuauclt.exeC:\Program Files\Viewpoint\Viewpoint Manager\ViewMgr.exeC:\WINDOWS\system32\taskmgr.exeC:\HIJACK\HijackThis.exeR1 - HKCU\Software\Microsoft\Internet Explorer\Main,Default_Page_URL = - HKLM\Software\Microsoft\Internet Explorer\Main,Default_Page_URL = - HKLM\Software\Microsoft\Internet Explorer\Main,Default_Search_URL = - HKLM\Software\Microsoft\Internet Explorer\Main,Search Page = - HKLM\Software\Microsoft\Internet Explorer\Main,Start Page = - BHO: &Yahoo! Toolbar Helper - {02478D38-C3F9-4efb-9B51-7695ECA05670} - C:\Program Files\Yahoo!\Companion\Installs\cpn\yt.dllO2 - BHO: AcroIEHlprObj Class - {06849E9F-C8D7-4D59-B87D-784B7D6BE0B3} - C:\Program Files\Adobe\Acrobat 6.0\Acrobat\ActiveX\AcroIEHelper.dllO2 - BHO: (no name) - {53707962-6F74-2D53-2644-206D7942484F} - C:\PROGRA~1\SPYBOT~1\SDHelper.dllO2 - BHO: SSVHelper Class - {761497BB-D6F0-462C-B6EB-D4DAF1D92D43} - C:\Program Files\Java\jre1.5.0_06\bin\ssv.dllO2 - BHO: AcroIEToolbarHelper Class - {AE7CD045-E861-484f-8273-0445EE161910} - C:\Program Files\Adobe\Acrobat 6.0\Acrobat\AcroIEFavClient.dllO3 - Toolbar: Adobe PDF - {47833539-D0C5-4125-9FA8-0819E2EAAC93} - C:\Program Files\Adobe\Acrobat 6.0\Acrobat\AcroIEFavClient.dllO3 - Toolbar: Yahoo! Toolbar - {EF99BD32-C1FB-11D2-892F-0090271D4F88} - C:\Program Files\Yahoo!\Companion\Installs\cpn\yt.dllO4 - HKLM\..\Run: [IgfxTray] C:\WINDOWS\system32\igfxtray.exeO4 - HKLM\..\Run: [HotKeysCmds] C:\WINDOWS\system32\hkcmd.exeO4 - HKLM\..\Run: [SunJavaUpdateSched] C:\Program Files\Java\jre1.5.0_06\bin\jusched.exeO4 - HKLM\..\Run: [QuickTime ... Read more
Relevancy 52.03%

I've had this problem for years now both on an older HP laptop running XP with SP2 and now on an Acer 4670 laptop running XP & SP2 as well and it's now drivimg me mad. You can adjust the volume, of say, Media Player by holding down the function key (Fn) and pressing the up and down arrows (normally bottom right of keyboard) which will then display a green display at the bottom of the screen. Same thing happens on the Acer when you switch on either Bluetooth or Wi-Fi using the hardwired buttons on the front you get the green message saying either "Disabled" or "Enabled". But this display deactivates and reactivates itself at random (currently it's off) If I go into Sounds and Audio Devices and play around with the controls it sometimes comes back on. It's now beginning to really P*** me off. Anybody got any ideas? Thank-you, thank-you and thank-you once more. . . .

A:[SOLVED] XP volume function key shoprt cut no longer works. . .

Moved you to Microsoft Support/XP support.

I would re-install the sound drivers from Acer's web site. See if that fixes it.
Relevancy 52.03%

Hello I am new to VBA and still have to learn some of the basics but I am trying to learn as I go I am trying to code an Array Function in Excel VBA to take a range of dates and get the maximum value date that is less than a given value the constraint which works in Excel a Function code Trying an to MaxIF as to Array VBA would also be a Trying to code an Array Function in VBA Excel to works as a MaxIF date I will be using this function in a macro though I can t seem to get it to work The code currently will run but the value given is a VALUE Error that tells me that quot A value used in the formula is the wrong type quot Here is what I currently have Here is the text version so you can copy paste Function MaxIf Array List Constraint As Double Function takes a list and returns the Max value that is below a given constraint Dim Const Array As Variant Dim Cell As Range Dim SmallerThan As Long Transfer data to Const Array while filtering for data smaller than Constraint For Each Cell In List If Not Cell gt Constraint Then SmallerThan SmallerThan ReDim Preserve Const Array To SmallerThan Const Array SmallerThan Cell Value End If Next Cell Use the Worksheet Max function on values in Array MaxIfArray WorksheetFunction Max Const Array End Function Any help would be appreciated Thanks nbsp

A:Trying to code an Array Function in VBA Excel to works as a MaxIF

Never mind. I was able to figure it out by using a Function Array. Thanks anyway!

Dim LastRow As Long
LastRow = Range("AB" & Rows.Count).End(xlUp).Row

ActiveCell.FormulaArray = _
"=MAX(IF(IF(R[4]C[-33]:R[" & LastRow - 1 & "]C[-33]=""BATCH"",R[4]C[-18]:R[" & LastRow - 1 & "]C[-18])<R[1]C[3]+0.41667-1,R[4]C[-18]:R[" & LastRow - 1 & "]C[-18]))"
Relevancy 52.03%

I have Windows 7 (upgraded from Vista). At first I was able to use the (Windows) Explorer search function with success. Now it is not working. But here is the strange thing: it works in some folders, but not others. Does this mean that the function is turned off somewhere for the folders where it is not working?

I am able to use Google Desktop to locate what I am looking for, but I want Windows Explorer's search function to work in any folder I need to search.

Any help would be greatly appreciated!

A:Search Function in Windows Explorer Works Only Erratically
suggest you rebuid the index not sure what will happen with google as well though i imagine it will be a resource drain
Relevancy 52.03%

Hi everyone, Yesterday, I have upgraded my PC to windows 10.After, completing the installation process, all my function key works expect BRIGHTNESS keys. Please, specify a way to get my keys in working condition.
Relevancy 52.03%

Anybody know what combination of keys will do this?

A:Insert date / time in Works spreadsheet?

Why aren't you using Excel. Has much more functionality. I have a macro that I use for Time Stamping cells in Excel. Puts the Current Data and Time in a cell with the single click of a mouse.
Relevancy 52.03%

Does anybody know the key combination to insert the date or time in a cell? Does Works spreadsheet even have these shortcut keys?

Relevancy 52.03%

Hello This is my first thread here
I was wondering if anybody could please help me, I have a lot of photographs stored on my laptop...which is running Windows 7....and I'm trying to sort them into folders (I have a LOT of photographs). I'm still only learning how funky Windows 7 is but have now come across some problem. When-ever I ask Windows to group by date (even group by date modified...etc) it doesn't actually show the date at the top of each group.

Whatever version of Win I had before always put the actual date as the name of each was VERY there any tweak or box to click (or even some sneaky hack) that would fix this so it would give the date? Ty

A:Is it possible to change how 'group by date' works in Windows 7?

Try Arrange by->Day.
Relevancy 51.17%

I have been trying to help a friend learn how to do form letters with his Microsoft Works Suite programs He has Windows XP SP We were able to successfully merge desired fields from a Works database but noticed that the format of date and time field results was not as desired The date field always merged as quot MM DD YYYY quot in the form letter no matter what format was used for date display in the database program He wanted to display for in Merging fields Suite or date Works time example quot November quot instead of quot quot Likewise the time field merged Merging date or time fields in Works Suite as quot hh mm ss AM Merging date or time fields in Works Suite PM quot when he wanted for example quot PM quot to display In Works on another computer his formatting carried over to the form letter from the database Not so in the version Our temporary fix was to format the date amp time fields in the database as quot text quot instead of quot date quot or quot time quot and then enter the exact display style wanted Then the merged value looked the same in the letter as it did in the database Is there a better solution to this problem nbsp
Relevancy 50.74%

ms works word processor failes to create labels using label function.
before win xp sp2 lablel function worked on my ms works word processor.
after installing win xp sp2 my label function does not work. will not connect
to my outlook express 6 adress book. Need help. this is after installing
xp sp2.
Relevancy 50.74%

Hi there,

When I turn on my computer (running Windows XP), it seems to boot up fine, but a few seconds after the desktop appears, the screen goes black for a few seconds. Then the desktop appears for 4-5 seconds, then the screen goes black. This just reapeats over & over and the computer seems frozen. There is also a little red 'X' hanging out in my toolbar, who looks especially evil. As time passes, the toolbar becomes warbled.

I rebooted my computer in Safe Mode, which works fine & have been trying to fix it from here all day. I tried following the 8 steps to rid/protect your computer from malware/viruses, but some steps can't be completed in Safe Mode.

Can you please help?

Relevancy 49.88%

We implemented ATA beginning on 3/15/2016 with two Gateways and one Central Server.  We've discovered that a few servers that are doing LDAP simple bind, which we've resolved by enabling LDAPS.  We have a server that's waiting on the Vendor to
provide a patch, so this single server continues to alert periodically. 
In the ATA error alert, "services exposing account credentials", the "export" function appears to have stopped updating the export.   The web-view shows current events (4/1/16), but the "export to excel" stops at 3/23/2016
in repeated attempts. The similar error (& cause), "sensitive account credentials exposed", is working correctly in its exports.  The system reports "Hooray, system is health!"  Servers have been rebooted, Webpages refreshed,
services restarted, etc...  
Any ideas?
Relevancy 49.88%

I ve tried to send a delayed email using the quot in "Do Time/Date Stamp Deliver Function using when Before" Not Outlook Do Not Deliver Before quot function Hoping the email would be date time stamped when I wanted the recipient to receive the email For example sent the email on a Tuesday and scheduled the email to be delivered the next day Wednesday at am The function did delay sending the email but the date time stamp was when I originally hit sent on Tuesday What is the purpose of this feature if the date time stamp will not indicate the date time I wanted the recipient to receive the email When using this function is there a way for the exchange to track the date time stamp of the email when it actually leaves the Outbox instead of when you click send I understand the exchange keeps track of the date time stamp of when an email is sent but why couldn t the exchange keep track of when the email leaves the outbox when using this function Time/Date Stamp when using "Do Not Deliver Before" Function in Outlook Is there any exchange setup that will make this function work the way it is supposed to Thank you nbsp
Relevancy 49.88%

Hi, I have been having a problem on and off on my Inspiron 1520. The problem is that when Itunes updates it screws up the CD-DVD drive so it wont read a CD or DVD and I need to go into the registry and delete the filters. Unfortuantly yesterday I attempted to rectify this problems once again and when I went into the registry, there was no upper or lower filters. Microsoft has a program that detects and fixes CD/DVD drive problems and that could not fix it either. Any Help? Im running Windows Vista 32-bit

A:DVD drive trouble with Upper Filter & Lower Filter Registry entries

Are all Windows Updates in, including Vista SP2?

Relevancy 48.16%

I have a WRT110 router with a Lingo voip connected via ethernet cable. I have two laptops connected via wireless where I would like to filter out a couple of websites. In the router menu I have setup an access restriction that filters by the two MAC addresses and entered the two website URLs. When I enable the access profile my voip service stops working. I have a dial tone and the service will dial out AND ring the called number (though I cannot hear the ring), but I can't talk. As well, my number can be called and it will ring, but still again no voice is heard.

Any ideas?

A:filter websites = filter voip voice ???

Bump. Anybody?