Search results

Working with a vendor table. There can be many different vendor companies we order from... Within the vendor company, there can be different contacts according to department. How do you structure a table accounting for this scenario? Example: Company XYZ has several different locations...

Gotcha! Cheers! -Kyp

Morning all! Quick dumb question.... When creating a contact table, and the contact has a physical address that differs from the mailing address, how is that usually handled? Are both address' in the same table or, are the address separated some king of way? Cheers! -Kyp

@Pat Hartman I am back at it this morning and will have a look. Thanks for the template! Cheers! -Kyp

@Pat Hartman I do understand what you are saying. (Don’t try to reinvent the wheel) Can you point me to any documentation or example that accomplish this same task? cheers! -Kyp

@The_Doc_Man Thanks for the explanation. I am always looking for the "Theory of operation", and "Cause and effect". For me, knowing the theory as well as the cause/effect helps me to fully understand the logic and further educate myself. Cheers! -Kyp

@jdraw The completed logic that properly works, appreciate your help! Private Sub cmdSaveUpdate_Click() Dim frm As [Form_Cost Center Details] Dim db As Database Dim rec As Recordset Set db = CurrentDb Set rec = db.OpenRecordset("Select * from CostCenter WHERE CostCenter.ID ="...

Changing the statement seems to work for updating the record however, I am still getting this error. I was able to fix "The data has been changed" message with Me.Requery at the end of the logic. Thanks for the assistance! Cheers! -Kyp

Yes the CostCenterID is numeric. I will give it a try. Cheers! -Kyp

Yes, that is correct. One record selected from the listbox populates the text boxes on the form. Make the changes in the text boxes and save the updated record.

@jdraw Thanks for the quick reply! Looking at https://docs.microsoft.com at the "ListBox.ItemsSelected Property" I used the example code in my list box double click event and watched the immediate window for the result and can see the selected record ID: Private Sub...

Morning all. Trying to educate myself on how to update a record selected from a list box on a form. This is what I have and while it somewhat works, it's not correct. Errors listed at the end of the post. Form Name: (Cost Center Details) In the form, I have an unbound list box...

Thanks!

I am assuming that "kupfile" is just an arbitrary field name right?

That's a lot easier to understand. Thanks!

I have seen this expression in several places. Would someone please explain the theory of operation. File As: IIf(IsNull([Last Name]);IIf(IsNull([First Name]);[Company];[First Name]);IIf(IsNull([First Name]);[Last Name];[Last Name] & ", " & [First Name])) The reason I ask is that when I...

Thanks @Gasman, I will give it a shot. -Kyp

I have not been in MS Access for a while. When I was using access, I was just learning so I am back to square one. I have two tables, tblVendorCompany and tblVendorContact. I've created a "One to Many" relationship as pictured below. What type of query do I need to create to combine the two...

That is a really big difference from what I had! I didn't know it was going to be that difficult, Wanted to start again with something easy! :cautious: I wish I could hear your thought process while putting ti together! I recon the next step creating queries, forms and reports will be a hoot...

That is correct, not including the company I work for, there are 15 different companies with our assets that we have to maintain. We also pickup new companies from time to time.