Search results

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

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

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

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

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

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

I know that to refer to a field in a different form we do sthing like this Forms![Products]![Product name] (for example). But when i try to use it in a query under criteria with the "Like" expression it treats it as normal text. What i basically need to do is have a form used as a search...

In a school, a customer ID (in a canteen for example) would be either student administration number or staff initials.... how can i make this customerID field so that it accepts either all numbers (for student admin. no.) or all text with only 3 letters (for staff initials)? thank you plz...

in an initials field... i want it so that it could automatically increment the 3 letters to uppercase... how? if it can't be done in a table where can it be made (i.e. in a form, query etc)

Is this relationship correct (see attachment)? When i create an orders query with the fields:- Barcode number (source: orders/products table) Product name (source: products table) Quantity (source: orders/products table) Unit price (source: products table) Total (calculated - [Unit...

In an orders table, i want to have a total value calculated... in the table... i was only able to do that in a query... but is it possible to do so in a table?

I am unsure about the relationships for this database, which is a big problem. Also, I created a query but some fields do not allow data entry, which in turn had the same effect when I created a form from the query. I think it's because i selected the fields from the wrong table or i donno. You...