Search results

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

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

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

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

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

I've heard and read over and over lookups are bad on tables. I'm still confused on the appropriate usage. I've attached a sample db here of my current db with 4 tables. tblAirlineTransactions - contains lookups for the three tables below. tblAirlines tblFuelProviders tblIssueTypes I've also...

First off, apologies as this is my 3rd attempt at getting this report right. Please allow me to start fresh here: I now have the following queries: qryRMonthlySum2_DailyBal - uses data from qryRMonthlySum3_Compare to obtain daily transaction balance (DailyBal) for each airline. The DailyBal is...

I am using qryRMonthlyGainSum4GainLoss (below) to obtain the Actual Balance as follows: ActualBal: Nz(([Total]+[AirGainLossNZ]),0) Another value for gain/loss, called AirGainLossNZ, is calculated in a separate query as shown below in qryRGainLoss15Report. Somehow I need to reset the value for...

I have the following query which will run on any given date. How could I obtain the previous value for ActualBal? i.e., if the report date is run for 5/1/21, would could I get the ActualBal for 4/30/21? SELECT qryRMonthlySumTrans2.TransactionID, qryRMonthlySumTrans2.TransactionDate...

I have a report which shows a summary of current month's inventory and transactions.I need to roll the previous ACTUAL BALANCE into the next month's report which will become the new month's BEGIN BALANCE. These numbers do not appear to be updating.. Hoping someone can point me in the right...

I have a combobox on a form which is used to build report criteria. The user selects a customer from the combobox, enters a begin/end date then a report is opened based on those values. The report is based off a query and shows only the customer selected in the combobox. I've recently been asked...

Im trying to build a cross-tab report with dynamic column headings. I've download various examples and am trying to import the code from a report in an example database into my own report. I've named the textbox controls for all column headings and detail rows to match that of the example. The...

This should be an easy one but my query is either showing a blank or producing an error when i try to use it for my report. I'm trying to pull two values from an existing query, then replace any null value for AirGainLoss with a 0. SELECT qryRGainLoss15Report.AirlineCompanyLookup...

I have two unbound text box controls on a form; txtStartDate and txtEndDate. I would like the user to only enter a value for txtEndDate. How would I get the date for the first day of the month (based on the date in txtEndDate) and populate it in txtStartDate? I believe the below gets me the...

I have a report based off 15 small queries. Some of those queries accepts a start and end date entered on a form to find transactions between a given time. I would like to re-use those same queries for a new report without having to make all 15 of queries again. The problem is, those queries...

I have a report that is executed from a button on a form. The report is not necessarily slow; it takes 10sec to complete. There are 15 queries that run to get the data necessary for this report. From what I've read, it doesn't seem possible to add a true progress bar. For this case, are there...

I have an existing query of transactions where fuel has been received by any particular airline for any given date. An airline can receive multiple fuel transactions per day. I need to find the SUM of fuel received for each airline; only for the very last day they received it, within the given...

For troubleshooting purposes, I have made two queries looking at the same table. One query 'RunGalIss' accurately uses DSum to total gallons issued for a particular group within a specified timeframe. However 'RunGalRcv' is setup the exact same way but starts with a negative value instead of 0...

I have two queries which are used to get the SUM of previous record groups and the group prior to that using TOP 3 and TOP 2. (I need the 3 most current groups of records). Now I need to reference those SUMs (for each group/airline) for additional calculations; I'm guessing through another...