Search results

locked file shown..

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

yeap..i ended up using dmax... and assigning a starting number to each db,, Private Sub Form_BeforeInsert(Cancel As Integer) On Error GoTo lerror Dim r As Recordset, db As Database, x As Double Set db = CurrentDb Set r = db.OpenRecordset("CUSTOMER SALES DATA********") x = DMax("[orderID]"...

how can you assign a starting number to an auto #? i was under the impression that that was not possible

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

thank you gentlemen..

i found this searching but i am not sure if thats what i am looking for.. Private Sub Form_Click() Private Sub Form_Open(Cancel As Integer) Dim x As String x = "password" Dim y As String y = InputBox("Enter Password for form") If x <> y Then MsgBox ("Invalid password") DoCmd.CancelEvent End If...

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

oh i just figured out how to do what i wanted to do!... thanks for the help

i get an error with allowupdates.. its not part of the library?? when i type ME. in the list that populates posible things you can use there is no AllowUpdates.. there is AllowAdditions but that doesnt work.. what am i doing wrong?

Existing records are not locked.. i just want to protect the data after its entered. i dont want people going back and changing data after its entered unless i authorize them to do so. I am going to try the code you provided and see how that works.. thanks

i think a requery function will take care of that...

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

using the nz() gets rid of the div/0 but it displays error... everything works fine.. but i cant leave any prices at '0'... which i want to be able to do...

here is another image showing the div/0

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