Search results

hmmm, simpler than I was making it. After some trial and error my extremely simple solution was: In the tab control properties 'On Change' event Me.txtRisk = Me.Risk2.value That just copies the value form my unbound text box into the input text box of teh field risk, bound to the table...

I have read a few posts about this but none have really told me how to achieve what I want. I have form with lots of information based on a master table. One on tab control I have setup a number of unbound text boxes with IIf expressions, these return values. These values are summed and another...

dK, you are spot on. So, following your guidance here is where I'm at: I actually did have 'tblHazard' as you describe, but I had not added 'Hazard_ID' to my 'tblProfile'. I added this as a number field, but not a lookup. Previously I was linking the primary key of this with the...

I tried to search but this wasn't the easiest to fit into a few short search terms. I have a 'Profile' form with a tab control in which a user can select a 'hazard' from a combo list or press a button to add a new one (takes them to a control panel). This I can do. That goes into a table. That...

Once again, thanks for your help guys. I'm off to post about my next problem now...

Hi, How do convert a combo box field to a text box on a form but remain showing the text value and not the numerical value? I want my form to display two fields from combo boxes as a text box and then lock it so there is no way the user can change it and they can see that it is a fixed value...

Thanks, but when I enter =Dir(CurrentDb.Name) into my 'control source' option fo rthe text box it automatically does this =Dir([CurrentDb].[Name]) and only shows #Name as the result. What am I doing wrong?

Me again. Can somebody tell me the command for inserting the current DB filename into a text box please. I can't find it anywhere. Thanks

Thanks Bob. I have also just realised how stupid I actually was. Just found the 'long date' format option as well, I obviosuly was looking with eyes closed. I think I need more coffee or maybe work on something else for a while.

Hi, This shodul be a quick, easy one for somebody. Despite my search efforts I can't find how to convert my date format to long format in my text box. I have a text box in which the control source =Date() This works and displays the date, but I want a different format e.g. 1 January 2009...

Job done. Another minor step forward. Thanks for your help.

Hi, I have a form with one subform. I can hide and siaply the subform using this code in my AfterUpdate event of the checkbox, that works: Private Sub chkRestrictionApplied_AfterUpdate() If Me.chkRestrictionApplied Then Me.tblRestrictions_Subform.Enabled = True Else...

Thanks Pat. After some more searching (my first search was poor) I found people reporting the same problem. It appears you have click the specific tab and double check that that specific tab control is highlighted then paste into it. If you don't and you cut and past by selecting teh centre...

Hi, I'm using A2007. I have a number of forms which use tab control for easier navigation. I have spent a consdierable amount of time sorting formatting and appearance and am now making some major changes to database structure. I am trying to add a nested subform to a tab on an existing...

Thanks you all for your replies, I'll think about these options and see what fits best. There wouldn't be any more than five per employee, generally there's none, but I need the ability to add a few at least. I would run a report and/or filter on the restriction category, but there's not...

Hello, I have a form based on a query. This form has a tab called 'Restrictions'. On this tab I can select a type of restriction from a combo. Under this I have a box for free text so the user can add notes relevant to this restriction. I have just realised that the user may want to add...

You need to set up a form with unbound boxes - combo, text, check etc and a search button. In the 'on-click' event of the search button you need to assign the code. You will also need a blank query set up with the source table for your info that you are interrogating. I lump everything I...

I use this for check boxes on my QBFs: If [chkBA] = -1 Then where = where & " AND [BreathingApp]= " & "True" End If [chkBA] is the name of my check box on the form and [BreathingApp] is the name of the corresponding field. Substitute for your names.

I am trying to get some of my colleagues to open a database I have created. They keep getting an error message on some of my forms: "The expression after update you entered as the event property setting produced the following error – can’t find project or library Expression may not result in...

Thank you, that's exactly what I need. Much appreciated, it was getting quite annoying.