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. cer5yc

    How to make SQL work in VBA

    Okay the SQL is no longer red after enclosing Data in parantheses but now I get an error that says "No value given for one or more required parameters". I have no idea what I'm missing here. Please help!!
  2. cer5yc

    How to make SQL work in VBA

    I have the following in VBA and the SQL line is red - can't figure out why Dim cnnx As ADODB.Connection Set cnnx = CurrentProject.Connection Dim myRecordSet As New ADODB.Recordset myRecordSet.ActiveConnection = cnnx myRecordSet.Open "SELECT...
  3. 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...
  4. cer5yc

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

    I looked at that previously but couldn't figure out how it would help me. Can you be more specific? I'm a bit confused ... sorry:)
  5. 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...
  6. cer5yc

    How to make a field have consistent data

    Thanks so much - that worked like a charm!
  7. cer5yc

    How to make a field have consistent data

    THANK YOU SO MUCH! That worked wonders. Do you happen to know how I can make all the addresses lower case? Some of them are in the file as JOHNS1@aol.com and I need it to read johns1@aol.com
  8. 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...
  9. 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 -...
  10. cer5yc

    Form showing more records than table

    When I made my form using the Form Wizard, the query it created as the record source for the form made three additional columns (Attachment.File Name, Attachment.File Number, Attachment.File Type) based off of the attachment field. File Name, File Number, and File Type are all unbound fields on...
  11. cer5yc

    Form showing more records than table

    Got it fixed - it was my attachment field/query needed to be tweaked a bit. Thanks!
  12. cer5yc

    Form showing more records than table

    Okay I found the Unique Record and figured out what's duplicating ... and now how a new problem. What's happening is I have an attachment field where users can attach a file - but sometimes there are multiple attachments for the same record. So if a record has three attachments then the record...
  13. cer5yc

    Form showing more records than table

    Not every record is duplicated but some are duplicated like four times. I built the form using the Form Wizard so I don't have a "query name" as the record source per se (i.e. the query that is used for the form does not show up in my Navigation Pane). I'm not finding any property on the form...
  14. 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...
  15. cer5yc

    How to get a subreport to quit printing on seperate page

    Also, all of my settings are set to not print on a new page. This is causing me all sorts of problems and all of my searches have turned up nothing so if anyone has any solution I would appreciate the help!!
  16. cer5yc

    How to get a subreport to quit printing on seperate page

    Okay - I'm not really a dummy ... it still doesn't work. When I go to report view it looks fine - the subreport isn't forced to a new page but when I switch to print preview (or I print the report) the subreport data is forced to a new page. Can't figure out why - please help!
  17. cer5yc

    How to get a subreport to quit printing on seperate page

    Never mind - I'm a dummy - had something set the wrong way
  18. 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)
  19. cer5yc

    Deleting a database

    Well that's what I figured the answer would be - but it sure wasn't the answer I was looking for :)
  20. cer5yc

    Disable Close button

    Thanks!

Part and Inventory Search

Back
Top