Recent content by ChiTownDiva

Thanks earthandfire... Maybe I'm an idiot (and that's not out of the realm of possibility [bigcheeks]), but I'm not understanding what "fsize Mod FixedWidthSizeForOneSpec" is supposed to be. Is the whole thing a variable? Thanks ChiTownDiva [ponytails]

Happy Monday All... I have a question... I want to import some data using an import spec (no problem), but sometimes the data will have one extra column that would need to be excluded depending on the customer (no problem there either--I have an extra import spec to take care of that). What I...

Thanks PHV...works like a charm!! [wiggle] One star from me! ChiTownDivaus [ponytails]

Happy Monday All... I have some code: Function GoGet() DoCmd.TransferText acImportFixed, "MGT/OWNER Import Specification", "MGMT", "C:\Documents and Settings\r60016\My Documents\Linkage\Supermarkets\Albertsons\Imports\MANAGEMENT.txt", False, "" Beep MsgBox "Management File Import...

Afternoon All... I have a database where I've changed the startup option not to display the database window. It works half the time. Sometime the form comes up, sometimes the database window comes up. I even have an AutoExec macro that says open the form. What is going on? I don't...

Thanks for the response PHV... If the form is bound to a select query, then how do you update table 2? I know you can't update fields in a select query. Thanks. ChiTownDiva [ponytails2]

I two tables with the customer number in common. Is there a way to link a form to a query to access the customer from one table, but update the information to another? Let me try to give an example-- Table 1 has customer id, chg analyst, standardization date. Table 2 has customer id, sr...

As soon as I hit the "Submit" button, I figured it out... IIf(Right([STORE #],3) Like "706",Left([store #],InStr([store #],"706")-1),[STORE #]) Thanks anyway... ChiTownDiva [ponytails2]

Afternoon All... I have an IIf function question. I have some store numbers: 42 78 189 23706 30706 35706 107706 121706 Here's my problem--I want to keep the digits in front of 706, so I want to write a formula or module that uses: If Right([StoreNumber], 3) = 706 then Left([storenumber]...

As soon as I posted my question, I figured it out. (Duhhhh). I think I just needed to step away from it overnight. Thanks PHV and Lupins46. ChiTownDiva [ponytails]

Happy Thursday All...[morning] What I want to do is update a field with this: If the month of a [date] field (formatted as i.e. 1/1/2005) is between January and September, then update [transaction date] field as 01012005 (or whatever the month and year are in the [date] field) else update the...

Thanks Bubba100 for responding.... I'm not sure what you mean by "references between the databases are set the same"...could you explain/ Thanks. ChiTownDiva [ponytails2]

Happy Friday All... I have some code that I'm getting a run time '3270' "Property Not Found" error on it. Does anyone have a clue as to why... Function Import() With Application.FileSearch .NewSearch .LookIn = "S:\SALESUP\Yasu\AprilVI" .SearchSubFolders = True...

Happy Monday All!!! I need to split a name in a single cell into multiple cells...for instance A1 contains Smith,John A. I need A2 to contain only Smith, A3 to contain only John and A4 to contain only A. I know how to do this in Access, but how do I do this in EXCEL? Thanks in advance for...

Thanks Geoff... I figured it out. ChiTownDiva [ponytails2]