Recent content by davper

I need a dope slap. Any volunteers? Just noticed I should be using acImportFixed instead of acImportDelim. Works as it should now.

I assume you mean 'runsavedimportexport'. I cannot specify the file to import at runtime. The name is never the same.

I am open to alternatives to my problem. Using Access 2007 on Win XP I have created an import spec and saved it as TODImport. When done as a manual import it works as it should. But when run as a VBA Script (DoCmd.TransferText acImportDelim, "TODImport", "tmpTable", strFile), it does not. The...

We have a winner! [Option] it is.:D Thanks for your help guys. I should keep a list of the reserved words handy for just such an occasion.

I can't figure out what is wrong with my insert statement. I know it is going to be something simple that I am missing. I have just spent too much time trying to resolve. Here is my code strSQL = "Insert into tbl_ProvExpenses (CID,ETID,Option,StartDate," & _...

A search for Recursive Procedure led me here: http://support.microsoft.com/kb/132242 This works perfectly. Searching is tough to do when you don't know what you are looking for.

When I build the combobox, I would have 2 values: the integer for the day of the week and this is your bound column and is hidden from view, The other value is the name of the weekday. If rewriting the combosbox is not possible, you can use a Select Case select case combobox.value case...

Thanks for the syntax but a recursive query is not supported in Access. At least from what I am finding at the moment. All examples seem to show that I need to know how many levels deep.

Weekday(Date()) returns an integer from 1(Sunday) to 7(Saturday) iif(Weekday(Date()) between 2 and 6, "Weekday", "Weekend")

I think you want to use an array instead of the many REG variables Dim Region(6) as String 'Arrays start with 0 Dim strSQL as String Region(0) = "MTN" Region(1) = "NCR" Region(2) = "SWR" Region(3) = "MTN" Region(4) = "NER" Region(5) = "SCR" Region(6) = "SER" For n = 0 to 6 strSQL = "UPDATE...

My issue: I have a list of accounts. And some of those accounts are merely a heading for a group of subaccounts. Each record has a Parent. It is possible (unlikely but possible) that a parent child relationship can go down infinitely. Realistically 4 levels but I have to prepare for the...

:eek: Wow! You actually went through the trouble of creating an example. I am so appreciative. :D Your example is spot on. I'll dig through the code and adapt to my app. Thank You So Much!

I have a form based on table1 where the user must select an EFFORT TYPE that is based off of values in table2 with limit to list enabled. I want to include in the combobox a value labeled ADD NEW EFFORT TYPE. when the user selects this item, another form (based on table2) pops up allowing the...

After much research and trial and error, I was able to solve my issue. I set the ControlSource of the subform container to nothing, edited the subform, then reset the ControlSource. Private Sub Form_Current() Me.sfm_ClinEff.SourceObject = "" Call CreateClinicalEfforts(Me.CID) Call...

Win XP Access 2003 I am trying to build a complex form where a user can view and change the details of a Contract. The form has a tab control that contains different sections of of the contract to keep the screen size down. On each tab, there is a form based on a crosstab query that displays...