Search results

The IsLoaded is to check if another form is open, it's basically an admin form. On this form I have some option buttons in the header to control sort order. When a user clicks them it is supposed to go back to the SQL server and run the relevant stored procedure so what I want to do is refresh...

I can't find out the reference to the form I'm supposed to be calling the GetData Sub, it keeps erroring. Private Sub optGroup_SortOrder_AfterUpdate() 'On Error GoTo LocalHandler Dim optValue As Integer Dim db As Database Dim myquery As querydef Set db = CurrentDb() Set myquery =...

The data is brought in from a SQL server stored procedure through an ODBC connection (!). I need to refresh the data but I'm not sure how. It doesn't seem to do anything at present: Private Sub optGroup_SortOrder_AfterUpdate() On Error GoTo LocalHandler Dim optValue As Integer Dim db As...

Well, there are 5 radio buttons so I gave each of them a name like opt_AccountCode, opt_InvoiceNumber. Should I be checking the value of the group ?

Private Sub optGroup_SortOrder_AfterUpdate() Dim optValue As Integer optValue = opt_AccountCode.Value MsgBox (optValue) End Sub

Okay, that works. In code I get an error saying: You have entered an expression that has no value. When I run the form, I click the button but it doesn't even bring up the message box or a n error. Dim optValue As Integer optValue = opt_AccountCode.Value MsgBox (optValue)

when I click on the properties box of an option button Click is not one of its events. It only has gotfocus, etc.

I have some option buttons in a group. I'm trying to get them working but can't find the event which fires. I want to do this: Dim strSelection As String strSelection = Trim(opt_AccountCode.Value) MsgBox (strSelection) 'Select Case strSelection 'Case strYes 'Case strNo 'End Select Any ideas?

I'm not sure but I don't think an actual statement is running. Maybe the error message is unrelated somehow. There are no timers on the form or any statement that would cause this to run when just clicking about between boxes.

How do you turn off the sort ascending buttons on a datasheet? In addition to that, how do you sort a stored procedures results? Is there a way to put the recordset into an array and then sort the array?

We get the following erro in an application after about 60 seconds (attached). Just says Invalid SQL statement. Sometimes it does not occur, sometime you have to click in a box and then click out of it. Some of the forms are bound to a table so could this be an ODBC timeout issue? If so, how do...

It's not a datasheet but one of the other views in a form with a table. If I double click on an invoice number, which is essentially one of the rows, it takes ages to load up a form...almost like it's rerunning the query to load the datatable. We know this because we took out 2 subtabs of the...

Hi Yes, we want to see the new data. So, - the form is opened - we run a stored procedure - data is put into a recordset - form recordset is set to the rst recordset - another form opens - user puts in data on this other form - use closes form - we now want to run the stored procedure again...

I'm getting an auotmation error when exporting data to Excel. This code all worked before and then I installed Access 2007. I still have 2003 at the same time and the db is in 2003. Microsoft site says that the automation error happens in older versions of Excel so I outputted a message box to...

I have a subform which shows up in 2 other main forms. On one of them it works fine. On the other it just shows up grey. I at a loss for what to lofically check through to find out why. It is a subform bound to a backend SQL db. I would normally populate it with a store dprocedure but this is...

found it: http://www.blueclaw-db.com/access_database_global_variable.htm

where then ?

As I understand it the best place to declare some public variables is in a new module. I can then put in stuff like Public Const strVersionNumber = "v1.0.0" Do I then have to call the module as the startup code?

No, we just want to requery the database.To do this, it has to rerun the stored procedure and put it into a new recordset. Because it's a stored procedure and the form was already open, there doesn't seem to be a way to refresh it. Maybe some onEvent thing needs to have the call for the stored...

Err... A form's data is brought into a recordset by running a stored procedure on the SQL server. Pressing a button on another form or double clicking a data row is supposed to refresh the data on the original form but it doesn't because the stored rocedure is not rerun. In Access you would...