Recent content by Fazered

Thank you for the very prompt reply. I have just tried your suggestion and surely enough, it worked, everything sped up and worked as it should do. So the issue now is whats the best was to get around this issue, as its a little inconvenient to constantly change the recordsource of all of the...

Right, i guess before i go on to mention exactly what the issue is, i'd best just explain that i have spend days trying all kinds of different possible solutions to sort this issue and have researched this no end, but not yet found a proper solution. Ok, so here is the situtation i am in. I...

I have been looking around on the net for a while trying to find out how to do this. I have found, so far, the following: Application.CurrentDb.Properties("AppTitle") = "my database title here" Application.CurrentDb.Properties("AllowFullMenus") = False...

Was this too confusing for everybody? Still struggling with this so any thoughts would be appreciated like you won't believe. Thanks

Right, you'll have to excus me if this is hard to understand, but i have done my best to try and make this as clear as possible to understand. I have a form with multiple Tabs. On each tab is a subform which links to a continous form with a query that selects jobs with a specific status from a...

Not to worry, after some careful thinking and pondering on a huge number of things, it is sorted.

Ok, this may or may not be a large problem. But I could do with some help either way. I am in the process of designing a medium size database, but i am having trouble working out exactly how I should set the Keys for the database and tables. The 2 diagrams below, ER and DFD should help explain...

Thanks for your reply, thankfully i managed to find a site where someone had exactly the same problem and so i have managed to get it fixed. What you suggested was exactly what i needed to do. Thanks anyway.

Right, so i have a table which hase pricing information, and i am trying to do a DLookUp in it to find the Unique ID (MixID) for a given Mix (Mixes). So, i wrote a subroutine to do this and set values for me, but despite the huge number of DLookup's already in the whole project (well over...

Oh dear, I think i need to re-learn my alphabet. God knows how i missed that. Thanks again.

Ok, i know this isn't really related to the my previous questions but it saves creating a new thread. I am trying to declare a public subroutine called 'DebugForm' which will receive a few or large number of variables and then put these into textboxes in a debugging form. (Obviously for the...

Thought i tried that at some point. Perhaps i didn't.... nevermind, Thank you.

Actually i do have one more question about that form. When you reach the last record in the form which in this case is customer number 27, and press the next button again, the form moves to the blank record which would normally be used to input a new record in the table. The record im talking...

That was indeed what i mean, i must have accidently written the wrong thing. On another note, that code was EXACTLY what i was looking for. I think thats 3-4 days of confusion and problems solves in only a few lines of code. Thank you.

Of course, i should have known that. Never mind, you learn from your mistakes. That is correct, I had commented out the last part of that line to help with debugging. I just forgot to remove it again before i posted to code into this thread.