Search results for query: *

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.

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

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

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?

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

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