Search results for query: *

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...

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

I can not find a reference to the tables... I have started a new database and they appeared..Are they necessary or ??

I can not find a reference to the tables... I have started a new database and they appeared..Are they necessary or ??

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...

BrainDead Thanks...Now everythings works! 4Wile

I forgot to check DAO 3.51, but now it says: "Compile Error" "Method or data member not found" Code is: Do While not RS.EOF Rs.Edit Rs.("Selected")=False RS.Update Rs.MoveNext Loop Rs.Edit is highlighted..

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??

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...

scking. I'm lost..Here's the query: INSERT INTO TestInTbl ( TestinDate ) SELECT ( DatePart("ww",DateValue(Mid([TestOutDate],5,2) & "/" & Right([TestOutDate],2) & "/" & Left([TestOutDate],4))) AS TestInDate FROM TestOutTbl; Where does the VALUE go and the...

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...

I can't find a reference to CDbl..I am a Newbie.. I looked in Help, Access2000 developers handbook, Visual Basic Super Bible...Cant find CDbl..????

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

Terry L. Broadbent... Perfect....Much thanks Bob Foreman

Terry L. Broadbent.. Remember I'm newbie... Do you mean NewTestNumber=CInt(OldTestText). If so, How can it used in a Query(qryTestUpdate) Bob Foreman

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...

I tried BUT it created a error message: "Wrong number of argument or invalid property assignment" Maybe I asked you for the wrong question...I need a table that contains the addresses of the selected state. I thought just changing OpenForm to OpenTable should do it. I'm still a...

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...

Turtlemaster... Much thanks...Now I understand.. Bob Foreman 4Wile@mediaone.net

Turtlemaster... What does "LMK how that works (for more help check out help on the image control)"? and "tell the activex control to " I'm still a newbie...sorry