Search results

I have two tables. tblTrafficFormat (This tables lists all the possible formats available): TrafficFormatID, Format, SummaryFormat (I am happy this table has the correct info within it) tblTrafficNational (This table lists all the volumes by Office where each volume is a particular format)...

I have a query which runs fine, however one of the outputs is a calculated field and i use the Format(someValue,"Fixed") method of specifying the format for the % Change . Here is the query SELECT tblTempBearsWeek3.SymbolCode AS [Short Ticker], tblTempBullsWeek3.SymbolCode AS [Long Ticker]...

I am receiving a Query too complex error. I have two sub queries developed using the Query Wizard. In one Subquery I get 9 columns with 28 records, and the other 9 columns and 30 records. Here are the two queries: Named: qryBestPerformingSpreads_Week9PricesBulls SELECT...

I am trying to use a Connection to an xlsx spredsheet to read in a table of information (the data is not a table, just laid out in a table, see attached, the one I am trying to load is xlsx not xls but I cannot for some reson upload the xlsx one on here) I have the following declared: Dim...

I have a userform that pops up when I am implementing a VBA subroutine. The nature of the form is simply to update the user what progress through the operation the code is using a label called lblProgressText. So, I have a form called frmProgress and in my loop I use: DoEvents...

I am trying to use a Combobox BeforeUpdate Event to achieve a required result. I have two combo boxes inside a frame. The first is a year number 2011, 2012, 2013, 2014 The Second is the Week No ranging from 1-52, but 1-53 in some cases and this updates accordingly with the year number...

I cannot quite get my head around this. I have a cross tab query. Essentially it groups together posted volumes into week numbers for different offices. However, when I run the query, the order of the columns is not in a logical number order. I get Week 1 then Week 10 then Week 11 and Week 2...

trtying to query the Symbol table to see if a recod exists with symbol code. I am querying the tblSymbol table from Excelk vba and the Access DB is on my machine. The code I am using is: Set rs = New ADODB.Recordset rs.Open "tblSymbol", cn, adOpenKeyset, adLockOptimistic, adCmdTable...

I am trying to update an Access Table from Excel VBA and it is stopping on the update line: Set cn = New ADODB.Connection 'MyConn = ThisWorkbook.Path & Application.PathSeparator & TARGET_DB cn.ConnectionString = "Provider = Microsoft.ACE.OLEDB.12.0;" & _ "Data...

I am almost certain my code is correct but cannot figure out why it isn't working so there must be more to it that I am missing.... Simply, I am trying to Cancel an update in a Combo Box's Before Update event in the Form: frmManageAdditionalCollections (the colletions combo box) Cancel =...

I have a form called "frmManageACF", query called "qryACFFill". On frmManageACF I have a combo box (name cmbACFFill) which has three cols. col1 = SiteID, col2 = Site code, and col 3 = SiteName. The combo box Bound column is set to 1. In qryACFFill, results are selected where...

I have a Main form (Home), and on it is a subform (Home_subform). Home_subform has at its record source some query results I made through the Query Wizard. I want Home_subform to change its record source to another Query which I have again designed with the Query Wizard. I want to do this in...

Is there a way to open an Access Database from a batch file or VBS file wait for 20 seconds and then close the Access file. Preferably I would like the Access file to run in either invisible or minimized mode. I would like the Access Database to close again after the 20 seconds has elapsed...

Having all kinds of prblems trying to get this to work. I want to read a value of a cell from a closed workbook. I have since read that using the ExecuteExcel4Macro method is the best way to approach this (tell me if it isn't). Dim ACPRanges As clACPRanges Dim arg As String Dim Sheet...

Help needed please on a split database (front and back end). I have completed the split and have deployed the backend to SharePoint. The front end is sat on my (and others) machines with linked tables to the SharePoint lists. This is all fine and works well. However this is where I need help...

I have a report and within the report is a subreport. Within the subreport I have an =sum([HoursRecorded]*24) and the Text Box label control is named 'SumHours'. The Subreport within the main form is named [subreportinvoice]. In the footer of the main form, I have the following...

I have embedded a sub report within a report. I have produced a subreport with all the timesheets on a single invoice so they are grouped one under another. However, when I then embed this within my main Invoice Report I get a number of instances of this subreport. I am finding this very...

I am trying to set my form up so that the user can move between controls with the tab button. I thought this would be very simple but I have an issue. I have 4 labels one below another, and 3 buttons to the right of them, one below another. I want to tab down the labels and then across and down...

I am using the following code to insert a record into the tblPayments Table I am confident that the values are correct in the query see screenshot and the table schema is: PaymentID, InvoiceID, PaymentDate, PaymentAmount, Notes theQuery = "INSERT INTO tblPayments " _ &...

I have three tables, Invoice, Timesheet and Linker. Invoice can contain several Timesheets and any client can have a number of Invoices. The Linker table stores the InvoiceID and the TimsheetID so I can keep track on which Timesheet Records are attached to any individual invoice record. Here...