Search results for query: *

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!!

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

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

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

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

Thanks so much - that worked like a charm!

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

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

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

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

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

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

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

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

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!!

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!

Never mind - I'm a dummy - had something set the wrong way

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)

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

Thanks!