Search results

Hi there, I have a SQL Server linked table with a NUMERIC(5,2) datatype and a trigger on that table firing on an Insert or Update which all appears to be working as required as I can use SQL Query Analyzer to view the correct data being stored in the table. The problem is that on creating a...

Hi there, I have a form that contains 2 sub-forms, let's say Employee and Department. Is it possible for a sub-form to refresh or display the details relevant to the other sub-form? For example, if the user is moving through the records of employees one-by-one in the Employee sub-form is it...

Hi there, I have created a basic report in Microsoft Access 2003 using the wizard. Unfortunately this returns many records so I have the user asking if there is a way to have the report prompt the user for a parameter criteria that will restrict down the results to only the records of interest...

Hi there, Can anyone advise me on how I can create a command button in Access 2003 that searches for a specific record? I know you can create the default one through he wizard however that only searches on the priary key. The command button I'd like to code searches on a fields string. Thanks...

Is it possible for me to bypass the error message #3604 'duplicate key was ignored'. When this error message is thrown it stops processing the subsequent stored procedures so just want it by-passed and not displayed to screen. TIA

One of my queries is repeatedly asking for a Data Source whenever you execute it despite the user already being logged into the database. Is there a way to disable this? TIA

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...

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.

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...

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.

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.

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...