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: cer5yc
  • Content: Threads
  • Order by date
  1. cer5yc

    How to make SQL work in VBA

    Can anyone tell me what adjustments I need to make to the following to make it work in VBA? SELECT Data.[Procurement Lead], Data.ProjectStatus FROM Data WHERE (((Data.[Procurement Lead])=IIf([Forms]![FilterForm]![FilterFormProcurementLead].[Value]='All',[Data].[Procurement...
  2. cer5yc

    How to let user no there are no records returned from Qry

    I am having a bit of a problem trying to figure out how to do the following and am hoping someone can help provide some ideas. Here's the situation: I have a form where when the user clicks on a button called "Contracts" another dialog form pops up where they can select values from two drop...
  3. cer5yc

    How to make a field have consistent data

    I have a field in a table for Email Addresses. My problem is the domain names are old. I need to make everything after the @ sign read "@aol.com" and make all the email addresses lower case. Right now there are various domain names and they all need to be consistent. My table name is...
  4. cer5yc

    Access 07 Attachment Field

    I have a form where users can attach files to the record. When they attach multiple files at once (i.e. hold down the shift key and double click) the first attachment shown is the last one clicked on. For example if there are five files the user wants to attach to the record named 1,2,3,4,5 -...
  5. cer5yc

    Form showing more records than table

    I have a form I created for data entry. My table where the underlying records are stored shows 19 records. However, when I view the records via the form, it shows 38 records. For example, one of the records in the table has a primiry ID # of 19. When I open the form and scroll through the...
  6. cer5yc

    How to get a subreport to quit printing on seperate page

    I have a report that has a supreport in it. I can't get the data in the subreport to quit printing on a separate sheet. Can anyone tell me how to get it to print on the sheet where the master report ends? (I have the subreport in the report footer section of the master report)
  7. cer5yc

    Deleting a database

    I have a database that is stored on a shared drive. I don't want anyone to be able to delete the database. Is there a way to do this? Thanks!
  8. cer5yc

    Disable Close button

    Can someone please tell me if there is a way to disable the close button for the database (not the close buttons for forms). Thanks!
  9. cer5yc

    How to have a form load when the database opens

    Can someone tell me how, and where to write the code so that when my database opens it automatically loads a form. Thanks!
  10. cer5yc

    How to use the Before Delete Confirm Event

    Can someone tell me how to use the Before Delete Confirm Event to suppress the normal Access message asking the user if they want to delete the group of records. I have a "Delete Record" button on a form and I want a customized message to pop up instead of the normal one Access automatically...
  11. cer5yc

    Getting a union query to work

    I have the following union query - they all work seperatly, they all work if they are only joined with one of the other queries. When I put them all together they won't work and I can't figure out why. I keep getting an error that says "The Microsoft Office Access Database Engine could not...
  12. cer5yc

    how to store a value as a variable

    I use the following query to determine whether a record is stored in my underlying Supplier Information table based on the value the user enters for the Tax ID. What I need to be able to do with this is once it runs, if the query returns empty I need to append the Tax ID that was entered into...
  13. cer5yc

    Formatting SQL statement to run in VBA

    Can someone tell me how to format the below so that it runs in VBA .. INSERT INTO [Supplier Information] ( [Tax ID], [Supplier Name], Address, City, State, [Zip Code], [Duns #], [M/WBE Owned] ) SELECT [Enter Tax ID #] AS TaxID, [Forms]![frmContractData]![txtSUSupplierName] AS SupplierName...
  14. cer5yc

    how to unassociate a label

    Is there a way to unassociate a label that is already associated with a control? Thanks!
  15. cer5yc

    Getting some code to work

    I need the following line of code to work - currently it's not doing anything Here's what I have: If Me.opgProjectStatus = 2 and Me.txtContractStatus.Value <> "E-copy to LOB" Then Dim MsgBox6 As Integer MsgBox6 = Msg("You cannot close a contract unless 'E-copy to LOB' is selected", vbOkayOnly)...
  16. cer5yc

    Make ACCDE

    Can someone tell me what the Make ACCDE option in database tools does? Thanks
  17. cer5yc

    How to stop exiting a form

    I need the following to run when the user tries to close the form: If Me.opgProjectStatus = 2 And IsNull(txtDateClosed) Then Dim MsgBox5 As Integer MsgBox5 = MsgBox("You must enter a value for 'Date Closed' or Select 'Open' for Project Status", vbOKOnly) Can someone tell me what event I need...
  18. cer5yc

    How to undo something

    I have an option group where if the user selectes "no" they get a message box asking if they want to change the value. If they select vbno, I want the option button to go back to the "yes" button. I'm in VBA and can't figure out how to make it do that. The undo operation isn't working...
  19. cer5yc

    Getting dates to format on a report

    I have a report that is pulled from a parameter query (based on a date field). So the user clicks a Preview Report button on a switchboard form and then enters a report start date and a report end date. The parameter is as follows: WHERE (((PO.Date)>=[Enter Report Start Date] And...
  20. cer5yc

    DateDiff

    Can someone please tell me how to get the following to return the # of months and # of days, in addition to the # of years. Thanks! Private Sub ContractTerm_GotFocus() If Not IsNull(txtContractEffectiveDate) And Not IsNull(txtContractTermDate) Then Me.ContractTerm.Value = DateDiff("yyyy"...

Part and Inventory Search

Back
Top