Search results

I've got it working, thank you.

I'm sorry if this is being cheeky, but I have another thread on here which involves a Dlookup for a calculation do you think you could take a look and see if you can see why that one doesn't work please. http://www.access-programmers.co.uk/forums/showthread.php?t=242018

Thank you for your reply, however I have fixed it. I had saved the Income Subejctive box as being unbound. It's fixed and working now.

Hi, I have a form that has been created from a table. One of the boxes in the form is the IncomeSubjective, which I have used a Dloopup within the On Current event to get the correct Income Subjective, which it is doing, as I can see the subjective in the box. However when I go to save...

I have tried changing it but it still doesn't work.

Hi, I am trying put a default value into a form (note this may be changed by the user at a later date) the default value is the value from the commitment (which is another form) divided by 2. Below is what I have used in the VBA, but it just isn't working, I keep getting Run-time error '13'...

Hi, it's 2003.

Hi, Thanks for your response. Unforntuately I can't get the attached database to open. I also don't understand what to do here sorry. I've managed to pick up most things I've asked about tbut this one has confused me I'm afraid. Also as an update, there would now only ever be one...

Hi, I hope this is the correct Forum! I have a Commitment Form and one of the combo boxes the user is to fill in is ExpSubjective. There is a button on this form which then opens the Income Form, (currently it pulls the commitment ID over which is fine) and the user has to select the...

Thank you so much. My form works again...thank god.

Hi, I have used the dynamic search forms to do all my searches. They were working absolutely fine, however in a couple of my tables, I have deleted the autonumber primary Key and made one of the other fields the primary key (as the other fields were unique anyway). I have fed all the...

I found the code nedded to hide them, so have hidden them all after opening the new forms. My problem, is I'm never sure where the bit code should go.

Hi, I too have used this search function in my database, and it works perfectly. My question though, isa when I then select one of the records and my new form opens, how do close the search form, without actualy physically closing it? Thanks.

Hi, Appologies agian if this has been listed before. I have a form Client Commitments by Cost Centre, this is a form with the csot centre details on it and a sub form with the clients who have commitmetns against that csot centre (these commitments are summed to give a total by client)...

Hi, I appologise if this type of question has been asked previously, I have searched but nothing seems to answer my exact question, and as I'm rather new to this, never quite sure on what I acutal want/need to search on!! I have two tables, Commitments and IncomeCommitment, both these tables...

Hi, ~I am looking for some advice on the best way to create my form. I have a client form, with a commitment subform, the subform is a continuious form, so within the client the user can scroll down to see all the commitments for that person. However, within each commitment there will be at...

Hi, Looking for help again! I have a form, which has two combo boxes (amongst others) they are provider and provider rates. These come from two tables, that are linked by ProviderID which is one(tblprovider) to many (tblproviderrates). If the rate I am looking for doesn't exist I want to...

Hi, After reading your reply, I realised I had entered my form the wrong way, as if I use a client search first then it filters the form to one client. thank for you reply.

Hi Appologies if this is already on here, I have searched but can't find what i am looking for. I have a form with client information on it (based on a table). This has a subform with commitment information on it (based on a query). On the subform I can add a new commitment, or double click to...

Hi again, I've managed to get everything working for now.