Search results

You did not tell him what to replace!

SELECT * FROM mSysObjects

Hi, I am sorry that you are having such a terrible experience with Access. I cannot comment without great detail. Maybe it is something that you are doing wrong. Since the issue persists, I recommend that you hand the DB over to a second set of eyes. I freelance on Upwork and I am often that...

You need to stop referring to the Column Property.

First, you cannot refer to the Column Property in a Query Criteria Expression. If you have a Combo Box with a Data and the Bound Column is 1 and is an ID, change the Bound Column to "2", or reposition the Columns in your Combo Box so that the Date is the First Column. Your expression should...

Hi, You can link to the CSV File in Access. Go to the External Data Tab, then click the New Data Source button from the Ribbon, and under the File Menu, select Text File. You will be taken through the Spec Definitions, i.e. delimiters, data types, etc., and once complete, the CSV Will be...

Once again, depending on how complex your Access Application will become, there are a couple of approaches available to you. If it is a simple application, keep it simple, you could add several more Fields to your Table to facilitate the Physical Address. If your Application is going to be a...

Neither am I. I mentioned what alterations could be done to the Table to facilitate the OP needs. I may be new here, but I have been developing in Access since 1991. Please do not underestimate my input. You, GPGeorge, and I are connected on LinkedIn. I am just using my Business Handler here.

Feel free to add new or additional Columns to facilitate your needs. No need to add a new table. You could also add an Address Type ID Column to identify whether it is a mailing address or a billing address. You can then have filtered query sets one for each for Drop Down Boxes.

Hi All, I am an Access Guru from the old days (c.1.0). I look forward to receiving and providing tips at this forum. I live in USA.Texas.Austin. I currently work at AT&T. I also have my DBA as spaLOGICng. You can find me at LinkedIN, Elance, and Facebook.