Recent content by Aleathiel

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.

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

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

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

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

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

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

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

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?

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

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

Hi, I created 2 query, one get all the qty on a pick ticket that we have stock and the other for the qty we don't have stock, I need to create a query that will combine these 2 into one and that will sum the qty if the same pick ticket appear on the 2 query, I can do it with another query that...

Thanks a lot Tom, its working really great.

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

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.