Search results

Hi 1. I need to know how to update the field list of the query after adding a new field into the table and the query? 2. I need to know how to update the records table after adding calculated filed?

How to Add String Of Times? Hi Thanks For your answers. I need know to add strings, how to add for example: 245:27+153:12 ? (The left side is hours and the right is minutes) Thanks

1. yes 2. There is a default value fields

Hi I need to know how to stop acces from update the record when the subform query is on focus? Thanks

The problem already have been solved. Thanks

Hi I need to define this query: I have 2 unbounded fields : ShowMonth and ShowYear (Each field represent the month and the year of Date field) And UserName field I need to define query that shows the dates and the UserName accordding to ShowMonth,ShowYear and UserName field (Without SQL)...

Any Idea Any Idea??????

Any Idea????????

Any Idea? Any Idea?????

So how to do that? :confused: So do you have any idea how to program the variant like autonumber (his data type is integer)? Thanks

When the form opens the subform query was loaded first and then the popup query fields shows. I think that if I could disable the query first and after that the to enable the query the problem will be solved

Any Idea? Any Idea?:)

Another information The query works when I run the query alone and the Form is open. But when I open the forum (That contain the query in the subform) I get the popup fields that related to the query and I always need to fill it again and again - twice per open form. What I need to do to...

Hi I need to know how to increment the autonumber (Record Number) after that some fields were filled? Thanks

Hi I need to define this query: I have 2 unbounded fields : ShowMonth and ShowYear (Each field represent the month and the year of Date field) And UserName field I need to define query that shows the dates and the UserName accordding to ShowMonth,ShowYear and UserName field (Without SQL). I...

Can you use RecordCount on my example above? So Can you use RecordCount on my example above?

I don't agree with you So why when you view with datasheet view you can see the checkbox? I don't agree with you

Your post is not relevant I am sorry but your post is not related to my question.

Hi I am trying to count records from underlying query with unbounded fields in the criteria and I get of course type mismatch. [c] = DCount("[Dat]", "PTable", "[ShowMonth] = '" & Me.ShowMonth & "'" And "[ShowYear] = ' " & Me.ShowYear & " '" And [ENT] <> 0 And [EXT] <> 0) When ShowMonth and...

You didn't understand my story. I am talking about viewing checkboxes as a checkboxes in Pivot Table View. I can't see checkboxes in Pivot Table view (Instead of Checkboxes I see the value of the checkboxes (True/False), But in datasheet view I can see the checkboxes. I need help here Thanks