Search results for query: *

I am trying to get a table appearance to a report... I have the lines across but am having difficulty with the uprights. I have a row of text boxes on the detail section of a report that are set to Can Grow = Yes. I want to separate each text box with a line which is the same height as the...

Gavinjb, did you find a solution to this cos I'm having the same problem? Query is fine but returns EOF when in VBA. Dim cnn As ADODB.Connection Dim rst As ADODB.Recordset Dim varRecords As Variant Dim stSQL As String Set cnn = CurrentProject.Connection Set rst = New ADODB.Recordset...

Please forget that I ever posted this. Using a check box instead of a text box in the subform works every time! It's been a hard day, OK? Softop.

Sorry, forgot to mention that the query result is to display on a subform.

Options for displaying boolean values in a query are True/False, Yes/No, and On/Off. Does anyone know of a way of displaying a tick box instead? Softop

There may be another way to do this but this is how I would tackle it... With each button set up a OpenArgs value to pass through to the subform. Private Sub Command1_Click() Dim stOpenArgs as String Dim stDocName as String Dim stLinkCriteria as String stOpenArgs = "0" 'for...

Thanks for your reply too cjowsey. From the list you supplied I need the nearest rate in the past. Softop.

Thanks nicsin for this but my problem is a little more complex. Problem definition... In Table1 are a list of rates. Only one rate can be in effect at a given time. On examination of the table a rate of 2.5 is to be used from 01/22/2004 until the next rate kicks in on 02/27/2004. This means...

Here are tables with US date format... Table1-Rates EffDate   Rate 01/22/2004 2.5 02/27/2004 2.3 03/15/2004 2.1 03/29/2004 2.8 Table2-Tasks TaskRef TaskDate A001 01/24/2004 A002 01/31/2004 B003 02/27/2004 A015 03/02/2004 C005 03/16/2004 A014 03/19/2004 A003 03/31/2004 B001 04/14/2004 Softop

I have two tables as shown below. They are not joined. I wish to create a Query that will select the correct rate from Table 1 at the appropriate date in Table 2. Can anyone help please (supply the SQL for the query)? Table1-Rates EffDate Rate 22/01/2004 2.5 27/02/2004 2.3...

Don't worry - solved it myself! If Me.txtVerse = "C" Then Me.txtLine.FontItalic = True Else Me.txtLine.FontItalic = False End If Thanks for looking anyway!

I need to format a textbox on a report to italics depending on the result of another field. i.e. If Me.txtVerse = "C" Then Me.txtLine 'format to italics ??????? Else Me.txtLine 'format to normal ??????? End If Any idea how to do this?

Thanks guys... easy isn't it?

In order to view a report I need to attach my Laptop to a printer (or network with a printer) and switch the printer on. Is this really necessary? I can't do my work on the road if this is the case. How can I overcome this problem?

When you right-click on a form and select Tab Order there is a box to change the order of the tabs using drag and drop. I want to do the same thing with a small set of database records. Please can anyone tell me where to find the control (as shown in the Tab Order form) that will allow me to...

With the formatting available in a report you can have multiple records of varying length, coupled with the Can Grow/Can Shrink features to display perfectly. Can this be emulated in a window on a form by embedding the report into the form with scroll bars? If so how is it done?

Works a treat! 'Me' comments also noted. Thanks, Bill.

Due to a change in versions of Access by Users I am converting existing code from Data Access Objects (DAO) to conform to ActiveX Data Objects (ADO). All is working well except one thing which is twisting my brain. I want to export all tables, a form, a macro and a module to a new database...