Search results

Well darn if that didn't work. Go figure! Thanks!

qselComplaintsCompliments ...but it did not work even when it was just code, AND I got the same message when I started from scratch & added tables to the new query. tblRoster did not cause a problem, but tblDepartments, tblActions, and tblActionList all caused the same error when I added them...

I have a database that worked fine in Access 2003. Now in Access 2007 I am getting this error when I try to view a query a form is based on: The field in the form WAS based on the following SQL: SELECT tblRoster.ActionID, tblDepartments.Department, tblActions.DateEnd, tblActions.DateStart...

That was it, or something similar. It was trying to paste numbers into a field that was limited to a list of numbers that did not include the ones the query was trying to put there. Fixed the problem & it worked. Thanks!

fk? What kind of issue might it have? Thanks.

I am trying to do what *SHOULD* be a very simple append query. The source query has 5 tables with NO key, indexed or required fields (although they DO have relationships between 4 of them to the main, 5th one that are internal to the query itself) The destination table has NO required fields...

I SWEAR by Airborne. I use it and it really works for me. I am not sure what IN it works. I think it has Zinc in it, like the Cold-Ease losenges, and echinacea & vitamin C. Cold-ease & Zicam also work with Zinc-gluconate, I think. (There are other zinc cominations). I have found sucking on...

I think it differs according to who is asking and what you are applying to get, but I took a quick look. I think some things, like CHIP, are based on people making above the poverty level, like 1.5 times or 2 times the poverty level. The Federal Poverty Guidelines are as follows: 2008 Health...

Just in case it has not been previously mentioned. I do not know all the details, but here is some general info for our foreign friends. The US Govt. does offer to those in need: 1. Medicare for the Disabled and elderly for health care 2. Social Security for Disabled and elderly for income...

I have been working on a database that has several tables that have relationships via "ID" fields populated using autonum. While I have been working, others have been using a previous version of the database to track data. I would like to transfer the data into the new & inproved database, but...

Actually... Actually, this was one of those real basic, quick fixes. This is the basic "find & replace" search box that the wizard creates when you select the option when you create a button. I DO want it to search only in one field, but I want the "look in" drop down to allow you to select...

I have a simple form with a "search" button that opens the Find/Replace utility. Is there a way for the "look in" field to show ALL the fields in the form, not just the one that you selected before clicking the button. Thanks in advance!

Worth a try I will try this. I just got back from out of town (the thing WOULD die when I am going somewhere!!!) and plan to try this. I wonder how much AT&T would charge just to LOOK at it. They are selling new Blackberries for $49. It may be cheaper just to replace it, but truly, I was...

Battery OK, No FAQ Well, I guess the battery is good. It still runs OK. I have to recharge it every few days, but it always runs down faster when I use the Bluetooth. Plus, now I think turning it off & on all the time runs down the battery faster. I could not find a FAQ specific to my...

I have a Motorola V557. It is a bit old, but I like it & do not want to replace it right now. Out of the blue a week ago, it started having a blank screen when you open it AND on the little screen on top. I have been experimenting with it. You can turn it off and on and the screen comes up...

I am trying to extract data from a survey that is buried in a patient note. The portion I am attempting to utilize is attached below. The database is normalized. Question 1 has a fixed ID of 52 with possible Answer IDs of 12, 15, 34, 49, and 75, for example. So when it is saved...

I'm not sure if that is the problem... Thanks for your response... I have not even GOTTEN to the report yet. THe Survey is a form with a field on it that is supposed to grab that number and save it in the table. THere is another reference in the same code that works...

Thanks! One more... Thanks Fast Fingers...and everyone else! That worked. Here is one more that SHOULD be a quickie. Same form... THere is a field that calculates patient age. The Survey has a field on it that I want to "grab" the age that has been calculated in the field on the parent...

I have a form that has a button on it that opens another form (survey) that pulls information off the parent form, including an autonum ID number. The survey cannot "grab" the autonum until the record has been saved. So if I create a new record on the parent form and hit the button that opens...

Got It! Thanks! Actually, when you told me that the columns were zero-based, I tried changing the number from 2 to 1. I figured if that didn't work, then I would try your container reference. THAT did it. Thanks! I KNEW it was something very simple I was missing! This one worked...