Search results for query: *

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

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

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

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

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

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

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

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

I am trying create a from with the design suggested by willir in thread702-894117. I have two subforms. one displays a list of dates. the second displays information for a specific date. sfrmDate has several nested subforms. sfrmDateList sfrmDate +----------+...

Im not sure if what I am trying to do can be done? I am trying to create a form to ease data entry. I have a database that has information organized by date. In the database there is information for each date. One bit of information is an item with its associated data. Depending upon the date...

I am trying to replace unmatched/missing records in a table with zero values, but I not sure how to do it. Im sure I need to make an append query, but Im not sure where to start. I have three tables A(date), B(count), C(item list). The tables have the following fields A: DateID, Date B...

I have a spreadsheet that has several blocks of text. I am building a database to store data from many spreadsheets. here is the basic layout spreadsheet b1 has the following some general info and two blocks of text: a1 b1 c1 d1 a2 b2 c2 d2 a3 b3 c3 d3 w1 x1 y1 z1 w2 x2 y2 z2 w3 x3 y3 z3 i...

Hi, I would like to add search capability to my website. I was hoping to do this with google site search. http://www.google.com/searchcode.html The url to my site is http://mydomain.com/subfolder/ However from what I can tell, the google site search will only allow search of the domanin name...

Ive written a macro to run from excel. This macro processes data from comma delemited text files. The macro is comprised of 3 subroutines. The first prompts the user to select a file name and opens the file, the second does some data manipulation and the third prompts the user and does a file...

Im trying to make a macro that will reorganize data from a a comma delimited text file. Ive set up the macro to import the file into excel. Then I get a worksheet with many similarly shaped blocks of data. Ive set up the macro to grab the data I want out of the top block and place it in a...

I just set up a wireless network in my home. I have a linksys wireless b router. I have two computers on the network. 1 desktop w/ win 2000 pro, 1 laptop w/ win xp pro. The desktop connects via a cable. The laptop can connect via cable or internal wireless card. If I connect the laptop via a...

In excel i have a column A cell 1 B cell 2 C cell 3 D cell 4 E cell 5 F cell 6 G cell 7 In Access A 1 B 2 C 3 D 4 E 5 F 6 G 7 . . . . . . I would like to populate cell 1, cell 2, ... with values 1,2,3... from the access database. I would like the criteria for the query in...