Search results
-
O
ColumnHistory
Recently i got knowledge of the fact that in Access2007, a new property was added for fields of type memo, namely 'AppendOnly'. Because i need a way to get informed about the date an extra info concerning a client was added, i thought that the use of this property could be the solution. So i... -
O
Obliged to get out of Access each time an error occures
In practical all of my subs i have the errorcode as shown below . More than often, when an error occurs, i see the appropriate message, but in the same time Access get frozen, and i'm obliged to get out of it by typing Ctrl + Delete!! What's wrong with this error code ? Private Sub ... On... -
O
locking the controls on a subform
In a form with subform i have Me.allowEdits = False Me.AllowAdditions = true in the load event . This way when the form opens, all controls on the form are locked. By hitting the button CmdNew Or CmdEdit i can manage the data on the form. But the settings mentioned hereabove, don't lock the... -
O
A difficult task
In a form with two listboxes, one is meant to display the orderID's of all orders that may be invoiced and the second to gather the orderID's selected in the first listbox. Each orderitem , as part of an order, has a field "INV" of type True/False, to mark the fact that this orderitem , although... -
O
Error 2046 : the command or action 'DeleteRecord isn't available
i'm using ms access 2007 ans as operating system Vista (home edition) -
O
Error 2046 : the command or action 'DeleteRecord isn't available
When i try to delete a record on the form frmOrders who do not have any related record in tblorderdetails ( subfrmorders is empty) by mean of a DoCmd. Runcommand acCmddeleteRecord, sometimes, but not always, it generates Error 2046: "The command or action 'DeleteRecord' isn't available now"... -
O
DoCmd.RunSql "Delete..." doesn't work
Thank yoy very much for the help! Your last suggestion works very fine!!! Greetings from Brugge in Belgium -
O
DoCmd.RunSql "Delete..." doesn't work
I tried each of the suggestions you sent me, but without success. The order can't be deleted. Any other idea what can be the reason for this behaviour? -
O
DoCmd.RunSql "Delete..." doesn't work
On the form frmOrders i have a button to delete the current order in tblOrders, if no corresponding orderitems exists anymore in tblOrderdetails. To delete the orderrecord, i use the following code: Application.Echo False Call TglVergrendeling(Me, SECTION_DETAIL, False) (= unlocking the... -
O
Are we on a new orderitem ?
In a parentform frmOrders with a subform sfrmOrders, it is easy to find out by code when we are on a new record ( = new order), by using Me.NewRecord. But i also want to find out by code when we are on a new record (= an empty line in the subform to enter a new orderitem. I tried the following... -
O
Can not delete a record or chage a ecord because there are related records in tblOrde
I have a form with a subform to manage orders. The suborder is frelated to the parentform bij OrderID. Entering orders as well as changing orders works very well. But the moment i go from the subform back to the parentform to close the form i get the message: cannot delete or change the record... -
O
Checking in a orersubform, that we deal with a new record in frmOrders
I like to check in a subform that the parentform is on a newrecord. Therefore i declared in the parentform a boolean 'intnewrec'. In the current event of the parentform i use the following code: If Me.NewRecord then intnewrec = true end if Now in the subform of this parentform i have the... -
O
error 94 - unlegal use of null
I tested delivered, and indeed delivered is null!!! Is it possible that the reason herefore sticks in the table where the field is created? Is it necessary to give that field a default value = 0 in the table ? -
O
Testing if a textfield is empty or null
Does it make sense to test a textbox on both possiblities namely: being empty or being null. Is so what's the best method to do so?