Search results

How do you make a combo box display a list showing items different than the value it actually assigns the choice? Ie. Combo Box shows -------- Combobox Interprets this as ---------------------------------------------------------- Test . . . . . . . . . . . . . . . . 1 OtherTest . . . . . . ...

Perfect, thanks a lot.

Need a statement like If (frmResultsSummary is open) then DoCmd.Close acForm, "frmResultsSummary" End if No clue what syntax is to check if something is open though, tried a few searches with no luck. -Klion

Thanks thats perfect. Hate it when I'm looking for solution in the wrong area :/

I have a record with two columns. One is FieldName, the other is RealName. I know the RealName, is there a syntax I can use to reference the FieldName from RealName? Eg. FieldName RealName Employer Student's Employer I know the RealName. How do I reference the info under...

thanks those were a lot of help. One question, how would I modify this to make a query showing two tables instead of just one? Alternatively if someone could tell me how to make the query show the plus signs so you can see related information like you can in tables that would work too. strSQL...

Thanks a lot, that got it.

Didn't really know a name for what I wanted to do for title, so here is the explanation: I am currently planning to make a form that will have listed on it all of the searchable fields for my database, then the user can choose to fill in whichever fields they want to search. At the bottom I...

Basically what will happen is the first error will occur, Case -2147217887, and the code will catch it fine. Then user will click ok and code will continue on and the same error is likely to occur a second time. However the second time instead of it going to error handling the debugger pops up...

Bah I figured it out now. It seems the problem was not what I thought it was, heh. Thanks :/

I have some code to import data from MS word fields to a table in my database, however I've run into a little snag. The problem is that some of these fields will be empty. So I have code trying to import empty fields which spits out an error (Case 5941: The requested member of the collection...

Thanks a lot, I basically had it working I just was trying to run it from the editor which it didn't like so much. Woot :)

I am trying to make a module that imports data from fields in a word document work. I got some good advice earlier for some code to import the data from the document, but the code the program uses to get the filenames of the document is currently strDocName = "C:\Contracts\" & _...

Upon searching previous threads I found an example survey database design for a very similar problem in this thread: results database I have a few questions about this. The way this database seems to work is instead of instead of storing the actual data it contains a unique reference to an...

That first article seems to be exactly what I was looking for for importing my form's data, thanks a lot :)

Alright, I was asked to make a database to hold answers to a graduation survey. The answers will be used mostly for statisical purposes. As it stands I've designed the form in microsoft word (the actual survey) which I want to be distributed via email or something similarily convenient. I was...