Search results
-
C
Random query question
I have sort of worked it out now.... What I did was create a seperate query that orders the record set by: ORDER BY Rnd(primarykey), and selects only the 1st record: SELECT TOP 1. Then in the form module I did this: Dim intRndNum As Integer Dim rsRndRecord As Object Set... -
C
Random query question
Hi there, What is the best way around generating a query to generate the contents of a table listed by id in random order? Using the Int((n * Rnd) + 1) example will not be accurate if an autonumber id row has been previously deleted. As the number generated may point to a autonumid that doesn't... -
C
Store a variable in a text field from another column
Hi there, Is it possible to store a field from one attribute in a table and refer to it in the same table within a different attribute? I may be getting myself confused or there may be a more logical way to approaching this but I will explain what I am trying to do: For arguments sake I am... -
C
Dynamic sizing text fields in reports
Legend! Thanks for that. It seems so simple now -
C
Dynamic sizing text fields in reports
Hi there, Is there a way of making the text field in a report automatically resize (in terms of row height) when a report is run? My report has a 'comments' field, and the comments text box on the report is say 8cm long by 2cm high but some comments for certain report rows are larger than the...