Search results

where can i find developers solution where can i find the developer's solutions from microsoft?

solution after much trying i was able to get what i wanted, even though i am sure there is a much better way to do it. i am posting the way i did it for those who are interested. in the page header i put the field [last]. this is the last name from my field list. visible = no in the page...

i have a list of names that i would like to print as a phone book. my question is: i would like to include the first and last names listed on the page in the header. for example if the first name of the page is Adams and the last name of the same page is Biston, i want the header to look like...

i did search the forum, i didn't find anything. maybe i don't know what to search on. i don't have solutions on my computer. please guide me.

i have a table that has a list of counties, states and zip codes. i have a form that asks the user for the state, when the state is displayed, i want it to show a combobox to show all the counties in that state. then when the cursor is on one particular couty, i want a listbox to show all zip...

this is what i figured out and it works. but is there a better way? If [answer] <> [Forms]![game]![Form1]![correct answer] Then Randomize (0) message = DLookup("[message]", "[incorrect_messages]", "[code_number] = Int((4 * Rnd) + 1)") MsgBox [message], 0, "Incorrect Answer" Else If [answer] =...

you are right, the rank is nor always separated by a comma. but the rank is always either Jr or Jr. or Sr. or Sr or III or II. Can I do anything with that?

i have a table that contains messages to be displayed if the user enters a correct answer([correct messages] and another table for messages if the user enters an incorrect answer (incorrect messages]. my question is: i want any one of the messages from [correct messages]to be displayed, at...

i have a name field that includes a first middle (or initial) last and sometimes a rank (jr, sr. III). I want to separate the field into 4 fields. My problem is that only some have rank, so i am having a problem with the last name. first middle last rank how do i do that?

this exact function works fine in another database. i guess there is something wrong with this database. what should i be looking for?

i am trying to call a function from a query. and i get an error message "compile error. in query expression fMyRemoveSpaces([field3])." what is going on? i copied the function from this forum, so i think the function is correct. other functions run fine on this computer.

i have a form where the user can select which category to display in report. how can i set it up for the user to select one category or all categories for the report?

i inherited this situation, there must be a simpler way: i have this table that i export to excel. once it is there, i copy and paste a macro, then highlight all the info to run the macro. then i have to open the file and add a code to the first line. whatever the case, it is slow and...

i really need the quotation marks

sorry, it is a tab delimited file

i want to make a macro to get external data. the fiel that i am trying to import is a comma delimited .txt file. how do i do that?

i have to send letters to those people. each letter is based on the fields inthe table. the letter will include lots of iif statements. i have the letter already set up, it works for a different table, now i just want to adjust it.

i have 2 tables. i want to update one field in one table. the thing is that the 2 tables must be joined by 3 fields. (date of call, call# and call phone number), meaning that call# is exclusive only to the call phone number). when i try to update, the field, i get a message that the"Operation...

thanks. works great. do you have any idea why i am getting those weird characters?

i have 2 tables and i want to compare them to see if the same name appears in both tables. of course there can be spelling errors, etc, so i am also comparing on addresses. however even there, there can be errors, like 123 main st. and 123 main street. is there any way to compare them? i was...