Search results

The solution to my dilemma seems straight-forward, yet my mind has not been forthcoming with a direct route. My Project form has a tab control with multiple sub-forms; these distinct sub-forms relate addresses (multiple addresses); companies, contacts, and tasks to each project (one-to-many)...

Access does not allow me to automatically rebuild my switchboard after having previously created a switchboard. I need to recreate my switchboard since I accidentally deleted both the switchboard form and hidden table. Don’t ask; I thought one could reinitialize the switchboard code by deleting...

My database serves as a complex contact manager, which no other commercial product emulates. My database has a Company Form for inputting company information. The Company form has an address subform. My objective involves selecting a previously entered address through a combo box field (addr1)...

I have immersed myself with a regular expression module, yet remain new to VBA programs. These modules should help me add field headers and correct inconsistencies in my free form data source. My concentration relate to effectively open a file, replace a bunch of text with multiple regular...

Access’s append and update queries aid me when importing data into my database. Even though the approach works, errors creep in when the data become inconsistent. Unfortunately, the import data has a free-form nature. Code and queries allow me to deal with this free-form nature, yet I hope to...

My database uses code and queries to import data. The complexity relates to the free form nature of the source data, which I can not change without code. One of my update queries delivers several type conversion errors when running it. My challenge becomes dealing with all the type conversion...