Search results

Hi Guys, I decided to normalize my addresses out of COMPANY and CONTRACT entries into a seperate table. This idea works fine until I try to add new entries or update existing entries. Normalization has made it impossble for my database to function properly. Heres the situation: Company...

Hi Guys, I'm trying to create a simple form that allows me to enter information about a new customer into my database. I've normalized Addresses into another table. I've attached a stripped down example of my problem to this thread. Everything works fine when I'm viewing exisitng records...

Almost there Hey Paul, Thanks a million man, works flawlessly This is what I ended up with for anyone that might need somthing like this: Private Sub Check44_Click() On Error GoTo Err_Check44 If Check44.Value = True Then Me.PropertyAddress = DLookup("StreetAddress", "Customers"...

Tried a few things... not working.. Hey Guys, OK this is what Ive done so far: Private Sub AddCheck_Click() Dim Locked As Boolean If AddCheck.Value = vbChecked Then Me.PropertyAddress = Me.PA Me.City = Me.Cty Me.PostalCode = Me.PC Locked = True Else...

Hi Guys, I have a big issue I'm not sure on: 1. I have a combo box in my "NewOrder" form that I use to select a customer for the order. I'd like to have a button that would open my NewCustomer form if a new customer was needed.. I can do that.... but how to I make it so that the new customer...

I agree Thanks Banana, I was wondering the same thing myself... just thought that i might be easier, and reflect more as to how the business functions. Not worth the chaos it would create. Cheers.

I agree Thanks Banana, I was wondering the same thing myself... just thought that i might be easier, and reflect more as to how the business functions. Not worth the chaos it would create. Cheers.

Hi Guys, For the company I'm working with, I'm required to allow for two contract types. One for a single on-going service, and one for installation (many one-time services). Right now I've got the single on-going service listed in a products table with a "ContractType" lookup field...

Hi Guys, I need a hand understanding receipts... heres the way I see it: Many Customers can at Many Times, buy Many Products. Resolution: Customers to Times (or Instances) = Receipt (or Order) Times (or Instances) to Products = LineItems LineItems within Receipts within Customers Fairly...

I'll try to make that work I'll try to make that work. Theres plenty of sources here to use the structure of an IF statement in VB... I'll let you know tomorow if I run into any problems. (I probably will so please check)... Id like to try to write this on my own! THanks man.

Very New to VB.. example code somwhere? pbaldy, Thanks a million for your response. I understand what you wrote, and I know where and how to input the code... But i dont know the code!! Where could I find examples for the specific coding?? If you have similar code somwhere I'm sure I could...

Please Help -- "Same as Billing Address" Checkbox --- is this possible!?!?!? Hey Guys, I'm looking to create a "Same As Billing Address" check box that would automatically udpate the address in an order to reflect the customer's billing address. I understand how to sync a combo box to an...

Sorry to push here guys, Not a jerk here or anything, but i need to know if this is possible!!! Anyone have any ideas??

Hey Guys, I'm looking to create a "Same As Billing Address" check box that would automatically udpate the address in an order to reflect the customer's billing address. I understand how to sync a combo box to an option group ([URL="http://www.fontstuff.com/access/acctut10.htm"] -- great...

Hi Guys, One of the things Im most struggling with from a theoretical standpoint is simply the signifigance of having more than one primary key in a table... and the overall purpose of a foreign key. Whats your understanding of this... perhaps give an example or one or the other... im...

Hi Guys, My company maintains properties, some of which ARE the address of the billing company, some of which ARE NOT... I've normalized my database by creating a seperate table for addresses so as to eliminate the redundancy of typing the address in twice in the case of the maintaned property...

Thanks man, I know that last setup was right messed and chaotic... I'm reforming it as I type this... I'll post futher questions specifcally in a new thread. Thanks again.

Hi Guys, Hopefully a simple question here. I looking to create a form that creates a contract for a particular client we deal with (grounds maintenance). In that form I'm looking to give the end user the option of selecting an existing billing address (for a property mgmt. company for example)...

A few New ideas... Need more help!!! Hey disgner, I've attached the relationship layout as you reccomended, though some things have changed since my last post. 1. I've had to split the company, contacts, and locations into three different tables as our contact person X may look after...

Hey guys, Im working on a project for a landscaping company that does Installation and Maintenance Services that wants to be able to build contracts, bid and log its customers into a simple database and I've run into an issue I cant resolve. I've normalized data so far as follows...