Search results

I am having trouble with a query that should be simple. I have these fields (among others) Season, PlayerID, PassingAttempts, TeamID. I want it to show the highest attempts broken down for each season. I tried to use MAX with Passing Attempts which works, but when I add Season to the query I get...

I recently converted a website that had an Access backend to SQL server. Had some queries that didn't work anymore (Mostly IIF to CASE changes). This one does not work at all anymore. Something to do with have 3 of the same table opened at once I would think. strSQL = "SELECT...

I have a form with some basic contact information. My client wants a button that copies some of that information, like name, phone number and e-mail address, and then it can be pasted into either an e-mail or an IM. Any ideas?

Hi there: I have a table thats set up like this: PlayerID Season TeamID PassingYards RushingYards ReceivingYards I would like the query to find the highest number in Passing, Rushing and Receiving per season. Do I need to do each one in a seperate query? Thanks.

Hi there: I would like to duplicate a record. However, I dont want everything. There are a few fields that I would like left blank in the new record. So is there a way to copy certain fields of a record? Obviously, the wizard just allows me to copy over the whole record. Thanks.

I have created a form that runs with several different tabs. My client runs it on a network. For some strange reason, the color of the tabbed area has turned white when on the network. When they send it back to me to fix, it has reverted to its original blue color. Any ideas of what might be...

Hi there: I want to import a tabbed text file into Access. Problem is the text file is updated each day with a different name, and the user wants it automated. The fields would be the same each day. Basically I want to create a command button that would get the user to specify which text file...

Hello: I have my results showing now, and I have them looping through a table by row, using this: <% Do While Not rskg2.EOF %> and this at the end of the table: <% rskg2.MoveNext Loop %> This is great for one record per row. But I want to do 3 records per row, in 3 columns. Thanks for any help.

I have a from that returns two variables for each request. So if I request.form("quantity"), I get this - 11,20. Same with product size. I get. 18KG, 22KG I want to create an insert qry that puts 11 and 18KG in one record, and 20, 22KG in the next. Is this possible?

I have a form that will calculate a shipping cost based on a Canadian postal code. Right now, I have a text field where they can enter in the postal code. If the code is entered in without a space (ie T2V1R3 instead of T2V 1R3) it will not work, as it looks into the database for the rate. Is...

Can you use an OR in an IIF statement? For instance: IIf (Location = "27" or "18", TotalMgt, TotalMgt2). It doesn't appear to work whatever I try.

I have a form with code behind a command button does a few calculations. Sometimes it needs to pull data from another record before it does this. All the calculations I have are correct, but sometimes the code does not work until I close the form and go back to that record again. I have added a...

I have looked through the message board, and cannot find an answer for this question. I would like to send 2 different reports to the same person, in the same e-mail. Is this possible?

I send a zipped Access file daily to a few guys. Everyone of them can retrieve the file and everything is fine. Except one guy. Everything he tries to open the file after unzipping, its read only. The read only check box is not clicked though. Any ideas whats happening here?

Help Here is my query: SELECT [Inventory Transactions].DealID, [Inventory Transactions].BuyerId, Suppliers.SupplierName, [Inventory Transactions].Supplier FROM Suppliers INNER JOIN [Inventory Transactions] ON Suppliers.SupplierID = [Inventory Transactions].BuyerId WHERE ((([Inventory...

I have a start date that gets automatically figure out when a combo box with Terms is selected. I want to have one of two option boxes get filled depending on the StartDate. I tried this and it didn't work: If Market = "2" and StartDate > "1/1/2004" then opt2004 = -1 If Market = "2" and...

I have a large report that is generated off of several other subreports. Everytime I run this report, the system hangs for a bit ( I would guess because of the size of the report), and then everything works well. However, when I close out of the system. I notice that the size of the database...

I cannot get this to work. =DLookUp("[Price]","tblPrice","[LocationID] = " & [Location] & " And [PriceType] =" & [PriceLookup] And "[Month]=#" & [Month] & "#") Is there something wrong with the syntax. It just seems to give me the same result all the time. Thanks.

I have a report that is generated based on several subforms and subqueries. If there is no data for one of the queries, all the text boxes that relate to that query give me a #error. Is there a way to change these to zero? I tried the code below, and it did not work. Function nnz(testvalue As...

Is there a way to do a DLookup with 3 criteria, I have tried this with no luck... =DLookUp("[Price]","tblPrice","[LocationID] = " & [Location] & " And [Date]=#" & [TodaysDate] & "#" And "[MonthForward] = #01/01/2004#") HELP!