Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: rfoye
  • Order by date
  1. rfoye

    Clearing a field on BeforeUpdate

    I figured out a workaround. For the bound instance, I can leave the code in the BeforeUpdate event. For the Unbound instance, I set focus on another field, set the value of the first field to null, then return the focus to that field. ------------------- Rob Foye Database Management Regions Bank
  2. rfoye

    Clearing a field on BeforeUpdate

    By the way, form is unbound for new records and bound for looking at existing records. It looks like on existing records, it reverts to the previous saved version, but the Unbound New records are not reverting to Null. ------------------- Rob Foye Database Management Regions Bank
  3. rfoye

    Clearing a field on BeforeUpdate

    Ok, I've searched and can't find an answer to my problem. I am doing a validation by using the BeforeUpdate event. If the value meets certain conditions, I want to Cancel the update and clear the field. Sub FieldName_BeforeUpdate(Cancel As Integer) ***some code*** If vVal = vbCancel Then...
  4. rfoye

    Intellisense odd behavior

    I've noticed that in some of my (Access2003) databases, the Intellisense starts acting really strange. For instance, after typing a period and then the first letter of the method, the intellisense will start to show the list of methods, then after 2 seconds, disappear and NOT complete the...
  5. rfoye

    Multiple Instances of form

    Thanks, MajP. I think your suggestion will start me on the path to find a solution, if there is one. Unfortunately, I'm under a time constraint and can't play around with this idea anymore. Instead, I'm having to continue using 2 virtually identical forms. But when I work on "version 2", I'll...
  6. rfoye

    Multiple Instances of form

    I have code that creates identical instances of a form by adding to the collection for the form. I would like to create multiple instances, HOWEVER, each instance would need to parse an OpenArgs value to set a recordset for the instance. Is this possible? In other words (I think), is it...
  7. rfoye

    Export a REPORT to Excel

    Thanks, Remou. I had just found the OutputTo action when your reply came in. It did what I needed it to do. ------------------- Rob Foye Database Management Regions Bank
  8. rfoye

    Using the Transfer Spreadsheet Command

    I've just been looking at the TransferSpreadsheet action, and what I've read says that you can not use a SQL string. You must first use the SQL to create a query object, then use that query object in your Transfer action. ------------------- Rob Foye Database Management Regions Bank
  9. rfoye

    Export a REPORT to Excel

    No, I don't want to transfer the underlying data set. I know how to do that. I need to be able to do the equivalent of the "Analyze it with MS Excel" menu selection. I can select a report, go the the menu and select "Analyze it" and an excel file will be created that retains the column...
  10. rfoye

    Combo box: display vs dropdown list

    GingerR: Your suggestion of putting the "filter" in the GotFocus event worked perfectly! Before making the initial post, I had tried that in the MouseDown event, and it didn't work. I keep forgetting "If at first it doesn't succeed, try a different event." Even better is that even if I tab into...
  11. rfoye

    Combo box: display vs dropdown list

    Both of you misunderstood my question. I don't want incative users to appear in the list at all (when selecting). ------------------- Rob Foye Database Management Regions Bank
  12. rfoye

    Combo box: display vs dropdown list

    I'm hoping I can do this with just the combo box instead of a combo box and an overlapping text box. I have a combo box that displays a Processor's name, but the value stored is the UserID (hidden column 1 of the combo box). If a processor is no longer with the company, I want the box to...
  13. rfoye

    Calculate milliseconds

    I don't know about you, but I get slowed down with timer calls where you have to specify the number of ticks or milliseconds. Here is a bit of code I wrote where you enter the Time Unit (Minutes, Seconds) and the number of those units that you want to wait. Public Function fMillis(lngVal As...
  14. rfoye

    Function that makes timer values easy (milliseconds)

    I don't know about you, but I get slowed down with timer calls where you have to specify the number of ticks or milliseconds. Here is a bit of code I wrote where you enter the Time Unit (Minutes, Seconds) and the number of those units that you want to wait. Public Function fMillis(lngVal As...
  15. rfoye

    VBA not recognizing the Excel .Selection method

    I'm formatting an Excel worksheet from Access using VBA. Part of my code is: Set appExcel = New Excel.Application Set WB = appExcel.Workbooks.Open(stFile) Set WS = WB.Sheets(1) WS.Range("E:E").Select Selection.HorizontalAlignment = xlLeft Selection.VerticalAlignment...
  16. rfoye

    Evaluating a concatenated string

    Thanks PHV. You saved my day. ------------------- Rob Foye Database Management Regions Bank
  17. rfoye

    Evaluating a concatenated string

    Is it possible to evaluate a string as the concatenation of a string and variable? I'd like to store a string such as: "A new file (" & stParam & ") has been created." into field "Message" of a table, then retrieve that field value and evaluate the string with the established value of...
  18. rfoye

    conditional cancel of Exit event

    Thanks, AceMan. I was working toward something like you gave me, but didn't think about the timer events. ------------------- Rob Foye Database Management Regions Bank
  19. rfoye

    conditional cancel of Exit event

    I've already got this. Private Sub cboDept_Exit(Cancel As Integer) If Me.cboDept = 0 Then Cancel = True End If End Sub What I need is a way to reference the control that the focus is moving to, something like: Private Sub cboDept_Exit(Cancel As Integer) If me.cboDept = 0 AND...
  20. rfoye

    conditional cancel of Exit event

    If the value of a combo box is 0, I want to cancel the OnExit event except if the user clicks on a button that closes the form. Can this be done? Is there any way to reference the control that will receive focus from within the Exit event of a control? ------------------- Rob Foye Database...

Part and Inventory Search

Back
Top