Search results for query: *

I have a database that I created that once the person using it is done with a report they immediately email it. Currently I have it set to email using Novell Groupwise, but we are slowly switching over to Exchange, and using Outlook Web. Is there a way to have MS Access make a call to Outlook...

I have a form (frmCriteria) that has a subform (frmCriteria_subform). The only item on frmCritera is a ComboBox where you select the "Property" that the data in the subform is related to. All of this is working fine. What I would like to do is once you enter data in the subform and move on to a...

I have a query that I have that generates a report from one particular form that is opened. I have several different forms that have the main form and a subform within the form. The subform on each is what is different. I would like to have it so that it can generate the report from any of...

I have a backend and frontend database. The backend database I am using as a "centralized" database for some aspects, such as employees, which I want in all of my databases. When I create a link to the table in my frontend, and attempt to create a relationship, I have noticed that the Enforce...

I have a database with numerous people use. I have the reports set up for Print Preview, since they need to preview the report, then if all looks good they send the report to a Mail Recipient. I encountered a problem with print preview with a user that doesn't have a printer installed. When he...

I have a form with a query attached that I cannot get the result to pull correctly. The code below is on a Combo Box: SELECT Hotels.[ORS Prop Code], Hotels.[Property Name], Hotels.[General Manager], Hotels.City, Hotels.State, Hotels.[GM's Email Address], Hotels.[Phone #], Hotels.[Fax #]...

I am using the basGWDemo code that Dimitri Furman produced. It is a great module, but I have encountered a snare, and haven't been able to find anything in the code, and can't find any posts. In the code, it is only accepting a single addresss for To, CC, and BCC. I want to be able to send a...

I have a reference in a form that is starting to drive me crazy. Usually I can resolve this, but maybe its from having a long week and not thinking clearly. Anyway, in the query I have the following tables: tblResponses -AssociateRef -QstnID -Chosen Value -ResponseDate tblResponsesList...

I have a combo box in a subform that was displaying data from previous selections. I was able to correct that with Me.ComboName=" " However, I am drawing a blank on having it conditional. If there is saved information in the table, it would display it, otherwise it would run the...

I have a listbox that has the following SQL in a query: SELECT tblResponsesList.Rspns, tblResponsesList.QstnID FROM tblResponsesList WHERE (((tblResponsesList.QstnID)=[Form]![QstnID])); I want to have it if I return back to the record at some point, the listbox will show all the options and...

I have the following code on a button control on a subform: Dim db As Database: Set db = CurrentDb Dim frm As Form Dim ctl As Control Dim varItem As Variant Dim SQLstr As String Set frm = Forms![frmQuestionaire]![frmQuestions]![frmResponses...

I have a listbox, set to Simple Multi-Select. I have the code behind it that successfully saves the selected items to a table. However, when I go back to the record in question it is not displaying the selected options in the listbox. I have done a search but came up with nothing on this...

I am trying to add an event to a text box that if you press the enter key, it would run the code for the OK button. The following code has been tried. Private Sub YourControl_KeyPress(KeyAscii As Integer) If KeyCode = vbKeyEnter Then Call cmdOk_Click End If End Sub At first, KeyCode generated...

I have a listbox on my form which I have set to simple. I would like to have each selection as a separate record in the table. The table that the data is being stored in is tblResponses. The subform that has the listbox is frmResponses Subform, which is a subform on the subform frmQuestions...

I have a database which I have created in Access 2002. In the database, I have a form which has the form, then a subform within a subform. In the second subform, I have a combobox with is pulling criteria dependent on the record number which is currenly open. The forms and subforms are all in...

I know that using a listbox for multiple selections, being stored in a table, is not the best choice. That it violated standardization. What I am working on instead is a continuous form with combo boxes. What I would like to do, though, is that if someone selects an option in the combo box...

I have a form with a subform linked. In the form, there is a field "txtFields" that I want to have as a condition in my subform. Basically, [txtFields] will either be Text or Combo. If it is Text, then a Textbox will be visible in the subform. If Combo, then a Combobox will be visible. I have...

I have a form in which I would like to apply a filter on open. I know that this can be added using the On Open event, as I want to do it in code. Where I am having the problem is this: I have a log in process set to database. Upon successful login, it stores the username in a temporary file...

This may have been answered, but I couldn't find a post. I found some close but not close enough. I would like to have a combo box that has a list of option from either a table or query. Once a selection is chosen from the combo, it would save the record to the specified table and show the...

I have a database that I have 2 tables using a One-Many relationship. I have these in a form and subform, linked by the Primary Key. What I need to be able to do is on the first of every month is to automatically create a record for the 1st day of the previous month for each of the related...