Recent content by pancho13

. OOPPSS!!....any suggestion how can I do this calculation after the event on any transaction?? btw....why shouldn't calculate the balance at the time of the transaction????....I do want to know my stock balance in the event of any transaction!!! any special reason for it? Cheers from down...

update query question - MS ACCESS update query question - MS ACCESS Hello there, Gurus of the world I'm playing with an Inventory db and I need to update the "Qty on hand" field according with the transaction that may occur from another table. I've got 2 Quick and simple questions. 1. How...

Hello Access Gurus of the world!! Any one could help me with this little problem.... How can I open a xls file from access, using some sort of commands or a macro.....actually a macro will be the go. Ho can I open a xls file using a macro in access thanks for your help :)

Thanks pcEARS Thanks for your suggestion, but even the wizard do not show the whole records, my question is How do I display that field from that table that shows all the records on it, so that I can add some checkboxes on the form for each on them??? Any idea Cheers from AussyLand

Form that show all the record from a table Hello Knowledgeable people of the world!!! I've got a simple little problem that you maybe able to help me with... I would like to create a form that display the whole records from a table and some check boxes next to them, like spreadsheet...

Hello there Knowledge access people of the world !!! How do I get back to the Start menu setting window after you have removed all 'thick' boxes , such as "allowToolbar/Menu changes", "Allow Built-in Toolbar", etc, to enable this menus again??? Cheers from Aussie land!!!

Thanks Jack The Problem with not capturing the "Location" data in table "B" is that I have a report on based on that Location fields, so I could have a look all the "equipments" for that "location" with problems, in order to quantify and do some analysis/follow ups. Keeping in mind that 1...

Again Jack, Thank you for your Knowledgeable input. Yes, you are right, The table "B" (- called "ACTION"), (which is the form for), is collecting data from the users, and the form is pretty much based in different tables, eg: "People", "Location", "Equipments", etc. You are right, again...

OOOppsss!! More Info....Here we go, then!! The form is based in table "B", there is a common field in the 2 tables, field "1", but I need to minimised the typing on the form for the users, so that why I need to do the dlookup field so that gives the user the option of selecting the value on...

Hello Everybody Just wonder if you wonderful people could help me with this... I would like to create a field in a form that contains a dlookup statement that looks a particular field on table "A" based, obviously, in another field from that table....no dramas here. but, The problem that i...