Search results

Thanks for your help. I converted the database but the problem did not go away??? There must be a difference in how a combo box is setup between Access 2000 and Access 2003. Agian thanks for your reply.

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

Thanks Peter that works perfectly. I was on the right track but was not aware of the need for the alias. I really appreciate your help. Kevin …

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 solved the problem and it appears to work 100%. I added another "Sorting and Grouping" entry for the field DATE. So now the "Sorting and Grouping" dialog looks kind of like this; {{= DATE Accending DATE Accending The first Date entry groups on Year value, the second does...

Thanks very much for your help. In the Crosstab query, on which the report is based, the DATE is the first element and it is set to sort ascending. In the report the "Sorting and Grouping" is set to DATE Ascending with a Group on Year. I noticed in my original post that my attachment was...

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

That solves the problem. Thanks so much for your help. Keving

ByteMyzer, your suggestion appears to stop my code from failing but it also appears that I am doing my lookup using a variable name rather than the student name? The following shows how I built the SQL string in VBA. The two commented lines are my original code replaced by your suggestion...

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

Thanks I will give that a try. Currently the Combo Box is bounded to the course code. Keving

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 finally got it to work. I added the # sign to the Dlookup statement as the following example shows. =DLookUp("[Points]","[Winning Teams Table]", "[Date]=#" & datevar & "# and [id] =4") It works great. I really appreciate your help. The # signs were a great clue. Like you, I am using the...

Thanks, for the help. I have tried to split the statement as you suggest but I have not been successful yet. I am also trying other approaches. Everyone appears to have a low opinion of the Dlookup statement? Thanks again. Kevin ....

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

Thanks for your help I found a solution. In the Open report event I run my VBA module that identifies winning teams. I use this data to then filter the data from the reports query source. I appreciate the help I received.