Search results

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...

:rolleyes: I am having a mental blank. I have a main form (parents and their grant applications) and a subform (children). The information for each is stored in three seperate tables. The parents and children are linked in the relationships via ParentID (one to many). The parents are...

Still struggling with this one and we really need to start using it, we dont want to have to retype all the applicants names etc when they applied last year. Why should the information not be stored in two seperate tables? How should it be done? Any suggestions would be welcome

I have search the forum but dont seem to be able to find the solution i am looking for. I am hoping its because it has a simple solution ....... I have a database which records grant applications for the current year. What i also have is a table which stores all the grant applications from...

What I have is a report which is grouped on Requested School, giving one page for each school. The report details pupils and what school year they are in. What I am trying to do is count how many pupils, for each individual school, are in each class year. The code I have used is below, it...

I have searched the forum for a couple of days and dont seem to be able to find the solution to my problem. Sorry if I have missed it. Anyway... On my form I have an option group for Accepting or Rejecting a request. The two options are saved as 1 and 2 in the table. I know that I can use...