Search results for query: *

CautionMP that truly is a beautiful thing i get my 21 digit number with leading zeros and without inverts thanks to you and every one who helped butcher, tasmania

CautionMP, i replaced arrTest with MyRecord but the error terror stops me here... While Not MyRecordset.EOF MyRecord = MyRecordset.GetRows(1) For intField = 0 To UBound(MyRecord) ' i can't get past this next line Select Case TypeName(MyRecord(intField)) the error is -...

bill, thanks again but their idea of a number differs from mine; especially when it is zero. however, i must conform to their protocol - no correspondence entered into etc. CautionMP, thanks heaps, i get the idea and i will try that code,it seems to offer more control. plus - who can resist...

thanks Bill i do not know why the fields have to be numeric; it is part of the transmission protocol to a national collection agency. no chance of changing that part i'm afraid butcher

if i export this... "RecordStart","02-04-06",10,1012,0,"RecordEnd" "RecordStart","03-04-06",8,0000,0,"RecordEnd" the 0000 turns to 0 - and it MUST be a number. i have another Number that reports seven '3digit values' joined together i.e. 001002003004005006007 this number needs leading zeros (or...

FancyPrairie this code worked great thank you for your knowledge and fast response butcher

After securing the databse can i find the Account Group the user belongs to using VBA. e.g. when a user opens a particular form if they belong to one group they can fill in all fields, if not they can only fill a couple. butcher

KenReay sensational stuff works a treat i will also use this to switch table locations for projects when i bring them to my PC and take them back to site thanks heaps butcher tasmania

KenReay thanks for your rapid response i get the gist of it i don't immediately see a 'file path' that i can recreate for each location; maybe i will see the 'connection path' in tdf.connect when the code is running i will let you know how i get on thanks butcher

i am trying to link tables using VBA the linked tables are at: C:\userA\csaDB\DbTs\csa_dbReplica.mdb each install has a different User folder user will input the 'UserA' part of the path on open - i can deal with that bit i assume i have to link to each table by name; some table names...

I have a replicated mdb that works fine on my small hub. when i put it on a large national server using OfficeXp Developer, the Conflict viewer does not appear. i have entered conflicting data to test it. the 'resolve conflicts yes/no' message appears. i have seen the (deliberate) conflicts in...

JoyInOK, thanks for your reply. Yes DocDelete is on further investiagtion reveals: the ConfirmDelete message will show- if i set the form's property as EITHER PoPup or Modal it will NOT show if they are BOTH set the message will not show- if VBA acDialog is...

i have converted a 97 MDB to 2002 (XP) if i have a form open with the window mode acDialog, when i delete a record on this window's subform the 'you are about to delete... yes/cancel' message fails to appear mmmmm... anyone else too?? butcher

DATES eh! i have overcome this way back in the past but i think it went something like this. subtract 4 months from each date in a calculated field and use this as the basis of any fiscal grouping. hope it sets you in the right direction. How you figger what you'll subtract is the tricky bit. It...

While working in Access VBA at Code level, i find i have often created an SQL string which the User(WhereWouldWeBeWithOutThem) may find usefull to use again. Q: can i 'programatically' save this string as a query? all 'F1' offers is QueryDef and i'm not sure i can spell what they are talking...

LizK... my sympathies. Access and charts are a total loss in my experience. Try sending your data to an Xl chart that you made already. Then have an Xl macro to look at the newest data when it opens. I hope this stuff is not too confusing you're welcome to the concept if you like. Don't know...

wild007 i've got the same message in access while trying to change a date even at the Table level. All was ok but then... Seems i had set an INDEX on the datefield. I'm not sure i need one but removing the index seems to help. I still haven't tested totally [but i can change the date so...

matchmaker The imperative to work in Word has eased for now. This project is for wide distribution to agents and the client now wants more control over background&layout so keeping it all in Access seems safer for now (whew!) My Brief: A three section report on a stock certificate background...

Is it possible to have an image in an Access table display in a Word document using Mail merge. All attempts so far return the field but not the image. A report works well, however, using Word will allow the user to size and place the image to suit their requirements. Outputting to Word...