Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. butcher

    leading zeros disappear from numbers when i export csv text file

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

    leading zeros disappear from numbers when i export csv text file

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

    leading zeros disappear from numbers when i export csv text file

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

    leading zeros disappear from numbers when i export csv text file

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

    leading zeros disappear from numbers when i export csv text file

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

    Finding user's account group

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

    Finding user's account group

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

    Link and re-link tables with VBA

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

    Link and re-link tables with VBA

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

    Link and re-link tables with VBA

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

    Conflict viewer does not display

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

    after 97 to 02 conversion, trouble in acDialog WindowMode

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

    after 97 to 02 conversion, trouble in acDialog WindowMode

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

    Week of Year

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

    Save SQL string as a query

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

    Access SQL Date Checking for Graph

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

    Replication Problems

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

    How do I merge images into a word Doc from an access Query

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

    How do I merge images into a word Doc from an access Query

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

Part and Inventory Search

Back
Top