Search results

sorry, its on the Keypress event

Yea, it changed for me when I entered the code. Remove 1st and last line? The private sub and end sub line? I only copied from the private sub line to the end sub.

Yes I copied it exactly as you have and pasted it in and added a 1 to the name of my original txtDescription_Change() so it wouldnt go to that.

This isnt working either. Am I missing something? What do you mean I can adjust the text box to lock, it just prevents additional characters? Thats what I'm wanting to do once it reachers 55

I'm trying to lock a text box after 55 characters have been entered but for some reason it doesnt lock and lets me keep typing in the box. Below is the code I have for the box. Any ideas what I'm doing wrong? I've stepped through it step by step and the len(txtDescription) will = 55 but it...

I have not tried that. You might be on to something there. It is a mapped network drive and I can open it through Access and through the open button. And now that you mentioned that, I've seen it say 'Disconnected' next to the drive but it has always still let him go to it and open anything...

This probably isnt so much an Access problem but I really didnt know where to begin to find an answer to this so I thought I would start here since you all are very hepful. I made a script file that will put a shortcut to a databse I made on peoples desktop. It has worked for everyone but...

I'm not sure if this fixed it but it was a 2007 Access file, I tried saving it as a 2003 version and it seems to be working. Not sure why that would make a difference but it seems to right now.

I made a database that opens to a main menu form adn for some reason when I click one of the buttons there it does nothing. But when I click it a second time it does what it should. It doesnt matter which button I click when I first open it either. Any ideas what might be causing this? It...

Yea, that worked. Thanks a lot for your help

Nevermind I went back through and tested it step by step and it was breaking on the .WindowState = xlMaximized saying xlMaximized variable wasnt defined. So I just took those 2 lines out and it worked like I wanted. Thanks

I tried your code as described above but it doesnt open and gives the error "Property not found". When I hit debug it highlights the msgbox line of code in the function, I'm not sure what property it's referring too, but there must be something else not working for it to go to that line of code...

I made a button open an excel file, but my problem is when it opens the excel program it opens maximized but the spreadsheet file opens as a smaller window in excel. Is there a way I can tell it to open to the max size? When the file gets open by double clicking it it opens maximized like I...

I think I finally get what you were saying before. I have my cboOriginator with the column count property set to 2(#1 shows the real name, #2 has the usernames, but with a width of 0 so its not seen). My bound column property is set to 1 because I want it to store the real name into the table...

do you really need to undo it? or try setting a variable = to cbo1 before undoing it, but I would think thats the same as setting cbo2 = cbo1 before undoing it.

I would think stepping through it like this would work. Maybe someone more knowledgable about this can confirm or deny though. if yes then cbo2.value = cbo1.value cbo1 undo, disable, & not visible cbo2 enable & visible end if

I did all that but its not showing the name when the form loads. I didnt see any code anywhere else either??

I still cant get it to work. Heres a copy of my DB. I'm wanting the frmTurnback to load the current users real name based on their username in the Originator combo box, but still list all the current employees from qryActiveEmployees. Your help is much appreciated. Thanks

That works but I dont want the actual username to display. I want to match the username to the actual person and display their real name. I made a query to do that, but I'm having trouble getting that value to display in my combo while keeping my row source pointing to a table with all employees.

I'm trying to load the current user into a combo box when a form loads up. I have a query that uses a function (which pulls the logged in username from the computer) and matches the username to the actual name of the person which works fine. But I also want the cboName on my form to use a...