Recent content by BrainDead

The code below will hopefully get you on your way... As I am also relatively new to access I am unsure of how to include all the RowTos in the If statement, but I am sure someone else will come and fill in what I have left out. Private Sub Form_Current() Dim frmMyForm As Form Dim ctlMyCtls As...

Howlsta.... I get the same error as above, and the me.ccfind automatically reverts back to [me].[ccfind] Any other suggestions??? Thnx

My best advice for you is to use the Search on this forum.... Its amazing what you will find, and what you are asking has been answered many times, so I am sure you will find what you want. HTH

I have a txtbox with the control source as the following: =DCount("location","domainfacts","location = '" & [me].[ccfind] & "'") This is so that a user can select a country from the combobox "ccfind" and then the amount of times that country appears in the field location will be displayed in...

Perfect.....Thnx

I have a delete button to delete a selected record. In order to stop accidental deletions I have set the property of the delete button to: Enabled = No Then once a user unlocks the record, the button becomes enabled. My question is how can I get the button to revert back to Enabled = No...

Like "*" & [Forms]![formname]![inputbox]& " This would be the criteria for the query. It will bring back all records with whatever is put into the inputbox on your form. HTH

=Format([Datein],"mmmm") THats what u want....

John, I believe that only listboxes have the multiselect property. So change your combobox to a list box, and choose: multiselect : simple Or, you can keep your combobox, but add a ALL to the top. I am not sure exactly how this is done. But if you go to the search you will find many posts...

Thanks Jack... From the code you have for the month, I am assuming that the code for the year will be: ByYear: Year([Datefield]) Thnx

In a query, how can I sort a date field, so that the records that come back are in order 15 June 21 August 6 September E.t.c. Thanks

I have a query that that uses a datefield from a txtbox to bring back records. If I give the query the exact criteria like 14-Aug-01 I get the results. But since I want to get all the records in Aug-01, I have the following criteria: Like "*" & [Forms]![renewalform]![date] & "*" Where...