Recent content by infomania

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