Search results

Hi, have a database and currently I have in there the date when a new record was created and also have the Username of the user who created the record. I want to add something so that when the user updates a courses record (or the related records contained in the sub form) that the User ID...

Hi After a lot of struggling I managed to get this to work OK: Private Sub Module_Code_AfterUpdate() Dim strCriteria As String strCriteria = "Module_Code=" & Chr(34) & Me.Module_Code & Chr(34) & " AND Course=" & Chr(34) & Me.Course & Chr(34) If DCount("Module_Code", "tbl...

Hi I have a form which is the main menu for my database and on it there are some options to run queries but the queries always end up hidden behind the form when they run :( Can anyone help me with what I do so that the queries come out on top of the form not behind it?? Thanks in anticipation.

HI, I have a form and I want show a message on the form when the it is locked as another user is editing the data in a particular record. I know the record selectors show the records lock status but it a very tiny symbol which will mean nothing to the users of the database and anyway I...

Hi there I have a filter on a form : There is a text box (txtSearchP) where the user will enter their search term then click button to apply the filter: Private Sub cmdSearchP_Click() ' Filter by Programme Description Me.Filter = [Programme_Desc] Like "*" & Me.txtSearchP & "*"...

Hi I have a database with a filter on the form which users can apply I know at the bottom of the form it highlights it as filtered but I want something a bit more prominent displayed on the form when a filter is active anybody any ides how I can do this?? Thanks

Hi, found some useful help on this site so decided to join, thank you to all of you who devote your time and when we need it. Hopefully thanks to you I won't be doing too much :banghead: in the future :)