Search results

  1. V

    Importing specific cells from Excell

    I would import the data to a temp table, then manipulate the data to the fields you wish and then append them to the final table
  2. V

    There was a problem accessing a property or method of the OLE object

    We had some problems with this control on just some of our computers, it was a version issue. They had some parts of Office 2007 installed ahead of the full Office 2007 deployment. So you might check that you have the correct version of the control for the Office version you are using.
  3. V

    This should be easy, but something's wrong

    Did you try putting a break at the very beginning of the Page Header section? To see if that event is even firing? I know it doesn't fire at all if you just go from design view to form view or layout view, you have to actually call the form to open for that event to fire. I used to put code...
  4. V

    This should be easy, but something's wrong

    Also be sure you are not just viewing the results in Form View but are actually calling the report, otherwise I don't think those events fire. To test just stick a button on a blank form and open the report that way.
  5. V

    This should be easy, but something's wrong

    Where is the Me.MeetingDate located? In the page header? Try putting a Break on the beginning of the Page header section and see if the code even runs.
  6. V

    HOw to open a POP UP form to a specified size

    Very nice solution, thanks
  7. V

    Show matching data in a form

    Since your row source is becoming complex, perhaps you should consider a union query. Using your current rowsource as the first query, and a limiting query as the 2nd query.
  8. V

    Using a report field to create export file name

    You could open the report as hidden, get the value, then output the report. But if the field is in the detail section, how would you determine which record? Unless this is a one record report DoCmd.OpenReport "rptTest", acViewPreview, , , acHidden MsgBox Reports![rptTest]![CA_EventDT]
  9. V

    Removing last digit on different length numbers

    Well you could convert it to a string and back, and do it with string functions. Seems like there should be a len for integers, but maybe I am thinking of another language where intnumber is your field Dim intLength As Integer Dim strNumber As String strNumber =cstr(intnumber) intLength =...
  10. V

    Logging ADO operations

    No matter how small your database is, you must back it up. The larger it is, the more users, the more frequently you should be backing it up. If any of your data contains money data, or legal data, then I would have more than one copy of a backup. all hard drives fail eventually, all...
  11. V

    need code to decide which date was inputed first

    There are probably alot of ways to do this. Depends on how much you want to give the user edit rights also. If you want to avoid alot of coding, you would have 2 NOW fields for both textbox fields (basically flags for when they were first set) If there was a value in their NOW field, you...
  12. V

    need code to decide which date was inputed first

    They do force us to be creative. If you have access to the data design, you could have another NOW datafield to compare - If there was already a value in it , then don't update the project name.
  13. V

    need code to decide which date was inputed first

    first date as in earliest date? not first data entered? You can compare the values of the textboxes If CDate(Text1) > CDate(Text3) Then strdate = Text1 'Text1 is newer Else strdate = Text3 'text3 is newer End If
  14. V

    TransferDatabase trouble

    Interesting, this works for me and sends out a table: DoCmd.TransferDatabase acExport, "Microsoft Access", "c:\temp\export.accdb", acTable, "qrytest", "tblexport" What is the value of treasuryreportpath ?
  15. V

    TransferDatabase trouble

    change acquery to acTable assuming "standard_feeder" is a query that should work
  16. V

    Cancel / stop command?

    If you are in the middle of a routine the END keyword ends the routine. It doesn't even go to the End Sub
  17. V

    Cancel / stop command?

    If you capture the ESC key, then you can do whatever code you want at that point - you don't have to let them into the coding. You want to stop the coding but not have the user involved at all, is that it? You stop code execution and then what?
  18. V

    Cancel / stop command?

    There has been some coding posted in this forum for using the Esc key to break into loops. You might search for that. Private Declare Function apiGetAsyncKeyState Lib "user32" _ Alias "GetAsyncKeyState" _ (ByVal vKey As Long) _ As Integer Good luck
  19. V

    Absence Management

    Could you show or describe the data design with more detail? Like?: [Tom] [Week1] [5] (absences) [Tom] [Week2] [3] [Mary] [Week3][5] [Mary] [Week4][1]
  20. V

    HOw to open a POP UP form to a specified size

    This is something I have found very irritating. I use a workaround, but maybe someone else has a simpler solution? When you load a form as dialog, it won't recogonize the movesize coding. Well, this is one way... in the form properties, set the autocenter property to NO Then put this code...
Top Bottom