Search results

Private Sub Command80_Click() n = 1 Do Until n = Me.Text65.Value Me.("Text" & n).Visible = True n = n + 1 Loop End Sub

You have variables of qdfapp and qdapp. Should these be the same?

How 'dumb' do I have to go? strMyString = StrConv(strMyString, vbPropercase) StrConv is a function that returns a converted string strMyString is the field your want to convert to 'proper case' vbProperCase is the code to tell it to do just that. Do you just want to display the converted...

strMyString = StrConv(strMyString, vbPropercase)

Nice job!!:D

Don't know about the uniqueness of Crosstabs to Access though or anything about ASP. Not much help am I :(

TRANSFORM Count([Monday].[id]) AS CountOfid SELECT [Monday].[Team] FROM Monday GROUP BY [Monday].[Team] PIVOT [Monday].[Field4];

Damn, You just beat me to it. Was just about to post the same thing. Good 'ol Rich

Whoops! Totally misread that one. I'll work on it. Not as easy as I first thought.

From Access Help: If you specify that a specific number of records be returned, all records with values that match the value in the last record are also returned.

SELECT DISTINCT (select count(Team) from Monday where Team="P") AS Pcount, (select count(Team) from Monday where Team="T") AS Tcount FROM Monday;

Any chance you could post the db?

You don't need two date fields on the form (only need the field you are using in the filter) and theres no need for the criteria in the query the filter will do that for you.

what do you have now?

We import a delimited text file via a macro each morning in order to generate a report and had a similar problem until recently. The macro would fail each time. So, I set the database to compact on close and now the problem has 'gone away'. I don't know the cause unfortunately.

Or, how about keeping the same query for all of the subforms and using a filter to select the records you want. This will save on maintenance if changes need to be made to the query.

on current??

add this to your UP button code DoCmd.GoToRecord , , acPrevious and DoCmd.GoToRecord , , acNext to your DOWN button code. The reason it always deleted the first record is that the ACTUAL record never moved and always stayed on the first record.

Using a query as the recordsource to your form. Add a field called txtMyDate Add a command button called FilterButton Private Sub FilterButton_Click() Me.FilterOn = True Me.Filter = "([SubmitAfterDate]>=" & "#" & txtMyDate & "#)" End Sub

I am trying to understand what you need and reading between the lines are you saying that you want to setup a 'filter' to show only those records based on a range of dates? If you are not saying that then more details please.