Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: infomania
  • Order by date
  1. infomania

    Change Default Print to B&W

    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.
  2. infomania

    Change Default Print to B&W

    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.
  3. infomania

    Change Default Print to B&W

    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...
  4. infomania

    Populating Unbound Continuous Form

    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.
  5. infomania

    Populating Unbound Continuous Form

    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...
  6. infomania

    Truncated fields using Crystal Reports v9

    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...
  7. infomania

    Truncated MySQL fields

    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??
  8. infomania

    Truncated MySQL fields

    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.
  9. infomania

    Truncated MySQL 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...
  10. infomania

    Crystal Reports and MySQL

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

    Crystal Reports and MySQL

    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...
  12. infomania

    Setting up CR to Run from ASP.NET

    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...
  13. infomania

    Preserving Sort Order

    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.
  14. infomania

    Preserving Sort Order

    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...
  15. infomania

    Converting a text string

    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
  16. infomania

    Converting a text string

    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...
  17. infomania

    Table level Security

    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?
  18. infomania

    Table level Security

    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
  19. infomania

    Invalid Date Value from Form Data

    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...
  20. infomania

    Invalid Date Value from Form Data

    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#)?

Part and Inventory Search

Back
Top