Search results for query: *

Hello, I'm attempting to update a field in a table where the foreign key is equal to the value of a combo box in my form. The table could hold many records with that foreign key (if that makes a difference). The code being used is this: Sub UpdateMarkup() Dim db As dao.Database Dim...

I have a report that has the following layout: GH#1 GF#1A - SUBREPORT1 GF#1B - SUBREPORT2 GF#1C - SUBREPORT3 GF#1D - DISPLAYS SHARED VARIABLE TOTALS In each report I have a shared variable which stores the total of a Running Total Field. The three shared variable have different names...

Thanks to the search I did through these forums I'm able to generate a fixed width, multiple line report that I can then export to text (we're talking lines of about 320 characters). My report consists of data on group headers and footers. I also have some data on report header/footer. No data...

Having the same export issue as the last post in thread768-800893. Thanks to the various threads I was able to find on here regarding exporting to fixed width multiple line files I able to get date exported (including lines of up to 300 characters) in a fixed width format. My issue is that the...

Having the same export issue as the last post in thread768-800893. Thanks to the various threads I was able to find on here regarding exporting to fixed width multiple line files I able to get date exported (including lines of up to 300 characters) in a fixed width format. My issue is that the...

I have a report that list's dates for each record. For each group I want to know how many records have Jan date, feb date, mar date...etc. Instead of creating all these text boxes and making the running totals, I thought of putting it in the back end with VBA...the problem is the code works...

This is not something that I created. I have a subreport (in the main report footer) that doesn't link directly to data in the main report - except that I would like them both to reflect data within the same date ranges. The issue with the way this report is setup is that the users have to...

I need to modify an existing invoicing database: I'd like to select which items of an invoice I would like to show on the actual invoice printout. There's a "Print" checkbox field in each record in the invoice details table. When this field is unchecked, I would like for that line item...

I have a database that saves customer price lists. On the main form (ListMaintenance), i have a button to add a new item to the list. A blank bound (to pricelist_detail) form (AddNewItem) pops up that contains all the fields associated with an item and the user fills in the appropriate...

Access 2002 I have a database that stores PriceLists. My main form contains the header information and the subform contains the detail information (the actual items on the list). I have a "drilldown" button in the detail section of the continuous subform which when clicked pops up a seperate...

I've already looked through a bunch of threads dealing with dlookup...alot of them have helped but I'm still coming up with this error: #name? I have a form based off of an invoice table. I have a combo box that looks up a customer. cmbCustomer: Column(1) = CustomerID Column(2) =...

I have a dropdown (Access 2003) that reads from an inventory table. I want to be able to select an item, click on a button to add the description and the price of the item to a listbox. I want to be able to add the prices of each item in my listbox (think of a simple point of sale system) and...

Hello, I'm using WinXP and Access 2003. I have report that is getting data from a query which has somthing like this: JobNo ContractAmt AmtBilled Month AAA 1000.00 500.00 May AAA 1000.00 750.00 June BBB 2000.00...

I have an inventory report that get's grouped like so: Product Line Inventory Item Warehouse OnHand OnPO OnSO I would like to suppress Inventory Item Header if there is nothing in the detail section. Sandy

I have a text box in a group that displays the sum of the values in 3 other text boxes (within the same group): Field Name: Control Source: textBox1 dlookup(...) textBox2 dlookup(...) textBox3 dlookup(...) Total =nz(Reports![Report]!textBox1,0)+nz...

Hi everyone, I was soo happy because I had finally figured out a way to manipulate the data from my database onto the report - but as soon as I finished typing in my switch statement, i got an error message stating that the string exceeded character limit for that property. Where do I place...

I have a text box that uses some functions to perform a calculation, one of them being a switch function. if the calculation renders a "0" it does not display it on the report - just a blank space. I'm thinking this has something to do with the properties of the text box...any ideas...

I need a text box to show something like this: if txtPeriod < 07 then select NumSold where itemNo=txtItem and year=2004 else select NumSold where itemNo=txtItem and year=2003 i know this isn't the right syntax - just trying to relay the logic. The query that is the underlying...

I have a 20+ page report and the odd pages are formatted oddly and have no actual text on them...I checked the properties on the headers and footers and I don't have any forced page breaks... Is there a simple solution to this? Sandy

I need to create a forecast report that gives an estimate of how much of an inventory item should be purchased in order to have enough on hand for the following month. Besides pulling up information (like how much onHand, onPurchaseOrder, onSalesOrder and onBackOrder - which are easy enough)...