Search results

Thanks for reply Spike. I take your point. So I am going to need 2 tables to store the potentially 500 pieces of information from each user; say 250 fields per table (with max fields allowed 255). I was a bit wary of having so many fields in a table and wondered whether there was a simpler way...

I have to ask the user up to 50 questions each of which requires me to record 10 pieces of information I may have 500 users. Anyone got an idea which is the best way to approach this? As far as I've got is A) Split tables with large field numbers for all users B) Table for each user To me, the...

Thanks Pat - got that now!! Best wishes, Roger ....

I have discovered my problem, I have to save the form before the table is updated. Then the values of the option boxes appear in the table. VBA is great but takes some getting around.

Hi pr2, Thanks for your comment so fast. Trying to put the value (1 or 2) from the option clicked, into the table field Response1 without coding it in (because I hope to have a lot of these on the form

Driving me crazy! VERY basic question from a new user. I create a Table1 One field is response1 set to NUMBER New blank form then created I create a yes/no option group in a frame using Controls Wizard returning 1 & 2 and set the Control source to =[Table1]![response1] This does not put...

Gemma the Husky; Putting the criteria in sorted out the problem but thanks for your interest... Roger

Thank you crxftw - that did it!! (And thanks for that speedy response) Roger ..

Hi All, I am trying to obtain a field value from my Access table LVFPath = DLookup("BusinessName", "Table 1") This works but LVFPath = DLookup("LVFTemplate", "Table 1") DOESN'T !! They are both fields in the same Database Table, Table 1 Variables declared and field names are spelt exactly...

Thanks Spike - VERY FAST responses! (What are you on and can I have some?!!!) There are multiple tabs and I can only resize the height to the limit of the longest tab. So now I'll shorten the longest to my desired height. Thank you very much for your help. Best wishes, Roger UK

Sorry Spike I may have posted incorrectly. It is the tab control on the form that I cannot adjust the height. The arrow move doesn't shorten and if I put a new height into the tab control property box then it reverts to it's previous value. But thanks for your speedy response... Roger ..

Hi All, I have create a form with tabs and have added controls etc. Now I want to make the tabs non scrollable by shortening the length of the form. I highlight the form in design mode but it will not allow me to drag the form size up from the bottom. If I make a test form with a tab then I...

Mr. B - Thank you very much - just what I needed......

Hi All, Wrong header description sorry! In my old Access a new blank form creation allowed me, in design view, to size the actual form the user sees. Not apparently not so in 2007 to 2010. Am I missing something? Grateful for any ideas.... Roger ..

Thanks Sean, Works - Made a good start to my day!! - Roger ....

Hello All, I have a pdf template that I wish to copy and identify as being associated with the ID of the record in my Access Table. Attempt below:- Private Sub Command36_Click() Dim PDFTemplate As String Dim recordID As String Dim newPDF As String recordID = Me.CurrentRecord PDFTemplate =...

Hi Everyone - Pretty clueless although have done some VB programming 15 years ago and starting again (that or going to live somewhere warm!) I expect my questions will need to be put into the beginners area! Never mind - Some advantages in being retired - Time...... Roger ....