Search results

ok thank you very much i'll try that edit: Yes it wooorrkeed!! :D:D thanks

ok i have no clue how to do that. I tried this but it does not really validate it... it accepts anything in the field.... it only works if the customer ID was then changed. Private Sub tbxCustomerID_BeforeUpdate(Cancel As Integer) Dim intLength As Integer intLength = Len(tbxCustomerID.Value)...

Oh lol I just found this website, I think it will be sufficient for what I want.... but I thought I should share it here in case someone else has the same problem http://gregmaxey.mvps.org/Custom_MsgBox.htm Ok now I get it, thanks to the website. I used a Select Case statement... and it...

How can I let a message box with a Yes or No choice to actually cancel the event when "No" is chosen MsgBox "Are you sure you want to cancel this sale?", vbYesNo This is the first line of an OnClick even for a delete button.... How can I actually let there be a different action for pressing...

I've been searching on the net to know what exactly does the error message "3026 - Not enough space on disk" mean when it pops up not allowing me to open my access file. Please offer your help. (This message pops up at many other cases... e.g. when saving a file - but i don't know what's the...

so that means i can only validate in a form, not in the table

how abt u take a screen shot of the excel spreadsheet and show it here, because im not really sure how does it look like. Is it like: Company name item code x item code item code x repeated in several columns (x if it is ordered)??

I want a customer ID field which only allows initials (3 letters) or admission number (4 numbers) and do not allow a mixture of letters and numbers. What input mask or validation rul do i use for this. i tried: (validation rule) Like "???" Or "0000" but of course it didnt work, as the ...

thnx. I knew about the "limit to list" thing but i forgot that applying it in the table will not apply to existing forms from the table.

What validation rule could be used with a "Combo box" field so that only the data in the combo box is accepted.

thanx for bothering, forget it cuz i finally found a solution. I used this as the condition .... and it worked!! (after using other resources for searching of course) DCount("*","Pending payments","[Customer ID]=Forms![Orders]![Customer ID]")>0

I want to create a macro (event "onLostFocus" of a field in a form) which views a message box under the condition if this field exists in a query. Look, I have a query which shows the customers who still did not pay (i.e. pending payment) for an order. I have another form which is the orders...

thanx its working perfectly now... it seems that reports just dont allow calculations which include external fields

thanx ill try that (although i've tried something similar before which didnt work)

when i try to refer to external fields to use in calculations in a report it always asks "enter parameter value". Like i have a field in the report called "sales", and i have "total price" in another form called "sbfrmOrders". I want to calcualte the percentage of total sales by dividing "sales"...

Sorting fields in a chart... how? I created a chart from a query, great! But there's one prob. how can i make it so that the fields are sorted the same as in the query, the default is to sort by name, i dont want that. How can i sort the x-axis fields according to the query's sorting? Anyone...

nevermind i just made it to open the query straight away... thanks for the help anyway.

still doesnt work

thanks for the help...

I have a form which is opened with a filter from another form. For some reason it views the form in form view, although it was set up as datasheet view. I even went to the form properties and the default was datasheet and i made it not to allow other views. This still didnt solve it. I want it...