Search results

say i have a table called tblEmployees and i want to find people who have the same name but different employee numbers, can that be done with a query or will that require VBA code? i won't know the names ahead of time, i don't know who has the same name. for example, columns: first_name...

i have two forms - frmOne and frmTwo. frmOne opens frmTwo with this code: intVar = Me!l_id intRoom = Me!l_room stDocName = "l_surveys" stLinkCriteria = "[l_id]=" & "'" & intVar & "'" DoCmd.OpenForm stDocName, , , stLinkCriteria on frmTwo i have the property for Order By set to...

this has to be simple but i can't get it to work... i have a selection form (frmSelection) with a combo box...the user makes a selection from the combo box and based on that selection another form opens when they click next...i have a Select Case under cmdNext_Click()..here's a sample of what...

on my form i have a few radio buttons, check boxes, text fields and combo boxes. i am able to change and update all fields except combo boxes. it modifies the wrong table... combo_table ------------ id value 1 house 2 school 3 work if on my form the combo box for a specific...

i have a form whose record source is a query...the problem i am running into updating the form once a record has been selected...the fields that give me issues relate to fields who utilize combo boxes...i'll give more detail here, using a condensed version of my form: SELECT...

i have a query that i've used on some forms that returns a list of records. however, i have some users who don't want the entire list...they'd just like a form that, after entering their parameters, returns the number of records (sort of like a count)....how would i accomplish that using vba...

i have an unbound form where users can enter as much or as little as they'd like to search the database. i'd like to have default values for two unbound textboxes for initial date and ending date. i was wanting to put in 1/1/1999 for initial and 1/1/2050 (or another high number) for ending date...

i am creating an unbound form that allows a user to search for records using any or all the fields on the search form. my vba goes something like this: If Not IsNull(Me!TicketNumber) Then strFilter = strFilter & " And [TicketNumber]='" & Me!TicketNumber & "'" If strFilter <> "" Then strFilter =...

we have a main table for tracking pickups....some of the fields are combo boxes with relationships to other tables....one such relationship is units (ml, gallon, ounce, etc)...in the main table everything works just fine....a user enters the location info, the amount and the corresponding units...

I have a Switchboard form that gives the visitor several options from which to choose. All work fine except one. The one in question loads just fine. This form has an unbound combo box used to search the database. When the user selects an option from the combo box the subform is then populated...

ok, i'm not the strongest SQL programmer, so i can't figure this out. i'm working on a report with the following source code: SELECT vio_access_mid.safety_survey_date, vio_access_mid.violation, vio_access_mid.comments, vio_chemical_mid.violation AS chem_vio, vio_chemical_mid.comments AS...

we have a database (*.adp frontend to SQL Server 2K) where we keep our records, however we want to be able to just view other info we might use to make decisions. this info is kept in different files - access *.mdb and excel *.xls files. here is the code i have to open these files (stored on our...

i have a form (frm1) and subform (sfrm1) that when a room number is double-clicked in the subform another form (frm2) and subform (sfrm2) loads. frm1 has building info and frm2 is used for inspection info. if a room has never been inspected then when frm2 loads the field [room] will be empty...

i have two files (test.adp and master.adp). the test.adp file is for testing (duh) and the master.adp is the file my coworkers use to enter data. i created several forms for data entry/retrieval in my test.adp file. in one form (building) the user selects the room and building they need. i store...