Search results

  1. C

    Filter a continuous form

    I am trying to filter a continuous form to show only records between two dates. On the form I have a field call ScheduledStartDate and two text boxes one call txtStartDate and the other named txtEndDate. I allso have a command button named cmdApplyDateFilter with the following code. Private...
  2. C

    Hide Show Menus and Toolbars

    Yes I do. This has always worked for me in the past but now does not seen to work on this one database. I am trying to figure out what might be overriding it.
  3. C

    Filter form on drop down box selection on button click

    Would this work for a date range
  4. C

    Hide Show Menus and Toolbars

    I have a form called frm_Logon that opens on database startup In the On Open Event I have the following code: Dim i As Integer For i = 1 To CommandBars.Count CommandBars(i).Enabled = False Next i This should hide all toolbars and menus. However it has absolutely no effect. I have tried to...
  5. C

    Forms not staying maximized

    Here is the senario I have two modal popup forms that are maximized. On the form that is in the forefront there is command button that opens a report. The on open event property of the report has DoCmd.Maximize in it to mazimize the report. The problem lies when the report is closed. The two...
  6. C

    Modal Report

    Is there a way to have a reports Modal property set to yes AND have a visible toolbar or menubar....
  7. C

    Close Report Open Form

    Here is my delima. I have many reports in this database. On the OnClose Event I hvae the following Code Private Sub Report_Close() DoCmd.OpenForm "frm_MainMenu", acNormal, "", "", , acNormal TabCtl0.Value = 3 End Sub The idea behind the second line is to go to a specific tab on...
  8. C

    Check for valid email address

    This worked absolutely perfectly. Thank you so much.....
  9. C

    Check for valid email address

    I do I just do not know exactly what to put into the beforeupdate event. I know it is asking for an argument, I just do not know what it is. My current code on the before update event is Private Sub GeneralEmail_BeforeUpdate(Cancel As Integer) CheckEmailAddressFormat End Sub
  10. C

    Check for valid email address

    Please excuse my ignorance but I am new to this. I created a module using your code and the called the function from the before update event on the email field in the form. It returned an error message saying argument not optional. I am not sure what argument it is looking for. Any help would be...
  11. C

    Check for valid email address

    That is awesome. Thanks. I noticed one flaw. If you enter an invalid email address and backspace over it after clicking ok on the error message and then try to move to another field you get a runtime error that says invalid use of null. However if you use the escape key everything is ok.
  12. C

    Check for valid email address

    That is great. Thanks it worked perfectly. I was wondering if there is a way to handle things like .ca or .uk as they are only two characters. I tried this but it did not work Private Sub GeneralEmail_BeforeUpdate(Cancel As Integer) Dim InputErr As Integer Dim DotEnding As String...
  13. C

    Check for valid email address

    I have searched and found nothing on this. I need a way to validate that an email address that is entered in to a field is in fact a valid email address format. I am not looking to check if the email address is a valid address just that it is formated correctly. Anyone have any ideas.
  14. C

    Continuous form Update

    I have a continuous form that has the following fields ActivityID ContactID TaxreceiptAmount ReceipNumber I need to populate the ReceiptNumber field with numbers that are incremented. Currently I am using the following code and it works perfectly Dim db As DAO.Database Dim rst As DAO.Recordset...
  15. C

    Query to increment value of a field

    On this code Set rst = db.OpenRecordset("SELECT tbl_Events.EventID, tbl_Activity.ActivityID AS ActivityReference, tbl_Activity.ReceiptNumber, tbl_Activity.TaxReceiptAmount " & _ "FROM tbl_Events INNER JOIN (tbl_Activity INNER JOIN tbl_Contacts ON tbl_Activity.ContactID =...
  16. C

    Query to increment value of a field

    I was actually able to get it working by importing all the objects into a new db Many thanks
  17. C

    Loop through recordset and run query

    I am using the following code based on Bob Larson's sample on his website Dim db As DAO.Database Dim rst As DAO.Recordset Set db = CurrentDb Set rst = db.OpenRecordset("qry_RecNumberCollect") Do Until rst.EOF DoCmd.OpenQuery "qry_RecNumberUpdate" rst.MoveNext Loop rst.Close Set rst =...
  18. C

    Query to increment value of a field

    Sorry did not see it. I was able to open it but I am getting an error. Please see the attached screen shot Masny Thanks
  19. C

    Query to increment value of a field

    Thanks Would you be able to repost the database you created in Access 2003 format. I can not open the 2010 one. Many Thanks
  20. C

    Query to increment value of a field

    The ActivityID is perfect. I will have to change the table references to have the _(underscore) in it because it would mean way to many changes to my project. I was told way back when to use that to simulate a space. Is there a reason not to do that cause if there is i won't do that in future...
Back
Top Bottom