Search results for query: *

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

Hi, I know that I can use DoCmd.OutputTo in order to export form data to excel spreadsheets but I'd like to only export data for the CURRENT record if at all possible. The form that data is exported from could be based on a number of different queries (depending on user-selected search...

Thanks very much. That works now. So when you save a form or report, you are actually saving design changes rather than the record to the table the form is linked to? Also, I've found that when I close a form, changes I have made to the records are seen in the table without saving at all. Is...

In fact, just to do a simple test I created a table with 2 fields and linked it to a form. Opening two copies of this database, it doesn't matter if I am adding or editing records (regardless of whether both copies are manipulating EXACTLY the same record or not) I get the following message...

Errrmmmm... I know this is quite messy but it works fine when I only have one copy of Access running: Private Sub Log_Transfer_Details_Click() On Error GoTo Err_Log_Transfer_Details_Click Dim Next_Location As String DoCmd.OpenForm "Personnel", , ...

Hi there, I chose Microsoft Access to write a database because I was under the impression that it could handle multiple users manipulating data concurrently. I have written the database and have done a few tests with two copies open at the same time. I have no problems in a form which is used...