Search results

Hi Guys. I currently have a search function via accountno on my form, once the account num is typed in and entered it will display the record of that account num, here is the code: Sub Combo64_AfterUpdate() ' Find the record that matches the control. Me.RecordsetClone.FindFirst...

I understand what your saying, cant belive i didn't spot this. I have an autonumber ID allocated to each account number, Thanks Rural!! ________ Alisonsexy cam

ok, here is the problem. Currently an account is logged onto the db, the account may need to be actioned again but i would not want the previous account to be adjusted. So i though a solution could be to have a letter allocated to the end of accounts, if the account comes up in the next report...

not quite sure what you mean? That account numbers consist of 10numbers. If a duplicate is entered a letter is placed after the REF number. ________ Web Shows

I'v tried this, but not working; Private Sub AccountNo_AfterUpdate() Dim rs As Recordset Set rs = CurrentDb.OpenRecordset("Select * From Spreadsheet where AccountNo = '" & Me.AccountNo & "';") If rs.RecordCount > 0 Then Public Var As String Var = Right(Me.AccountNo, 1) Case Var Case "A"...

Hey I currently have this code which tells the user there is a an accout number already on the db: Private Sub AccountNo_AfterUpdate() Dim rs As Recordset Set rs = CurrentDb.OpenRecordset("Select * From Spreadsheet where AccountNo = '" & Me.AccountNo & "';") If rs.RecordCount > 0 Then MsgBox...

can some one please help? Mosh ________ Wiki vaporizer

hey guys, i noticed that there is a office links which actually merges the report with the selected program from the dropdown on the button, only problem is i have set the db so that it hides all buttons in access, how can i do it so that the "officelinks" appears in the navigation? Another...

thanks you pat! ________ Lentilka live

can some one please help thanks ________ Live Sex Webshows

hi people. Im trying to make a query where the query will search for a specific word in the field, e.g. search for "debt cleared" in 'Other Notes' field. The other notes will also contain other info but i would to search for a specific word(s). Can some one please show me what kind of criteria...

Thanks you jeremie. Mosh ________ Laguna Bay Condo

hey people, im new to the forum and so far its been v.benficial, iv got a simple database running but can't get a query going; can some one please show me how to do the following on a query: What do i put in the criteria so that it does not show records with null value? Thanks Mos ________...