Search results

Hi all. :) I have a form which, when the user clicks "Save" generates (or is supposed to generate) a new record in a series of tables using the AddNew method in ADODB.Recordset. My code is as follows: Set rstInformation as New ADODB.Recordset With rstInformation .Open "tblInformation"...

I'm having trouble finding an entry anywhere about this, although I'm sure I'm not the first person to come across it... When I am typing my entry into a combobox it begins to autosearch, highlighting the part of the entry that it finds that matches the beginning that I typed in (as a normal...

I'm wondering if there is a way to return the value of the warnings function (terminology??) in access. I know how to set the value, just not how to check it. I am putting together an administrative form that allows the admin or developer to switch back and forth between False and True based...

Today is one of those days where I can't seem to wrap my head around anything, so here goes. I have a database where the contact information is linked to an agency name via a third table which has the contact ID# and agency ID#, and nothing else. In a fourth table there is a list of programs...

I have a combo box on my bound form which has a control source in the query and a row source of another query. The combo box has the following code associated with it's BeforeUpdate property: Private Sub cboSiteName_BeforeUpdate(Cancel As Integer) Dim rs As Object Dim rst As New...

I am working with SJ McAbney's post on updating a table using a combo box when the entry is not in the list. However, each time I try to add a new entry I get an error message that I am creating a duplicate value in the primary key or index. yet the value is added to the table which the combo...

I am sending out personalized emails based on a response to a meeting invitation. What I would like to do is open a new recordset and pull information from a specific record within that set. I have code written to perform this task automatically for each reply. Replies are entered in groups...

I am having a problem with access crashing everytime I try to run, view or edit a specific module in my database. This module has worked for the past few weeks (in fact I am supposed to post the code on this forum for others to use) but all of a sudden (and on a new computer, though one set up...

Anyone know why, when I run this code, it will only create a string of a limited number of email addresses? Anytime I select more than five items in my list box and ask it to create the string and pass the variable to my procedure (see end of code snipet) it only gives me the username part of...

Anyone know how to force a carriage return in a concatenating string in VB? I have a long list of names that my code gathers from a list box and I want to force a carriage return inbetween each one. I searched the forum but wasn't able to find the answer on here (although I probalby just...

I have a module of code that sets up a Lotus Notes email and brings the user to the notes email window. I have a form where a control calls the module. The module works just fine, except that i can't get the email addresses to show up in the To: field in lotus notes. I have on the form a list...

Anyone have any suggestions for really good resources for learning more about programming security into your databases?

I'm trying to create a query where the informaiton returned is based on a date where the month (and only the month) is the month (tblMeetingInformation.dtmMeetingDate) immediately prior to the month entered on a form (frmSendList.txtDateSelect). In other words, if the date selected is in march...

Does anyone have a good naming convention for active-x controls? (Something like the "txt" for textbox and such). Thanks!

I am trying to create a module whereby access can automatically send an emila through Lotus Notes. I have a query set up to return all the email addresses for a specific subset of participants in our program, however I have not been able to get access to dump all of these addresses into the...