Recent content by nsukari

The problem is that I want to be able to update multiple records at once and it won't allow me to do that. I get an error that says cannot update ID 5,8,45, etc. although Ik did not add any commas to ythe query. One record at a time updates fine.

CidMatrix, I want to use CFGRID, but I keep getting the message that my browser does not support Java2. How can I update?

I have a query that updates the record in the DB with the new information the user submits. What I want to do is allow the users to update all of their records at once, click submit, and then have the correct records update in the DB. Is there a way to di this? I tried using CFLOOP, but it was...

There are two columns in my table "Programs", SPM ID and Program Name. I need to be able to automatically populate the "Program Name" by selecting the SPM ID from the drop-down list. How can I do this? Thanks for the help.

Thanks for trying to help. I've tried changing the fields one at a time but to no avail. Even though I didn't want to use CFINSERT, it's working with so I'll just stick with that for now.

No. That still doesn't work. It keeps saying there is something wrong with this line: <CFQUERY NAME=&quot;addexpense&quot; DATASOURCE=&quot;WMRA&quot;> Everything else is fine.

I have an application that is working well except for one thing. The submitted data will not insert into the Acess table. I have checked all of the field names, I have tried other applications running on this same DB and they work, and I have checked each field in the table to ensure that there...

Thank You. It works perfectly.

I am trying to create an update query to correct the names of one table before comparing it with the other. The problem is, I have four people with the suffix of Jr. on their last name. I want to get rid of the &quot;.&quot; without having to list each name indiviually. Is there a way I can do...

Thank You so much! It worked perfectly.

I have a simple application set up so that users can register for certain events through our website. The registration information is added to an Access database and a confirmation e-mail is sent to the reigstrant and the person in charge of the event. The problem is, I need to limit the...

I am using the following script from javascriptkit.com for a slideshow. I need to know if there is a way for me to point to an entire directory of photos instead of listing the photos seperately. I am often replacing photos or adding new ones and instead of having to update my script each time...

I am using the following script from javascriptkit.com for a slideshow. I need to know if there is a way for me to point to an entire directory of photos instead of listing the photos seperately. I am often replacing photos or adding new ones and instead of having to update my script each time...

To your first query add a third column for Max of Rep#. Now your query resilts should be Region MaxOfSales MaxOfRep# A $15,000.00 0302 B $7,000.00 0004 Here is the code for the join query: SELECT Query1.Region, Query1.[MaxOfRep#], Reps.Name, Reps.State, Query1.MaxOfSales FROM Reps RIGHT JOIN...

Count([Table].Field))>1