Search results

I have a database that is used in a retail environment. I cant figure out what causes the locks of data. I have an invoice (form) that it is filled out at point of sale(customer table). The middle section of the invoice (subform) gets the data from an inventory table. The issue that i have...

guys i need some quidance... i have a server setup that i need some help with i have a database file that holds 1 inventory table. Then i have 2 other database files that represent 2 retail stores. my problem is that the store files have a form which acts like a sales invoice. The sales...

how can i have the letters PAID in red running accross a form if the balance is '0'????? i been thinking about it and cant even come up with any logic other than having a invisible "PAID" that if the balance >0 then make visible? does that make any sense? and how would i code it? Thanks!

i have a subform within a form that i want to create and automated procedure. the subform has a couple of combo boxes. upon input into the subform i want to do something like if the value of combobox1 starts out with the letter B then the value of combobox3 equals combobox2 * 1/2 i am just...

i have a subform within a form that i want to create and automated procedure. the subform has a couple of combo boxes. upon input into the subform i want to do something like if the value of combobox1 starts out with the letter B then the value of combobox3 equals combobox2 * 1/2 i am just...

i have a subform within a form that i want to create and automated procedure. the subform has a couple of combo boxes. upon input into the subform i want to do something like if the value of combobox1 starts out with the letter B then the value of combobox3 equals combobox2 * 1/2 i am just...

how can i password protect a form? i want a have a button that on click will ask for the password. if the password is correct then proceed to open the for else tell them they are not authorized. i know i would need an if statement but thats as far as i got.. can some one provide me with some...

i have a form that looks like an invoice.. i want to be able to lock the fields invidually after they are updated but only for the current record being accessed... and password protect them to allow editing.. any suggestions or pointers would be great! thanks

I am trying to track down why i get a #div/0 error... i have a form that is a sales invoice. It also has a subform with in where the items being sold are entered. in the subform i have on the footer a Sum([Selling price]) so that i have a total in the subform.. then i pull that total into the...

I cant figure this out... i have a query that reports sales by week.. now on the date field in the query i have the following <=[forms]![frmReportParameters]![DTPicker1] And >=DateAdd("d",-7,[forms]![frmReportParameters]![DTPicker1]) whick picks the date off a calendar on a form. Now this...

I have a form that displays inventory using a datasheet format.. is there a way that i can make it so that if that record has a sales order number (because it is sold) then highlight that record...

i searched around but i couldnt really find or atleast understand how to do what i want to do. I want upon the user clicking on a checkbox for the background of the form to change to a set color?? thanks in advance:)

Hey guys.. I have a form that displays inventory of goods. there is a list box with a list all property. If they items are sold a sales order number appears next to it. Now with that in mind how can i have something that if there is a sales order number on that item then highlight it with a color?

Is there any way that i can get the database password to change after a certain period of time?

i am trying to find a good reputable server company.. what i want do do is store databases on the server that remote stations can use.. i am currently leaning towards rackspace. here is the setup i have worked up so far... Managed hosting.. o/s win 03 standard with IIS 6 and .NET v1.0 &...

how can i get a form to print "Original Copy" Delivery Copy, Sales Person copy and so on? I want to be able to click the print button a form and have it print a determined number of copies for that record and have it distinguish between copies by printing something different in them?

ok guys i need help figuring out something here.. i am trying to incorporate this into a formula in a form in the retail industry we all determine profitability based on gross margin % and $.. example if an item cost $250 and you sell it for $599 you can take 250/599 = .417 which tells you...

quick question guys... if i have a sales order that the sales order # is an autonumber and i manually delete the records my next new record still follows the last number i had before that is now deleted.. example sales order 1001 sales order 1002 if i delete all the records on the table and...

quick question guys... if i have a sales order that the sales order # is an autonumber and i manually delete the records my next new record still follows the last number i had before that is now deleted.. example sales order 1001 sales order 1002 if i delete all the records on the table and...

i havent been able to figure out how to get my subform to work properly.... i've posted in the forms section (http://www.access-programmers.co.uk/forums/showthread.php?t=99624 ) it is really important that i figure this out so that i can keep my job.. how else can i obtain help? even if i have...