Search results

Yes kinda...the db links to multiple tables spread across two backends (in different dirs) I've been working on the db in a 'dev' enviroment and it needs to be installed into the 'live' area...but relinking will be a utter pain in the butt using the linked table manager, (mainly because of the...

Is it possible to provide a way to change the linked tables via text entry? Ie list the current link location and allow a user to select/cut/paste etc? The reason I ask is I've got one db linked to two backends, and its a pain in the arse using the manual link system (because the dialog isn't...

There is one button that does a quick bit of validation and then runs a sub (called RunSubs), this sub then runs a set of subs in turn. I've tried disabling just this button but that doesn't work as it has focus. I've tried making the RunSubs a fucntion and then returning a bool, ie hoping to...

I've got a simple form that starts a set of subs, but the from still responds to the user even if the process is going. Whats the best way to stop this?

sorry the comment should say "have to call again because for some odd reason it doesn't" ie calling the routine again and again deletes the tables eventually, and as i'm only deleteing those begining with _ its safe to do this...but i can't see this being the 'correct' way, even if it does work.

well the count is just a status thing (and yea its broke but not terribly) And its definitely not deleting, cause the code after it breaks (as it creates these tables again)

Trying to use the following code: 'deletes all tables starting with '_' Dim db As DAO.Database Dim td As DAO.TableDef Dim X As Integer Set db = CurrentDb SysCmd acSysCmdClearStatus X = 0 SysCmd acSysCmdInitMeter, "Deleting Old Tables...", db.TableDefs.Count For Each td In db.TableDefs If...

I have the following: Month Tot Mat Acc 2004Jan £246,000,000.00 £2,698,000,000.00 £1,144,570.91 2004Feb £262,000,000.00 £22,000,000.00 £1,133,320.02 2004Mar £237,000,000.00 £43,000,000.00 £1,114,454.21 And need to swap the fields and the rows around, to get...

no, no memo fields in this problem...though freakily there is in another problem i've got to solve:eek:

ah ok, it could well be a design problem...though it wern't my design:) (and its not really a database either:D) Ok its all to do with Notional Risk (what that is, not a clue). It starts as a linked table (not sure where its created from) that has ~6k records, which can be broken down into a...

I've got a problem in a access/excel (both 97) solution. The problem needs to use more columns/fields (ie 255) than access or excel can cope with. Now ADO 2.5 can (if i've read the right www pages:)) cope with a far greater number of fields. I can't just use ado can i? as the 255 limit will...

The following code lists all the printers on my NT4 machine: Public Sub devListPrinters() 'lists the current printers to the debug window Dim I As Integer Dim S As String Dim R As Long Dim Buffer As String ' Get the list of available printers from WIN.INI Buffer = Space(8192) R =...

ah yes late binding...i'll look into that. as for importing the lot, I'm not sure if that would work...its a set of about 5 worksheets laid out as a form...so a lot of unnecessary crap would be imported...but I'll keep it in mind.

I've got a routine that successfully imports various data from an excel sheet. But I'm having problems with the excel program being left loaded! Currently I use this to shut it all down: Excel.Workbooks.Close Excel.Application.Quit Set wsSheet = Nothing Set wsBHSheet = Nothing Set wbExcel =...

ah yea validation, i did want to restict the day param to the vb constants or at least an enum, but couldn't see how in A97

Right think i might have done it: Public Function NearestDay(dDate As Date, iDay As Integer) As Date 'Returns the nearest day to give date Dim I As Integer For I = -3 To 3 If WeekDay(dDate + I) = iDay Then NearestDay = dDate + I Next I End Function Can anyone see any potential problems...

Thank you very very much...i knew it should be a simple calculation but just couldn't get my head around it!

bah...i looked as well...must be a really good monday:D

Trying to write a function that returns the nearest day to a given date. So give today's date and saturday it should return 24/01/04, if it was tuesday then 27/01/04. I can do it if i just want nearest set day, cause its just a simple select case...but its far to early on a monday for me:p

Thanks for your help, I think I will strongly suggest that they do use multiple front ends, thats as much as I can do. Oh well worth a try...