Search results

IMO, Thanks for that, I'll have a look when I get a chance. Rich, I guessed that was the case. What I do is to set the startup options and define the application title etc here, and then for captions on forms / reports I'll set them at design time or at run-time using VBA....well that's the...

Hi IMO Well I've trying to play around with some reports by setting the pop up, border style properties etc but I can't get it to display just the report and no title bar. You say that you achieved this with your forms, can I ask how you did this? As far as the Control Box menu is concerned...

Ah.... I just want to make sure you do mean the little menu the allows the user to 'Move' ,'Restore, 'Size' etc...? What version of Access are you using as I'm using XP and its possible that the Control Box property isn't available in design view in previous versions of Access.

On the 'Format' tab of your reports properties, set the control box field to no.

No probs, glad I could help. :cool:

Chris, If you want to enforce referential integrity on a one to many relationship then the record on the 'one' side must have a unique key like an 'ID' number that uniquely identifies that record. If you set this field as the primary key then also make sure that the 'Indexed' property is set to...

Hi there Basically 'Referential Integrity' is a way of checking that the relationship between 2 tables is valid. Take the following example: You raise a purchase order to a supplier, the relationship between them is that one supplier can have many orders but one order can only have one...

Hi there, In your front end you need to use the 'Linked Table Manager' which is found in Tools---->Database Utilities---->Linked Table Manager (Access 2002). If you select all tables and check 'Prompt for New Location' then in the next dialog box in 'Open File' you can put then UNC full path...

Rich On your form are you showing multiple records (continuos view) or just plain form view? As another suggestion, in the On_Current event or whatever is applicable could you not count the number of times KeyID appears and if the count =1 then perform your calculation else return a zero etc.

Rich, Just a thought, but would the IIF function do?

Hi there Am I right in saying that you need to perform a search based on alphabetical values? If so, I don't know well you cope with code, but one way around it be to declare in a module a public variable: Public myString as String Then create a public function that returns the value that...

Hi there I have a very similar situation whereby I store the login name and permission in public variables. On my login form the user selects there name for a combo box, then enters their password and then clicks OK. The code behind cmdOK is as follows: Private Sub cmdOK_Click() ' Check to...

Hi everyone I have a database that records purchase orders. The orders can be raised in one of 3 currencies - Sterling, Euros & US Dollars. The underlying field has been set to a general number and NOT currency as I have a seperate field (combo box) that denotes the currency. Now a user can...

Glad I could help! However I would go with Ian's suggestion. It's far better to create a public function to display your msgbox. This means that you can call it from any form etc.

Try something along these lines: cmdButton_OnClick() Dim Response as Integer Response = MsgBox("Do you wish to continue?", vbYesNo, "E-mail Report") If Response = vbNo Then 'User chose no Exit Sub Else 'User chose yes etc. etc. End If

Hi there, Firstly the reason for the #Error is (I think) that you are trying to calculate a result that includes a Null. If you have a zero in [INI COMP] then it should work i.e. prove that theory. As for the formula, are you wanting to calculate each record in the report? If so the try =...

You need to use the Call event. In the On_Click event of Button2 put this code Call Button1_OnClick() HTH Rob

If you say the subforms are linked to one another correctly then scrolling through or selecting each record in the child subform should automatically select the associated record in the grandchild subform. I've had this kind of problem before and I think it's something to do with missing...

Ooops!! Should have been =Sum(sum([hours earn]+[ini comp])-sum([hours req]))

Try =Sum(sum([hours earn]+[ini comp])+sum([hours req]))