Search results

Thanks Pat - that was an incredibly informative reply - some of that stuff I hadn't even thought of. I still have a problem though. My tables are like this: Invoice ->many Orders Orders->many OrderItems Orders->many OrderLocations OrderItems->Many taxes. If I want to input a new Order and...

That's what I was going to do - but won't it run my summary query 4 times then? Or does it cache results? Also, the resulting SQL statement will be fantastically long - is there a max string length for SQL statements in code?

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

Well, the reason I had to do it this way is I can't make a simple items table that I lookup items in. Virtually every item is different and created at design time. This is a trucking company. Every "item" is actually different on every order. Sometimes they might charge $20/hour for their...

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

oops - I misread your post the first time I replied. As far as I understand it, all you want is a form that can add data to your database? Or are you saying you want a form that will allow users to change the database *structure*?

Short answer cuz I don't have much time rightr now: Use a list box :-) There's lots of samples and info in the help files on how to use list boxes and then determine, in code, which items in the listbox are selected.

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

Yes, my setup is already as Audrey suggested, but to no avail. This may be unsolvable, but if I find a solution I'll post it :( Very disappointing.

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?

Hm. Actually, cogent1, that might work rather well - if it doesn't I'll let you know. I might still need a query because there is more than one item on the order, and I would have to group my result by order, summing the taxes etc. On the other hand, might be able to do that on the report too...

I'm not sure what you mean.... Possible taxes are GST and PST. At present, I allow the user to select whether an item should be charged PST, GST, or both. The GST and PST rates are fixed according to the Taxes table, but can be modified by modifying that table. So when I calculate the value...

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!

Actually, I found a workaround. Turns out if you specify a line spacing in the control, Access chooses to discard the last line in the field. Not very convenient, IMHO, but as long as you put the line spacing to 0" it all shows up.

Same problem here I just ran into exactly the same problem, only I'm using my table as a datasource. I have a memo field that seems to have all the data in the table, but even though the grow/shrink properties of the textbox on the report are set to TRUE, it seems to only grow enough to show...

My apologies - my posts were a bit slow in arriving to the forum, and I was confusing myself. I'll try not to drag others down with me in the future.

Solved ? In case anyone's interested, you can't do this: nz(Sum([x]*[y]),0) + nz(Sum([a]*[b]),0) and hope to get the right answer. The two individual sums will be correct, but instead of adding them Access will concatenate the two sums. You have to do Sum(nz([x],0)*nz([y],0)) +...