it.toolbox it.toolbox

Function for Resetting Controls on an Access Form

Programmer's Blog,  msDate = 41772.67 This function resets the control objects on a form. Before jumping into the function, I want to review some important information about controls. Control vs. Controls The Control object represents a control on a form, report, or section, within another control, or attached to another control. The Controls collection contains all of the controls on a form, report, or...

analyticsvidhya.com analyticsvidhya.com

Statistical Analyst – Ahmedabad (2+ years of Experience)

Designation – Statistical Analyst Location – Ahmedabad About employer – Confidential Job description: Do you take great pride in your Craft and Skills? Are you someone with a natural sense of curiosity, and desire to improve? Are you looking for a job you can be passionate about and is more than just a paycheck? Does a collaborative environment that rewards and recognizes great contributions excite you? If this sounds like...

analyticsvidhya.com analyticsvidhya.com

Analyst – Viscadia – New Delhi (1-3 years of experience)

Designation – Analyst Location – New Delhi About employer– Viscadia Job description:               Responsibilities Develop statistical/heuristic models/frameworks that relate marketing or sales activities to financial results Apply various optimization techniques to help clients and Viscadia to the best decisions Inculcate a mindset of constantly looking to identify and address the main business problems and...

databasejournal.com databasejournal.com

Working with external text files in MS Access - Page 2

Working with Schema.ini files Once you've got the Schema.ini file properly defined in the same folder as the text file, you can then take advantage of what's in it when using text files. Why might you want to do this? One big reason would be that some text files don't have headers in them, so there's no easy way of letting Access know what the column names should be. Since the Schema.ini file contains the field names, your linked...

databasejournal.com databasejournal.com

Extending the InputBox function for MS Access Forms

Access provides a rich functionality in terms of controls that are available for use on forms, and what you can do with each control. For instance, the Text Box control has an InputMask property that lets you control how whatever the user types into the text box appears. Depending on what value you choose for the InputMask property, you can have the user's input look like a telephone number without requiring the user to type...

databasejournal.com databasejournal.com

Reporting what's not there

I tend to answer a lot of questions at the UtterAccess Discussion Forums (http://www.utteraccess.com) A recent question there got me thinking about the fact that it's easy to write queries that will show you data in the database that matches a criteria. However, if you want details of when there is no data in the database that matches the criteria, it becomes more difficult. The specific question posed was something like: How would i...