Search results

I have a combo box in my main form that gets its list of physician names from tblPhysician. When the physician is chosen and the record saved, it saves the PhysicianID to my main table, tblOncReg. When I delete a physician, any record that had that name chosen continues to have that name in...

I set it up to start a new record when the form opens, and now it opens the form with the fields clear until I make a combo box selection. Thanks I will have to do something to prevent the addition of a record though...

They are bound. Is there something I can do in the OnLoad event to open the form with all values cleared?

I've got a form that contains a combo box. When a selection is made from the combo box, the rest of the fields automatically populate with the data associated with the selection. This works fine, but when the form first opens, there are values already in the text fields before I make a...

Good point.....thanks.

I should have updated this thread a few days ago....I figured out how to disable pretty much everything but what the user can do in the forms. Once the DB is converted to .accde(i'm using 2007), you have to change the extension to .accdr. This opens the DB using the runtime switch. Pretty...

I have a button, that when clicked, should go through every record in a table(tblEmployee), and set [PassChange] to Yes(-1). I'm not sure how to specify to run through till it reaches the end of the file, but I think the rest should look something like this: Dim RecIndex As Integer RecIndex...

Thanks guys You were all a great help. I have finished building my first DB, without any prior knowledge of Access. I have learned a lot.

Thanks RG That works now. Can you explain what the difference is between referencing .value and .text? Also, if left off, is the default reference .value? Thanks in advance

bob I tried that and it doesn't seem to work. Not sure if it makes a difference, but I have a 'Password' input mask on the text box. Here's the code with my values plugged in: Private Sub Text20_Change() If Len(Me.Text20) > 0 Then Me.PassChange.Enabled = False Else...

If I have an unbound text box and a checkbox in the same form, what code can I apply to the text box so that as soon as a character is entered, the checkbox is disabled? On what action would I apply this code?

I finally found a solution to my problem. After I converted the db to .accdb, I changed the extension to .accdr. This opens the database using the runtime switch. This eliminates ALL toolbars, right clicks, etc.

Bob Even after I create the .accde file(equivelent to MDE in Access 2007), these issues are still present. In "Access Options", I go into the "Current Database" settings, and disable "Allow Full Menus". That removes the "Access Options" button from the Office button menu, but a user could...

John Right now in the "Current Database" view in "Access Options", I have the navigation pane, ribbons, menus, and shortcut menus disabled. However, when I close and re-open the DB, I still see the "Home" ribbon and the Office button on the top left corner. With those items there, the user...

Still haven't found anything that works. With the "Home" ribbon and Office button still there, a curious user can right click either one, go into Access Options, change the startup form from the main login form to the main form, thereby negating any security I have set up through forms. The...

I did a search and nothing I found is working for me. I use all the code that ghudson provides in his code listing, and it's not working. When I try to hide menus, using his code, it only hides the "Access objects" list and disables right clicking in the forms. I need ALL menus disabled and...

Hey guys Instead of typing it over again, you can view my issue in this thread I posted in the "Forms" room: http://www.access-programmers.co.uk/forums/showthread.php?t=125180 Is there a way to use VBA code to open Access with ONLY the default form and NOTHING else? I'm talking no toolbars...

So with the help of many of you on this site, I was able to build my first Access database. Thank you all. Now that I'm all done, I have one final thing to figure out. I have incorporated user authentication into the database for a minimal level of security. Everything finally works like it...

I have an unbound textbox in a form that accepts a password. When submitted, I want length of the password to be evaluated. If the number of characters is equal to 8, then the process should proceed. If it's less or more than 8, then a message box will pop up saying the length is incorrect...

Thanks for the help. I had the input mask set to "Password" so that the password shows up as *** when it's typed. Can I put code behind that text box so that 8 alphanumeric characters are required AND the **** shows up instead of the actual text?