Search results for query: *

I can Hide/Show the first set of fields but not the second set. I've search the internet to only find several examples of just showing hiding 1 text box. I've used the <div> tag before with the JavaScript toggle to show/hide while developing another site and it works great, but because of the...

I've been trying this for days. JavaScript isn't even firing. Any Suggestions?? I'm using it with Coldfusion. <script language="JavaScript" type="text/javascript"> function hide(divToHide) { var me = document.getElementByID(divToHide); if (me.style.display ==...

Hi Everyone, I am trying to install a 180 day trial version of windows server 2008 r2. When I try to install it, I get 2 choices, 1 asks to Upgrade: Upgrade to a newer version of windows and keep your files and programs.... The other is Custom(Advanced): Install a new copy of windows... I...

Hi All, I've been at this for a few days using several DLookUps. DLookUp is finding a record ID for a record not even in the table. ReqNo = 23a21 and SPID = 11 ReqNo 23a21 doesn't even exist in the table I cleared RQID beforehand to be sure nothing is in it What am I doing wrong? Code...

Hi All, I have an issue where I was asked to remove a date on a record. A task was closed in error and now needs to be reopen but the date needs to be removed. Any help would be greatly appreciated. Thanks, Kathy

I need to show a button on a page depending on query results. This is already existing code I am trying to modify. Is the following example correct? Thanks in advance... <td bgcolor="#FFFFFF"><div align="center"> <cfif UserID.Name is “ABC” OR UserID.Name is “XYZ” OR UserID.Name is...

We have a ColdFusion web application that uses an MS Access database. Once in a while when I open the database to fix data, which shouldn't need to be done but the way it was written it's currently the only way, the website will go down. I've had it open for hours removing profiles that are...

I keep getting this error tying to set up a datasource in ColdFusion. "The ColdFusion ODBC Server service is not running or has not been installed. You may also use the "MS Access with Unicode" driver to connect to MS Access datasources." I opened the data source in ColdFusion administrator...

I'm new to coldfusion and I've been tasked to create a popup disclaimer that a user has to acknowledge before he/she can proceed. This popup will show up based on a user's level of access. What is better to use to create this type of popup, cfwindow or a javascript popup?

I've deleted data in a table in SQL Server and set a primary key and saved the table. I went to my MS Access db and linked the table I just deleted the data in from the SQL Server. When I open the table in Access, all the data is still there and the primary key isn't set. I close both the SQL...

Hi All, I have an Access to SQL Server connection issue. I run a process against the production db and it runs fine. I run it against the Development db and I get an ODBC connection failed error. Nothing changes in the code. Same code for both environments and exact same data(QUERY) being...

I'm testing a stored procedure and want to know if I can just select the rows I want to delete and click the delete button. I have 1 record in another table that's a foreign key in this one that I will have to delete first. I want to do this so that I can just test the code a few times with...

I'm linked to an SQL Server, using MS Access. All the tables are linked to the same db and I can open and view the data in all the tables except one. All the fields for all the records show #NAME?. I first get an ODBC - Call failed! Then the table opens and I get all the #NAME? in the records. I...

I'm linked to an SQL Server using MS Access. All the tables are linked to the same db and I can open and view the data in all the tables except one. All the fields for all the records show #NAME?. I first get an ODBC - Call failed! Then the table opens and I get all the #NAME? in the...

I keep getting errors connecting to the SQL Server from MS Access. I can view the tables, run queries and other insert queries work. This one isn't working... I am connected! The object name is correct - "dbo_T_IMPORT_FDDR_DISCREP" Insert statement in query object <--- Append query INSERT...

Is it possible to Insert records to SQL table using MS Access (VBA)? Contractual issues won't allow me to fix anything on the SQL server but I have to insert records into some SQL tables but the records that I need to insert into the SQL tables are in MS Access tables. The MS Access...

I get an error 1004 on a line but with the exact same line of code above it, I don't... What am I doing wrong? Do While ThisWorkbook.Sheets("Part_List").Cells(rowPartList, 1) <> "End" << No Error here If (ThisWorkbook.Sheets("Part_List").Cells(rowPartList, 3) = "") Or...

I get a Subscript out of range but the file does exist and the name is correct. Dim wb1 As Workbook sPath = ActiveWorkbook.Path sFilename = sPath & "\AMSRRList.XLSX" Set wb1 = Workbooks(sFilename) <<< error is here Thanks in advance for any assistance

I'm not sure what I'm doing wrong here. I've tried every example for this that I've seen... If (conInt > 10) And (conInt < 33) Then Set cmt = ActiveSheet.Cells(RowCount, 1).Comment With cmt Text Text:="901-031-573-104" <<<<< error is here <<<<<< End With End If Thank...

I've looked for hours all over the internet and tried everything. Nothing I tried is working. I can't figure out why I keep getting this error. I cannot work forward until I get this resolved. Any help will be greatly appreciated.