Recent content by leerlap

I have what I thought was a simple question, but can't seem to find an answer to. I'm using access as a front end to a back end SQL database. I have all my tables linked, but I'm still in development and keep needing to change my sql tables slightly. It was my understanding that in access...

Neil - thanks so much - very useful - i've already played around with your suggestions and they work great - thanks again. Lee

Neil - thanks for the quick and detailed reply. The steps all make sense, but can you teach me a bit on why this is how it should be done? I've only used queries in the past for setting up information to be used in reports, so have little knowledge about their real use. Also, i should mention...

Thanks for your response. Actually in this case, clinicians are only clinicians and patients are only patients (this is for a research study where we recruit clinicians to participate and then they recruit a few of their patients). So, my problem still remains. Each clinician has an ID number...

I'm pretty sure this is a very basic question, but it's tripping me up and any help is appreciated. I have two tables, A and B. Table A is a list of clinicians with their names. Table B is a list of patients. Table A contains variables for ClinicianID and LastName. Table B contains...

Hmm - ok - so is there a way to turn off ctrl-s and the save and save as buttons so users won't use them? Also, is it best to create a button on the form to do the shift-enter save?

GumbyD - this feels like a stupid question, but what's the "record selector bar or pressing Shift + enter on the key board" ? Should I build in a "save" button into the form? This issue sounds like the right answer however - look forward to your response.

GumbyD - that's interesting, but I'm not in charge of the server, nor do I have any access to it. I'm a part of a large university system and the file is sitting on a very large server. I can ask about this, but I'm fairly certain my question will go unheard. Pat - i'm actually just using the...

GumbyD - yeah, i've tried that - with the same result. I'm really baffled...So, with that configuration you're able to have multiple users work on the same database and save new data into different records?

I'm having some trouble getting a small database up and running in a multi-user environment. I've read many of the posts here about setting up a fe and be, but this seems to make sense to me only if a lot of folks will be using the database. We will have, at the most, 4 people working on this...

Hmmm - still having some difficulty. Any other specific guidance? Thanks. Lee

Just need a quick line of code, i believe. I have a variable [TEXT] on a form that i want in a different place on the screen based on another variable. So, if a user selects option 1, [TEXT] will be at x=0 and y=3, but if user selects option 2, [TEXT] will be at x=0 and y=6. Example: If...

thanks Thanks - works great - appreciate all the help. Lee

Visibility Fixed! Steve - this worked perfect - thanks. I noticed I do need to put the same code in both AfterUpdate and OnCurrent. Is there a good reason why? Is it that the code in AfterUpdate sets the frame for new records and OnCurrent maintains the old ones? Again, thanks for your help...lee

Steve - this worked perfect - thanks. I noticed I do need to put the same code in both AfterUpdate and OnCurrent. Is there a good reason why? Is it that the code in AfterUpdate sets the frame for new records and OnCurrent maintains the old ones? Again, thanks for your help...lee