Recent content by JoshuaAnthony

That's got it. Thanks!

I was! :) It works perfectly when I do it manually. The PROBLEM occurs when I use the VBA code that I posted above. I've actually been shown a good way around my problem that works (on another board): Dim strSQL As StringDim strTbl As String strTbl = "myusertable" strSQL = "SELECT...

The following code works fine because I explicitly reference "[Forms]![Main Page]![Program]" strSQL = "SELECT * INTO " & strUserTableName & " FROM [Current] WHERE [Program] = '" & [Forms]![Main Page]![Program] & "'" The PROBLEM is that I actually want to define a make-table query based on my...

How do I do this? I tried using CreateTableDef() but that didn't seem to work (table wasn't added to my list of tables), although it didn't raise any errors... Thanks, Joshua

Hi, (Sorry if this is posted in the wrong area!) I use DoCmd.OutputTo to transfer data to an excel file. It seems to work fine but I can't open the file properly (even if I have an OLEunbound linked object) until I close Access. If I try to open it before closing Access, Excel opens and I...

It was for exporting the dynamic recordSource of a form to an Excel file. Somebody has actually suggested something in another forum (I was desperate for an answer!) that worked: strSQL = "SELECT [ID Number], [Field1] FROM [" & Me.RecordSource & "]"

Hi, This code works for me: strSQL = "SELECT * FROM [" & Me.RecordSource & "]" But I can't seem to select certain fields from the recordSource. This is one of my attempts that failed: strSQL = "SELECT [" & Me.RecordSource.[ID Number] & "], [" &...

I have a Microsoft Excel Chart as an unbound object in my form. I have set it to automatic update and in tools->options->advanced, set refresh interval to 1 second. Now, I have VB code that updates the chart when I move to the next record but unfortunately my unbound object doesn't update! I...

Sweet, should be able to figure out an algorithm from here. Thanks!

Hi all, Is it possible to drag items from one control to another in Access? I assume I will need to use MouseDown and MouseUp events but I don't know how to tell whether the cursor is over a particular control when these events occur. NOTE: My controls are continuous subforms if that makes...

Have decided to open a new form (filtered for only the current record) and export data to excel from new form (via button on old form) if that makes sense. Would still like to know if there is an object I can place on a form to do this, allow me to perform excel macros (to build a custom chart)...

Whoops, sorry about that Zameer! Thanks very much for your response. It is much appreciated.

Somebody has answered this for me in another forum. For those who are interested, "Go to Tools menu>Options...>View tab>unselect Window In Taskbar"

Hi, I know it is possible to export data from Access to Excel and to import charts from Excel to Access Forms but not quite sure if it is possible to import a chart (onLoad of form) that is based on data from the current record data of the form (onLoad)? If so, how exactly should I go about...

Hi, Just wondering what determines whether a form has an icon on the Windows taskbar and how I can remove that for all forms except for my "Main" form? Thanks, Joshua