Recent content by jax

The main table is actually a linked to another database which is used for recording the same clients but for a different, seperate reason. I am not sure how large a table would have to get before it affects the performance. At this point we are unsure how many grant applications we will...

The main table is actually a linked to another database which is used for recording the same clients but for a different, seperate reason. I am not sure how large a table would have to get before it affects the performance. At this point we are unsure how many grant applications we will...

The main table is actually a linked to another database which is used for recording the same clients but for a different, seperate reason. I am not sure how large a table would have to get before it affects the performance. At this point we are unsure how many grant applications we will...

I have never liked using tabs but this might be a time when they will be the best solution. I will give it a try and let you know how i get on. Thanks again

Hi Ken, Thanks for replying. I have looked at making each grant application a subform but it will make the Client form very untidy. In answer to your question - each grant application requires very different information - so its not really possible to have one table for all the grants.

I have searched the forum but seem to be missing something. I have a client table and several grant tables for different grants that each client can apply for. The tables are linked one to many. What i have is a Clients main form showing Refnum, Name, Address etc. What I want to do is have...

Yes its a numeric field Thank you very much - that works - Thats a real high on which to finish work on a sunny friday afternoon Thank again

I have tried Set conDatabase = CurrentProject.Connection and Set conDatabase = CurrentDb.Connection and Set conDatabase = Application.CurrentDb.Connection I admit I am just guessing and learning as I go along with the help of this Forum, so dont really know what I am doing sorry

"Runtime error Data type mismatch in criteria expression"

Hi KeithG, thanks for that, I have added .edit and .moveNext but I am still getting errors I think i might have a problem with this line of code Set conDatabase = CurrentProject.Connection which is causing it to error here rsttblChildren_Details.Open strSQL, conDatabase, adOpenDynamic...

I am trying to change all the entrys in a table that contain 0's to 1's when a user clicks a check box on a form. I am using the code below but it keeps erroring can anyone help? Table is called tblChildren_Details and the Form is called frmBatch Private Sub Check12_Click() Dim...

I am trying to do something similar to this. Can someone help me with some of the vba code that JDEANS has copied above..... set conDatabase = CurrentProject.Connection what is the code looking at? Is (conDatabase) the name of JDEANS database?? I just cant get this bit right. Thanks

I have solved a bit of this problem. I have used an unbound box on the form to show the maximum figure in the batch field (DMax) in the table, and then on on_click of the check box i just get it to add one to the maximum number. My problem now is updating all the records. I can only get my...

I have a database which contains information about grant claimants. Grant applications come in all year round. I want the dbase users to be able to click a button which will generate a number for all those claimants who havent received their payment yet (ie put them into batches). I have a...

I have a pop-up activex calender which works perfectly. My problem is that when it opens, half the calender is hidden behind my subform. Can anyone tell me how I can get the calender to open at the front. There is no format option on the calender and I am not sure what the vb code should be...