Search results

Hi. I'm working on a form that lets the user import data from another Access database. I'd like to let them choose a database from a particular path. In order to do that, I'd like to have a combo box containing the names of all Access files in that path. I am able to get all the files with this...

Greetings. I have an issue with getting data converted to some sort of format that would be more friendly to databases than its current form, and I'm wondering if anyone here would have some advice. It's a big dataset, around 200,000 records, and they are in tab-delimited format. Unfortunately...

Hi. I'm currently frustrating myself to death trying to figure out why this isn't working. I want to create a table using SQL (or VB if necessary) that has validation code, and I've been told I should use check constraints to do that. However, I can't seem to get check constraints to work at...

Hi. I'm wondering if there is a way to define the settings for each column to be imported when importing from Excel using TransferSpreadsheet. As an example, I am trying to import a four-column spreadsheet from excel in which the first column contains mostly numeric but a few text entries. I...

Hello to all. First time poster. I have a question about creating tables in Access with an SQL query (or VBA, I guess, if that's not possible, though my example below is SQL). Specifically, I'd like to know how one adds validation rules programmatically. For some reason, I can't seem to find...