Search results

Hi all I am trying to show on an invoice the deceimals instead of 100s to be in 1000s. i am using the below vb but the text i am getting is only 50/100 incase the number am converting is 50 cents. appreciate if you can advise if the below needs to be modified or i should use another vb and what...

Dear Gasman If we went that way, how to link the forms to the entries in the table? thanks

Dear Friends i was wondering if there is a way to make the forms and reports i have in my database show in a combobox where i can choose which form to use same as queries names in a combobox? if yes, i appreciate letting me the way to do it. Thanks

CJ thanks a million buddy. You gave me an insight of what i might be facing. In fact using a form to update is the best option as i have as well same cases like your where some items are shipped and others not. Looks like i found my way. Thanks again to all ya guys

Hi again all the flag seems a good idea, but i was thinking of keeping it on a separate table. am not sure if this is better than flagging or no. incase i went with flagging, can this logically be changed through an update query to change the flag from the reserved to the movement type of...

Hello Friends i am not a newbie but i am facing a small issue and seems not able to get around it. i have a database (warehouse management system) which i developed. now the need risen to create a kind of reservations table or module for stocks which are actually required to be reserved or put...

Guys, with all due respect to you i dont advise nor lectures in ethics. the first question says it all.if you have a problem with that, simply report it to the forum supervisors or read the first post. nothing more to say to all of you here.

guys, its an simple experiment for personal knowledge. read my first post.

Exactly, and it will be only me who knows how to fix it. thx

Hi Plog thx for your quick answer. crash i mean delete few tables when the database backend is used to write data on, or cause it to become very unstable. moreover, this code which you mentioned i will need to add it to all front end users, right? if that's the case, i prefer not so no one...

Hi All i got a crazy idea of trying how to crash a database intentionally. i am looking at a timer or a code or anything that would allow me to cause a functional database to crash or delete a table or set number of records intentionally. appreciate your ideas and thoughts if anyone have tried...

Hi plog thanks for your reply. so with what you are saying i need to redo my revenues and expenses to be in the same table which will cause some major work to my DB keeping in mind that i have a WMS and purchasing and CRM modules in it and this might affect of these modules in a way or another...

Hi All i have a database which i can track sales and purchases, and ultimately i can track expenses and revenues. i am trying to create something in the DB to have it give me the dividends which should be given to the shareholders in every quarter. i am a bit out of ideas on how to extract the...

Dear Friends I am exporting a report from access 2010 as PDF to email and the email attachment is coming highlighted. I need it to be white like the report when seen on screen with alternate rows to NO. if I export it to PDF and view it from within access it comes perfect, but when exported to...

Hi I tried to re-create the transactions forms using a query to give me available locations to select from which in turn this will be posted into a transactions record in the transactions table, but didn't succeed in that. I basically want to accomplish a limitation on the choices I can use...

Dear Plog here is the summary. The transactions table is the table where all the movements of in and out of the locations be recorded. The locations table is called Locations. The form for entering the data into the transactions table is called ADD TRANSACTIONS for adding items and REMOVE...

Dear, can I send it to you by mail? its still 2.4mb when zipped with all the not required tables and reports in the database,. still cant send it here.

Dear Plog The size of my mdb is hige and will not be smaller than 2mb to attach here :(

Hi Plog Please find attached the database I did. Its a .rar file inside a zip file. this is the only way possible to upload my db to you. Thanks Sir

OK, I kind of getting hit with a big brick here, am not sure if am looking correctly, but I seem not to be able to create the data entry form having the list box based on the query to limit users in selecting the right warehouse location. would anyone be able to help in that either by...