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: *

  1. grgimpy

    Execute / Calling Functions within VBA?

    It looks like it gives examples at the bottom of the FAQ: Open a folder: fHandleFile("C:\TEMP\",WIN_NORMAL) Call Email app: fHandleFile("mailto:bpo@yahoo.com",WIN_NORMAL) Open URL: fHandleFile("http://uk.yahoo.com";, WIN_NORMAL) Handle Unknown extensions...
  2. grgimpy

    Sending email from Access using Outlook

    You are probably missing a refence to Outlook Object Library in the database you are trying to execute the code from. Open up the Visual Basic code then choose Tools -> References. Make sure the Outlook library is selected.
  3. grgimpy

    Required Fields Datasheet Form

    Worked great...thanks again!
  4. grgimpy

    Required Fields Datasheet Form

    I will play with the beforeupdate event. Thanks for the input.
  5. grgimpy

    Required Fields Datasheet Form

    I have a master form with a child subform setup. This is a one to many relationship. I want to ensure all fields are being filled into each subform record before new records are added. I would like to accomplish this without requiring the fields to be entered in the table properties. I have...
  6. grgimpy

    Runtime Errror 6 Overflow when running make table query

    Many times Error 6: Overflow is caused by trying to store data in the wrong data type. Maybe you are trying to store data from one table into a field that is of a different data type in the other table. Another way this error will come up is if you divide by zero in your calculations. You...
  7. grgimpy

    Form Coruption

    Try the method outlined here: http://allenbrowne.com/ser-47.html
  8. grgimpy

    Unlock subform 2 for editing

    Thanks AceMan, but I'm still getting the same error...
  9. grgimpy

    Unlock subform 2 for editing

    I have my main form (frmORC), a subform within the main form (fsubDatasheet), and a subform within fsubDatasheet (fsubTestShot). I am getting Error 2455 (You entered an expression that has an invalid reference to the property Form/Report) on the following line of code...
  10. grgimpy

    Matching the ID fields of a form and subform

    I should note that the relationship from tblORC to tblTestShot is one to many in case that wasn't clear.
  11. grgimpy

    Matching the ID fields of a form and subform

    I have two tables (tblORC and tblTestShot). tblORC has the following fields: [ID],[Date/Time],[Item Number],[Discrete Job] and a lot more that aren't important. tblTestShot has the following fields: [ID],[Test Shot ID],[Test Shot Number] and some more fields about that "test shot". I have a...
  12. grgimpy

    ocxCalendar Problems

    I personally like using this calendar form created by Allen Browne: (http://www.allenbrowne.com/ser-51.html). Also, just bring up the calendar automatically when the user moves to the text box (got focus event).
  13. grgimpy

    DoCmd.TransferSpreadsheet

    ...FileDialog.AllowMultiSelect = True End If 'Only display excel files FileDialog.Filters.Clear FileDialog.Filters.Add "Excel Files", "*.xls" 'Open on specific folder FileDialog.InitialFileName = "C:\Program Files\" 'Locate file location If FileDialog.Show = -1...
  14. grgimpy

    Close Access and Log Off

    Try using the Form_Close() event.
  15. grgimpy

    if value is 1,then run rpt A, ..., ...,

    The code for opening a report is DoCmd.OpenReport "Report Name", acViewPreview Do you have a form that shows each record? How is this code run? With a command button? Need more information to help.
  16. grgimpy

    Setting the background colour of a tabbed form

    In Access click on Tools -> Options. Then click the "Forms/Reports" tab. Then deselect "Use Windows Themed Controls on Forms". Apply and reopen your form. The tab control should be the normal background now, but your command buttons and other controls will also look slightly different.
  17. grgimpy

    Updating info when entering date in form

    Is "onHand" a function you created? Is the subform in datasheet view so that it lists all the records associated with the entered date? If so, where does it show the total, and what exactly is the total of? You need more details to your question. Also include the error number and description...
  18. grgimpy

    Query syntax question

    Create a query based on the data table. Use SQL similar to the following to get rid of the hyphens and spaces for the field containing the identifier: SELECT Replace([Name]," ","") AS [No Space], Replace([No Space],"-","") AS [No Hyphen] FROM Table1; Then just base the query on the newly...
  19. grgimpy

    Help with a type mismatch error

    you are wrong missinglinq unless something has changed in recent updates to VBA. http://support.microsoft.com/kb/212673/en-us
  20. grgimpy

    Help with a type mismatch error

    if you do not declare each variable separately then dim x,y,z as string is actually translated as dim x as variant, y as variant, z as string maybe i was not clear in my explanation but please tell me if this example is incorrect.

Part and Inventory Search

Back
Top