Search results

Otherwise it might be a reference issue, but not having used access 2003/xp I am not sure as to what reference might be missing.

Can't be sure, but maybe the version of access you are using does not have the FileDialog object. If you are using access 2000 you need a fair amount of code to bring up the file dialog box, but do a search on here for common dialog and that should show you everything you need to know. Hope...

Yes you can just make a routine that does most of the work, applying a parameter. Then call the routine from each button with 1 line of code that can be copied and pasted and slightly modified for each button. For example Public Sub sFilterListBox(strFilterValue as string) Dim strSQL as...

oh i see. ok, something like: Dim strSQL as string strSQL = "SELECT tblCustomers.CustomerID, tblCustomers.FName, tblCustomers.LName, tblCustomers.City, tblCustomers.Phone FROM tblCustomers WHERE tblCustomers" & me.cmbField.value & " LIKE " & Me.Toggle22.caption & ";" On each toggle buttons...

so where are you getting the value to filter by? unless you are confusing filter with sort that is.

I would guess you need to make a query (or use sql in vba) that would change the rowsource of your listbox according to your selected field - I assume you are using a combo box for the selection? eg. After update of myCombo strSQL = "SELECT myTable.myField FROM myTable WHERE...

Code to import data from the files. Public Sub sImportFiles() '========== ' ' Purpose: ' To import multiple files of type strImportFileType from strImportFromPath, to strImportToTable. ' '========== Dim strFileToImport As String ' The name of the file to import. Dim iCSVcnt As...

More to follow...

The configuration code... '========== ' ' Module: ' modConfig ' ' Description: ' Code to read information from tcfgConfig. ' ' Contents: ' Global variables relating to the module. ' sGetConfig To get the configuration information from tblConfig. '...

The next snippet checks to see if the file identified from the previous has already been imported or not. Public Function fFileImported(strFImp As String) As Boolean '========== ' ' Function: ' fFileImported ' ' Purpose: ' To check if a file specified by strFImp has already been...

Hi all just thought I'd share some code with you, in the hope that someone might find it useful. Will post each snippet seperately. The first one copies files to be imported to a different folder (as the files I am importing are on a server, by copying them locally the import process should be...

Hi all, Am currently developing a little (I say little, hah) database to import CSV files from a network path, the CSVs hold information about network attacks on a daily basis (CSVs are created by CiscoSecure ACS). At present the database I am working on imports multiple CSVs into Access no...

Well I'm trying to teach myself ColdFusion at the moment, but I will endeavour to learn the events of a form at some point. Thanks for your help, and apologies if we started to head towards argument territory.

So the Before Update event happens after the user has typed in changes, but before the changes are sent to the table?

The books I use are the Sybex Access books. I'm not syaing that they suggest using unbound forms, becasue to be honest I find it hard to study by reading, and most of my learning has come from doing. In terms of what it is I don't understand, well in this case it would be preventing updates to...

Ok my bad, didn't spot that bit, apologies.

I wouldn't be writing custom code for each form, I would be reusing the same code (cut & paste style) as often as possible, hence the reason I changed the code in my initial post, to that in my latter post! Ok, some forms are going to require custom code, but the basics will remain the same...

I can't offer any advice on how to do this in Access, as this is way above my head too. But can you not just use the standard Windows search facility (i.e Start|Find files or folders...) to find any text files containing the contents of your variable? There are advanced options for "containing...

Well let's just put the differneced in opinions of bound vs. unbound forms to the fact that they are just differences in opinions... I'm sure there are threads all over the forum that discuss this issue. Anyway, thanks to those that offered advice and suggestions. I have since modified the...

Fantasatic, Nz works a treat! That's why I like all this IT stuff, always learning, can never know everything. Thanks again. G