Search results

It gives a runtime 287 error

Send never worked for me that's why I had to use SendKeys, however I have just added true to sendkeys line and its working. I'm not sure if this will hold up though.

Hi there, This was working and suddenly it is only opening the email and not sending automatically so SendKeys has stopped functioning. Is there anything else I can do. (PS complete newbie - please speak in lay mans terms as best as you can, I really am just trying my best to get things...

ok I will try by sending them each an email. @Gasman you were correct - I don't think I gave the correct permissions to the SPList so have asked for this to be tested again. Hopefully this will have solved it.

Will do. Now some of the other colleagues are getting a message that says they cannot open the database because it is being used/locked by admin. It seems like only one user can open the FE at a time. Surely this cannot be correct .

Yes this is exactly what I thought - the source tbl for the query is a Sharepoint list and said colleague did not have access so I have granted access thinking this is what was causing the problem as it was the problem for my other colleage, but we are still getting an error message. Yes it is...

For some reason when testing in a user environment colleagues are getting this error message when clicking on a button linked to form, however when I open the database and click it, its opens and runs just fine. I know it has to be something simple but I cant seem to think why it is saying the...

Hi everyone, I'm an access newbie attempting to put a database in a trial environment and some users are getting the above error message when they try to open the file. I have saved it as an accde file for security. Do I have to create a 32-bit version for them to open it and if so how would I...

The form is bound. I think I just got frustrated because I couldn't figure out the code for the search button (on click) after the text box matches the users choice from the list box If any one could help me with this I would very grateful.

I don't have more than one person with the same name - the FName was just an example its not the actual data that is in that field. There can be no duplicates in the field i am using.

Hi all, I need a form to populate once an option is chosen from a listbox. What I having working: User Types into a textbox The list box filters based on value in the text box The user chooses item from the list The text box now matches this Where I am experiencing problems: The user...

I have done this and have managed to get access to use VBA I have just checked and seems to be working now.

Hi Pat, I tried this but it's not doing what I wanted it to do. Also update ...I now can use VBA as I have been given some the permission to do so. This is how I wanted the combo box to work:- For example if the list contains the following: Avengers 1- (AV1) Avengers 2 (AV2) Avengers 3...

Sorry Excel using my own personal excel account. When I used the work excel nothing worked so I started using Access and only the macro builder.

@Pat Hartman Yes that's what I want. A textbox that controls the filtering of a list box, but I am not able to use the code builder. Functionality of the form only works when I use the macro builder and I am not quite sure how to achieve what I want to using the macro builder. @theDBguy I...

Sorry are you saying it will work or it won't work. It was working perfectly in excel but in Access I don't know how to do this without VBA code unless I use the combo box method and that method is glitchy.

Hi all, I am quite new to Access and the VBA world but managed to create a lovely form using VBA in excel. My work place has disabled macros so when I took the file to work it would not work. I decided I would use Access (better for what we are doing anyway). I have recreated the form however...