Search results for query: *

I have a mainform/subform which automatically resizes itself "sometimes" at the mainform level. Its quite random and I cannot determine what the problem is. I've read extensively in these threads but cannot find any clear direction. Im using A2K in WIN2K environment. Here are the Format...

Im trying to the Dsum value from a table, immediately following the addition of data to the new record's last field: Amount. For reasons unknown to me, the Dsum only sums across other table records, and does not include the newly added record. What is the accepted workaround for this problem...

I'm trying to fire a procedure from VBA without much success... I have OrderItems (mainform), each OrderItem can have several Drops to customer (subform). When I navigate the OrderItems I want to add one default Drop per OrderItem. My problem is I can't trap an empty recordset in the subform...

I'm trying to reference the result of a function in a query. The function's job is to parse a string into a certain format. I have set up a public variable for the function output in the form's VBA code, strResult. So to generate strResult my code is: strResult =...

I've trawled through the threads in this forum, and used some of the points I thought applied to my situation. But can anyone tell me why, DoCmd.GoToRecord , , acNewRec doesn't work in the form_open event? The form is bound to the table so I fully expected it to jump to a new record when it...

I am writing a piece of VBA code for a dialog form. The dialog form is populated with 1 to 30 buttons from the outcome of another form. I know I can use the onclick event in each button, but the number of buttons varies, depending on the outcome from another form. The buttons are named &...

I know I could use tags and controls collection to achieve this, but I'm also curious as to whether anyone has used dynamic control names in a loop. I want to update several fieldnames with the only difference in their control names being a number on the end eg. "DateFx" where x is a number 1...

Is there a VBA eqivalent to the 'In' SQL keyword, or am I resigned to using lengthy 'or' statements? SELECT * FROM tblName WHERE fieldname IN ('ax', 'bx', 'cx', dx') thanks

I have a Order mainform/Order Details subform. In an Inventory form I have a button to add new items to the Order Details. When each item is added I wanted to update the subform (Order Details) to show the new item. Ive tried various combinations but keep getting this error: >> Runtime error...

I have a form with a table recordsource and two comboboxes: cboCompany and cboOrder. When the user "tabs" through the records, I update appearance of the combo boxs as the records change, with code in the Form_Current event. Unfortunately I get "No current record" error immediately after tabbing...

I'm not even sure if this is possible, but just testing the waters here. Msgbox "INFORMATION:" & chr(13) & chr(13) & _ "You are not allowed to edit records" & chr(13) & chr(10) & _ "with this logon.", vbInformation I want to set the word "information" in the msgbox to display as...