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

    getting ms word info into a table

    Hi MajP, I got to the same conclusion that you were guessing, it IS in fact backward, so I created a database from scratch, thanks for your help.
  2. Aleathiel

    add specified boxes to an existing table through vba

    Wow, its working like a charm! Thanks a lot Alex! My final code was: ----------------------------- Private Sub Command33_Click() On Error GoTo Err_Command33_Click Dim rstExample As DAO.Recordset Set rstExample = CurrentDb.OpenRecordset("BOL") With rstExample .AddNew...
  3. Aleathiel

    add specified boxes to an existing table through vba

    Hi Alex, thanks for the response. I'm looking to add the data to all the field in the table, I named the text box in the form the same name that the fields in the table. the recordset thing helped me a little, but I'm still lacking knowledge to be able to use it adequately, if you could provide...
  4. Aleathiel

    add specified boxes to an existing table through vba

    Hi all, I don't really like to bother other people with my problem but this one is too much for my knowledge and Im sure people out there know how to do this :) I have a form that contains fields that I want to add in a table that is present as a sub_form on my form, the problem is i don't...
  5. Aleathiel

    getting ms word info into a table

    Its a list to do thing for our truck drivers, each truck driver's have is own sheet that have the number P#### on it, on the word document, I have the P#### as a header not in a table and right after I have my table that first column contains the city and company, while the other contain the...
  6. Aleathiel

    getting ms word info into a table

    Hi all, I'M trying to do something special, trying to get word information in an access table or query. The thing is that I have a lot of word file for each day, like P0124 for today, P0123 for yesterday. I need to get the information on the day I choose, like if I want yesterday, I enter P0123...
  7. Aleathiel

    Custome paper size

    This one helped me a little but Im still stuck, since its only change the width and height of the section, not the width of the page itself, its like the printer doesn't recognize other format that is bigger than 4x13. I need to print all my detail section on a single 4x24 not 2 since the...
  8. Aleathiel

    Custome paper size

    Hi all, Been 6 hour I'm trying to find a way to make a code so that my report print on a 4"x24" label since I cannot change it to higher than 4"x13" byt the normal way and the user defined paper format is not bringing me a pop-up to enter my new size. If anybody could help me find a way to do...
  9. Aleathiel

    Continuous paper in a matrix printer

    Hi Guys, i have the same problem right now with my label being too long (2 feet) and my longest choice is 1 feet, I tried the user defined but I got no pop up to ask me the height and width. Is there a way to set it by coding?
  10. Aleathiel

    adding and removing only specified file in a table

    Hi all, Here is my problem: I have a table with 6 field that are: SO_NO, SO_STATUS, CUST_CODE, REQUEST SHIP DATE, SHIPPING INSTR, QTY ORDERED I want to delete the entire row only for the SO_NO that are finished (this is taken with the SO_STATUS while "4" is not finished, "9" is finished) and...
  11. Aleathiel

    Group and sum in Union query

    Golum your a King, it worked perfectly, thanks a lot :)
  12. Aleathiel

    Group and sum in Union query

    ...someone help me find a way to only do it in 1 query instead of 2? here is my sql statement: Select A.SO_NO,A.SO_STATUS,A.CUST_CODE, A.REQUEST_SHIP_DATE, A.SHIPPING_INSTR, A.SumOfQTY_ORDERED FROM [KIT TYPE C Sum Qty 2] as A UNION Select B.* FROM [KIT TYPE P Sum Qty 2] as B; Thanks in advance!
  13. Aleathiel

    count with groupby

    Thanks a lot Tom, its working really great.
  14. Aleathiel

    count with groupby

    Is there a way to do a count that only count 1 time identical data on a report? Its been some time I'm trying, I can do it with another table but the time to get the report is like 2 time longer, so Im trying to find a code that would do that and would not take a longer time to get the report...
  15. Aleathiel

    Specific number of line

    If I do that, I will just get 10 copy of all my pick ticket, I dont want that, only want blank cell, so that the total with the pick ticket I already got is 10 cell.
  16. Aleathiel

    Specific number of line

    I need to have a specific number of line, because I have a query that take up the pick ticket number and there is always 10 or less. The specific number of line is for having 10 box containing all the pick ticket number, so if there is 6 pick ticket, I still want 10 box or line. Is there a way...
  17. Aleathiel

    Printing label with no pause

    This is the code for my print button, its print label from a query that give me the one I need, and the the query is based on an odbc pull. Private Sub Command2_Click() On Error GoTo Err_Command2_Click Dim stDocName As String stDocName = "Report1" DoCmd.OpenReport stDocName...
  18. Aleathiel

    Printing label with no pause

    I just saw that when I print from access, before printing one label, its says printing 1 of 1, when agama say printing 1 of 1 for the complete list, it look like it is divided instead of one long document, any hint on why it does that or how to correct it?
  19. Aleathiel

    Printing label with no pause

    I'm using arial narrow, arial black and a bar code Font.
  20. Aleathiel

    Printing label with no pause

    I'm not sure about that since it is working fine with agama (that is using linux) but is slow with windows, could it be because of windows only? that windows sucks :P

Part and Inventory Search

Back
Top