Recent content by TheDoubleB

Have you tried building you SQL statement using IF statements? If you query is based on data entered on the form then you can use IF request.form(&quot;name&quot;) <> &quot;&quot; Then ... and add a add a line to the SQL statement sql=sql & &quot;other criteria&quot;, building it as you go...

Can u send the form and code, I'll be glad to take and look and see if I can help? bb5124@comcast.net

I had a similar problem and I created a new form and cut and pasted everything from the old to the new form (instead of importing) and the new form worked. I don't know if the problem was in the conversion. I didn't research it further because this worked.

Sorry, there were a few typos in the first piece of code I sent. Private Sub Command21_Click() On Error GoTo Err_Command21_Click Dim dbs Dim rMST Dim FN As String Dim A() As String Dim I As Integer Set dbs = CurrentDb() Set rMST = dbs.OpenRecordset(&quot;Select * from EnterTableNameHere Where...

My code is looking for a SPACE between values. You can replace the &quot;,&quot; with &quot; &quot; and it will parse correctly. You can cut and paste the code behind the On_Click event of a button on any form, just change the &quot;Command21&quot; in the code with your button name.

I use this code behind a button: Private Sub Command21_Click() On Error GoTo Err_Command21_Click Dim dbs Dim rMST Dim FN As String Dim A() As String Dim I As Integer Set dbs = CurrentDb() Set rMST = dbs.OpenRecordset(&quot;Select * from EnterTableNameHere Where ([FullName] > ' ')&quot;) Do...

It is a multi-table query. I use nested <CFOUTPUT>'s for the GROUP Function. If I use <CFOUTPUT query=&quot;UData&quot; GROUP=&quot;CODE&quot; >. I get one header record at the &quot;CODE&quot; level and multiple Detail records by nesting the <CFOUTPUT>'s.

My goal is to duplicate an existing Access Report. The first table has the basic information. The middle paragraph is just a small line with the address, city, state, etc. I'm using the nested <CFOUTPUT> to show the detail for each unit record. Taking out the style didn't help. If you want to...

There is a ampersand nbsp in between those <P> </P>'s. I noticed it didn't show them after I posted the code.

Here it is: <CFOUTPUT query=&quot;UData&quot; GROUP=&quot;CODE&quot; > <TABLE Align=&quot;left&quot; Cellspacing=0 border=&quot;0&quot; WIDTH=&quot;80%&quot; > <TR> <TD><FONT Size=&quot;-1&quot; color=&quot;blue&quot;>REG</FONT></TD> <TD><FONT Size=&quot;-1&quot...

I am grouping my output and when there are more than three detail records in the group the next group heading displays over the top of the previous line. If there are only three group records then it works fine. Anyone ever have this problem?

I haven't been able to find any sort of help or solution about granting group permission to a table without going through the security menu. Can I use the Owner property in the MYSYSOBJECTS? and if I do, how does system know if its a group or user permission?

I have a secure DB that has code to delete and then recreate a new table. When the table is recreated the owner is the current user and when another user with the same group permissions logs on, it will not let them delete and recreate this table. Set tdf =...

Never mind....must have been temporarily brain-dead...just changed the double quotes to single quotes....

I am using the following codes: <CFQUERY name=&quot;SNNote&quot; dbtype=&quot;ODBC&quot; datasource=&quot;Afr&quot;> Select * from Notes Where SNID =#NR# </CFQUERY> This works and I can display the data. However, when I try an update with: <CFQUERY name=&quot;SNUpdNote&quot...