Search results

  1. C

    Error on Dim WApp and Dim WDoc

    That was it! I had exported all of the objects to a new database, and forgot to reset the references. Thanks for your help.
  2. C

    Error on Dim WApp and Dim WDoc

    Could someone help me with this code. It was working at some point but stopped working. I'm trying to open up a word document '.docx' in read only. It hangs up at the following lines: Dim WApp as New Word.Application Dim WDoc as Word.Document I get: 'User-defined type not defined' This one...
  3. C

    Tags/hyperlinks in textbox

    I was wondering if it is possible to place a tag or hyperlink into a textbox/memo field and not have the tag/hyperlink show up. I have a memo field that can be quite long and I want to insert text at various places in the memo field. Having a tag of some sort would help me do this. Any ideas?
  4. C

    OnChange - txtbox keeps pace with other txtbox

    Actually I stand corrected. The code that you suggested does work, that is copying the .text rather than copying the field. Thank you. I used: Me.PreNote = Mid(Me.Note.text, 1 , cp) It worked like a charm. Thanks a million.
  5. C

    OnChange - txtbox keeps pace with other txtbox

    I'm not sure how to do this. But doesn't DoEvents cause other problems? Can you give me an example in my case?
  6. C

    OnChange - txtbox keeps pace with other txtbox

    I used the code you did but this does not keep pace. I would like the PreNote and PostNote field to actually mirror their individual parts in real time. Is this possible?
  7. C

    OnChange - txtbox keeps pace with other txtbox

    I'm having trouble understanding what is going on. I have: Form - TestForm Fields: Note, PreNote, PostNote, and cursorposition I have the following code: Option Compare Database Option Explicit Private Sub cmdClear_Click() cursorposition = Null PreNote = Null PostNote = Null...
  8. C

    Split() Where Cursor is

    I guess I need to use Mid() instead of array(). But it works great.
  9. C

    Split() Where Cursor is

    That's it! It's exactly what I needed. Basically I want to use the split function to divide textbox string so I can insert other text from another listbox that I click. this will work great. What I'll do is when I click the position of the curser, this will split the string into 2. then...
  10. C

    Split() Where Cursor is

    Can anyone tell me if it is possible to split a string where you place the cursor? Thanks.
  11. C

    Goto Record in acHidden Form

    Thanks HiTechCoach for your reply. I'm a self taught vba, amature and have only been able to learn this code as I see examples. I've used the form as this is the way I've learned it from the examples I've seen so far. I'm not sure what you mean (because I'm reletively new to VBA) by I...
  12. C

    Goto Record in acHidden Form

    I'm trying to sort a string of numbers. Each number is separated by a comma and there may be spaces. Example: 4,6,2,35,26 ,24 I've written a routine to strip out the spaces, then sort the numbers by using tempTables, then reassembling the string in sorted order. So now my string is...
  13. C

    Dynamic Multiple Choice Inputbox

    I would appreciate any help on this inputbox. I want to fill data on a form with info from a multiple choice input box. The inputbox choices come from an inventory table. The choices for the input box will change as inventory for that particular item change. Example: TblInventory with...
  14. C

    Capturing and saving images using WIA

    But the WIA Library does show up in References in the VB Editor. It's checked, i see it in the system32 directory....But when I try to re-register it I get an error registering it.
  15. C

    Capturing and saving images using WIA

    ActiveX Component can't create Object. Object Variable or with block not set.
  16. C

    Capturing and saving images using WIA

    I've tried the code above and it works great when in Access 2007. But when I tried in runtime, it errored out. It helped me to get a little further by placing the wiaaut.dll in the system32 directory on the workstation that I'm running the runtime version. But I still get an error. It seems...
  17. C

    Document Scanner

    Can someone help me with code to scan a document. I've searched everywhere but can't seem to find how to do this. I'm totally new to this but can't find examples. I have a xerox documate 272 scanner, and I want to scan my documents into a specified directory and save the file with a specified...
  18. C

    RestoreDown button

    No, what I mean is Restore Down. It's the buttom that sizes down the active window. It's found between the minimize and close command button in the upper right. We use the Restore Down button so that we can move the window to a second or third monitor. Any ideas?
  19. C

    RestoreDown button

    Can someone help me with code for RestoreDown. Sometimes the restoredown iconis too small for my users. So I need to place a bigger icon button on my form. But I can't find any information on what the code for 'Restoredown' is. Does anyone know what it is?
  20. C

    Question Default Scanner

    To clarify, I want to use a document scanner, I am not using a barcode scanner. I
Back
Top Bottom