Search results

I have done a simalar thing in want you are trying to achive. try this: Dim Record_Count as integer Dim Record_selected as integer Record_Count = DCount("Primary_Key_Field", "tbl_your_record_source", "Your criteria")'this will count the amount of records to be processed If Record_Count = 0...

Thanks wyane I got that one working but later got another problem with a Dsum. Miscell_Sold = DSum("Quantity", "tbl_Sales_Miscell_Complete_Sold", "Sold_Date = #" & Date & "#") I get error message "Invalid use of Null" error no. 94 it only works (sums all) when I take out the critera. Whats...

Thanks wyane That fixed most of my problems.

When the error comes up is the selected record in the new record? If so try inserting this code just before the goto record line If Me.NewRecord Then Exit sub end if Does this help?

Hi all 1)I am wondering what is the difference between the Form_MySubform and Forms!MySubform 2) I have heard that Form_ variety causes corruption. In what way? the way data is stored or the form itself? 3) When I try to change the record source in a subform from the main form or...

Hi all I am having a problem with a Dcount that returns zero when counting the todays records even though there are records with todays date. here is my code: Total_Each_Book_Count = DCount("Book_Id", "tbl_Sales_Each_Book_Completed", "Date_Sold = " & Date) "Total_Each_Book_Count" is a...

Can I just state the obvious? Try checking the system clock, as the system may have been reset and so will the time (and Date). Hope this helped.

Thanks rbrule I fixed my problem. Thanks

Hi all I am trying to make a query that has two table sources, first table (one field) to count the related records to the main table. The problem with this query is that I can not edit any records that the query shows. Does any one have a solution? Thanks in advance

Hi all I am having a problem with a link to a calculation (sums a calculation in query) in a subform (datasheet view)which also has a nested subform, I have a text box in main form to bring the calculation over, it is then recalculated with another subform (this one works well) in the same main...

The reason you may think you are a hopeless case is because Microsoft loves to be very complicated, using technical jargon which daunts users when they go out of their comfort zone (Help documentation). The wizards that is combined with access writes very complex code, which some have said is...

Thanks Doc, took your advice and works now. thanks again

Post your data base and I'll look at it tomorrow. By the way, when you talk about "read only" is the form set read only via visual basic, macro, or form properties? If it is set via visual basic or a macro these could be setting within the code like(where "checkbox" is the name of your...

Test it out with more then one record, each opposite values

Is the data type in the table design a yes/no data type?

Hundreds of em' which one ya want? The first thing you need to do is to base your form on a table or query.

I think there is a limit of 5000 forms (subforms included) is the same with tables, querys and reports.

You want to use a query with the criteria based on the combo box. the subform would be based on the query. see attachment for help on this.

A better way of doing this (if you want all caps) is in the table design, form design or where ever you want the text in capitals is to use the greater then symbol ">" in the format property of the text box. "<" is for lower case However if you want only some of the letters in caps then Input...

Sorry I made your head swirl. I didn't mean to speak the doom and gloom You won't want to see my database then. It is full of visual basic programming