Recent content by thethack

I have a form with a header. On the form detail I have separate tabbed folders for different forms. However, when I open this form the tabs are covered by the header and i cannot access the tabs without going into view, change it to datasheet view then change it back to form view. Any ideas...

Thanks for the thought Aleb but that is not the case as no one else had access to the data at the time. Oddly enough it will show up in different data fields. Another field in the query that I sat up an IIF function in treats the value of the field with the #Deleted data as null.

I have a single table with multiple rows of data for each entity (total of 8 records per entity - 4 for one fiscal year and 4 for the subsequent fiscal year). Here is the table structure: EntityName (Text Field) EntityConcentrator (Text Field) Value (Number Field) FiscalYear (Text Field)...

Try this Copy and paste this statement in the criteria of the date field on the query grid: Like "*" & "05-28"

I have a query with several tables that when I run it one of the columns returns #deleted whenever there is no data in that field of the underlying table. I have removed the table completely and then I get the #deleted response in another column from a different table. I did a search on...

I want to have a different sub-form based on the contents of a combo field (response in combo field is limited to a list) in my parent form. I have 8 possible options for the combo field and depending on the option chosen, I want the sub-form's Source Object to change. The combo field in the...

I have a report that tells me how many prenumbered forms I will be distributing to various entities. The query that generates the report has an expression that calculates data from several fields within the table from which the query is based. This calculation determines the number of forms to...

I have three Tables. One table lists events. One Table lists Participants. One table is my join table which makes the participants link to the event table a many to many relationship. Meaning many participants may compete in many events. The data from a participants participation in an event is...

Thanks Doc.... that looks like it may very well solve the overall concern. I will have to give it a try. I appreciate your taking the time to be so thorough in your reply.

Thanks Jon, I was finding that to be the case in the example query I downloaded. I guess I will have to manually do something at this point. I appreciate your input.

Thanks Rich. I did the search you referenced and found where you had recommended dowloading the qrysmp from Micrsoft. I have done that and I think I can do the ranking of the participants once I get the best scores in the same field. I had hoped to come up with a query that would look at all...

I am recording scores for each of several attempts per participant into a Data Table and want a query to yield their best and second best scores from all attempts and then rank the participants based on their best scores. As one participant's best attempt may be their third try and another...

I thought I read once where access only supports two subforms in a form... maybe that is the problem.