Search results

Access 2007 db, Win7 Have a button setup to open a form that only 1 person can have access to. Would like to generate a password prompt. Would like it to be a simple on button click, password prompt shows up, user enters and form opens. Would like to do this without 85 lines of code :rolleyes...

Data is stored in flat tables. This percent field is culled from a formula. Was looking for an expression to get the max value from the percent field without having to use a totals query as their are many fields in the query that would skew some of their results, and again, would have to change...

I'm trying to get out of a group query... I would need to change all of them for the union query... and the results are skewed was looking into using max as a criteria for the hi value field. by writing an expression in a new field of this existing query. Is that an option?

Have a massive 2007 accdb. Using Windows 7 Running a massive union query. Now have to come up with different solution in query. Staff take tests. Staff have to pass tests with a 70% or greater score If fail, they retake test. Retake doesn't always occur immediately. On failed report, I post the...

INSERT INTO QuestionResponses ( [Question#], Question, ProgramId, [OutcomeID#] ) SELECT QuestionList.[Question#], QuestionList.Question, QuestionList.[ProgramID#], QuestionList.[OutcomeID#] FROM QuestionList WHERE (((QuestionList.[ProgramID#])=[Enter Program ID]));

forgot to state I'm using Access 2007 Windows 7

Running an append query. It works when I have existing date in the table and append. When I add a new record and try to append to another table, it is not working. Giving me type conversion failure table key violations lock violations validation rule violations This is alot of violations for...

The field contains the records.... I ended up using the sum function The field contained a 1 or 0 I did want to count the 0's... instead summed and got the count of 1's so figured the % of 0's from that count and the overall count. Got the results needed this way....

have a query with test results in field 1, set up count for field 1 to give me field1....group by.....field1....count of those with criteria of 0... Have 12 fields in this query that need the same setup.. Is it possible to count 12 fields in 1 query? It works for 1 field, but, when the others...

="[recordID]=" & Nz([RecordID],0) this is my where condition in macro... need to go to current record on open of the form My brain can't think anymore today. Help... Windows 7...Access 2007 Jen

I have not tried the html, but, definitely will give it a shot. Thanks much.

I did set the formats of the memo field and the text box field to rich text... ???

Forgot to mention.. Using MSAccess 2007 WinXP

Creating a report. In a label I want to be able to format certain words. I've created a rich text memo field in the table. My question... Do I need to put the text into the table and drag onto the report design form or Can I just select the empty memo field from the table and place on report...

Hello all, I am a fairly experienced user of Access. Currently using Access 2007, with WINXP(yuck-work stuff) Am creating a db from scratch for a massive project. Definitely looking for some help with this. I really appreciate everyones offer of their knowledge.