Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JoshuaAnthony

    SQL syntax for VBA

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

    Create new table from existing query

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

    Errors exporting data to Excel files. Problem with opening file.

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

    dynamic SQL based on form 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] & "], [" &...
  5. JoshuaAnthony

    Updating Microsoft Excel Chart (unbound object) in form

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

    Dragging items from one control to another?

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

    Imported Charts based on exported data...

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

    Forms -> Icons on Windows Taskbar

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

    Export Current Record (Only) to Excel

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

    Multiple active copies: "The Save action was canceled"

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

Part and Inventory Search

Back
Top