Search results

I see people are viewing the db, any luck?

I see people are viewing the db, any luck?

Hi, could people take a look at the OrderLineItems form for me. When I enter a Company, I want the Products drop down to only show those products relating to that companyu. Products list can be found in table Products. The drop downs are a little mssed up now showing ID's instead of names but...

Hi, Can anyone help me with this. Usually ok doing these but having a problem with this one. using the Northwind DB and I have the Customer Order Form. I have inserted a combo called cboSupplierID which lists Suppliers. I then have a combo called cboProductID which lists Product Names. When...

Hi, I am thinking of ditching the laptop and getting a tablet. Briefly looked at the new Nexus 7. Do you have any recommendations? Few pointers I intend to use it for personal and business use. Doing Access databases, using Excel, Word, Outlook etc.. Using photoshop, Fireworks...

You want your table set up to be BusinessID in Businesstbl to BusinessID in Peopletbl. On your forms you have BusinessForm, then subform on another tab if you wish PeopleForm. The MasterID will be businessID in Businesstbl to businessID in peopletbl. Therefore linking each person back to a...

I think my box is a list box that displays results based on a query. Can i change list box heading?

No worries mate. Thanks very much.

Create a form to input new entries for businesses. Use the form to edit any details for existing businesses. Create a template for the info you gather and make your table and form replicate that template. I'm getting confused in what you are actually trying to record? What addition info is...

Does XP and Windows 7 both support B Nazanin font? and more importantly do both your versions of Access on each PC support that font package?

Sounds like a complicated way of assiging people to businesses. Why not have alist of business stored, then assign contacts to that business. So you only enter business info once, then for each person that turns up, you just enter their name, dob etc.. The link then assigns them to this...

Hi, i have an unbound box which looks at a query to pull through columns with ID, name, DOB etc... on. is it possible to code in some colour for the column header? Thanks Will

Thanks very much. It sort of just happended lik that, didn't plan not to offer one but didn't plan to offer one obviosuly. I agree though, you never know whats around the corner.

Thanks. New to all this. Do you have a copy of your t&c's? Think is, some of my clients, i have not done contracts for. Clients have been friends or people I know through friends so nothing contract wise drawn up. Do you have a copy of a contract I could view to get some ideas? Same to...

Hi, Just something I need to think about but not sure on the answer to. If someone pays me to design a database, once I handover to them, is that DB there property to do as they wish with? Only reason I ask is I want to know where i stand with regards to people taking my database designs...

Is Null is usual command. But not sure how to get it in your query without seeing it first.

Nope just a standard office block. Would you mind giving me an idiots guide on how to set it up, get the database on it etc...? I go away end of the week, so hoping someone might be able to set it up while I am gone. Thanks

Hi pat, Are you familiar with the Northwind database? I am looking at editing the Order form and putting in a combo to select a Company. Then i want to do the cascade after update on this field, but then options in my second combo (Products) to filter based on company. The Northwind db...

Hi, I have 2 combos on my subform sbfOrderDetails one called cboProductID and one called SupplierID. These selections are stored in table OrderDetails. I want to select a SupplierID and my combo cboProductID only show products that relate to that supplier. My table Products stores the...

Hi, I have invoice reports that pull customer data. However the products I have are split between 2 companies. In the table Supplier I have a logo attached. Is it possible for the invoice report to pull this images based on a combo box select on the order form? So if I select CompanyA on...