Search results

I have a linked Excel graph in my form. The process I go though to update them is: User clicks on button Excel opens up Procedure in Excel runs that updates the data and the graphs Excel Closes The user does not see any of that. This process works fine. But the linked graph does not actually...

I have created a Macro-Enabled Worksheet Object containing an Excel Graph in Access. It opens nicely when I right click and select Macro-Enabled Worksheet Object -> Open. My question is how can I accomplish the same thing using VBA code. Thanks in advance.

I'm trying to have a linked Excel chart in Access form. What I've done so far is create a chart in Excel and Paste Special>>Linked into Access. I also have code inside Excel that will update chart data, it works fine. Then I have code in Access that calls the code in Excel to update the data...

I'm experiencing weird behavior with my form name. I saved my form with a particular name and I have used that name all throughout my code and it still works fine. But when I open that form, the name I see on the top of the form is not that name at all. It's actually some value I gave a combo...

I have this chart, and Im trying to reduce the space between the bars. Does anyone know how to do it in VBA? Thanks

Sorry if this seems like a weird questions but I was unable to find much on this, but what is the type of SQL that Access accepts? I'm familiar with SQL Server which uses T-SQL. I just want to know if there are any functions which are available to Access SQL but not in normal SQL

I building a front end UI for SQL Server. Im trying to figure out why certain functions are taking long to process. I know that Im running a lot of functions, but I want to know if there was any way to speed things up. For example, one button will launch 20 functions whose results will be...

Im experiencing very weird behavior from Access. Im populating Access table using a stored procedure from SQL Server. Here is the code that does the populating. The problem area is the rst!id (highlighted in red). This is the Identity Column from SQL Server. When Access gets to 32768 it results...

Ive created a table in Access but when I click on the filter option, it comes out blank. Im using VBA code to populate the table from SQL server. All other column work fine. I have attached a screenshot of what it looks like. There is data in that column. Does anyone know what could cause...

Im not sure what is causing such jump in size. I have about 20 tables, each has maybe 100 rows. The biggest table as 3700 rows. But the total file size is close to 700MB. Im using Access 2010. Thanks.

Here is my VBA Dlookup Code: Public Sub test() Dim frm As Form Set frm = Forms!StationLevelSummary i = Nz(DLookup(" [tblPaxAtStationLevel]![number_of_days]", "tblPaxAtStationLevel", _ "[tblPaxAtStationLevel]![Time_Band] = '" & frm.txtbox_am & "' " & _ " And...

This is the code I'm trying to run from a Standard Module: Public Sub RunPaxCalculations() Dim frm As Form Dim intNumberOfRecordsInFilter Dim i As Integer Set frm = Forms!vr_selection 'intNumberOfRecordsInFilter = frm.filter_entrance.ListCount intNumberOfRecordsInFilter = 5 + 1 'Debug.Print...

I have about 4 combo boxes with a list value of dates in them, combo1 is the 'main control'. When a date from combo1 is chosen and a button is clicked, the other 3 combo boxes receive a default value that closely matches combo1. In fact the default value each of the 3 combo boxes receive exists...

I know that a public constant is available to all subs and modules (hope thats right). I also know that you can only declare these in a module, you can't for example declare these in the form. So how what is the best way of declaring them? At the moment I just have a module that has nothing else...

When Im selecting a value from a texbox, and the value is a number, my query returns chinese characters. But when I run the same query for a text box that contains text, I get the correct text. This is the query I run which gives me chinese characters: SELECT...

I have a form and a sub-form. the form contains a button and the sub-form contains a chart. When the button is clicked on the main form a table gets recreated in the background, the table has some data that should be used in the chart. How do I refresh the chart in the sub-form so that it uses...

I keep on getting this error. I cant figure out why!? the weird part is that I have exactly the same stored procedure but insted of FinancialYear it has a calendar year. So instead of of having something like '2013', it has 'FY2012 - 2013'. The calendar year SP works perfectly, but this does...

I have a SQL Server stored procedure created in a module. I want one of the parameters to come from a combo box in one of the forms. But I can't seem to get access to the form. When ever I type if Forms!Myform. I dont get any drop down options from VBA. Here is a small part of my code: Set...