Search results

Hello, Using Access 2003 I am trying to loop through a query, dim each record as a string, Ignore all Nulls, concatenate the fields together, and then Dim all smaller stings into a LargerString. Query Name: ReviewSFQ (The below code is pulling ALL records from a table, I’d like to change it...

Is there a way to program how a textbox reacts to your cursor when the field is already populated (either by default value or by manual entry?) This doesn't seem consistant in my DB. In some textboxes the cursor will highlight the text and then move on without deleting the data. In other...

Hello All, I have a Continuous form with a text field named Description that holds data input by users. The information usually contains a size such as 1/4" or 1/2" but won't always have the " which is used to denote Inch. I'm using the following code to automatically copy the last field into...

I have a Form: Orders With a subform: OrdersSubformOrderItems I have created a third form: JobNoSearchF When the user enter the last four or five digits of a job number on an unbound text box located on the subform and clicks the search command button the JobNoSearchF forms opens up and...

My first post: First off thanks to all those that answer questions on this forum. I’ve spent hours upon hours finding solutions and learning programming. I’d be stuck without you, so a big THANK YOU!!!! I’ve spent a ton of time looking into this and haven’t found an answer so thought I’d...