Search results

Hi. I need to clarify something. Are you saying; Alternatively; in the question table to put the answers along with the questions? If this is so; why would I need the ans table? I am not following how this would work. Can you give me a sample of how this would work please. Thank you

thank you for replying. I will give this a try and post back.

Ok. I need to design a form in my database to have the user complete questions on a personnel exit interview. Most of these questions would be yes; no type. I know it’s now good database design to use yes/no fields in table. I have researched and found the “At your survey” by duane hokum...

all using access 2010. Have a form with a control that upon click in the beforeupdate i would like a message to popup to give the user an opportunity to change the entry if isnt correct. I dont want to restrict just give them a message something like "make sure you're using the correct date"...

Can you give me an example? Is there specific wording for forcing the date control to use month end?

all using access 2010; i have a form that includes a date field. Is there a way to force the user to only choose a month end date? When the user clicks the date from the popup, they may use 9/1/2013 when the mgr. want them to use only 8/31/2013. I am thinking validation field to put a msg...

Ok. I am taking this step by step to test my forms to use the autonumber as primary and foreign keys. I designed a form with just my main table which runs off a query because I need to get a certain age criteria. The primary key I keep invisible. This query only contains the main table. I...

All my tables have autonumbers as primary key. SSN is a unique key. I apologize i didn't make this clear. Again; I always had trouble using autonumbers because of identifying with a ramdom number. I will go try again. Thanks for all your help.

I get this a little. I do have a autonumber for each of my tables. Ive had trouble using autonumbers as primary keys in the past. Can you give me an example of how this would work in my database please. thank you

All; using Access 2010. I have a database that is working fine. The user who uses it is good about maintaining it far as keeping the data clean. But now he has asked for an enhancement that I can’t figure out how to make happen. My main table has basic info; SSN, Name and Date of birth. SSN...

sorry. this is a typo when typing the code for this forum . i ran the correct code with strFilter. I still get the same error.Thanks.

All, using access 2010. I have a main form with a combo box trying to search a subform. The combo box is named cboSSN and the recordsource is a qry that contains the SSNs. The parent and child links are SSN. I want to select a SSN from the combo and in the afterupdate; view the subform record...

thanks for your help. Closing out:)

ok. I checked both form. Both filter by and order by is blank. The parameter was in the query for the subform.

Correction. I found that the query used for the report is the same query used for the subform on the main form. I can make a copy of the query and use one for the report and the other for the main form. Any other suggestions?

Yes I have. I will dig deeper.

All; using ms access 2010. In the query I use for a report; I put a parameter so the user can filter a date. It works fine but now when I go to open a form that has a subform relating to the report; users get the popup for input also. This doesn't stop the form from opening but it is annoying...

Thanks for your reply. I only can think of the code to change the tbl or query names. Public Sub PrefixTblName() Dim t As TableDef For Each t In CurrentDb.TableDefs If Left(t.Name, 4) <> "MSys" Then t.Name = "tbl" & t.Name End If Next End Sub I have not used any...

Hi all. Using ms access 2010. I've search the internet with no avail. is there a vba code to search and change all default values in tables or criteria in queries from one word or number to another word or number at the same time? Ex. I would like to search if a default value is = to "odd"...

I removed the "distinct" and now it gives me the yes no but for every record. I don't know if this is correct. but when I choose a yes it still only gives me the no records. What am I doing wrong?