Search results

I have an access front end for a SQL database and I have created a Call Records Table and a Call Attendees table. On the Call Records table I have two unbound Listboxes, "AvailableAttendess" and "CurrentAttendees". Available Attendees is a not inlist query to the Call Attendees table so that...

I'm trying to create some VBA that will loop through my listbox, de-select all of the items, and then return to the top of the list without selecting the first item. Below is the code I am using based on what i was able to find through google, but the top item still remains selected...

Hi- I have a form called "Record Call" when a user can input the calls that they have made or are scheduled. This form is based on the table "CallRecords". I have created a new table called "CallAttendees" and added a listbox to my form for users to select who attended/participated in the...

Hi- I've created a front end application using Access with a SQL back end. I have a shortcut to my application on each user's desktop, which references the application stored in their My Documents folder. I am trying to find a way to limit the users to only having one instance of the...

Hi- I have a form which contains a listbox sourced from a query and several text boxes where the user can enter filters for the query. The query has references back to the form for the criteria, i.e. the filter for "Company Name" is handled in the query criteria as Like "*" &...

Hi- I currently have an access application that users will interact with through a terminal server. I had built an "add to outlook" function for meeting appointments, but now that the application is running on the terminal server this functionality has been rendered useless. We currently do...

Hi- I'm developing a report using a query as it's source data. One of the filters I am trying to apply to it uses data from a textbox on a different form. I have used this method before without issue, but it seems to be causing a problem here. In my form I have a listbox called...

Hi- I've created some VBA to add appointment information contained in my database to a user's outlook calendar. The code works perfectly until I tried to include an attachment in the appointment using an attachment field in my database. I've scoured Google and these forms to try and find a...

Hi- I have a listbox containing a large number of potential prospects. When a user double clicks on one, I am trying to pass information contained in the list box to the new entry of a form that launches on the double click. What is weird is that the first field populates in the new form, but...

Hi- I am running into some issues when trying to create a summary report. I have a table called PipelineDB which contains sales leads. I am trying to create a report that will have three fields for different groupings. Attached is an excel file of the template i'd like to create. I am able...

Hi- I have been building a customer & sales lead database and was hoping I could get some help with a NotInList event. I have a menu form where the user will select a prospect from a combobox. The combobox is currently set up to not allow them to add items to the list. When a user types in a...

Hi- I have a calculated field in my report called "New Business Revenue". I used the expression builder to calculate this value for each item in my report. I subtotal my report using a field called "Stage". In the "Stage" footer field I am trying to sum my calculated "New Business Revenue"...

Hi- I am making my first access report and I have subtotaled by report by a field named "Stage". In the "Stage Header" section my stage name is getting cutoff. The text will not overlap into the next column. I would like this Stage Header to be one line and overlap the next column. Is this...

Hi- I am working on an Access database where people will be entering & editing potential sales leads. Currently i have made two forms, one for entering a new lead and one for editing existing records. The difference between the two comes down to which record the form launches to and the New...

Hi- I've written VBA code to sum two fields in my form and save the information down into a third field. My variable where i calculate the information is working correctly, but the text box i am trying to save the value to always shows zero. All three fields are set up as doubles in order to...

Hi- I've been working on creating a new form to track prospect & clients. I have very little experience in Access programming (basically learned everything from google searches & this site). I have a form to capture the creation of a prospect/client for our company. In this form there is a...

Hi- I've recently begun a project at my company to capture some Propect & Pipeline information which caused me to take my first foray into Microsoft Access form creation & programming. This site has been an incredible help for almost all of my issues to date. Now that I've hit my first snag...