Recent content by gemoon

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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