Search results

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

I changed the code from a public to a private function to a private sub and made some subtle changes. With breakpoints all over the place the flow through the code seems logical but c.name is coming out as a control on the previous form. The previous form opes the current one with acdialog...

just looking at this and getting some errors should =fn etc be call fn etc? Also doesn't like me.newrecord or c = Screen.ActiveControl Screen.ActiveControl appears to be the contents of the control if i changeto c = Screen.ActiveControl.name i get the name of the control but i get an error -...

OK thanks everyone. I've used arnelgp's method withan orderby (but not desc which I undertsand I don't need). I have a follow on question. From the previous rows I don't want the user to be able to change anything other than add notes. I know I can set the form to allow only additions but then...

when a certain form is opened the open event runs this code Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs = db.OpenRecordset("SELECT * FROM PaymentsMadeForALbaran where saleslink = " & Me.OpenArgs, dbOpenDynaset) Set Me.Recordset = rs This is to do with...

it's slightly more complicated than that the 1.262 was my figure based on what I know. It's actually 2 different taxes added together and could be a number of different figures. I also need to update various other fields based on what's in the gross field. I can do it long hand but I wanted to...

THanks to all. Everything taken on board!!

I want to do it on the back end. Front end isn't a problem and it always gets copied on start up so will always be C and R. WHat I want to know is I quit he front end I want to compact the back end. How do I know if it's in use? Effectively when the last user quits I want to compact the BE.

I have a continuous form which displays rows from a table. I have 2 controls in particular Me.Price and Me.Gross Price is without tax, gross is with . If Gross is changed then the before_update does variou things and calls a sub called applychanges which effectively looks up the tax(es) for the...

1. I'm pretty sure I can issue a command to compact the database from within the code, but what should I be aware of, such as a) How do can I tell if the backend is in use by someone else. Presumably I should not run compact database if it is. b) by running the compact from VBA will the front...

Thanks I was wanting to look at this guys website but had in my head a different name! Bob Larson for some reason! Looks exactly what I'm after as well so much appreciated.

he wants a "find" box in the header which he wants to type his search and then click the find button. i'm not sure how to code to reload the form based on a like operation.

I asked this question before but focused on something that has now become irrelevant. I Have a number of forms which either display the whole table/query or a predefined subset. The form is continuous. The user wants to be able to search on specific columns for a string. I've pointed out he can...

Lol, I forgive you and thanks!!