Search results

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...

OK I spoke too soon. This almost works. I've changed the query a bit. Basically a list of records/rows are displayed. The user can click a check box on the rows that he wants copying. The check box is copyrecord. The following works but doesn't process one of the records unless there is only 1...

Ye sit does. I actually had that coded but removed it as I was getting an error and assumed it was because of the where and it wasn't!! I do have another problem which I'm just about to type in.

Thanks I've got this working but bascially the user can mark the ROWS he wants copying. In the VBA I want to return those ROWS only to run a create and copy query. I've got this working to some extent but hitting a wee snag as detailed in my (soon to be published) next post on this thread.

OK solved!! I had this in but was getting an error which wasn't related. SIlly me. Solution is Change strSQL = "ListSalesAll" to strSQL = "ListSalesAll where USer = 'Fred'"

I have a query ListSalesAll that is used in a number of places I want to be able to pass a parameter to this to limit the number of rows returned as once the database gets growing it could be quite large. I tried doing this Dim dbs As DAO.Database Dim qdf As DAO.QueryDef Set dbs = CurrentDb...

thanks all. i ended up with an update query passing it some parameters where necessary.

Finally got around to implementing this. I used "Find as you type". Had a slight problem which threw out an error. It fell over when trying to deal with a control called "Emptycellxxxx". As far as I know my form didn't have such a control. I put in some code to ignore these controls and it works...