Search results

How can I pass an Option Group parameter to execute a stored procedure? Basically I have 3 stored procedures and want the user to define which one of the three to execute by what option then select. I am looking for sample coding along the lines of: if option 1 then strSql = "exec pump " if...

Thanks. Was going mad there.

I am trying to get a count from a table with the WHERE clause restricted by whatever parameter the user enters into the textbox called 'UserDefined' however it keeps compiling errors. The code is: Me.MyTextbox = DCount("*", "[DBO_FINAL_PUMP]", "[PUMP]= " & Me.UserDefined & " ") Thanks.

How would I go about getting a message box to appear after a command button has been pressed? For example when the user presses the 'Duplicate Record' command button I want a message to appear saying 'Duplicate Created'. Thanks in advance.

How can I open up my database back into edit mode? I was creating the startup form and unticked all the boxes for opening up the database with tool bars which has worked in hiding all the tool bars however now I cannot open the forms up to edit them. :confused: Thanks in advance.

How can I code a user prompt box to display when a command button is pressed? Basically I want the user to confirm that they want to delete a record when they press the delete record command button. Thanks in advance.

Thank you.

Quick question: How do I code Microsoft Access 2003 to open up a specific form on user loading? :confused: Thanks in advance.

I have text boxes and list boxes on a form but whenever I open it the data of the first record within the table is shown. Is there a way to suppress this so that all data fields are blank? Also how whenever I select data from a list box it is highlighted however how is it possible to...

How can I insert the current date into a date field when an 'Event Procedure' of 'On Click' is performed on the field? I have created a button that inserts that date into the field when pressed however I would like the date to be entered if the mouse clicks on the box if this is possible...

Thanks. Okay if I understand you I went into Query > SQL Specific > Pass-through and changed the qryMultiSelect to read exec mail_count TEST_TABLE however this time it doesn't error but neither does it output the data. Did I understand you correrectly?

qryMultiSelect is just a basic query. I thought one was needed to run any queries in Access? I don't know if this is right or not as I am new to Access. Basically I just want a coded button that executes the stored procedure and outputs the results to the screen.

How can I run a stored procedure on SQL Server from an Access form? Whenever I execute the below code it errors with "Invalid SQL Statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'" Private Sub Command27_Click() On Error GoTo Err_Command27_Click Dim db As...

How can I output a count from a query into a text box? strSQL = "Select count(*) From test " Thanks in advance.

Brilliant. Thank you. :cool:

How can I go about passing data from a forms text box into a SQL query? Basically I want the [userdefined] entry in the below SQL to be data entered from a text box: strSQL = "SELECT * FROM [userdefined] ;" Thanks in advance.

Brilliant. Thank you so much. :cool:

Using Access is it possible to query the database using multiple list boxes where the user can specify the AND or an OR clause? For example, I have 2 list boes which I want the user to use to build up their query however sometimes they will want to use data from both boxes with an AND while...