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...

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...

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...

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...

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...

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...

Hi - I have what should be a simple question for someone to answer. I'm creating an access database and will have 2 fields. The first will allow the user to enter a date. The second will show this date + 14 days ahead. So, if i enter 5/3/03 in field name [Date], field name [Date14] should show...