Search results for query: *

This is an example of my current permissions table. Username LName FName MI Password Roles ChangePassword Locked UnitsAllowed 108 Schneider William M. 108 Budget No No 6120,6121 I've got the validation and login...

What would be the best way to achieve this? So far this is my code (but I am certainly not saying this is the best way to calculate a total); it is not calculating anything, just displaying a 0 (so it must be at least syntactically correct). <cfset ChargeTot=0> <cfif isdefined("NarAmt") or...

Can I use this function around a field in my SQL statement. I can't find any mention of it in my DB2 SQL programming guide.

I would like to write a SQL statement using DB2 SQL syntax. More specifically I need to date to be based on Year To Date criteria. Any ideas where I begin? My date field is alphanumeric. eek!

[IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL]SQL0199 - Keyword OUTER not expected. Valid tokens: FOR WITH FETCH ORDER UNION EXCEPT OPTIMIZE. SQL = "SELECT BPKQCD, BPKRCD, BPGDNB, BPBAVA/100 as Balance, BSJ6CD, BSJ7CD, BSNBCD, BSBEVA FROM YABPREP FULL OUTER JOIN YABSREP ON...

Anyone see anything wrong with my query of queries? I get the following error:PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag <cfquery name="GetActual" datasource="amflibc"> SELECT YABPREP.BPKQCD, YABPREP.BPKRCD, YABPREP.BPGDNB, YABPREP.BPBAVA/100 as Balance FROM YABPREP GROUP BY...

I would like to write a query joining two tables by UnitID and NatureID. Is there a JOIN I can use that will return all rows from table1 and all rows from table 2 where they meet the criteria? As well as join where there is a match, and return rows where there isn't a match?

Why doesn't this SQL statement work? <code>Dim MyDb As Database Dim MyTable As Recordset Dim NextCounter As String Set MyDb = CurrentDb() Set MyTable = MyDb.OpenRecordset("next_rdd_number") NextCounter = MyTable("next_number")...

I am getting the following error when running a query from Access that links to a AS400 file via Client Access Express. [ibm][client access express odbc driver (32 bit)]invalid string or buffer length. #30038 Does anyone know what this means? I've searched extensively and cannot find anything...

I am using the following code Private Sub Form_Load() If Forms![MasterDemoApplication]![AccountNumber] Is Null Or Forms![MasterDemoApplication]![AccountNumber] Like "" Then oldCustomer.Visible = True oldCustomerContactPhone.Visible = True oldCustomerContactFax = True...

How do I return the result of this SQL statement. I want to pass the value to a module. sql = "SELECT COUNT(QuoteItemNumber) AS CountOfQuoteItemNumber FROM QuoteHeader GROUP BY QuoteNumber HAVING (QuoteNumber = 'q-021305-799')" Set rs = db.OpenRecordset(sql)

I have been challenged with turning a multiple page Access report into multiple documents. Has anyone worked with FORTIS? The user would like to press print, to print the possible multiple page doc, and have FORTIS recognize it as separate documents. Any ideas at all??

I know that Access will print to your default printer. However, Is there a way to specify a different printer, without changing your default printer?? Thanks!!!

I am a newbie to writing a CF script. Anyone have any ideas on how to accomplish this? running a scheduled CF script to check the folder for entries, then read those files and check for the subject from those emails (something like "Subject: Quote Q-"), then parse the "From: " and "To: " , send...

Is there a way to turn off how often Access tries to automatically update records? We have some laptops with wirless connections, and would like to change this interval so users do not experience disk or network errors.

I have a form with a datasource of a query with 3 tables. This form also contains subforms. THe query of the main form and all the subforms contain the primry key of each corresponding table, or my subform is bound directly to the table. The problem is a couple users will enter information in...

I am using the following code <style type="text/css"> BR.pageEnd {page-break-after:always} </style> to force a page break on my printable CF form. I use <br class="pageend"> to call the break. My problem is it's creating at least 2"'s of white space at the top of the paper I am printing...

Is there a quick way to do a check via a cfif to see if my form has been submitted?

On my Insert page which receives info from the entry form, I have an INSERT statement. If the user doesn't fill in every field, the SQL doesn't work. So I added cfparams with a default value="". Shouldn't think take of those empty fields?

Can I do something like this? <cfif month(GetSAP.DateEntered) EQ month(now())> <font color="#FF0000"> <cfelse> <font color="#000000"> <td valign="top" width="50">#GetSAP.AccountNumber#</td> <td valign="top" width="230">#GetSAP.CompanyName#</td>...