Search results for query: *

I am working with a SQL Server database table which has a couple of Date (datetime, null) columns (‘FirstSurveyDate’ and ‘SecondSurveyDate’) in which some date records in ‘FirstSurveyDate’ column are NULL. This table is linked to Access. I am using a simple query to show all the records from...

I have a table which I am trying to query with multiple criteria. The table which has other columns has 3 that are of interest. These 3 criteria on the 3 columns come from 3 combo boxes on a form. The 3 columns of interest are SurveyName, SurveySubject And SurveyResult and they are in a table...

I have 3 combo boxes on a form. The first combo box’s rowsource is a list of regions such as North, South, Midwest, West …… The second combo box’s rowsource is dependent on the selection of the region in the first combo box, for example, if 'Midwest' is selected in the first combo box, a...

I need to filter records in a table in a paticular way The table looks like this . . . . . ID TyNum TNum STNum TName TGender TAge 187771 1 0 0 Alex Male 21 187771 1 1 1 Alex Male 21 187771 1 1 2 Alex Male 21 187771 1 1 3 Alex Male 21 187771 2 0 0 Alex Male 21 187771 2 1 1 Alex Male 21 187771 2...

I am trying to build an Access query which counts number of records based which have two fields with no zeros in them. The query result/output is supposed to show records by their IDs and the number of rows that have no zeros in them. The table looks like ....... ID TNum STNum TName TGender...

I have a table in which records are identified by 4 different numbers. The table tabulates the results of marketing department’s focus group surveys. The 4 different identifier numbers are the (1) Participant’s unique ID; (2) Survey type number; (3) Survey Case Number and (4) Survey Instance...

I am working on a way to track users who log in and out of 6 Access databases (front end) in different locations (network drives) into a table in an exclusive database with details (fields) such as ConnectionID; Username; User Computer name; database name; date/time logged in; date/time logged...

This is a follow up issue to the ones I posted in the ‘Forms’ and ‘Tables & Relationships’ forums. The users of the summary report wish to enter data related to each customer interaction by clicking on the scheduled date in the summary report. This works fine if they are clicking on a date in...

I am trying to use CASE statement with two conditions. The issue I am experiencing is as follows. I have a form (Form0) with two combo boxes and a command button. Values from both combo boxes are required to open other unique forms (one form for one pair of values from the two combo boxes)...

I am building a database for our sales team. This team needs to track its customer interactions in one table (preferably). Sales team meets customers on a monthly, quarterly and annual basis depending on who the customer is. Senior management wants to track these interactions. It needs to know...

I have created a form named 'CustIDpromptform' which has a textbox to enter customerid (long integer) and a command button which is supposed to open a second form which displays customer contact information when a customerid is entered in the textbox and the command button is clicked. The...

I am trying to work with 3 options or contents of 3 textboxes on a form that displays several records. The first option is default and is supposed to be the usual choice. Either of the other two can be selected by the user depending on the situation. When the user makes a choice (between 2 and...

I am trying to automate the process of creating an Outlook calendar appointment by clicking on a command button placed on an Access Form. Here is the code for it: ------------------------------------------------------------------------------------------------ Private Sub...

I am creating a data entry form which will have some fields which will be pre-populated (on load) with data from a table (these fields cannot be edited) and data in other fields will be entered by the users to be stored in the same table. Is there a way to make half the form in 'snapshot'...

I am trying to create a query which will tabulate the following data: Apt Number 101 203 402 501 504 202 105 1005 103 102 201 206 403 304 205 102 101 4066 3045 205 3001 205 503 5001 206 204 As.......... Apt. Numbers with | Totals Apt. Numbers starting with number 1 | 7...

I have managed to add music to a splash screen I created. I want the music to stop when the splash screen closes but this does not happen. The following is the code for the play sound function ............ Option Compare Database Declare Function apisndPlaySound Lib "winmm" Alias...

I have managed to add music to a splash screen I created. I want the music to stop when the splash screen closes but this does not happen. The following is the code for the play sound function ............ Option Compare Database Declare Function apisndPlaySound Lib "winmm" Alias...