Search results

It's funny how some people give you what you ask for and some people give you what they think you need, isn't it? Dave E

As far as I can see it's just a tag you can attach to any form or control as a customised label. It has no affect on any of the properties of the control or form, but can be used to identify the form or control in a piece code.... That's how I read it, anyhow... Dave E

What if? You load the field with the value as text (which it must be if it can hold letters as well as numbers) from the scanner A hidden field on the form (Textbox2) has a Controlsource of - =Right$(Textbox1,Len(Textbox1)-1) This will strip the first character off the string, so that -...

Yes you can... If you have a result field whose source is a table field. So if you had say, Field 1 = UnitCost and Field2 = Tax then have as the AFTERUPDATE code on Field2 - Total=UnitCost*Tax where Total is the Table Field3 That should do it.... Dave E

Hi again, What about a different tack? Have 7 unbound tickboxes called 'Mon' thru 'Sat' and 'All' These would be displayed in a row on the form and each one labelled according to the day it represents. The user ticks the day(s) of the course and then on saving, usually when the form is...

Who is this Dale, Pot? Dave Eyley:D

And if that doesn't confuse you, oh foolishone, then nothing will. :D Dave Eyley

I'm having a problem understanding your problem... The table you show indicates that there are 4 different categories: 0 Everyday 2-6 Mon-Fri 8 Mon/Wed/Fri 9 Tue/Thu But you want the form to show the value for each day? But Mon/Wed/Fri has a value - 8, while having a value of...

I thought about this one... You've probably got a table in the db which will hold the data for this operation - I'll call it - 'Stats' The form I'll call 'StatForm' The field for Push-ups qnty I'll Call 'PushQ' The field for Push-up score I'll Call 'PushScore' So, on the form we create the...

The way I do this is - Open a new form in design mode. Get the form properties sorted in the way you need them, i.e. RecordSelectors NavigationBar Menus Toolbars Headers&Footers (these are the trickiest because they be moved) ScrollBars Click on the rectangle drawing icon and draw a...

I don't know why. I am still a bit worried about the workings of your forms. If you continue on this route, you will eventually disappear up your own Query :-) Is there another way you could do this? Perhaps by adding a 3rd form rather than returning to the 1st form. You could take the...

A field on form2 should be able to send its value to form1 without any problem, it should be like - Forms!Form1!Field1=Forms!Form2!FieldX It is important, however, how the code is executed. If it is in an AFTERUPDATE property on the FieldX form, and FieldX gets filled in by a query, then the...

Try opening the query behind the combo, clicking on the empty space above the grid and then open the query properties. Here you will see a list of properties, 2 of which are - Unique Values and, Unique Records Click on the Unique Values and the problem of a long duplicate list is gone. Dave...

Can't you use the subform but in continuous form mode and lay it out to look like a spreadsheet? Might need the header and footer for various totals etc... Dave Eyley

So the combo gets a value in it and then runs the code which does the record selection? 1. Why a combo? Why not just a textfield? 2. What runs the code? AFTERUPDATE? ONGOTFOCUS? 3. Are the records on Form 1 in a subform? or is the combo in the header and the fields in the details section...

OK, (I think) It's a bit complex.... Can you explain the use of the combo, since if you take one value back to Form 1 and put it in a combo, what's the combo used for if it's only got one value in it? I'm English, remember, you've got to lead me along gently... Dave Eyley

Right... Let's check we're on the same wavelength here... You've got Form1 populated with an underlying table/query. One of these fields is a combo that when selected is used to open another Form (Form2) with data that is related to the combo field on Form1. When you select an option fron...

I'm a little lost here.... DoCmd.OpenForm "frmMain", acNormal, , "[cbo123] = " & Forms!frmkeywordsearch![lstSystem] looks OK... The underscore you've used after the = sign is just to let me know there's a space there, right? There must be something wrong, but I can't see it. Could you post...

While I was away thinking about this one, an answer arrived. But I could still give you mine anyway... Create a Mainform with one field on it called 'SONo' Create a subform and populate it with all the fields from the table including 'SONo'. Drag the subform onto the mainform and use the...

How about - On the AFTERUPDATE property on the UNITCOST field on the subform, put the following bit of code - If Not IsNull(Forms!MainForm!Combo) Then UnitCost =UnitCost*Forms!MainForm!Combo End If The If...just checks to see that the conversion has been selected before proceeding. If it...