Search results

Not sure how to do this, any suggestions? I have 2 excel files: file A badge # name position file B F/N L/N course name course date Thought I could use access to do this, I need to look up the badge # in file A, a user was qeuerying the last name one at a time (are hundreds, which get uploaded...

I have always used integers or auto numbers as primary and foreign keys. Currently for a school project using oracle and sql plus, I have to code a db the instructions are to make all the pk and fk strings, though it was never explained why, can anyone explain to me why this would be better? is...

I need assistance, the lookup won't work after doing the append, advice? 2 tables Users & Scores Users name, dept & IDStudent (primary autonumber) Scores IDStudent (primary number) w/lookup to users SELECT [ID] AS xyz_ID_xyz, [Dept] & ', ' & [Student Name] AS xyz_DispExpr_xyz, [Dept]...

can I import into 2 different tables? do you have any screen shots?

I have 2 tbls User & Scores, I need to periodically import into these from excel. I suspect I need to import into a table then create an append query...I have autonumber in the user table PK and Scores w/number, will this work? or would this be an update query?

I have an excel spreadsheet (a dump from another database) which I'm importing into one table; the fields are named: name, scenario (there are 3), q1, q2, q3, q4, q5; I need to create a query which groups together each name and related records, so the query results would be John Smith...

I have 3 tables, w/the same field names (imported from other db) each have a name, q1, q2, q3, etc. I need to bring them together as one if names are the same in each. (some names differ, from table to table) , any ideas how to accomplish this?

I have a form that opens regularly, I need it to open a popup form when the date is equal to the first of the month, I was thinking of comparing the system date to the first of the month date, not sure how to do this? any idea?

Is there a way to customize the long date format, so the results display Sunday Jan. 20, 19xx? (abbrv the month) or abbreviate both the day i.e. Sun. Jan. 20, 19xx

I need to quickly replace "blank values" with 0's, as a result of users skipping over questions; I've tried doing a find and replace but that didn't work, it seems like I've run into this problem before but my brain has locked up

I keep forgetting and it's driving me crazy, how do I eliminate the left grey rectangle on the form? what property?

Help would be greatly appreciated. I have a combobox which feeds the listbox, when selected the listbox opens another form, frmResults. Problem is the frmResults always opens the first record, not the correct record. Does anyone know of a similar db? combobox ->listbox -> form Seems like it...

cbospec2 is on frmExerciseSelector; the rowsource is SELECT tblExercise.exercisename, tblExercise.idMuscleGroup FROM tblExercise WHERE (((tblExercise.idMuscleGroup)=[Forms]![frmExerciseSelector]![cboMuscleGroup])) ORDER BY tblExercise.idMuscleGroup; attached are the 2 tables...starting to think...

wrong record The listbox cboSpec2 opens up frmresults, but the wrong record, it seems to always select first record - using Private Sub cboSpec2_AfterUpdate() Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmresults" DoCmd.OpenForm "frmresults", acNormal...

OMG you are the greatest! you have NO idea how much time I have into this! Reasons being, initially the listbox was a combobox, hence the name; when I needed it to display all the results a changed it, probably got interupted and didn't change the name....hence I've been trying to code for a...

I have a listbox cboSpec2(not mutliselect) that suppose to open frmresults. the sql is - which works! SELECT tblExercise.exercisename, tblExercise.idMuscleGroup FROM tblmusclegroup INNER JOIN tblExercise ON tblmusclegroup.idMuscleGroup = tblExercise.idMuscleGroup WHERE...

Ooops, just realized it's a combobox -->listbox->form, would the syntax/results be any different?

Does anyone have a sample database they can post, I looked though the samples and didn't find any. I have a combobox that's when a record is selected it's suppose to open frmResults. It's an unbound combo. I suspect its something to do with Me.RecordsetClone.Findfirst - but the code I've seen I...

I have a cboSpec2 on frmExerciseSelector which displays a list of results, when the user selects a result it's suppose to open frmresults, which it doesn't. I can get frmresults to open by it's self to display the correct results but I need frmresults to open when a selection from cboSpec2...

thanks, I figured that. Do you know of a similar sample somewhere, since I'm certain it was down somewhere else before