Search results

Not quite... Thank you. I looked at your database. However, the combobox "State" on your form seems to be pulling from tblStates. When I typed in something else, it allowed me to do so, but did not "remember" the new entry to be used again on the next record. How can I have my new entry...

Is there a format to this? Is there a special format to this? I have tried cboBoxName (cboBoxName) [cboBoxName] =[cboBoxName] SELECT [frmFormName].[cboBoxName] FROM frmFormName; The only selection that is displayed is what I typed in (above) as the source. Am I doing this wrong?

Is there a feature in Access similar to Excel or Explorer where if you start complete a field with a word/phrase you have used before in the same field, it will suggest it? If not, can it be easily created?

Tracking Data in Date/Time Field I have a database with a date field to document the date that a particular piece of information was obtained. However, on rare occasions, the information WAS obtained, but there is no date that this occurred. Any suggestions on the best way to track this? I...

Ok... I'm a bit new to programming commands. Please bear with me! The criteria is being entered into a form (pops up like a dialog box). A query is run that is based on what is entered in the form. I am looking for an error I can use if the query fails to find the criteria entered on the...

Thanks Thank you. I will try this. What about if the criteria entered is not found?

I have a very simple database I wrote a few years ago that provides reports on data (mainly calculating sums & percents on those sums). When run, the reports open form-dialog boxes that prompt for criteria. The dialog boxes then become invisible & the query accesses the data in the invisible...

Applications Selected Thanks for your response. Sorry for the delayed response on my part...I went out of town & your reply got lost in the mix. I have the following ticked: Visual Basic for Applications Microsoft 9.0 Object Library Microsoft DAO 3.6 Object Library OLE Automation Visual...

Update... Update....the users at the other site are using Access 2003, and I am using Access 2000. Any ideas how to get around this error?

I have a report written in Access 2000 that pulls up just fine on my PC, which is running Windows 2000 on a network. However, other users using Windows XP on the same network across the street get this error message: They are getting this message when they click "OK" on a dialog form I...

Family Tree? You seem to be possibly working on a family tree? If so, there is a really good database program out there called Family Tree Maker by Genealogy.com. I think last time I bought version 9.0 for about $60. I think they are at version 10.0 or 11.0 by now. However, it is a GREAT...

FYI...if a date has 8 digits...like 11/29/2004, when I paste it, it always converts the year to 2020, such as 11/20/2020. Otherwise (such as shorter date like 9/3/2004), the field is pasted blank.

What about this... I WOULD like to know about this part: When I origanally enter a date, I type it in as 9/2/04. When I leave the field, it automatically converts to 9/2/2004. However, if I go back and change the field, say, to 9/3/2004, I get the error message, I have to change the date...

I love it!! Too funny! True to form EmmaJane? Anyway, it's no big deal. I'm about halfway done anyway. I was hoping someone would have a quick answer that could help now AND if I come upon the problem in the future. Anyway, The database is VERY big. It will take more time than it is...

I could.... I suppose I could. I have never used an update query before. The information is in 3 tables....the demographic table, the promotions table (names in the update table get a new record annually as they get promoted to the next level...this is where the group number is saved, to...

No, the groups are static. There is a field with the group number....1 thru 8

Database I have a database with a list of students & residents. There is a subform on my form that I am updating for a number of students. It is not all of them, just a number of them on a list, so Ihave to go in to each one & enter their rotations. A number of them, 8 groups of 12-15...

I am copying & pasting 2 records many, many times. However, everytime I paste the record, the date fields (2 in each record) come out 11/29/2020 (instead of 11/29/2004) or blank. Any idea why? It takes a lot longer to retype the information in. Also, if I have to go back & edit the field, I...

Still looking for suggestions.... I'm still looking for some suggestions. Can anyone recommend a better way to go to generate better data NEXT year? Thanks for anything you can offer!

Got it! For anyone who is interested, I finally got it to work like this: Thanks for your help!