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!

  • Congratulations Wanet Telecoms Ltd 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: *

  1. gemoon

    Force new record in subform

    I have a form which creates a record in table A. The form has a subform which has several text boxes. The two forms are linked via [FieldB]. When the user creates a new record with the form and enters data in the the subform, a record is created in table C. The new record includes the value of...
  2. gemoon

    Ranking items by date

    PHV, That is it! Thank you so much. Also, thanks to Hosacans for your explanation of there being two instances of the same table. I am fumbling in the dark here and your explanation was enlightening. Thanks, Ed
  3. gemoon

    Ranking items by date

    PHV, Thanks so much for your help. It looks like I am almost there. I tried your solution. It does assign the ranks correctly for the ties, but it assigns a rank of 2 to both the first and second rankings so I would get the something like the following. Date Total Rank Date 1 100 2 Date 1...
  4. gemoon

    Ranking items by date

    mp9, Thanks so much for your reply. Sorry for the late response, but I was pulled off of this problem for a few weeks. Your addition was just what you I needed. Also you were right that the order is not correct. I misstated above that I was looking for a low to high ranking. Actualy I am...
  5. gemoon

    Ranking items by date

    I am trying to produce the following format which can then be exported into a graphing program: ----Date1------ ---Date2------- Rank Type Total Type Total My starting point is qryTotals: qryTotal Date Total Type Date1 2 x Date1 6 y Date1 3 z Date2 20 x Date2 5 y Date1 10 z I'm...
  6. gemoon

    testing server IIS or Apache?

    One of my clients has recently changed to their hosting from win 2000 to an apache server. Their site will now be using php and mysql. I currently have IIS installed and runing as a local testing server. I was using this to test asp with ms access. I am trying to decide how to proceed on...
  7. gemoon

    Report layout question - hide duplicates?

    This is the first report I have ever created, so please bear with me if the answer to this question is obviously. I have a report that displays a fairly complex dataset. Im having trouble setting up the report to display the data correctly. A portion of the report contains date, location, item...
  8. gemoon

    Averaging by year

    Thank you very much. I tried your solution and was still getting the same compile error. This time it refered to 'year(tblA.[date])'. I think the problem is with my database. It has become corrupted or something similar I coppied these two tables and the query into a new database and the query...
  9. gemoon

    Averaging by year

    This seems like an easy problem, but for the life of me I can’t get the solution. I’m trying to write a query that averages values by year. I think I’m on the right track by using the DatePart function, but I keep getting a compile error message. I have two tables with 2 & 3 fields respectively...
  10. gemoon

    Word macro that scales and object by a percentage

    Thanks, I ended up using Selection.InlineShapes(1).ScaleHeight = 70 Selection.InlineShapes(1).ScaleWidth = 70 Ed
  11. gemoon

    Word macro that scales and object by a percentage

    Im trying to write a macro for workd that among other things will scale an object's height and width to 70%. I have pasted my code below. I used the macro recorder to get a starting point. Selection.InlineShapes(1).Fill.Visible = msoFalse Selection.InlineShapes(1).Fill.Solid...
  12. gemoon

    popup for thumbnails from querystring

    I have tested the following and it works: <a href="#" onClick="MM_openBrWindow('images/lgImage,'','width=400,height=500')"><img src="images/Image" alt="alt text" width="250" height="203" border="0"></a> But becuase i dont know how to write a double quotes, I am writting the rendered html as...
  13. gemoon

    popup for thumbnails from querystring

    i am very new to asp, so forgive me if the answer to this question is obvious. i have an asp page that queries an access database. the page has thumbnail images. i want the user to be able to click the thumbnails on the page and have a popup of a larger image appear. not all thumbnails have...
  14. gemoon

    query problems

    As I thought the answer was obvious. Thanks for the second and third set of eyes. ItemID is numeric so removing the single quotes fixed part of the problem. When I wrote the code, emulated what I saw on the help forums. What is the deal with quotes and &? Do single quotes designate text strings...
  15. gemoon

    query problems

    I am new to asp so please forgive me if the solution to this problem is obvious. I have two asp pages, index.asp and detail.asp. index.asp queries an access database then writes text with a link to the second page. When the link is followed an id # is passed to the second page. detail.asp then...
  16. gemoon

    Hiding subforms for new records

    Thanks, I took your suggestion and modified it using something I found on another post. Private Sub Date_GotFocus() If (Me.NewRecord) Then Me.Parent![sfrmCoreSize].Visible = False Else Me.Parent![sfrmCoreSize].Visible = True End If End Sub Thanks again, Ed.
  17. gemoon

    Hiding subforms for new records

    Im having trouble hiding forms. I have some two linked subforms. The two subforms, sfrmDate and sfrmCoreSize have one field each, Date and CoreSize, respectively. When a new record is added sfrmDate, I want to hide sfrmCoreSize until a date is entered. I want to do this to prevent someone from...
  18. gemoon

    Show present and missing records in subform - where not exists?

    TheAceMan1, Thanks for the reply, What I should have said was to display all species from tblSpecies with either the present count number or an empty field awaiting a count number to be entered. For example: There are 100 species in tblSpecies. And in tblCount for depth 10cm there are count...
  19. gemoon

    finding missing records using where not exists

    im trying to write a query that returns missing records. im sure this is probably a simple task, but with my minimal understanding of queries i havent been able to come up with a solution. i have three tables. tblA: aID, a tblB: aID, cID tblC: c, cID tblA and tblC are 1:many in relationship to...
  20. gemoon

    Show present and missing records in subform - where not exists?

    I have a subform that displays species and count for a specific Depth. I am trying to get a subform to display all species with counts that are either present or missing. I want to do this so counts can be entered for each species when a new record is added for depth. It seems to me that this...

Part and Inventory Search

Back
Top