Search results

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

llkhoutx - i've now put the same code: Select Case Me!Frame6 Case 1 Me!field1.Visible = True Me!field2.Visible = False Case 2 Me!field1.Visible = False Me!field2.Visible = True End Select in both AfterUpdate and Form_Current and this seems to work (is this what you meant??). However, when i...

Visibility issues continue I finally had a few minutes to go back to figuring this issue out. Thank you llkhoutx and Indesisiv - i tried both of your suggestions and both worked to a point. However, i had trouble fully implementing them. llkhoutx - i liked the simplicity of your approach...

I'm having difficulty figuring out to make certain fields visible based on user input. Here's a simplified example of what I'm trying to do: I have two radio buttons that enter either a 1 or 2 in the variable [group]. There are two fields (that are linked to a table) on the form: [group1] and...

Great! This worked like a charm. Thanks so much. It seems like there should have been an easier (non-VB) way to do this, but i can work with this. Is the 'me.' part necessary? I tried it without and it seemed to work fine; however, i'm sure there was a reason to include it. Well, i can...

Thanks for bearing with me. I tried the steps you mentioned, but came up with a couple of issues: 1. I entered me.[Date14]=dateadd("d",14,Mydate) into the afterupdate event for the textbox Mydate on my form, but received the following error msg: "Microsft Access can't find the macro 'me.'...