Search results

Does Access support CASE expressions in SQL yet, like SQL Server? As detailed here

Hi everyone! I'm having a lot of difficulty with this one. Here's a tiny piece of the table: Year | Profession | Cohort | Supply | Additions | Subtractions 2000 Doctor 1 100 10 10 2000 Doctor 2 100 10 10 The cohorts...

Hi there, I use Excel as a frontend to Access, partially because my client *really* wanted to edit the Access database tables in a spreadsheet environment. My code imports sections of the tables and puts them in Excel worksheets. The client makes changes, and then my VBA code dumps the...

Hi there, I'm trying to figure out the best way to do this, and coul duse some input. I currently have a few data columns with primary keys KEYA KEYB KEYC, and a few other data columns with pk KEYA, KEYB, KEYC, KEYD, and a few OTHER columns with pk KEYA, KEYB. Right now I have three tables...

I'm writing a predictive modeling program with Access 2k wherein the data for each year is dependent on the data calculated for the year before it. So right now I have one query for each year that I'm predicting information, and the criteria limits the input data to the year before it. (i.e...

I'm developing a complicated predictive model program with Office 2000. There's so much data, it needs to be in Access (some tables have > 85000 rows), but some of the base tables require editing with Excel, because the end user wants to be able to use formulas to manipulate base data for each...

Ok, I've trying to do something complicated and could use some advice. Right now, I have a whole bunch of tables and queries in an Access database. I'm using the data to do predictive modeling, and their are a series of "scenarios", so that every table's data is duplicated and appended to the...

Sorry, long question but really not that complicated: I have an aggregate sum query on an orders table (in code) that, given the appropriate parameter (an invoice number), will come up with one row of data (4 items - subtotal, total, and the totals of 2 taxes). I want to make an update query...

I need some advice. Ok, I know it's very bad to store calculated values, but I'm writing an app to keep track of orders and invoices. I keep my taxes in a lookup table, and if they change, I don't want to see incorrect values for, say, last year's invoices when I look them up. So I think I...

Hi there everyone, Does anyone know if I can set the height of a pageheader or reportheader either with a macro or in code? I've figured out how to repeat subreport headers thanks to the MS KB article at http://support.microsoft.com/default.aspx?scid=kb;en-us;231808 but I need to not only...

Please help me get rid of unwanted messages. Here is a detailed explanation of the problem: The Problem: I have a report based on a query. When I click on the the switchboard item to open the report, the report runs a macro in its "on open" event. The macro opens a "date" form that allows...

My question is if I use VB to open a form that is base don a query, with DoCMD.OpenForm, and use parameters in the "Where" clause, does Access run the whole query and then filter the records in the form, or does it enter the "Where" clause in the query before running it?

Please help me with this query! I've got a table "orderitems" that allows people to enter unit prices, # of units, and then select a tax code from a combo box. The combo box gets values from a tax table which has three fields: tax_code, tax_desc, and tax_rate. Taxes available are NONE, GST...

Ok, I need advice. At the risk of repeating a question that has already been asked (I've searched, but you never know), I'm wondering about using VS.NET (with either an MDB or and MSDE backend) to create my database app instead of using Access. Since I own Access 2k but recently got a new...

Does anyone know of an easy way to make sure that a report's first page is printed with a larger top margin for pre-printed letterhead, but all subsequent pages have a smaller top margin? Thanks!

Bug in Access? Turn null values into zero... This should be easy. I have two tables, "Orders" and "Trucks", related by an order_id field. I run a query that returns all Orders records and only Trucks records that match an order_id, then I group by order_id. So I end up with a table something...

I've got a form that shows orders. An order has a field "invoice_number" that is null until that order has been put on an invoice. What's the best way to disallow edits to that order record (and its subforms) ony if there is a value in that invoice_number field, so that orders cannot be edited...

Date turns into 12/30/1899 ?? I've got a form where, among other things, users enter a date in a text box. The box is formatted to MM/DD/YY. In my VBA code (Access2k) I've got Dim my_date As Date my_date = SubFrm_invoice_2!txt_invoice_date.Value Later on I go on to use an SQL statement...

Hi there everyone, I've got records that are orders. Each order has about 10 possible items. Each item has a checkbox stating whether or not PST will be charged on the item for that particular order (it has to be done this way). I wanted to make a query that calculated the PST for each order...

Hi all, I want to make my own little wizard to create invoices. The first form should ask for an invoice number and have "Next" and "Cancel" buttons. The next form should ask for a PO number, and the next form should display a list of orders to add to the invoice. The last form will give the...