Search results

I have an inventory report that I am given among the fields are Item, Ship Date, Signed Quantity, Filled-Recvd, On Hand I am given an initial amount in the onhand field but the fields below that for that item are blank. What I would like to do is [Signed Quantity] - [Filled-Recvd] and then add...

I have two tables table1 his a master list of companies that I have already delt with table2 is a list of companies that I have delt with as well as new companies and I allow for multiple instances of company data to be in table2 table2 my have several records refering to "ABCD Inc" but table1...

I have a form that pulls it's info from a query. This query tracks stock symbols and their 52 week high. the table will have multiple instances of the same symbol. I only want to see, on my form, the symbol with the last date so if APP has an intry on the 9-6-2004 and 9-8-2004 I only want to see...

I have a query that I have polling a database with PO number I have the query right now asking "what po do you want to print" Can I make it reply with a msgbox that po not found if po field is null? and would I put that in the criteria field? thanks, honor401

I have this code that I have moved from word to access. Sub formatndc() ' ' formatndc Macro ' Macro recorded 9/7/2004 by honor401 ' Selection.Delete Unit:=wdCharacter, Count:=1 Selection.Delete Unit:=wdCharacter, Count:=1 Selection.Delete Unit:=wdCharacter, Count:=1...

I am exporting a query out to excel. I can give the work "book" a name but I need to specify the work "sheet's" name inside the work book instead of having excel give it the name of the query it was exported from... is this possible? thanks, Scott

I have a delete query that I would like to run on a table that would delete all records before I import into that table again. I would like this to happen with out any user intervention at all like "you are about to delete 50 records" how could that be achieved? Also is there a better way than a...

I have a query fields that pulls from a table discription upc product id vendor price in the description field under criteria I have Like "*" & [Search by word:] & "*" I have a form but when I open it I am asked for search criteria I would perfer, instead of the standard access question box, a...

Hello everyone. first time poster, long time lurker. kind of new to programming and have a question. I have a macro that I recorded in word. I know how to get to the code. I know how to import it into access as a new module, but once I get it into access how do I use that code to format the...