Search results

I Tried to set Default Value with a global variable ... a combo box -cboFiscalYear with the current fiscal year ... [modGlobalVar].[intFiscalYear] ie the Defaultvalue property of the combobox = [modGlobalVar].[intFiscalYear] However, there was no joy. What am I doing wrong...

Hi all,:) I'm looking for some advice: the problem is that I've got 13 sections in which people are working, and administrative assistants that are taking care of 1 or more of these same sections. In addition to the usual security, there is also a requirement to make the AA's only output...

:confused: I've hit a "mind block" --- part of me says that it can be done and part of me struggles with reality ! I've hit the error -- "Runtime error 3211 -- The database engine could not lock the table 'tblLevels' because it is already in use by another user or process." A few things --...

Solved the problem! Just after putting this up on the site, I came across this which solved the problem-- Forms![frmTV]![axTreeview].SelectedItem.Text = Me.LevelAbbrev For those of you that are interested!!

I am using a treeview control. When I press the View/Edit button (in the figure 1), I get the “Level” form. My problem is that I do not know what/how to call the explicit Treeview control, so that I could make it equal to “me.LevelAbbrev” when I close the Level form. (assuming that I have made...

Hi ! I have several workbooks each with one sheet (located in the directory /AA ) and I want to put all the worksheets from them into one summary workbook. (located in the directory /CR ) The cavaet is that I am doing this from VBA code in Access. My code lines are: Dim ExcelApp As...

Adding... Yes this seems to be the way to go, but I am nervous about the fact that this subform (a form within a form) ... How do I call these? Also the control that I am looking at is a calculated field ... the sum of all the invoices. Are there any precautions ?? In addition, is the value...

No, I actually have the following code in the close form procedure: Private Sub cmdClose_Click() .... DoCmd.Close ... .... End Sub

I need to see if the value in a control has changed from the time that the form opened until the time that the form is closed. At the beginning of accessing the form ("frmTrxWInvoicesExp"), I store the sum of the invoices into a variable in a module of Global Variables The code is...

RG, That is BEAUTIFUL -- You solved the problem. THANKS!! PS varPlanned.Requery seems to work --- and recalc provides an error.

Hi RG, the only bit of code is: Private Sub trxPlanAmt_AfterUpdate() Me.varPlanned.Requery End Sub This is for a text box on the screen. After the update to that box, I'm trying to requery varPlanned which is a calculated text box with =DSum("[trxPlanAmt]","tblTransactions","[relBudID] =...

how do I programmatically update a calculated field with dsum in it? the quote from ms is "Unsaved changes to records in domain aren't included when you use this function. If you want the DSum function to be based on the changed values, you must first save the changes by clicking Save Record on...

Roy, I didn't mean to start an international incident ... <wide grin> I'll just say THANK YOU again!!

Thanks Roy it was the first one --- 1 - Tools | Options - Keyboard tab How can someone stop from pulling their hair out?? AGAIN THANKS....

I have a problem - even though the Form Cycle property is set to "Current Record", the return key (not the tab key) still brings up an 'add' record. Of course all the data goes out of sync. Everything looks fine UNTIL you press the 'Enter key'. I've spent the better part of two ripping out...

Same sort of thing I want to do the Same sort of thing, but I want the form to initially hold a number (which I am going to pass to the query). When I put the number into the Form_Open procedure, it asks me for "Forms!frmCustomType!TypeNo" which the field I put into the query. I thought I had...

I guess I have a real problem then because the correction.zip db DOES NOT work on my system. In fact, the first time through it still deleted the entire column of twp data. Still confused ... but I've got to do something !!

I've done what you've suggested, but still no luck! It still seems to recalculate ALL the entries (as opposed to just the current one)... Marty

A Problem still!! I have revised the database accordingly by adding a second piece of code: Private Sub LivesInTwp_AfterUpdate() Me.cboLivesInCounty.Requery '<---seems to take the whole column for ' for revaluation purposes End Sub...

Reversed ?? Thanks for your prompt reply. ... but I have to pick County first ... still confused I guess I just have a mental block on this county -township thing!! Marty :confused: