Search results for query: *

That sounds like a solution, but how can I do this in the code? There is only one physical printer. And... how can I direct to report to the B&W printer using DoCmd.OpenReport? Thanks you your feedback, PHV. Infomania People do what you least expect from them. Expect more... get more.

Interesting but not what I was looking for. I was hoping to create a function in a module that would be used, somehow, to set the printer color option to B&W before calling the DoCmd.OpenReport. Infomania People do what you least expect from them. Expect more... get more.

I am using Access 2003. I would like all the reports in my application to print in B&W even though the screen preview may show some color. I have tried setting the printer properties to do this but it keep reverting back to Color on the next print. Is there someway to set a global property when...

The way the query is designed (including 6 tables), the rescord set is not updateable. I'd like to initialize the data in a continuous, unbound form where I can edit values and add add additional fields before running a SQL updates to the tables involved.

I am trying to populate an unbound form with the results of a query using the following code: Private Sub Form_Open(Cancel As Integer) ' set initial values Dim stSQL As String Dim conn As ADODB.Connection Dim rs As ADODB.Recordset Set conn = CurrentProject.Connection Set rs...

I am using CR 9 and a MySQL database (XP Pro OS). I have updated CR 9 to address MySQL database issues. I have constructed a SQL query and am running it from within the Command feature. The results I am getting indicate that string fields are getting arbitrarily truncated. For example I have a...

No this didn't solve the problem. the above was successful in bumping the CR type up to a String [17] and I'm still cutting off data. Help??

I changed user_group.group_name to left(user_group.group_name,255) as group_name and it seemed to solve the problem. I suppose I could have used left(user_group.group_name,100) to match the database type. This may be the solution but I'm not sure what to use for MEMO fields.

I am using CR 9 and a MySQL database. I have updated CR 9 to address MySQL database issues. I have constructed a SQL query and am running it from within the Command feature. The results I am getting indicate that string fields are getting arbitrarily truncated. For example I have a field in the...

Thank you. That did the trick. It requires a reboot after installing the patch. All tables are now visible. infomania

Is there some trick to getting the MySQL database tables visible in Crystal Reports? I am using the MySQL Driver 3.5 (on WinXP Pro) , the current version on MySQL and CR v9. I can connect to the database (I see it in CR) but when I click on the expand +, the tables are not there. I can...

I am having difficulty setting up the VB script to set parameters before opening a Crystal Report (using Visual Studio 2003). I am using a report created in CR v9 which I brough into my ASP.Net web project. The report has 4 parameters, one of which I would like to set as the user opens the...

Thanks, PH That did the trick. I replaced: DoCmd.Close DoCmd.OpenForm "frmDS_AUCT_ATTENDEES" with Me.OrderBy = "" For the cbRefresh_Click event and this cleared the user's action.

Using Access 2003 as 2000. I have a datasheet form which sorts records by two fields (TABLE_NBR Asc, LASTNAME Asc) in a row. After opening the form a user clicks on LASTNAME and sorts Asc. When the form is closed and repoened I loose the sorting order that was built into the query (it retains...

Roy Thank you... I think I will use the multiselect listbox approach. These users make lots of typos. The info in the referenced thread is just what I need. Infomania

I would like have a function to convert a user entered, comma separated, text string to a proper text string to be used in a WHERE clause. Example: Dim strInput, strConvInput, strSQL As String strInput = Me.BoLInput ' user entered string ' user string looks like: 123a, 134D, 115,123 ' user...

Thanks... restating you response. Users who do not have SELECT rights to a table cannot refresh a report that was created by a user who has SELECT rights to the table. Is this correct?

I was wondering if my DBA set up access security to deny read access to a table for some users, would they be able to run (refresh) a report created by a user that had read access to the tables? I am using CR 9, accessing data on a SQL Server 2000 database. Infomania

I seem to have resolved the problem by reconstructing the query such that it is based off of the table instead of an intermediate query. As such the following produces the correct result set: SELECT DatePart("h",[TIME_ARRIVE_WOODS]) AS [HOUR], Count(tblTRACKING_DATA.TRACKING_DATA_ID) AS...

Both of those suggestions, while eliminating the error message, produce no results. Is there some way I can create a string variable in the AfterUpdate event for the field and then use that in the query (as #strDate#)?