Search results

yes. hopefully attached

Yes that's what I meant.

I'm not sure what a tabbed document is. When I open a new form get another Tab. The user ants to drag this tab to a different position. This is similar to opening a new tab on a browser and then dragging it to a new position. IS this what this code does. How is it initiated.

I think I mean tabbed documents. If I open a new form I get a tab with the form name in.

I have a system where a number of forms can be opened at once. The user wants to be able to move these to an order he likes. Is this possible. So for example form1 is opened. A process then opens form 2 and from here he can open form 3. Each form can be clicked on. We now have a system where...

Thanks for this but just discovered how to use the filter!

I have aform which uses a query as the data source. The query uses a couple of fields on the form as parameters. eg the criteria on the customer field in the query is [forms]![Customer]![txtCustomer]. I want to override this to pick all customers. Is there a clever way of doing this or am I...

OK I'm not sure I can do 1). I have a continuous form so rows are presented like a datasheet. So, and tell me if I'm wrong here, if changes are made to say rows 1 and 2, the before update can give the user the option to cancel or not. If he doesn't and the user then changes row 3 he may want to...

Not entirely sure what you mean here. Btw I'm using UNION ALL WHen I just use union the sort sorts both tables as if they were one EDIT: OK not sure if this is what you meant but I've added the following to each of the 2 selects "1 " & [table1.thesortorderiwant] AS SrtOrder and "2 " &...

Hmm I think I may for this one be using a bit of both! OK I copy this standard code to where I want to back out data. Not sure where I got this from without looking at all of my threads but I can find this out if necessary. The code is in the following events After Update On Delete After Del...

I have a union query which is formed from 2 other queries to join 2 similar tables into 1. The first query takes the rows from table1 where a certain item in the table is equal to x. It doesn't really matter what the 2nd query does other than it uses a different table, table2.. I join the 2...

Because I am! If I open a form and start to make changes there are a couple of events that start the transaction On Dirty and On Delete. At that time the user may wish to open anther instance of a form to make changes to a different set of records. At the point I mentioned it then throws out an...

OK I'll take a look. Slowly getting there! The user wants to be able to look at multiple invoices for a a client - hence multiple instances. He also wants the ability to discard any updates hence being in a transaction. I think i may have to put an end to that.

No. The user wants to open multiple instances of the form compare invoices/orders etc. That said now you've pointed it out there's nothing to stop him doing it. Better put a stop to that. I used Allen's code to create multiple instances

In the past few months I've asked a lot of question. Two in particular were in essence 1. How do I back out updates 2. How do I load more than 1 instance of a form I got some great feed back and implemented both with help from this community In isolation of each other they work a treat. The...

obe? anyway it's all working now...

Thought so, so scrapped it and did it after the commit. You mean Klein bottle do you. Is that like a mobius strip!!?

Not sure what you're on about. The error I get is along the lines of file doesn't exist. I get no error number, and nothing is highlighted in the VBA code as to the line it's falling over on. I'm sure your right about the sequence of events but yesterday I basically opened up access and went...

I have some code which allows for backing out updates. It starts off with a DBEngine.BeginTrans and end with either a DBEngine.CommitTrans or DBEngine.Rollback depending upon the user. This has been working great for 99% of my needs. I can't claim the praise for this as I got it off a thread...

I'm going to once I get 5 minutes...and certainly before I release to the user ;)