Search results

Hi, I'm afarid I can't help you much on this one :( By the sounds of it, I'm assuming that the blood pressure field is a text datatype? Maybe you might want to consider splitting this data into two number type fields. In the tables this would look meaningless but you could concatenate these 2...

As a quick fix, Go to the Tools menu and select Startup. Untick display database window and you can also set a default form to be displayed when the db is opened. HTH Rob

Assumiing you're placing this in a query... Between [Please enter the start date] And [Please enter the end date]

In the design of your form, call the form's properties and click on the events tab. You should see the Before Update event, click on the build button (3 dots on it) and select code builder. This will take you to the VBA screen. You can then use code to test for entries. Something like below...

Are you able to compress it using something like WinZip?

Hi Groundrush OK any chance you can post an updated example of your db so I can have a look?

Hi RichieP Ok I had a look at missinglinq's example and modified it slightly. In your text box 'Duration' change the control source to 'Duration' so it's bound to the field in your table. Change the name of 'Estimate of Duration' text box (the one on the right of your form) to txtEstimate. Add...

Hi Goundrush, Sorry for not coming back to you, I've been rather tied up on other things. I did download your database the other day and generated the error 2427. The reason this is happening is that if you select a job that does not have any false alarms then you are trying to assign a null...

Hi Groundrush Ok I've had a look at your code for your. Presumably the bit you commented out in the On_Current event is where the problem lies? Firstly when you want to reference a control on a subform you need to use the full syntax: [Forms]![myMainForm]![mySubForm].[Form]![myControl]...

OK.. I think I misunderstood your post :rolleyes: Reading it again are you counting the number of records in the underlying recordset of your subform?

Hi there, A little more information is needed. What are you wanting to display in your text box? Is it a total of the subform? If so then in your subform's footer create a hidden textbox and set its control source to =Sum([YourControl]). Give it a meaningful name e.g. txtTotal. Then in your...

Just to chip in my few pennies worth :) I use the tab control when I have a form based on one table that has too many fields to display on the screen. Using this means I can group my controls in a logical order in each page of the tab control. Generally speaking subforms are used when you...

Why not use the On No Data event to cancel the report?

Glad I could help :D

Hi Sharon In the underlying query for your form "telephone log amend - full" trying settig the cirteria for your primary key to =[Forms]![Telephone Log Amend - Select]![yourListBoxControlName] See if that works HTH Rob

Ah right ok... What I tend to do is create a seperate lookup table to contain information. This table is not linked to anything else. For example I have a PayGrade table which contains about a dozen records of the different grades of pay i.e. manager, project manager etc. Then in my main...

Hi, Are you changing the table structure i.e. field name etc? If so then I'm not aware of a quick refresh method to update your other objects in the database. The best advice I can give is not to change the existing structure unless it's absolutely necessary

Hi there, I've been thinking about this and I'm struggling to understand why it is you want to set your labels/captions for your buttons at run-time. Is it not practical for these to be set in design? What I have done is attached an example (in Access 2000 format) of how to retrieve the prices...

Ok I think I understand :) Am I correct in saying that this table is only a lookup table where you want to store your captions? Thus allowing you to change them in the table and then at runtime to set captions on all your forms by code without having to change them in design view? Probably...

Can you explain in a bit more detail what you are trying to do?