Search results for query: *

Hello, I am still stuck on this one; For a form that creates a job ticket, I need to get values from a query and assign those values to certain applicable text boxes. One query value is based on the currently selected value in a combo box (cboCustomer). I had a suggestion in another thread to...

First, thanks to everyone for thier help in the past. There are some tricky things that I have to deal with for the application that I am creating and I am more of an Access novice than expert. Anyhow, hear is the latest challange. On a form that creates a new job ticket record, I need to have...

Pretty simple question, sorry if this is a little too simple; How do I check the open propery of a form in an if statement? I need something like this; if( frmJobTicket isOpen = true) 'do this else 'do this Thanks, -Joe

Hello, I have to open a form that will be used to create a new record. Typically, I would just set the Data Entry property of the form to "yes" and would be pretty much set. However, when the form opens I want to use the default values that are contained in a particular record of the data...

Hello, I have to produce an automatically generated number using VBA for an Access db. The format is supposed to be the year followed by the day and month followed by an incremental number. For example; 200505010001 200505010002 200505010002 etc.... The incremental number part would reset from...