Search results for query: *

I am wondering if its possible to run an update query and add a prefix to the fields being updated? The specific example is when we receive an order and not all of it can fit onto a truck it creates a back order. In the invoice form I have a "Create BackOrder" button that brings the...

Ok I tried searching through the forums and didn't see what I was looking for, so either Im going about this the wrong way or I didn't look hard enough :) Regardless here is my question.. The end result that I am looking for is to create a report - a general ledger that would show a companies...

Ok I apologize since I know the answer is fairly simple, but all the things I've found searching have been for more complex situations. It's always the easiest parts I struggle with the most... I have a form based on a query of Accounts Receivable. In this form I have added a listbox showing...

Ok I have a very simple DLookup function that I cannot figure out! I have an order detail subform in my order form and I just want the selected product to update the SalePrice field to the Price in the Product table. I took the code directly out of the Northwinds database and changed the code...

Hi I was wondering if anyone could point me in the right direction in regards to books, websites, texts etc that would be good for learning VBA? I have some understanding of it, and a good understanding of other DB principles, but I don't know VBA very well. I would say I am a high level...

I have a Report that shows how many doors need to be built and by what machines. The report itself works fine, but I have a subreport that doesnt want to work. The subreport is based off the same query as the main report, except for it has a function to multiply its total value by 2. This...

I have a form "Batch" that shows the status of a batch and a subform with all the orders that are selected into a batch. Batch: Batch_ID In Production Y/N Shipped Y/N Production Subform: Order_ID Order_Date There are two checkboxes; one for In Production and one for Shipped. These two...

I have a form setup for the addition of materials that belong in a product, with product being the main form and ProductMaterial as the subform, which is continuous. I have 6 combo boxes all dependent on the one in front of it. These are now working great (thank you people!) in the first...

Hopefully the last time I'll need to ask questions about this same database, but you never know :) My question is this. The database is for a furniture manufacturer, and they want a form for designing new products. They want to be able to name the new product give it all its information and...

Hi, I wasn't 100% sure where to post this, but I do know that these boards are by far the best and populated with the best minds, so I think you guys will probably be able to answer this. I have a query that when run comes up with a prompt that asks for a batch number. There are 4 of these...

Hello, I would like to first apologize for what could be a long winded post. I would also like to say what a cool site this is and I can't believe I just found it! Ok so heres the rundown. I just recentley started a job at a furniture design company. They have been around for about 18 years...