Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: 4Wile
  • Content: Threads
  • Order by date
  1. 4Wile

    Table made into a Report

    Table name: Item Field names: Description, Year, Week, Cost Report name: Cost per Week Sample Report: Cost per Week Popcorn Week 1999 2000 2001 1 1.20 1.46 1.15 2 1.19 1.46 1.14 Etc...
  2. 4Wile

    Creating Reports with Wizard

    The Wizards for reports are gone...I must have changed the options or ?? I have MSOffice 2000...
  3. 4Wile

    How to delete MSysObjects, MSysACEs, MSysQueries

    I can not delete MSysObjects, MSysAccessObjects, MSysQueries, MSysRelationship, MyAccess..There all tables that showup on every new Database. I have reloaded my MSOffice and its still there...The message is (Typically) "The Database engine could not lock table 'MSysObjects' because it is...
  4. 4Wile

    Dim CurDB As Database

    I have a code that is; Dim CurDB As Database Set CurDB = CurrentDB() I get error message "Compile Error" User defined type not defined..CurDB As Database is highlighted.. I copied the code from a working MDB form. What happened??
  5. 4Wile

    Pictures on Forms

    I go to Forms, design. Then go to a Command Button, and Tab for Format. Scroll to the picture and find the picture for the Command Button. Click on picture and nothing happens. I just reloaded the entire system and still nothing...Yesterday it was worked perfect...I tried two other MDB systems...
  6. 4Wile

    Query help

    I have qryTest as: INSERT INTO TestInTbl ( TestinDate ) SELECT DatePart("ww",DateValue(Mid([TestOutDate],5,2) & "/" & Right([TestOutDate],2) & "/" & Left([TestOutDate],4))) AS TestInDate FROM TestOutTbl; My Environment is: TestInTbl: TestInDate Number 0...
  7. 4Wile

    Query convert text to decimal number

    Would like to convert text to a decimal number using query. Text is 12345.65 converted to 12345.65(Real & Decimal number) Like: INSERT INTO Newtbl(TestNumb) SELECT ???? [Oldtbl].[TestText] '???? I need expression FROM OldTbl
  8. 4Wile

    With UpdateQuery convert from Text to Number Field

    Query qryTestUpdate, Tables OldTestTbl and NewTestTbl OldTestTbl: OldTestText1 Text OldTestText2 Text NewTestTbl: NewTestText1 Text NewTestNumber1 Integer qryTestUpdate: INSERT INTO NewTestTbl(NewTestText1, NewTestNumber) SELECT [OldTestTbl].[OldTestText1] AS...
  9. 4Wile

    Change DoCmd.OpenForm to DoCmd.OpenTable

    I have expression: DoCmd.OpenForm "PhoneList", acNormal, "", "[PhoneQuery].[State]=[Forms]![Phone3a]![ByLocation3]" This Works! PhoneList = Report Phone3a = Form ByLocation3 = Selected State PhoneQuery = All members address I would like to change...
  10. 4Wile

    Make a report from MS Word files, Picture and Text

    When I get a bulletin and it will be scanned to MS Word. I would need to change the MS Word file to a MS Access report? Can it been done. Please be specific, I'm newbie..

Part and Inventory Search

Back
Top