Recent content by INeedAccessHelp

Hello all! I'm having a problem with a crosstab query I've created. The query in SQL view is as follows: TRANSFORM Sum([Casesm1]+[Casesm2]+[Casesm3]+[Casesm4]+[Casesm5]+[Casesm6]+[Casesm7] +[Casesm8]+[Casesm9]+[Casesm10]+[Casesm11])/Sum([Pvol1]+[Pvol2]+[Pvol3]+...

Thanks Ben. Works great!

Thanks Mike! That solves the problem if the user enters a comment that includes a single quote. Now, if a user enters a comment with a double quote, I get an error. How can I allow BOTH of these characters?

Here is the code: CurrentDb.Execute "UPDATE table SET table.COMMENTS =" & "'" & Me![ReqComments] & "'" & " WHERE table.ID = 2;" The problem comes about when the Me![ReqComments] memo field contains a single quote (example: John's book). Any help with this would be greatly appreciated. Thanks...

Thanks for your response. The problem with that is the OnOpen events for Form2 needs the value PRIOR to beginning those events.

Hi This seems like a simple issue, but I just cannot get it to work. When clicking on a command button to open a form, I want to pass a value from one form, to populate a textbox on the newly opened form, BUT I want that value to be passed BEFORE the OnOpen procedures begin. Example: A...

Thanks for the response Jeremy. I hide the dbase window while the dbase in production. When it's not in production (I'm doing testing or development) the dbase window is not hidden. When the window is not hidden, the maximization works just fine. Here is the function call I forgot to include...

I have DoCmd.Maximize on the Form_Open event as well as the Form_Activate event of the form. The form maximizes correctly if I don't hide the dbase window. As soon as I hide the dbase window using: ChangeProperty "StartupShowDBWindow", dbBoolean, False the form is not maximized...

Thanks Rick, but that doesn't work. Any other ideas?

Hi Here is the function: Public Function SortByTag(ctlCurrent As Control, frmCurrent As Form) Dim SortOrd, FormName As String SortOrd = ctlCurrent.Tag If ctlCurrent.Tag = frmCurrent.OrderBy Then frmCurrent.OrderBy = SortOrd & " DESC" frmCurrent.OrderByOn = True Else...

Hi Here is the function: Public Function SortByTag(ctlCurrent As Control, frmCurrent As Form) Dim SortOrd, FormName As String SortOrd = ctlCurrent.Tag If ctlCurrent.Tag = frmCurrent.OrderBy Then frmCurrent.OrderBy = SortOrd & " DESC" frmCurrent.OrderByOn = True Else...

Thanks Smitty, but I don't think a UNION will work here. The union query returns the count FROM EACH query as a separate record. I need Query_3 to ADD the results of Query_1.CountOfID and Query_2.CountOfID and return the total. Does this make sense?

Hello everybody I'm attempting to add the results of 2 queries using a 3rd. Here is an example: Query_1: Counts (by using Total in the design grid) the number of ID's in Table_1 Query_2: Counts (by using Total in the design grid) the number of ID's in Table_2 Query_3: Adds the results of...

This problem is VERY puzzling to me and it's the only thing holding up the release of this dbase. I have a form that allows users to make changes to a record. I don't want these changes to be permanent unless the user clicks a button which changes a flag (to a "1") on the form. This...

Thanks! It works fine. I also tried setting a string variable to Now(), then set the text box equal to: Left(variable_name, 8) This worked also.