Search results for query: *

hi i create an image with text in it and then i save it as a png and when i try to use it in a web page the quality of the text is very poor, not sharp. I have tried creating the image the same size as the final button and also larger, then scale it down beofre saving it as a png but there is...

Hi, I am typing directly into a table field (memo format) I want to include (and appear with) line breaks ie Text appears in this type of format NOT LIKE THIS: Text appears in this type of format any ideas on how I achieve the paragraph like format?

Hello All, I have a union query based on two crosstab queries. I have formated both xtabs' fields The Value and Total as Standard with 0 decimal places. However in the union all the decimals come back. How do I set the formating in the union to 0 decimals (Please note the number and titles of...

Hi all, stupid question... I've searched high and low, a few times to avoid accusations of a "man-look"... but how to I id what query/table/sql is providing data to a pivot table on a form?! Thanks in advance.

Hi all, Is using this code enough to clear a collection (the same rst.close and set rst = nothing)? set cln1 = nothing Why I ask: I have stripped out a load of temptables and replaced them with custom collections. Complicated SQL's were used to populate combo boxes and list boxes. Now user...

Hi, as I'm debugging in Access97, when I step into the code whenever I come to a line docmd.gotocontrol xyz the message command not available appears and I have to end the code. Is there a way to step over this line or do something so I don't loose the flow of stepping through?

Hi all I am using this code (see below under valuelist:) to create a string to create a ValueList to fill the rowsource of a combobox. It works fine, except if the number of characters exceeds 2048. To avoid the 2048 problem I thought I'd try filling the combobox using a userdefined function...

Hi all I have a query which uses a function to create a criteria. If I only select one item from my listbox then the query works OK applying the criteria returned by the function crit. However when I select more than one, the query returns nothing. When I print crit in the dubug window it...

Hello all, How do I test that a multidimensional array has nothing in it? This is my code and process: A form is opened. The following is declared at the form module level. Private marr1() as variant Private mintrows as integer The form on open event includes: mintrows = -1 The user selects...

Hello All I would like to code this principle, is it possible? (I know how to do everything except delete a row from an array based on a criteria) I would like to have a multidimensional array with field1 and field2. Say it is populated: field1 field2 Joe bloggs John smith An...

Hi all, I currently have a DBase with several tables that are cross referenced with a series of autonumber IDs. It is more complex than this but to illustrate the principle: tblCustomer has an CustID field and a CustName field. tblOrders has an OrderID field and a OrderName field. My user...

Hi all Is it always better to use variables to hold temporary data rather then putting the value in an unbound text field. I am thinking of three scenerios: 1. Creating records 2. As items which determine process eg which form to open next 3. As a criteria for a query (using a function in the...

If I have a variable set as Private strName as String in the declarations section of form1 and I have another Private strName as String declaration in form2 will that cause any problems? I want the same name because they represent the same piece of data type, but I want the instance ie Jack or...

Hi all, I have form1 which opens form2. On form2 are two subforms. subform1 has an on current event: dim strCond as string strCond = "ID = forms!form2!sub1.form!ID" forms!form2!sub2.form.filteron = true forms!form2!sub2.form.filter = strCond When I have the recordsource of sub1 including a...

Hi all, I have tried the following syntax in a query to filter it based on a column of a combo box, but it doesn't like it, the query won't open. This works when placed in the criteria row of the query: forms!frm1!control1 This doesn't: forms!frm1!control1.column(1) Is my syntax off, or is...

Hi all, when in design view of a form which has a tab control with style set to none, how do I access see, move between each page?

Hello all, I am trying to cut down on queries by incorporating some subqueries into their parents. In this case Query2 was originally set-up to find unmatched records from Query1. The code below doesn't exclude the records from Query1. Originally I thought I would use the NOT IN clause, but I...

Hi All I have a user-defined function (fnclistbox) filling a listbox. I want it to populate all the rows and all fields from a recordset. I can get all the rows but how do i get all the fields? Presumably it is something to do with the line "fnclistbox = rst!Engine" in the code below. I have...

Hi all, I get error 3021 no current record when I open a form which has listbox whose row source property is refering to to a user defined function which moves through the records in a query to populate the list box. There is nothing in the listbox row source. The function is a private...

Hi all, For an access97 dbase, I am trying to replace the temporary tables with multidimentional arrays. I can create an array OK, but how do I replace the temporary table (tbl2) in this SQL with the array? Set rst = CurrentDb.OpenRecordset("SELECT DISTINCTROW tbl1.Fld1, tbl2.fld2 FROM (tbl2...