Search results for query: *

Sorry, didn't mention that but I have no control over these images - they come in from lots of non-technical users so there will not be an easy way to force them to be a particular size or aspect ratio. There may be a tag which could allow them to crop, etc on upload, but the guy running the...

I am generating an automatic email using CFmail in an app. Part of what I am in putting in there is pictures. I want them to be thumbnails, so I resize them in the img tag, either the vertical or horizontal. However, here's the problem: I need to be able to do both. In most email programs...

I am importing data from Access to SQL Server. The challenge is that one of the fields I am importing is a Memo field, and sometimes it is VERY long. The maximum length I found via a query was about 28,000 characters. How can I get this successfully imported without cutting these fields off...

Thanks for that suggestion, you would think that would work but it never seems to actually work. I set that up in a report, but when I Print Preview or send it to PDF, it doesn't actually start a new page for each section. Help???

Thank you everyone, between all of these posts I was able to do what I needed!

Yes, the form that the subroutine is in, is bound (I'm assuming that's equivilant to the Record Source field) to the StoreAudit table, which does contain a pkey field, of type autonumber. The Forms![StoreAudit]![pkey] refers to this form, and grabs the pkey of the current record. What I'm...

The following code which I got from the archives here keeps giving me a "Method or data member not found" error on the rs.FindFirst "pkey = 5" Private Sub select_store_location_Click() Dim lPK As Long Dim rs As Recordset DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70 lPK =...

Question - I want to format my reports so that each new section begins on the top of a new page. The current solution is to put a blank cell in the bottom left of the section we want to always start at the top of a page. Then we set the properties so that it always starts on a new page...

Is there any way to lock the view on subforms in Access XP so that it always comes up in subform view? Right now it always defaults to the datasheet view. Thanks, Arthur

Don't feel too bad, I've programmed extensively in SQL server and CF and I just asked the same question!

Thanks everyone for your help, I got it figured out by using subforms. Mostly a consequence of not having done much work in Access.

Yes, all those things are set the way they are supposed to be. I notice that if I only reference one table in the form, then I can add new entries. But when I reference more than one, I can't. So do I need to make a top layer table that gathers everything on the form, then make a query that...

My problem is probably very simple, but here goes: I made a form based on an underlying relational database. I put a sample entry in the database, which displays on the form. The problem is I can't add new entries. Whenever I try to I get a prompt that says "You can't go to the...

I am importing from Access to SQL Server 2000. I am doing the import via a Coldfusion script, because the client does not want to mess with Enterprise Manager or anything like that, and I don't have access to anything on their systems. I have a bunch of fields that are quite large, not a few...

Is there a way when sending mail via cfmail to send it so that it appears as an html email if the receiver has that capability, or it appears as text-only if that is what the receiver has?

Thanks for the variables, however please forgive my ignorance but I'm not getting a value for them when I cfoutput them. Do I need to have one of the additional CF services installed, like Siteminder Authentication Service? Currently I am working on our dev server, on an NT network which I am...

We are trying to be able to skip our initial cf based logon screen if the users are already logged into a particular domain (which means they already are authorized - the person we are doing the job for wants to avoid users entering username and passwords twice) Is there a way to check from CF...

Could someone please help me connect to an oledb datasource? I have tried everything that I know of, and the connection keeps coming up as failed. I'm using SQL server 2000, and CF Server 5. The db was imported from Access. Is this correct: (from CF administrator OLE DB ds) DSN...