Recent content by Peter2222

Hi, I have a Library database (access), and one database (access) that I have set up a reference to this library database. I refered to it using tools > reference > browse etc. this worked fine. Then instead I tried doing it programmatically like this dim ref as reference set ref =...

Try using the table that the form is bound to, and change the data using the table instead when you close the form. perhaps using ADO?

Thanks for the reply, but why if it's just a recordset are we ever asked to save any changes?

split it up! just a quick response for people not happy with large hauls! database splitter!

re thanks for the help, I tried that and that helps. Also, I tried leaving the form as it is and I specified that the Order by property of the form to be [JobNumber] (- each record has a job number). this sorted out the problem for what ever ordering I have on the table. I really don't...

Re Hi, Thanks for the tip, so does it set the order in which the subtable is ordered in? Thanks Peter

Ado here's an example of opening another table and adding a record: this bit of code opens the connection and recordset to the target table where DBFullName is the full name string of the db and TableName is a string for the table name. [Id] is the Id in target table, and Id is the Id in the...

Hi, looks like you're problem is sorted, I was going to suggest using ADO instead of DAO simply because it's newer. If interested I'll send an example of the code that I would use...

Hello, I've sorted out a problem that I had with a Form that had a subtable on it, by setting on the properties of the form for the 'Order by' criteria to equal the Id number of the form. eg: if each record has an Idnumber I have put [Idnumber] as the Order by property. I have no idea what...

A bit of progress Hey there, I've been having a wrestle over that form, I went to the properties of the form, and have set the 'Order by' criteria to the Id of the form, this has got rid of the problem. Is this sensible practice though? Hopefully hear back from anyone Thanks Peter

count Hi, I might of lost the plot but, whenever I've writtern reports, I've done this... if i want to count the number of "Items" on the report, I'd put a text box on the report and write: count([Items]) where Items is then name of the field...

Here's the code. Hi there, thanks for the reply, I close the form by clicking the close button. I added an event to the form that calls this sub when closing: Private Sub MoveDataToWorkLog() Dim curTotal As Currency Dim strTotal As String Dim ThisJobNumber As Long Dim frm1 As Form Dim ctl1...

:confused: Hi, I've put a button on a form (lets say form 1), that when clicked opens up form 2. Both forms are connected to ONE table each. There is a sub table on form 2 that displays records with the same Id as on form 2. The Problem is when I open The table that feeds the subtable. If I...

Hi, I've put a button on a form (lets say form 1), that when clicked opens up form 2. Both forms are connected to ONE table each. There is a sub table on form 2 that displays records with the same Id as on form 2. The Problem is when I open The table that feeds the subtable. If I change the...