Recent content by foshizzle

ok the hash tags make sense. Thanks! This worked!

I'm trying to run the VBA below to delete table records based on a certain date. The date is selected by the user in a form control then set to TempVars using TempVars!tmpEndDate = Me.txtEndDate.Value Dim strSQL As String strSQL = "Delete * From [tblBalance] WHERE [TransactionDate] = " &...

I was able to get this working using the suggestion from theDBguy. In doing so, I had to go back and join qFUEL_TANKVOLSUM and qFUEL_TRUCKVOLSUM in qFUEL_REPORTTOTALS. Without going to too much detail, I understand it is hard to determine the method for my madness. I'm not a programmer nor a...

I have the following code which is used to run several reports. This code is one part of a larger subset of queries. This query simply queries for the daily balance stored in a table (for reasons not discussed here). I'd like to use this query for one final report for the current day's balance...

Pat - I think you were on to something here. I re-built the query for this and it worked without adding the additional blanks. thanks for the suggestion!

Hmm.. I also tried this, which also returns the expected results in the query itself, but the report hangs.. Let me check that report out again PARAMETERS [TempVars]![tmpEndDate] DateTime; SELECT tblBalance.TransactionDate, tblBalance.AirlineCompanyLookup, tblBalance.Balance AS PrvBalance...

Hi Pat, Here is the modified query. When I run it this way, it takes an hour or so, then spits out the same result. what did i miss? PARAMETERS [TempVars]![tmpEndDate] DateTime; SELECT tblBalance.TransactionDate, tblBalance.AirlineCompanyLookup, tblBalance.Balance AS PrvBalance, (Select...

I have the following code which will return all Airline Companies if combobox "cboAirlineCompany" on a form is left blank. The results of the query returns the expected results however, if I run this in a report, the first page is blank as if it was using NULL from the blank combobox. Then, all...

arnelgp - Thank you. I no longer get the error when opening the form and have verified the security works as its supposed to!

We've recently started rolling out the 64-bit version of all Microsoft Office applications. The problem is, this broke the security which was originally from accesssecurityblog.com and no longer online. Luckily, I did a copy/paste for my documentation which is shown on the attached PDF. I've...

ok - ive found a work around. thanks anyway!

I've tried both of these in the detail section of the report with no luck. I don't get an error or anything. I've tried placing a message box to pop up as well to verify something is happening using "MsgBox Me.txtTransactionDate.Value" but nothing happens.

Is it possible to hide a report control based on a date? On this report, I have two text controls in the report detail: txtTransactionDate and txtGainLoss I only want to show the txtGainLoss control if txtTransactionDate (report date) is the last day of the month. I'm not sure its possible...

Hi Doc, these two tables obviously have two different PKs. In this case, the PK in tableA would never be in tableC. I was confused of why I should bother with the PK fields. At any rate, I got it working with your advice using this: INSERT INTO tblAirlineTransactions ( TransactionID...

I'm running an APPEND query and trying to only insert records that do not yet exist. This query appends records from two different tables as follows: tblAirlineTransactions TransactionDate, AirlineCompany, IssueType, GallonsReceived tblGainLoss TransactionDate, AirlineCompany, IssueType...