Search results

I thought it was only dates that I couldn't fathom but now I'm stuck on numbers! I want to limit the user to 2 decimal places when input on a form. I can only get as far as displaying the rounded 2 decimal places but can't stop him putting in something like 231.1278364731. It will display as...

OK I think I know what I'm doing. There are multiple users but they look at their 'own' data so shouldn't be a proble.

OK understand the way this list box would work but don't think it fits in with the design I currently have. He'll have to do with the solution provided by MajP (thank you again). If he's not satisfied what I could do is add another yes/no field to the table. If he selects it then I can sum on...

I'll take a look but I'm still not sure what my form is going to look like!!

I can see a list box is a list of items. I can't see how to add that to my form. From my example on each row I have a sum, sum 1 sum 2 and sum3. Are you suggesting I have a list box on each row and the contents are sum 1,sum 2 and sum3? I may be a bit thick here but I don't get it!!

Thanks, I'll take a look. I know it's a pain as I've tried a few years ago and gave up. The user's current software has a real whizzy set up. As you scroll all controls change depending on their content. Looks really flash.

What I have is Row 1 sum 1 Row 2 sum 2 Row 3 sum 3 with MajP's original answer I can total rows 1 and 2, 2 and 3 but not 1 and 3. Not sure how a list box will help me here.

I'll give it a whirl. I'm not keen on enabling the record selectors and the timer event don't half get in the way when you're trying to debug stuff!! Anyway appreciate your help.

I'm not after changing the form to fit the screen resolution I want to be able to change the width of certain controls as they can contain different amunt of text. e.g. customer could be abcde or abcdefghijklmnetcetcetcetc. If I set the control for the widest I'm using up to much of the form.

i'm using a continuous form so i can set the optimum widths but i want to do it dynamically. the customer name can be as little as 5 characters and as much as 40.

OK never come across that before I'll take a look. Taken a look and no idea where to start!

This works so many thanks for that. I have a couple of questions one is from me and the other I know I'm going to get asked! So is there anyway to select a record without having the record selectors of the form set to on? I usually disable this straight away so the users can't do anything that...

CHeers I'll give it a go. I'm using a continuous form and I've disable the record selectors but I'll give it a go.

I am developing a database for a user who previously used an off the shelf piece of software which didn't entirely fit with his method of working. He's happy with what I am doing but he has been spoilt rotten by the nice to haves he currently experiences with his off the shelf package. One is...

Hi I have a form with various numbers on and in the form footer I sum these. The user now is getting all excited and wants the ability to highlight cells in a column, like he can in Excel, and get the total of these instead. I've looked at how to do this for a few hours but can't see that it is...

Works a treat, thanks. I was on the right track thinking I needed a UNION but was looking at doing something with the second query!!

OK I'll give it a whirl!

I have a table (A) that basically holds invoices. It has an invoice number which the user wants to be sequential. Another table (B) holds the last used sequence number so that. When a new invoice is created the sequence number from Table B is read, 1 added to it and that is used for the new...

Yeah that works, thanks Mr theDBguy

Right I know what's happening but don't know what to do. When the user clicks the copyrecord checkbox it's always the last one that isn't processed. I assume this is because focus hasn't been taken off the row and the row therefore hasn't been updated. Hwever I use a button in the form header to...