Recent content by arryb

Apologies, Wrong amounts supplied. should be 29 days in 3RD2005 @ 286.13 46 days in 4TH2005 @ 453.87 I just calculated them incorrectly in this example. Basically i need to divide the total INV amount by the Total number of days covered and * by the days in each qtr.

Hi all, Have a problem with records and dates. Any help/suggestions appreciated. I have users who enter invoices into a form. Part of the entry criteria is a From and To date. These dates can vary from one month to a year. I need to be able to "split" the input record into seperate records to...

Thanks, However, it didn't work! Still get the same error i'm afraid. I will have a play to see if it is something along those lines. If anyone can help further i would be very grateful?

Help, This is driving me mad. I am trying to connect to a database using User Level Security. i have the following code so far: 'reattach table from new database Set tbl = db.CreateTableDef(NewTabName) tbl.Connect = (";DATABASE=" & Directory & ";UID=RileyM;PWD=RileyM;") tbl.SourceTableName =...

I have a timeconsuming task that is intitiated at the click of a button by the user within my access 97 database. Is there any way of continuing to browse throught the database (forms etc)while the code is still running?? Any ideas! Thanks Arry

Thanks for your help guys. I didn't find any missing ones but added in the Microsoft Office object library and it seems to work now!!! Thanks Arry

I am running code in Access 97 as follows. SQL = "INSERT INTO [Tbl_Adjustments_Data] ( [Invoice Number], [Invoice Period], Type, Type2, Comments, [Date From/For], [Charge (£)] )" & _ " SELECT Left([F1],10) AS [Invoice Name], Right([F1],4) AS [Invoice Period], TempAdjustment.F2...

Danvlas, Thanks, That worked a treat. You're a star, so have one!!

This doesn't seem to work. The replace function isn't compatible with Access 97 and substituting the space with %20 means the file cannot be found. Pants???

I have some code related to a button which opens a specified file in excel. excelpath = "C:\Program Files\Microsoft Office\Office\Excel.exe" filepath = "C:\Aarons Folder\Interconnects\Interconnects_FileReader_V2.xls" Call Shell(excelpath & " " & filepath...

I will give it a try. Cheers

I am currently importing an rtf file to excel from word using the copy all and paste option. This is fine except for the fact the the Header is not copied. I need to be able to grab certain text from the header to declare as a string within my excel spreadsheet. In there an easy way to automate...

Cheers Bud, thats great.

A croos post but i feel it has more relevance here. I have a nagging issue that i need help with. I have an excel document which is opening when a button from my access database is clicked. This button opens excel, closes access, and then gives the user various options to open several rtf...

I have a nagging issue that i need help with. I have an excel document which is opening when a button from my access database is clicked. This button opens excel, closes access, and then gives the user various options to open several rtf files which are sorted and populated into different...