Search results for query: *

Hi, Within Access, I have some data in a table that I'd like to use to selectively populate another table. Per the example table below, I'd like to dump all data into another table, although where the State is equal to California, I'd like to only populate the values where LName is equal to...

Hi, I'd like to make my Access forms viewable online, in which there is a lot of VBA code behind them. Ideally, there would be a converter to transition them to whatever language necessary. Regardless, what are your opinions and recommendations? Thanks.

Got it working! Was related to the code on my action page. Thanks very much for your help

Thanks, that sounds like it might work. However, when adding the revisions, as outlined in Phil's post, I receive the error "The given fieldname "primarykey_1" could not be found in the table "tbltest"." I believe this is because the name of the field in the database (which I cannot change due...

Does anyone please have any ideas from my question in the above post? I've been researching the issue and I can't determine a way to traverse row by row, when the values are tied to a single variable and separated by commas. Thanks

I've come across another issue now. On my form page, if I display all rows that contain the value "r1", and then submit to my action page, the variable "PrimaryKey" contains "1,2", "Column 1" contains "r1,r1" and "Column2" contains "r2,r4". When I'm looping through the values on the action...

Thanks PlanningCouncil. It is a site. As of right now, only the members have permission, but the non-members can still see it. If they attempt to enter, they are given the option to request access. Any more ideas? Thank you.

The unique identifier is a non-primary key field. If multiple rows have the same unique identifier, then they will be displayed on the form. Unfortunately, I can't post the form, as it contains proprietary information. Thank you for your help. I will report back, based upon my progress.

Thanks, GUJUm0deL. The number of rows displayed is dependent upon the amount of records equal to, in this example, "r1" so there could be more than two. Should I place your code on the action page, in place of the cfupdate? Also, what does the cfsqltype perform? I'm not using sql in this...

Hi, I have a sub-area in SharePoint, in which the members of it have been appropriately defined. Although non-members can't access it, they can still see that the link to the sub-area exists. Is there any way that I can hide the link for non-members? Thanks.

Anyone have any more ideas? Thanks a lot!

To be honest, I've never used an update query before. Also, all of my other pages use a cfupdate command. I'd be willing to research the function and implement it, if it's the cause for my problem. If not, please let me know if you have any other ideas. Thanks.

Here is an example of how I'm displaying the records: <CFQUERY NAME="displayData" DATASOURCE="test"> SELECT * FROM tbltest WHERE recordID='#session.recordID#' </CFQUERY> Upon submission, the page utilizes an "action" page to use the code below to perform the update: <cfupdate...

Hi, I have a CF page that allows me to edit records in a MS Access database (the primary key in the database is autonumber-based). If I try to edit one row of the database from my CF page, everything works fine. However, if more than one row needs edited and is displayed on my CF page, upon...

Thank you for the fast reply. So, this is something that does not need backed up?

Hi, Our nightly backups are approaching capacity and I've noticed that the mysql.err file is rather large. Can this be excluded from the backups? Would it have an effect on recovery, if a disaster occurred and the mySQL databases needed recovered from backup? Thanks.

Does anyone have any ideas? I believe I know the cause for the "Invalid data 1,2 for CFSQLTYPE CF_SQL_INTEGER" error, I just can't figure out a workaround for it. When there is more than one table displayed (two in the following example), the table entries are modified, and the "submit" button...

Hi, Here is the ColdFusion portion of the update page: <cfupdate datasource="YourDataSource" tablename="YourTable"> It works with only one table, but when there are two or more tables present, I get the following error (where 1 and 2 are the primary keys of two different rows in the Access...

Anyone know why I'm getting the primary key-related error in my post above? I still can't figure it out. Thanks.

Thanks! The lack of <BR> before the </cfoutput> tag was the cause of the tables not displaying properly. However, with more than one table, I am getting an error on my cfupdate page. My primary key is an autonumber and when I edit the tables and then click "Submit" (which goes to my cfupdate...