Search results

I have a form and have tried to list the currency types in it but it doesn't display the $ sign, hence anything with dollars, I have to put in a general number. ANy ideas on how to get it listed in Access or VB ?

I recently installed Excel 2007 and now my code is falling over. It failes on this line: oSheet.Range("A2").CopyFromRecordset rs None of the references in the VB window have changed so any ideas? I'm using DAO: Private Sub cmd_Export_Click() 'MsgBox...

This code seems to work but it seems to put in the data incorrectly when the number of worksheets differs. It retrieves data from a database and runs the pivottable wizard, which puts all data for the codes ZCCA etc. into a different worksheet. Problem is that when it's now run, there are some...

I have selected 0 and 1 in the Bound properties but nothing comes up. Sometimes I select 0 but it brings up the ContactID instead. Is something wrong here? DB attached.

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

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?

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

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

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?

We create a recordset that the form uses for its data. When we select other records on a different form it does not refresh. How can we requery the stored procedure in Access? .Requery does not work on SQL stored procedures... Thanks

We create a recordset that the form uses for its data. When we select other records on a different form it does not refresh. How can we requery the stored procedure in Access? .Requery does not work on SQL stored procedures... Thanks

I have a form which displays data in some form of table (not a datasheet). When you double click a row it takes you to another form so it's activated somehow - what is that? Anyway, this data can be sorted by clicking on the top row of any column and selecting ascend, etc. The only problem is...

Do the Access functions dlookup, etc. cause performance issues when using remote SQL servers where the data is held?

How do you convert an mdb file to ADP?

If I design an .ADP project in 2007, will users be able to use this if they only have Office 2003? ...or is there a way of making an exe file with Access projects?

I get the following error when trying to compile code int an MDE: This error is usually associated with compiling a large database into an MDE file. Due to the method used to compile the database, a considerable number of TableID references are created for each table. The Microsoft Jet...