Question about Microsoft Works 8.0 for PC

5 Answers

Failure of Report Filter function in M/S Works 8 database

I have an 88kb file in a database with 51 fields and is 112 lines long. After adding 5 new fields the Filter function suddenly refuses to work with just one of the fields - not even a new one but one that previously worked. Constructing filters with all other fields and varying their order etc all result in success but as soon as I introduce the one suspect field I get error message - No files match your criteria. Check Filter formula for accuracy. Have reinstalled entire Works suite but no change. Have checked field is correctly formatted and can see no corruption in input data. Using filter in other smaller files does not create any problem.

Posted by on

  • 3 more comments 
  • discoveryhal Nov 13, 2008

    This problem with just the one file occurs on my main PC as well and in an identical manner. It must be a problem with the file rather than the software but I can not identify what!

  • discoveryhal Nov 13, 2008

    To clarify, filter worked until database had 5 more fields added then found that if one particular field (an old one - not one that was added)was included in the filter then process failed with "no matches found". Same result if run the file on another machine so confident is not the OS software! Other files work perfectly!

  • discoveryhal Nov 13, 2008

    Using Filter with ALL OTHER FIELDS in a number of different combinations works OK but as soon as I introduce this one particular field it stops the filter from working. I have reformatted the field (it's a text field) and checked every single entry to make sure no apparent corruption. All was OK until I added extra fields. The failing field was not one of the new ones.

  • discoveryhal Nov 13, 2008

    Filter in M/S Works 8 allows the selection of upto 5 choices and I'm using the Easy Filter option (i.e. not formula but selections offered on the drop down menus). The Field (called Sections) contains single word text with no symbols or other characters. It does not matter at which point in the Filter I place the suspect field for it to fail.

  • discoveryhal Nov 13, 2008

    Well, it's not the Registry! I have now created a new field with a different name and entered the data in another way. The Filter now works on the new field as well as all the others! My work around keeps me operating but does not answer the question as to why the one field should suddenly become unresponsive. By the way - in the Report Creator the dodgy field would appear if selected but of course no report generated if the field selected as a Filter. Unless anybody knows the real answer I think we have come to the end of the road on this one. Thanks for trying.

×

5 Answers

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Genius:

    An expert who has answered 1,000 questions.

  • Master
  • 1,913 Answers

Check your text length and other attibes.

Posted on Nov 13, 2008

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Sergeant:

    An expert that has over 500 points.

    Champion:

    An expert who has answered 200 questions.

  • Expert
  • 347 Answers

Hello, 

It might be a problem in the regitry. A file might have been deleted by mistake.

I suggest you to try this: 

click on start, all programs, accesories, system tools, system restore.

Then select a perod of time where you didnt had the problem, restore your computer to a previous state and let me know if that solved, or didnt solved your problem.

Good luck,
Dahaka

Posted on Nov 13, 2008

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Master
  • 1,879 Answers

Describe the the filter's function and type of data the suspect field contains

Posted on Nov 13, 2008

  • monk3ybidzness
    monk3ybidzness Nov 13, 2008

    The offending field MIGHT be conflicting with another field thus returning a null to the filter.

    Try the filter on the said field "solo".

    If it works, add some combination fields but keep it at about 2-3, to find out where it is creating a problem.

×

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 112 Answers

It seems that everything is fine as far as the software. There must be something conflicting in the data in the fields. check other fields to make sure they are ok.

Posted on Nov 13, 2008

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    MVP:

    An expert that got 5 achievements.

    Master:

    An expert who has achieved Level 3.

    Sergeant:

    An expert that has over 500 points.

  • Master
  • 449 Answers

Hi!!!

did you try to update after you re-install
or maybe there is error during the installation of your
operation system
or update?

Posted on Nov 12, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Configure.csv


CSV means:
A comma-separated values or character-separated values (CSV) file is a simple text format for a database table. Each record in the table is one line of the text file. Each field value of a record is separated from the next by a character (typically a comma, but some European countries use a semi-colon as a value separator instead). Implementations of CSV can often handle field values with embedded line breaks or separator characters by using quotation marks or escape sequences. CSV is a simple file format that is widely supported, so it is often used to move tabular data between different computer programs that support the format. For example, a CSV file might be used to transfer information from a database program to a spreadsheet.
A comma-separated values or character-separated values (CSV) file is a simple text format for a database table. Each record in the table is one line of the text file. Each field value of a record is separated from the next by a character (typically a comma, but some European countries use a semi-colon as a value separator instead). Implementations of CSV can often handle field values with embedded line breaks or separator characters by using quotation marks or escape sequences. CSV is a simple file format that is widely supported, so it is often used to move tabular data between different computer programs that support the format. For example, a CSV file might be used to transfer information from a database program to a spreadsheet.

Dec 27, 2010 | Acer TravelMate 2300 Notebook

1 Answer

Unable to import text file to access table


Hey everyone, I was able to fix my problem using the following:

filnam = Me![Text2]
Set objFile = CreateObject("Scripting.FileSystemObject")
Set objText = objFile.OpenTextFile(filnam)
Set rs = CurrentDb.OpenRecordset("FlatFileImport")
once = False
If Not IsNull(Me.Text2) Then filnam = Me.Text2
Open filnam For Binary As #1
Do While Not objText.AtEndOfStream
strTextLine = objText.Readline
Data = Split(strTextLine, ",")
If once Then
rs.AddNew
rs.Fields(1) = Data(0) 'Site ID
rs.Fields(2) = Data(1) 'Client ID
rs.Fields(3) = Data(2) 'Client Name
rs.Fields(4) = Data(3) 'DDA Account
rs.Fields(5) = Data(4) 'Process Date
rs.Fields(6) = Data(5) 'Good Checks Singles
rs.Fields(7) = Data(6) 'Good Checks Stubs
rs.Fields(8) = Data(7) 'Good Checks Partial
rs.Fields(9) = Data(8) 'Good Stubs Partial
rs.Fields(10) = Data(9) 'Good Checks Multi
rs.Fields(11) = Data(10) 'Good Stubs Multi
rs.Fields(12) = Data(11) 'Check Only Checks
rs.Fields(13) = Data(12) 'Check Only Stubs
rs.Fields(14) = Data(13) 'Check And List Stubs
rs.Fields(15) = Data(14) 'Check And List Checks
rs.Fields(16) = Data(15) 'Suspense Checks
rs.Fields(17) = Data(16) 'Suspense Stubs
rs.Fields(18) = Data(17) 'Correspondence
rs.Fields(19) = Data(18) 'Envelopes
rs.Fields(20) = Data(19) 'Express Mail
rs.Fields(21) = Data(20) 'Lookup Stubs
rs.Fields(22) = Data(21) 'Online Lookups
rs.Fields(23) = Data(22) 'Stubs Only
rs.Fields(24) = Data(23) 'StopFile Hits
rs.Fields(25) = Data(24) 'SLC
rs.Fields(26) = Data(25) 'SL2
rs.Fields(27) = Data(26) 'MICR Scanline
rs.Fields(28) = Data(27) 'KeyStrokes Correspondence
rs.Fields(29) = Data(28) 'Keystrokes SLC
rs.Fields(30) = Data(29) 'Keystrokes SL2
rs.Fields(39) = Data(38) 'Exception Queue
rs.Fields(40) = Data(39) 'COA Queue


'IMAGE ARCHIVE ITEMS
rs.Fields(41) = Data(40) 'Image Archive Reports
rs.Fields(42) = Data(41) 'Image Archive Storage

'BATCHES PROCESSED
rs.Fields(43) = Data(42) 'Batches Processed

'ARC ITEMS
rs.Fields(44) = Data(43) 'Low Speed ARC Attempts
rs.Fields(45) = Data(44) 'High Speed ARC Attempts
rs.Fields(46) = Data(45) 'Low Speed ARC Converted
rs.Fields(47) = Data(46) 'High Speed ARC Converted

'ICL ITEMS
rs.Fields(48) = Data(47) 'ICL Attempts
rs.Fields(49) = Data(48) 'ICL Converted
rs.Fields(50) = Data(49) 'ICL Non-Conforming images

'RETURN ITEMS
rs.Fields(51) = Data(50) 'Auto Returns
rs.Fields(52) = Data(51) 'Returned Items

'POSITIVE POST (CDM) ITEMS
rs.Fields(53) = Data(52) 'Positive Post Checks
rs.Fields(54) = Data(53) 'Positive Post Stubs

'REMOTE PAYMENT CAPTURE ITEMS
rs.Fields(55) = Data(54) 'Remote Payment Single Checks
rs.Fields(56) = Data(55) 'Remote Payment Single Stubs
rs.Fields(57) = Data(56) 'Remote Payment Multi Checks
rs.Fields(58) = Data(57) 'Remote Payment Multi Stubs
rs.Fields(59) = Data(58) 'Remote Payment Check Only Checks
rs.Fields(60) = Data(59) 'Remote Payment Check Only Stubs
rs.Fields(61) = Data(60) 'Remote Payment Check & List Checks
rs.Fields(62) = Data(61) 'Remote Payment Check & List Stubs

'DOLLAR DEPOSTIED & PP CORRO REJECT ITEMS
rs.Fields(71) = Data(70) 'Dollars Deposited
rs.Fields(72) = Data(71) 'PP Corro Rejects



rs.Update
End If

once = True
MyLine = ""
MyLine = MyLine & ch
MyLocation = Loc(1)
Loop
MsgBox " File has been successfully imported! "
Close #1 ' Close file.
rs.Close
'close and erase the file from memory
objText.Close
Set objText = Nothing
Set rs = Nothing

Sep 08, 2009 | Microsoft Access 2003 for PC

1 Answer

Example sorurce code for database


Hello my friend try this code: This code is design for Visual Basic 6.0
Function for Connection and recordset string.  '========Connection String====== Public Sub connection(ByRef dConnection As ADODB.connection, ByVal dLocation As String)     dConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dLocation & ";Persist Security Info=False;" End Sub '======End of Connection String======
'=======Recordset String=========== Public Sub recordset(ByRef sRecordset As ADODB.recordset, ByRef sConnection As ADODB.connection, ByVal sSQl As String) With sRecordset .CursorLocation = adUseClient .Open sSQl, sConnection, adOpenKeyset, adLockOptimistic End With End Sub '======End Recordset String========
How to apply the above function? Application:
'====== Command Save Button======== Private Sub cmdsave_Click() Dim cn3 As New ADODB.connection Dim rs3 As New ADODB.recordset
Call connection(cn3, App.Path & "\CASGC.mdb") Call recordset(rs3, cn3, "Select * from Debtor_Creditor_Account") Set dtglobal.DataSource = rs3.DataSource   
With rs3   .AddNew   .Fields("Code") = txtCode.Text   .Fields("Description") = txtDescription.Text   .Fields("Tag") = cbotag.Text   .Update   .Requery    End With   MsgBox "New Account has been Added", vbInformation   Set cn3 = Nothing Set rs3 = Nothing
End Sub '=======end of Command Save button=====
The advantage of using this code is setting your database connection is you have a reliable connection towards your database where ever you place your database you can you don't to remount you databse connection control. Also you are no longer need to use a ADO control or DAO control just copy the function and paste it in your coding area and call the function and you have now a working database and recordset connection string. 

For more details regarding how to apply this code just email me at this address: geo_jonas@yahoo.com to get more codes. thanks.. Please rate this Solution.

Jul 08, 2009 | Microsoft Visual Basic 6.0 for PC

1 Answer

Hi, Need to create multiple running auto numbers in one table in one field, can anyone help?, am using access2000.


you can add page #'s in reports, insert, page #
you can't add auto #'s in the table without just adding the # in one field for each one
Access is a database program, the report option is where the page or file # is entered
I hope this helps

Apr 08, 2009 | Microsoft Access 2000 Step by Step...

1 Answer

How to connect vb with ms access


se Adodc OR Even better.. ADODB. for this you need to get MDAC fromMicrosoft free download.(check under project_References- Microsoft DataActiveX objects.. the current no is 2.8. if it is not there download invb directory.

next, you can learn about creating a DSN from control panel, ODBC. onceyou learn this, connection becomes a piece of cake. get some free vbtutoriasl from WWW.

then

you need to use DAO or ADO to connect to the database. better study both but since ADO is current, i am showing that code.
under Menu Project_References, put a check mark on Microsoft ActiveXData Objects latest version (though it works for all, currently 2.8with sp pack 1 ).

at the general declarations:
dim conn as adodb.connection, rec as adodb.recordset, esql as string,esql1 as string
Private Function connect()
Set rec = New ADODB.Recordset
Set conn = New ADODB.Connection
esql = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "D:VBDesigndhana2.mdb" & ";Persist Security Info=False"
'here you put the correct path of your mdb file. and check if you have jet 4.0

conn.Open (esql), , , 0
End Function

private sub form_Load()
connect
end sub
and for adding records:
say let us say you have 3 fields. then have 3 textboxes and 1 command button on the form.

private command1_click()
esql1="select * from Yourtablename"
rec.open(esql1),conn,, adOpenDynamic, adLockOptimistic
rec.AddNew
rec.Fields(0) = text1.Text
rec.Fields(1) = Text2.text
rec.Fields(2) = text3.text
' you need to check if in your access table design you have Allowed Zero length .. set it to Yes for all text fields.
rec.update
if not rec.eof then rec.movenext
rec.close
conn.close
set conn to nothing
end sub

this will add new records to access table from VB.
' for picture store the full path of the path and the picture file nameint the text field. and in the picturebox of VB form for viewingrecords again you need ADO or ADODC and here you code:picture1.picture=Loadpicture(rec.fields(3) ' depending on where thepicture field is located. you need to make a few trials.
under Menu Project_References, put a check mark on Microsoft ActiveXData Objects latest version (though it works for all, currently 2.8with sp pack 1 ).

at the general declarations:
dim conn as adodb.connection, rec as adodb.recordset, esql as string,esql1 as string

Private Function connect()
Set rec = New ADODB.Recordset
Set conn = New ADODB.Connection
esql = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "D:VBDesigndhana2.mdb" & ";Persist Security Info=False"
'here you put the correct path of your mdb file. and check if you have jet 4.0

conn.Open (esql), , , 0
End Function

private sub form_Load()
connect
end sub

and for accessing records:

private command1_click()
esql1="select * from Yourtablename where id =" & val(text1) ' for integers

esql1="select * from Yourtablename where name=" & "'" & text1 & "'" ' for string

rec.open(esql1),conn, adOpenstatic, adLockreadonly

label1.caption =rec.Fields(0)
label2.caption= rec.Fields(1)
label3.caption= rec.Fields(2)
' you need to check if in your access table design you have Allowed Zero length .. set it to Yes for all text fields.

rec.close
conn.close
set conn to nothing
end sub


' similarly there are routines to ADD, Delete, Edit, View etc.

Feb 26, 2009 | Computers & Internet

1 Answer

Storage of MS-Access 2007


(please refer for www.office.microsoft.com for further information)
Database specifications Attribute Maximum Access database (.accdb) file size 2 gigabytes, minus the space needed for system objects Note NOTE: Although the maximum size for a single database file is 2GB, you can work around this limitation by using a split database. A front-end database file can point to thousands of back-end database files, each of which could be as large as 2GB. For more information, see the topic, Split a database.
Number of objects in a database 32,768 Number of modules (including forms and reports that have the HasModule property set to True) 1,000 Number of characters in an object name 64 Number of characters in a password 20 Number of characters in a user name or group name 20 Number of concurrent users 255 Table Attribute Maximum Number of characters in a table name 64 Number of characters in a field name 64 Number of fields in a table 255 Number of open tables 2048; the actual number might be smaller because of tables opened internally by Access Table size 2 gigabyte minus the space needed for the system objects Number of characters in a Text field 255 Number of characters in a Memo field 65,535 when entering data through the user interface;
2 gigabytes of character storage when entering data programmatically Size of an OLE Object field 1 gigabyte Number of indexes in a table 32 Number of fields in an index 10 Number of characters in a validation message 255 Number of characters in a validation rule 2,048 Number of characters in a table or field description 255 Number of characters in a record (excluding Memo and OLE Object fields) when the UnicodeCompression property of the fields is set to Yes 4,000 Number of characters in a field property setting 255 Query Attribute Maximum Number of enforced relationships 32 per table, minus the number of indexes that are on the table for fields or combinations of fields that are not involved in relationships* Number of tables in a query 32* Number of joins in a query 16* Number of fields in a recordset 255 Recordset size 1 gigabyte Sort limit 255 characters in one or more fields Number of levels of nested queries 50* Number of characters in a cell in the query design grid 1,024 Number of characters for a parameter in a parameter query 255 Number of AND operators in a WHERE or HAVING clause 99* Number of characters in an SQL statement Approximately 64,000* *Maximum values might be lower if the query includes multivalued lookup fields.
Form and report Attribute Maximum Number of characters in a label 2,048 Number of characters in a text box 65,535 Form or report width 22 in. (55.87 cm) Section height 22 in. (55.87 cm) Height of all sections plus section headers (in Design view) 200 in. (508 cm) Number of levels of nested forms or reports 7 Number of fields or expressions that you can sort or group on in a report 10 Number of headers and footers in a report 1 report header/footer;
1 page header/footer;
10 group headers/footers Number of printed pages in a report 65,536 Number of controls and sections that you can add over the lifetime of the form or report 754 Number of characters in an SQL statement that serves as the Recordsource or Rowsource property of a form, report, or control (both .accdb and .adp) 32,750 Macro Attribute Maximum Number of actions in a macro 999 Number of characters in a condition 255 Number of characters in a comment 255 Number of characters in an action argument 255 default.aspx?assetid=za100776681033 Top of Page
Project specifications The following list of tables is specific to Office Access 2007 projects:
General Attribute Maximum Number of objects in an Access project (.adp) 32,768 Number of modules (including forms and reports that have the HasModule property set to True) 1,000 Number of characters in an object name 64 Number of columns in a table 250 (Microsoft SQL Server 6.5) 1024 (Microsoft SQL Server 7.0, 2000 and 2005)
Microsoft SQL Server database Microsoft SQL Server maximum capacity specifications are described in the SQL Server documentation. Form and report Attribute Maximum Number of characters in a label 2,048 Number of characters in a text box 65,535 Form or report width 22 in. (55.87 cm) Section height 22 in. (55.87 cm) Height of all sections plus section headers (in Design view) 200 in. (508 cm) Number of levels of nested forms or reports 7 Number of fields or expressions that you can sort or group on in a report 10 Number of headers and footers in a report 1 report header/footer;
1 page header/footer;
10 group headers/footers Number of printed pages in a report 65,536 Number of controls and sections you can add over the lifetime of the form or report 754 Number of characters in an SQL statement that serves as the Recordsource or Rowsource property of a form, report, or control (both .accdb and .adp) 32,750 Macro Attribute Maximum Number of actions in a macro 999 Number of characters in a condition 255 Number of characters in a comment 255 Number of characters in an action argument 255
Zulfikar Ali

Jan 16, 2009 | Microsoft Computers & Internet

1 Answer

Code for find the Ms access database size using visual basic


The way to get the database size is to point to the directory that the database is do a DIR statement with an output to a file as in DIR payroll.mdb>dbsize.txt and then read from the text file, the first field of the second line being the name (which you really don't need) then the size value of the database.

To import the text files using VB 8 use

'Imports System.Data.OleDb Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\path\filename.mdb") Dim cmd As New OleDbCommand("SELECT * INTO [import] FROM [Text;Database=d:\path;Hdr=No].[dbsize.txt]", conn) conn.Open() cmd.ExecuteNonQuery() conn.Close()

Nov 10, 2008 | Microsoft Office Standard for PC

1 Answer

Create access mdb file by vfp code


Try this

#define dbLogical 1
#define dbNumber 2
#define dbInteger 3
#define dbLongInteger 4
#define dbCurrency 5
#define dbSingle 6
#define dbDouble 7
#define dbDateTime 8
#define dbBinary 9
#define dbText 10
#define dbOLEObject 11
#define dbMemo 12
#define dbReplication 15
#define dbDecimal 16
if file("C:\accesstest.mdb")
delete file c:\accesstest.mdb
endif
public oAccess
oAccess = createobject("Access.application")
oAccess.visible= .t.
newMDB = oAccess.NewCurrentDatabase("C:\accesstest")
newtable = oAccess.CurrentDb.CreateTableDef('testtable')
with newtable
.fields.append(.CreateField("Field1", dbLogical))
.fields.append(.CreateField("Field2", dbNumber))
.fields.append(.CreateField("Field3", dbInteger))
endwith
oAccess.CurrentDb.TableDefs.append( newtable)
dbc2Convert = "\\tpdfiles\data\dfreeman\tip\data\rta\rta"
open database (dbc2convert)

dbgetprop(rta,"table",)

After it runs you will need to close the MDB and reopen it.

Oct 15, 2008 | Microsoft Computers & Internet

1 Answer

Steps and definition of ReOrganizing mysql Database


I can't really tell what you mean by "re-organizing" a database. Some things this could include are:

  • Creating new tables
  • Deleting unused tables
  • Changing the structure of the database's tables (adding fields, removing fields, moving fields between tables, etc.)

Aug 28, 2008 | Sun MySQL

Not finding what you are looking for?
Microsoft Works 8.0 for PC Logo

Related Topics:

22 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18386 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...