Search results

Hello I need to create two user login accounts for the database so that one account can have full rights and one only has read/write access. How do I go about doing this?

Thank you very much, works brilliant:)

I see, I am new to the VBA side of access...can you explain how can i use that String so that it is sent as a email body? Do i replace the "acSendNoObject" with strBody = "Dear " & Me.FirstName"? I would appreciate the help:)

Thanks for the pointer, works like a charm:) However, just to eliminate the need for an attachment, is there a way to show the form contents in the message body of the email rather than an attachment file?

Hi there. I have a Table and a Form setup. What i want is an email sent to a specified email address after a new record is entered into the table (Via the Form). I would assume that the VBA code would be on "After_Insert()"... Does anyone have any ideas? Thanks in advance:)

I have the following code inside the OnLoad on the form to display the filtered query results. Me.Filter = "[Combo7] =" & Forms("SearchForm")("Text0") Me.FilterOn = True Just to clear up what exists on the both forms: Form name: SearchForm Text0 = The text field in which the criteria to...

It just opens a form. It is set on the "on click" part of the Event tab.

Thanks for the information DCrake:) I have the following code for the button im clicking Private Sub SearchButton_Click() On Error GoTo Err_SearchButton_Click Dim stDocName As String DoCmd.ShowAllRecords ' clears any previous filters DoEvents ' waits...

Ah right, so how do I go about using the string nce ive coded it?

Thanks for the help. I've tried using the code below but it asks for Me.Combo7 and Me.Text0 which are the names for the combo box and text field respectively. Is there sometign wrong with the code? SELECT Content.[Article ID], Content.Category, Content.Problem, Content.Cause, Content.Fix FROM...

Hi there Is there a way to search through specified fields in a Table? I have a table which has a few records inside with the following fields: [ID, Software, Fix] I have a Form setup which needs to act as a search form. You enter the search criteria into one field and then you specify via...

Indeed, Thanks for your help:)

Thanks for the answer:) However in this mode, I cant edit/save/add/delete records. Is there a way so that when the answer is displayed, I can edit it. Im aware the results of a query cannot be changed but is there a workaround?

Hi, Basically what I need my Query to do is ask me for an ID, which the user inputs and then open a form with the correct record already displaying. So far I can get it to ask for the ID but it shows the relevant record as a table/query rather than in a form. How do I go about doing this?