Search results

better explanation of the problem I think I need to explain the problem a bit better. The solution Banana proposes doesn't do it I think. Attached is a screenshot of the table that gives me all the grief: tblQuality This table must hold data on 9 different analysis/test and who did them. As a...

Hi Banana, Thanks for your reply. Apart from the OperatorAnalysisID that is what I have (Why would you need that field? I don't see it in linking tables of other examples I've seen). However, that still doesn't allow me to select Operators for each of the analysis. Not on a form anyway. What...

I’m building a database of protein mutants we use in the lab. A lot of analysis is done on these proteins by various people and it’s becoming a bit of a nightmare keeping track of all the information per protein. What we need is a database. I’m getting a reasonable grip on it all I think with...

Hi Doc_Man & Fonz, Doc_Man, I've not been able to get your suggestion to work. I think I understand what your doing but my skills aren't good enough to make up last bit. I've ordered a few books to finally get a better understanding of what I should be doing. What Fonz suggests works like a...

Has thgis been solved? Starstream, did you get this to work? If so, please post tyhe solution. I'd like to do this as well but am getting nowhere. Thanks.

Please help, I'm in real trouble here I cannot believe that nobody can give me a tip on how to do this query.

I really need some advice here. Could someone point me in the right direction please? I may need to explain the problem a bit better. I currently have the 3 tables in one query. The qry has 3 "record modified at" fields that sort the records in decending order. My problem is that the qry...

I need to able to quickly find which the last records that have been modified. I have an invisible field "txtModified" on the main form and selecting when changes where made to the record on the main form is easy using a qry on that field. The problem I face is that the form with all details of...

The way I have got this to work correctly is by basing the form on a query in which records are selected based on what I put in on the first form. Maybe that is not the best way to do it but is works fine. Should I leave the linkCriteria out of that line? Or use linkcriteria instead of my...

Can someone explain to me why the code below doesn't work? I think I'm doing everything right here. By clicking a button on frmFormsAndReports_period I open up the next form (frmBooks_Between_Dates),pass on the linkcriteria and then expect the first form to close. However, with the current code...

Works like a charm with a little extra added luxury thanks to our moderator Modest (see this thread, http://www.access-programmers.co.uk/forums/showthread.php?t=108015)

Bloody brilliant Mate! You're a champion. I don't understand the VBA you've used but it works. I'm beginning to understand the more simple coding that is sort of intuitive but this is way beyond me. I'd better start reading up on it. The only thing thats not going at the moment is that the...

I have an unbound textfield (txtGoTo) on my form in which users are only allowed to enter 4 digits, not more, not less. This is controlled by the input mask for that field and works just fine. However, there are a few things that I would like to improve to make it more user-friendly. When I...

My booknumbers are not identical to the record numbers so typing in the record selector doesn't work the way I want it to. Or can you change the way the record selector works too?

Good, got this one to work the way I wanted it by retrieving the number from the textbox and clicking the "Go" button frmBooks2 opens up with the correct record. One problem solved. The other question namliam is refering to is different though I think (that's why I made it a different posting).

No not really. That's what I had figured out already. I'm still stuck on how I do that, correct syntax etc With this code I aim to pass on the value with the 'on close' event: open "frmAllBooks" where forms!frmAllBooks.BookID = forms!frmBooks2.BookID Doesn't work so something is wrong. Any...

The same? No, not at all! Read again, they are completely different issues. Here I seek a solution for when I first open the form and want to go to a certain record. The other issue relates to returning to this form from another form and automatically going to the right "level" in the form...

I have a continues form that holds a few thousand records, each record has a unique primary key autonumber (not visible) and a unique book number that I assign. Numbers currently range from 0001 to 3378. When I know I need to go to e.g. record 2222 I don't want to scroll through the whole list...

Hi Mailman, You're confused. My poor VBA skills must have thrown you. I want to go from frmBooks2 back to frmAllBooks. There is no subform involved. FrmAllList is a continues form based on a qry and shows all books from 0001 to (currently) 3378. When I've been working on e.g. bok 3205 I'd like...

namliam and giovi2002, I can see the solution as suggested but don't understand how to get there. I have the following now that obviously misses a few things. I cannot figure out how to proceed from here. Could you please be a bit more specific? stDocName = "frmBooks2" DoCmd.FindRecord...