Search results

[Solved]Re: Question regarding DLookup Text Boxes Hey Minty, Would just like to say thank you, This post helped me on reading about my issue and learning how to solve it!, Fantastic Resource of information at that website, already bookmarked :)

I see :) that helps a lot, I am looking to eventually work in this field as I find the challenges quite fun, and I am learning Access and Databases during my spare time! Thank you for looking over it! But then How does a User Assign a customer to the specific task that is being created/edited...

Yeah I am getting a little confused myself, Of Course I feel like that would be best to see where I might be going wrong here. Okay so first of all (Attached - OfficeAssignmentForm) This form is what the user will be using to create a Task. It shows the Task ID, Allows the user to assign a...

Oh Sorry I thought I had to Link the query to the specific ID(Primary Key) of the Task. I should link it to the 3rd Column in TaskList Table? Account_Ref (this value is the Primary Key of my customer table, but is in the TaskList Table as a foreign key i believe) When I do this, It runs but it...

Hmm Almost on the right path, I have added the correct control (txtTaskID) however when the query is triggered (double clicking on a customer record in subform) it states it is about to update 0 rows now. Haha :banghead: I have went from updating all rows to none :) something must be wrong...

Found it, there does not appear to be any Example Events though. I attempted to link it to my update Query to update records in Tasklist table however whenever a user double clicks, the query asks to update 9 records instead of just the one Task they are trying to create. Is there a way to do...

Hey Minty I have replicated the search example you linked and actually rewrote it to suit my need however the doesn't seem to be a double click example anywhere in it. Would you have any other examples of these related to my issue above?

ok this may be my fault, I will explain hopefully a bit better. I have 3 Combo Search boxes on TaskList form. 1. SearchbyCustomerName 2. SearchbyCustomerPostCode 3. SearchByCustomerPhoneNumber Below this I have a number of text boxes that have the Dlookup as described above. Examples: If a...

Hi again PLog! PostCode is a unique result for each customer, so it wont have multiple records., Also the combo box is using a query to get customer name from the CustomerTable, and is then using an Append to append the CustomerReference to the Task List table. Is this wrong? I do also wish...

Hey Minty Thank you for that, I perhaps should have explained what this is being used for, The search combo boxes are being used to select a specific customer and then populate a seperate table (called tasklist) with the CustomerReference. Its more of a Find a customer and then assign them...

Hi There everyone! I have some Combo Boxes on a form 1. Search by CustomerName 2. Search by PhoneNo. 3. Search by PostCode. below these I have a number of text boxes related to all kinds of info such as CustomerName, Address1,2,3,4 - PostCode, Email, Phone, etc. These Text Boxes are...

I'd Just like to thank everyone here for their replies, So far they have helped me quite a lot in understanding of this and development of my template. I was away most of the weekend and must apologise for not replying to everyone here sooner! Thank you for your words! I have indeed been...

Hello there, Joined this website after receiving tons of help from here anonymously, However I have now hit a quite confusing part in my learning of Access. Relationship design. I am hoping that some wonderful person here will set me on the right path :banghead: Basically I am using a copy...