Search results

  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!
  16. E

    MS access Search help!!!!

    Database Here is the database. I know it's not perfect but hey it's a work in progress. Any help / suggestions would be appreciated! I am very new to most of this again..... I had to remove most of the functions of the rest of it to fit under 100kb so basically it is just the search part...
  17. E

    Dll file for each computer accessing the database

    Dll files Thanks for your response, I tried setting up what you said with no success. I think the best way would be to use a install shield program or something similar to do this. Thanks for your help again!
  18. E

    MS access Search help!!!!

    Access Search Well, I went through everything step by step. The Coding is the same within VB. After adjusting some things and confirming others, I get an error when opening the form saying the Open Form action was canceled. Run time error 2501 I went through it all again. It all wroks great...
  19. E

    MS access Search help!!!!

    Help! Anyone know what I am doing wrong? Jon K you made the file originally what am I doing wrong here?
  20. E

    Dll file for each computer accessing the database

    I have a datbase using an active X dll file that does barcoding for me. The issue is that the access file is going to remain on one main computer and everyone can access it through that computer via file sharing. But since the dll file isn't on anyones computer it errors out. WHat would be the...
Back
Top Bottom