Recent content by Jameo

I am importing a spreadsheet with the following code: Sub ImportExcel() Dim strXls As String strXls = "UNC Address Removed For Post" DoCmd.TransferSpreadsheet acImport, , "tblStockImport", _ strXls, True, "Delivery Volumes!" End Sub This works fine, however, the issue is that my...

Hi all, I am having a small issue with an update query - hopefully you will be able to help. I am trying to update a table that has column headings as follows: Gas Day|Gas Hour|Sitename|Avaliability The raw data is received in such a form, so for each day I will have 24 rows of data...

Hi all, I was just wondering if it was possible to create a cross tab query that has sub column headings. For example, I would like a parent column, with a site name, and under that, have other options i.e _________________________________________________________________________________...

Hi all. I will try and set the scene to help you understand what I am trying to acheive. I currently have an access database that has data for a variety of gas storage sites. Ultimately I output a table to excel, with the following headers | SiteName |...

Hi mate. I have managed to get ti right, finally lol. Private Sub Command2_Click() Dim Q As QueryDef, DB As Database Dim Criteria As String Dim ctl As Control Dim Itm As Variant ' Build a list of the selections. Set ctl = Me![List0] For Each Itm In ctl.ItemsSelected...

Hi DCrake. Sorry I will try to be a little more clear now. The SQL string for the query that I wish to use is as follows: SELECT [Power Station Data].[Gas Day], [Power Station Data].[Gas Hour Sort Order], [Power Stations].[Power Station Name], [Power Station Data].[Average Flow ( Vol )]...

Again thanks david. I have just one more question. How would I pass this critera string to a query? I do not want the filtering to take place in the actual form. Thanks

Thanks for that DCake, much appreciated. Just to confirm, CustomerID will be my field that will be filtered by the list box? Also, would the above code be placed in my command button module that runs the query? Many thanks

Hi all, I have a form that filters a query. From that form there are multipe listboxes. At the moment, in my query, I filter the results using the following in the query criterea i.e. [forms]![search]![cboarea] etc. etc. However, I would now like to add amultiple selection list box...