Search results

I have a combo box pulling three columns, Primary Key, Request and Name. The properties box has a column count of 3 with column widths set to 0,1,1. The Combo box works perfectly under Access 2000. My problem is the combo box displays a blank column in Access 2003?? The Request column appears...

I am using the SELECT TOP 3 statement to select the top 3 values from a given data field. The SELECT works great, as long as there are no duplicate values in the TOP 3 values. For example if the top 3 values are 210, 202 & 199 they are selected correctly but if there three records that have...

I have a table called Team Standing that includes [TEAM] [PLAYER] [GAME DATE] [POINTS]. From this table I have a query that provides for each game date and team a count of the players, [GAME DATE] [TEAM] [PLAYER COUNT]. [PLAYER COUNT] is calculated using the total COUNT . What I would like...

I have a problem with a report based on a crosstab query The crosstab query shows the number of players per team by date as the sample below shows. Date Total of Last 1 2 3 4 5 ….. 2006/05/11 173 11 8 8 9 11 2006/05/18 149 8 7 10 8 11 2006/05/25 181 13 7 11 10 11 2006/06/01 160 11 8 9...

Hello. I am having trouble with a select statement in my code. The select has actually been working for months and then all of a sudden I got a surprise. One of the pieces of data has a single quote imbedded in it and it causes the lookup to fail. Here is the problem. SELECT * FROM...

I would appreciate any help with this problem I can't seem to debug. I have a form with a linked sub-form. On the main form I have a combo box. The main form is built off a course table, keyed by course code. When the form is opened the first record in the course table is displayed and...

I am having problems with some ADO code that creates or updates a record in a database table. The code worked perfectly under Access 2000 but I get a duplicate record message under Access XP, when the record already exists. I assume ADO rules have been tightened up and I am doing something...

Is there a way to change the properties of a MsgBox, i.e. the default location where it pops up or the font size of the message text? Any help would be appreciated. Kevin ....

When you create a report a number of key setting are made via the page setup dialogs. Margins, number of columns, presentation of columns etc., to name a few. My question, is there any way to programmatically check that your desired setting are in place when opening a report and if they...

I am trying to use Dlookup in a report page footer to populate a text box. The Dlookup statment works great when the criteria is hard coded as the following examples demonstrates. =DLookUp("[Points]","[Winning Teams Table]"," [Date]=#2002/08/15# and [id] =4") When the hard coded date is...

Please help! I am trying to get from a query to a report but I am having lots of problems. I am using MS Access 2000 and I am relatively new to Access and SQL. My problem: I need to produce a report that shows the players on the four winning teams on a given date. Sounds pretty simple. To...

Please help! I am trying to get from a query to a report but I am having lots of problems. I am using MS Access 2000 and I am relatively new to Access and SQL. My problem: I need to produce a report that shows the players on the four winning teams on a given date. Sounds pretty simple. To...