Recent content by elliotth123

  1. E

    Adding a Auto increment Text/Number

    Help! Yes I did download it and go through the queries but it was not was I was looking for, I still need a way of fiinding the first blank field of a column , insert a number (taken from an input form) and then increment that number by one till all blank fields (1 for each record) is complete.
  2. E

    Adding a Auto increment Text/Number

    Help! Nope.... nothin there helpful unfortunatly... anyone?
  3. E

    Adding a Auto increment Text/Number

    Anyone? Anyone on this last post?
  4. E

    Adding a Auto increment Text/Number

    So far,.... Here is what I have done with it so far: I created 2 more fields IDSub and IDNum. Then I created an update querey and form that will prompt the user for the prefix (IDSub) and fill in the newly imported records IDSub field with the prefix. I have also created an update query to go...
  5. E

    Adding a Auto increment Text/Number

    Help! I kind of understand what you are saying but, this won't allow it to prompt the user for the prefix. What about an update query that will take the first blank record and insert an id (it will get this via a txt box on a form). Then increment the number portion until the null boxes are...
  6. E

    Adding a Auto increment Text/Number

    I have a daabase that I am importing via excel. I want the entries to be numbered ex: MT0001 MT0002 etc.... I would like it to promt the user for the last number(or next number in sequence) entered, then fill in the blank records with the next increment number. The prefix will also change...
  7. E

    Code/macro to do auto replace

    Thanks for the advice!! I'll work it out in code thanks!
  8. E

    Code/macro to do auto replace

    Hmm Well I sort of understand that.... I am fairly new to VBA... Let me rephrase what I am trying to do maybe you can think of a better way than what I said. I am importing a excel file with book information into a table. Around 150 at a time. I want to be able to easily say fill in the...
  9. E

    Print only certain Page numbers

    Found it figured it out thanks anyway
  10. E

    Code/macro to do auto replace

    I am looking for a way of creating the following: I want to be able to click a command button and have it prompt the user for input. Then take the input and replace all cases of NA with that string in field B for all records. I would prefer to have no other prompts other that the user input and...
  11. E

    Print only certain Page numbers

    I am looking for coding to have a print function print only a specific page number each time. EX: Print page 3 of 4 every time. Can this be done? Thanks!
  12. E

    Macro/VBA Code Open CSV file, save as xls, run excel macro

    Help! Here is what I have come up with Of course this doesn't work though: Public Sub Command0_Click() Shell "excel.exe c:\resourcelibrary\import.csv ", vbNormalFocus ' Opens Specified file 'Format database ' ' Format Macro ' Macro recorded 11/7/2004 by Elliott ' '...
  13. E

    Macro/VBA Code Open CSV file, save as xls, run excel macro

    Anyone? Can anyone help with this?
  14. E

    Macro/VBA Code Open CSV file, save as xls, run excel macro

    I need to create a module that will open a CSV file from a specific location Then save it as a xls file over wirtting file in there Then running a Macro within excel to format the xls file. Then save it. Can this be done? I need the code for it. Thanks!
  15. E

    MS access Search help!!!!

    WOw that was it! Thanks. I can't believe it was something so simple! I was going to change it to number But in the end I need it to be text as it is going to be a combo of text and numbers. Thanks for your help. I think that is it for now!
See more
Back
Top Bottom