Search results

For my DB - looking at attaching both PDF and JPEG to each record. What is the best method for this - and to keep it easy for the user. I've read up on Hyperlinks but this mean right clicking, edit hyperlinks etc etc. I want to the user to 1. Click on a cmd button that will browse and...

Ah ok - i just tried it on a cmd button

I tried this but got the following message

Thanks I have a dead simple DB The form in question is read from one table. When the user enters this form - i need to to be READ ONLY. I then need an 'EDIT' cmd button that will allow the users to make changes.

Thanks I'm going with point 2 and it works fine. However i need a command button that would then make the form EDITABLE. I've been trying this (on the cmdbutton) but it wont work Me.Form.RecordsetType = Dynaset Any idea's?

Hi I have currently have Private Sub Form_Load() Me.Form.AllowEdits = False End Sub But this locks the whole form including my Search Box, and doesn't let me type anything in here How can i exclude the Search Box? thanks

Like the standard one at the bottom of a form - Record 1 of 520 etc How can this be shown somewhere else within a form?

Thanks I think you misunderstood my 9 'Period' Fields They are not the same but relate to each Period (month) of the year. So Period1 would be August, Period2 Sep etc.

I have 2 tables tblStudents tblFees tblStudents has all the info on the students and the StudentID is the PK tblFees is empty. Field1 is StudentID, Fields2 to 10 are the 'Periods' The idea is to enter amounts in here once they have paid. I'm trying to build a query that will take the...

What i have done so far is created a table that consists of StudentID ClassID Period1 Period2 ... .. ... Period12 This will allow me to enter the fees for each student for each period. I don't think this is that good TBH. What will happen in year 2? How will 'the user' create a new table for...

I need to pick your brains about having a 'Payment' Table/Form I'm creating a DB for a small Sunday school. The DB is dead basic - it captures all the basic, emergency, class, parent details etc. I have now been asked to to add an addition to this DB. They need to record the FEES paid (which...

brilliant this worked. Thanks for your help everyone.

Hi - i'm still struggling with this? Anyone please help me??

Thanks dapfeifer You've been a great help. I've got most of it to work - just need to work out how to make it 'uneditable' again Thanks again

But i'm not actually entering anything into this textbox. This is a subform that's coming through from somewhere else - ie the data is already populated. I tried the 'after update' and it didn't work - nothing happening, presumably as the textbox is not getting touched? Advice?

Thanks Where do i put these codes? (I'm a bit of a novice) Cheers

Hello again I need something like this. If the content of TextBox1 is "Yes", then i need the user to be able to view TextBox2. If the content of TextBox1 is "No", then i need the TextBox2 to be greyed out. Is this easily done?

THanks folks. These properties changes you've mentioned - where is that done then? I'm a novice and generally use the 'wizard' for everything.

Hi again I have a form with say contact details. When the users opens this form - it needs to be in VIEW mode only. I then need a button that will switch all fields to EDIT mode Is this at all possible? and if so how?

Thanks that makes perfect sense and it worked too