Search results for query: *

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

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

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

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

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

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

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 am trying to filter a query using a date value from a form. I keep getting an error: "The expression you entered has an invalid date value." and points to the WHERE criteria: #[Forms]![fmReportSelection]![fmReportSelectionSubform].[Form]![txFlag3]# The unbound form field (txFlag3) has a...

I have an unbound form which is used to insert row data into a table. Several fields are optional. I am using the NZ(StrField, "") function to insert a blank in the text fields. For number fields, which are mostly FK indexes, that are optional, I would like to have a Null in the field, not a...

I have a series of chart reports that need to be filtered by 1 or more field criteria. The initial query that produced a nice line chart (#Trucks arriving at hour intervals) for ALL data is: SELECT qryMillArrivalTime.HOUR , Sum(qryMillArrivalTime.CountOfTRACKING_DATA_ID) AS NBR_TRUCKS FROM...

I am using Access 2003 (as Access 2000) to develop a crosstab report that should look lile the following: DIAMETERS WIDTH 127 135 137 147 205 25 215 15 5 12 300 1 3 14...

I have a text file I am parsing into an Access table. One of the fields has values like 0000029688 and should be resolved as a number: 29688. The number of zeros is variable but the string length is always 10. Is there a simple (or complex) function I can use? Thanks

I want to capture the identity of the currently logged on user for an Access app that does not have security enabled. In this state, CurrentUser() returns 'Admin' as the user. Is there a VB script I can use to get the windows logon identitty? Thanks.

Using Access 2002, I created a small database on my laptop by importing the design and data from a Access 2000 application that was a design master (I created). I then created a replica and placed it on the network server and retained the local copy as the Design Master. (The new db is in Access...

I am using the Photo Gallery on one of my pages. It works great when viewed with IE but in Netscape the result is a string of thumbnails (all of them) across the top, some of which are tiny (REALLY small). My page formatting is screwed up as well. Is there any way to alter the code to solve...

I have a report where I want to list the details for the Top 80% (by sales) of items, a summary line for the next 10% and again for the next 10%. Briefly, the SQL looks like this (to return all records): SELECT item , descr1 , count(distinct ordNbr) as orders , sum(sales) as sales FROM...

I am creating an application for barcode scanning and I need to increment the box count when a new box is started (we might pack 10 items per box). I have an unbound form in which the user enters the order number to get started. A subform (linked by [ORDER_NBR]) is bound to a data table. The...

I have a data set that looks like this: ITEM QTY BoxNbr ABC 6 1 ABC 6 1 ABC 6 1 ABC 6 2 ABC 6 2 ABC 6 2 The query result I want is: ITEM Sum-Qty Boxes ABC 36 2 I want to count(distinct BoxNbr) (as in SQL). How can...