Search results

I've somehow got rid of the error, but it's actually doing exactly the same as before (Not creating a new record with what I typed previously)

Right, something is breaking somewhere, it's throwing an error code at me. It says it can't open the new form because of this line: " DoCmd.OpenForm "Products", , , , acFormAdd, acDialog, ProductCode"

Apologies, where does the FormOpen method go? Oh is that in the "On Open" section of the form properties of the form that opens up?

I have a form on my database that I use for invoicing. It has a [ProductCode] combobox where I type in my product codes and when the correct one is selected, it populates the other fields (e.g. Product Description, Price etc.) If I want to add a new product, I type directly into the...

I solved the problem myself through trying things at random. In two years, this has never worked properly and now it does! I added DoCmd.RunCommand acCmdRefresh to the end of the New Repair button. So on a new record, I guess it refreshes like I needed it to and with the Me.Refresh "On Current"...

Sorry, you've lost me...The way the database is supposed to work is that one customer owns many computers, and one computer will have many repairs. One computer will have one owner, one repair will have one customer and one computer. Is that not the same as what you refer to in your second...

I've uploaded a blank copy of my database, with a few dummy records put in to play with. The main problem is getting the Manufacturer combo box to display properly on the Repair form. I have tried all kinds of things and I just cannot get it working, I think there is something fundamentally...

Hate to be a pain in the backside, but I backed up the database, closed it, made a copy, deleted all the records, put some dummy data in and your code fix works after all :) I don't know why it didn't initially. Many thanks for your help, you have made things so much easier for me! :)

I would, but it's got a couple of hundred customers' names and addresses in it.

Product code. Which might be something like MSW7PRE-C.

Row Source: SELECT Products.ProductID, Products.ProductCode FROM Products ORDER BY Products.ProductCode; Column Count: 2 Bound Column: 1 Column Widths: 0cm;5cm If I just select ProductCode in the Query, it displays the ID for some reason, so I have to have the ID and the ProductCode selected...

That's sorted, now I need to somehow force the combobox in the Invoice form to refresh on its own as I still have to delete the text (else it still says it's not in the list if I click off of it), click off of it or press Enter to accept the entry, retype it and then it's there.

The Invoice form stays open all the time, the Products form opens and closes separately. I added Response = acDataErrAdded to AfterUpdate() but it didn't do anything.

Hi all, I have a form for entering products into an invoice, I have a datasheet and I start typing the product code in the box and if it exists in the database, it autocompletes the field, then populates the other columns with the product description, price, etc. If the product code doesn't...

To be honest, I don't COMPLETELY understand what a cascade update will do. I don't want that box checked, no?

I'm using Access 2003. tblComputer.ComputerID = AutoNumber tblRepair.ComputerID = Number I've just gone through all my backups and it seems to have been set to ComputerID ------------ CustomerID all this time. I wonder how the damn thing ever worked! Sorry to have troubled you all, I'll keep a...

I found the problem but I don't understand the cause. The one-to-many relationship between tblComputer.ComputerID and tblRepair.ComputerID keeps changing to tblComputer.ComputerID and tblRepair.CustomerID. I don't understand why it's doing that.:confused:

Every so often, I need to restore a backup of my database, because I'll add a customer, add the details of their computer, create a new Repair (I have a computer repairs business that uses a database to log all repairs) and it will suddenly say to me: If I add a new repair for existing...

Yes, it's actually in a subreport, not a text box. It'll display the first 15 products, but won't display any more. I've tried selecting "Can Grow" etc., but that doesn't seem to work. I have a Report Header, Page Header, Group Header, then the subreport with the products listed, then in the...

It seems like I've tried everything to get this working... I'm using Access for invoicing. Some customers buy many products and not all of the products will fit in the Detail section of one page, so simply do not appear at all. How can I get Access to create a duplicate of Page 1, and continue...