Search results

My question was answered in the original post. I placed requery code on the main forms OnCurrent. Fortunately, the performance hit was not significant using today’s machines. I was hoping for some insight on the scenario. Code-------------------------------------------------------------...

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...

Yes, the field is bound combo box. The objective behind the combo box involves changing one address to another common location (it happens a lot). The combo box serves less as a search utility. Two combo boxes serve this purpose, Addr1 and AddrName. Either type in the new address line and...

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...

Thank you for everybody’s suggestions. Here’s a new improve approach. IIf(Nz([New].[ProjDate]),Null,CDate([New].[ProjDate])) It works for the LastUpdate field, yet return 4 type conversion errors on the StartDate Field. Arghh! Ok (saying to myself), count to 10 and breathe. Let investigate...

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...