Search results for query: *

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...

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...

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...

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]...

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...

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...

Happy Monday everybody... I have an excel spreadsheet wherein if cells in column O falls in between different ranges then I want to format the entire row. For instance: If a cell from O12 on is between 1 and 20, then color the row yellow, if it falls between 21 and 34 then color the row...

Afternoon All... I was wondering if there was a way to append a number of tables based on, say the table extension (i.e. _txt would be an extension) to a "master" table with out writing individual queries to accomplish this. An example: Odom_txt sacra_txt phil_txt Master EDI Feed The tables...

Good Morning.... I'm trying to import multiple DAT files in a particular directory into an Access database using an import specification. The problem is that sometimes there may be 10 or there may be 50--it varies. After the file has been imported, it still can have the same name--that's...

Murnin' All...Happy Hump Day... Last week I posed the question: "I wonder if Access can: 1. In a windows folder, change the file extension from DAT to TXT (or CSV). 2. Use an import spec and import the file into the database. 3. Append the file to an existing table. 4. Drop the imported...

Good Afternoon All... I need help...[sadeyes] I wonder if Access can: 1. In a windows folder, change the file extension from DAT to TXT (or CSV). 2. Use an import spec and import the file into the database. 3. Append the file to an existing table. 4. Drop the imported file from the...

Is there a way to reverse a pivot table when the source is no longer available? ChiTownDivaus

Addendum: As long as I don't use "All" for the parameter, both formulas work fine. Thanks. ChiTownDiva [ponytails2]

Happy Tuesday (I think!) I don't know why for the life of me I can't ever seem to get this...I think I have a steel plate in my head when it comes to this... Okay...he goes... Got a parameter called {?Session Status}. The choices for the session status are: All Cancelled Closed Full On Hold...

I need to pull records based on Jan 1st of the current year until the last day of the previous month...what do I do when I have to pull Jan through Dec in January of next year? I've been going around and around with this, but I still can't figure it out. Help!!! ChiTownDivaus [ponytails2]

How can I determine where a parameter is being used in a report? Thanks in advance. ChiTownDiva [ponytails2]

Dumb question comming... How do I set the column width? I know it's not: SET WIDTH "NAME" A20. It's thursday and I'm having a brain fart. Thanks. ChiTownDivaus [ponytails2]

Happy Monday Everybody [bigcheeks] I might be in the wrong forum, but here goes... When we upgraded our database, we discovered the driver we currently use to run Crystal Reports is incompatible with the CLOB datatype. We know that the driver we need to use is CROR8--the question we have is...