Search results

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

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

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

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

I have a combo box on a Repair form, which is bound to "ComputerID" and uses a query as its row source. The query contains the values of Computer.ComputerID (the ID of a computer), CompMan.Manufacturer (the manufacturer of the computer) and Computer.Model (the computer's model/type). The...

Hi all, I have a customer database where I log computer repairs for my computer repair business. It's far from perfect, however it suits it's function. The problem I'm having is - When you go to the Switchboard and click "New Customer", a form appears where you enter their address. This form...

I know I'm going about this completely the wrong way, so please help me with this if you can... I have written a database that handles Computer Repairs. When a new customer comes along, I go to the Switchboard, click "New Customer" and a form opens at a new record. I type in their details in...

I've got a database that stores data on customers and sales for my computer repair business and was wondering if anyone could help me re-write the following code to be more in line with what I need. On my Repairs form, I have a tab containing around 5 subforms. These subforms are based on...

Ok, I have a database with a list of customers. The main switchboard contains a text box, with a Search button (which is controlled by a macro). Basically, if I want to find a customer, I put the customer's name in the Text Box, press Search (aka Run Macro) and it opens up a form giving me a...

Hi there, I'm creating a database for my computer repair business and it's going to store details on my customers, their computers, and any repairs I carry out on them. I've created some tables, but I'm unable to create the relationships I require between the tables. Here's what I have: I...