Search results

Just the job! Many thanks - much simpler than i thought it would be :rolleyes: El.

Hi all, I have a db for logging meeting action points. Each action point has a description and owner. I'd like a query/report which will produce a list of action points grouped by owner (easy), but with a particular owner's action points at the top. Essentially, rather than do a GroupBy and...

To illustrate this problem, i've attached someone else's example db for sorting which i took off another thread. I wanted to check if my db was corrupt or something. Anyway, all the fields in the Employee table were text, but i changed one (Full Name) to memo, and sure enough, this db now has...

Hi all, Found a weird problem when editing records in continuous form view (and datasheet view) when a particular memo field is being used by OrderBy to sort the data. When i have just created a new record and tab to the next record, the record i was just in jumps to the top of the records, but...

fixed! heh, fixed it. Seems that there's a little redraw bug here. All three labels were inside boxes with transparent fill. The only difference between these three and the other labels on the form was that i'd put these on AFTER i drew the boxes. Therefore they were 'in front' of the...

Hi all, title says it all! I've got a form with numerous controls and labels. When i first open the form, all looks fine - all labels are Black Arial 8 Bold. But when i start scrolling through the records, the text on three of my text labels gets bolder. I haven't a clue what is causing this -...

I'm trying to use Format and FormatNumber, and getting the same problem. Why does this happen? I'm getting a 'data mismatch' when trying to use a numerical criteria on a query field that uses FormatNumber to change the number of decimal places displayed. FormatNumber is converting the field to...

That seems to work, but only when you move away from the field. Looks like the record is saved when i leave the field, rather than when i've changed record. Thing is i was using On Change because i wanted the requery to happen whilst i'm still in the field (a live update), but because the...

Hi all, I've got a subform, fed by a query which contains a lot of calculated fields. All the calculations use the contents of a field on the main form. What i want to do is have a live update, so that if i change the value of the field on the main form, the subform is requeried and the fields...

ok .. but what about the joins in the query? I need two joins really (Principal and Site from one table to another), and i can't set any primary keys on it because none of the columns contain unique values. Pete

Hi all, Been pulling my hair out about this for a while, so i hope someone's feeling kind: I'm using the BHRefPrefix to build part of a reference number. The Principal and Site exist on a separate form, and i need to use both as criteria in order for the correct BHRefPrefix to be returned...

Nope - Option Compare Database ah - just read the helpfile. Thanks for the pointer! El.

Hi all, got a weird one here: I've got a popup form whose contents are updated as the records are changed on another form (through Form_Current). This is working ok, but i'm trying to use a public variable so that the main form knows not to invoke a requery on the popup form if it isn't open...

weird - that seems too simple to work, but it does. THANKS! El.

Hi, i'm trying something similar - using the contents of a combo box as a critera in the query which feeds the form. I'm trying to implement an 'all' option in the combo box, which will be used put a like "*" in the criteria, thus displaying all records. The code i'm using in the criteria area...

Well you learn something new everyday! TWIPS indeed :rolleyes: for anyone fascinated by this subject, i found further info on TWIPS here: http://www.applecore99.com/api/api012.asp El.

Hi all, I'm currently coding a form field to change height depending on a variable. I've noticed that while viewing an object's properties in design mode, the height is displayed in cm, but when you code it in vb you have to give the value in pixels. Is there a way of changing the default...

Ok, looks like i solved this one. Seems that even when Form_Load() has happened, Access doesn't know how many records there are until you do something (like update or change a record), which is why i was getting '1' all the time. If you force a Me.RecordsetClone.MoveLast then Access will know...

Hi Mile, thanks for the quick reply. i've already tried this in Form_Current() and it does exactly the same. It returns the number 1, when there are actually 4 records. I have the same code running on a button which moves to the next record and it works fine there. So it's working when you...

Hi all, I'm using a variable called recordstotal to hold the total number of records on a form. I only need to initialise it once, on form load and i'm using the following code: Dim recordstotal As Integer Private Sub Form_Load() recordstotal = Me.RecordsetClone.RecordCount...