Search results

Hi, sorry to bring up an old thread again but this little idea had taken a back seat until today. i'm working on a database used for outbound calls (basically a form that pops the contact details from a table, has a button to dial and empty fields for responses to a survey) and i'm trying to...

thanks a lot for that. i'm going to shelve this idea until i get a little better at this access malarkey :) there's loads of little jobs for me to be doing here and this one looks like i may be a little out of my depth.

hi, cheers for the help. i've tried the code you posted and it works, but it does the same as the first code and changes record after it's complete. i need it to just check the spelling of the record that's currently loaded on the form. cheers Wayne

Hi everyone, I'm trying to get a spell check to work on a text box on a form. i've got it popping the spell check window after the box has been updated but i'd prefer it to just highlight the errors in red, rather than pop the spell check box. another problem i'm having is when it's finished...

awesome, thank you very much indeed! finding out the purpose of all these quotation marks is the thing i'm finding hardest when trying to learn VBA.

Hi, i'm trying to make a form to filter a table and open a data entry form with the filtered data ready for editing. i've got it working when filtering a 1 field but i'd like to filter the data by 3 fields and i can't get it right. the code i'm trying to use is DoCmd.OpenForm "Main", , ...

got it, cheers mate.

hi everyone, i'm trying to improve the dialler that i place on microsoft access forms. basically there's a command button that dials the number that is in a text box, but we have a new job that's just come in that requires numbers to be copied and pasted into the text box. these numbers have a...

cheers mate that worked a treat, i still can't get my head around where all the quote marks and & symbols come from but i'm learning. it's very much appreciated. thanks again Wayne

ok, i've tried having a go with the code from the link you sent me and my current form load subroutine looks like this..... Private Sub Form_Load() Dim strSQL As String Dim db As DAO.Database Dim rs As DAO.Recordset DoCmd.GoToRecord , , acNewRec 'goes to new record...

Hi, Thanks for the advice and the link. Would you mind giving me an example of a value with delimiters? i'm trying to decipher the code in the link and it would probably be helpful to see one before i try and create one. Thanks Again Wayne

little update, i've found a few posts on other sites that i'm pretty sure are trying to do the same thing as what i'm doing and i've progressed (can i call it progression when the code doesn't appear to do anything?) but the code doesn't appear to do anything. just wondering if one of you guys...

Me Again! Are you sick of me yet? anyway, i'm trying to make it a little further with my new call answering database at work. Basically it consists of a main form that has a button leading to a call answering form for each business that we represent. it also has a text box that displays the...

thanks for explaining, it's things like this that help people understand why instead of just knowing not to do something :)

sorted. in case anyone else is wondering, i changed .text to .value and all is good.

Hi Everyone, I'm trying to continue with my rebuild of our call answering screen. it's basically a form with a button for each company we represent, clicking the button will lead to a call answering screen for the company. we also have software that pops the correct screen when we receive a...

i've solved it. turns out it was the installation of the telephone client software. we had to replace its server a few weeks back. i was thinking about it earlier and this machine is the only machine to have the client installed since we carried out the work. i decided to check the install...

hi, it's error 429, a runtime error. i am definitely using the correct path to the dll file and it was definitely enclosed in quotes. i also tried your NEW reference instead of the CREATEOBJECT and when i ran the debugger it stopped in exactly the same place. like i said, i don't think it's a...

hi, i've tried registering the .dll and .tlb files with both the 64 and 32 bit versions of regsrv and all i get is an error. i'm a bit reluctant to start messing with the code as the database in it's current form will work on all of the other machines in my workplace, which leads me to think...

hi, the library file consists of a .dll and a .tbl file that is referenced through the tools>references menu in the vba editor. i believe it is referenced in the code in the general declarations like this... Option Compare Database Dim WithEvents CT As Metro_MaxxCom_CTI_COM_API.CTI Dim...