Recent content by wcrc

I had that problem once and fixed it by using the on exit property instead of after update. HTH

Just so I'm clear on this: You have a set of numbers in a batch (example 1-100), and if the user needs 30 items then you want to give the user item number 1-30. If that is the case how do you track each batch of items? Is this an open ended system that will never restart or will it restart...

you might want to add a YES/NO field to your main table. Then use a comand button to run a query on the subform that looks for items with Yes in that field.

Is this for keeping a running total number of items ordered? If so, then would an autonumber work here?

Help? Is there any help for me? I am still lost here.

Sorry so long on the reply, but I realized after your post that I was trying to effect a table property (Required) in a form field. Once I changed the target to the table, it worked. Thanks for the help.

I presently have snapshot viewer 9.0 on top of the fact that I am running Access2k. The weird thing is that there are 4 reports that should save into snapshot format, but 3 of them have this problem. The code is identical except for the file naming tags. Does this help?

I get the following error when I try to automatically save my report in .snp format. "The formats that enable you to output data as a Microsoft Excel, rich-text-format, MS-DOS test, or HTML file are missing from the Windows registry" This is the command button code: ------ Private Sub...

This code doesn't work! That shouldn't suprise you supercoders, but I don't know how else to write this statement. Any help? Code: Private Sub Equipment_Status_AfterUpdate() If Equipment_Status = "AWP" Then Me!subJob_Desc.Parts_Date.Required = True End If End Sub Effectively, I would like...

As I said it was easy. I found that Autocorrect was on and that was causing the problem.

I am pretty sure that this is going to be simple, but I can't figure it out. I have a datasheet subform that will highlight all of the text entered in a field after a short pause in typing. i.e. I type "ABC{pause}D". I will always end up typing over "ABC", ending up with just "D". I had...

You could try to use the Query builder and use the IS null property on the second line . In essence saying betweeen date1 and date2 OR Is Null Try this: Criteria Between [Forms]![Find_Record_Form]![Purchased_From2] And [Forms]![Find_Record_Form]![Purchased_To2] Second line Is Null

I want to scream over this one, but please bear with me. I have a field in form that concatenates 2 fields from a table, the powers that be, want to store this calculated value as a joined field with another table. (bang head here) I presently use a make table query to concatenate the field...

That worked like a charm Thanks again

Sorry for the delay in the reply but the boss needed me for super important *mundane* server tasks. Is there a way have this output to a snapshot vs a report format? This is about as good as I have been able to get. DoCmd.OpenReport stDocName, acPreview DoCmd.OutputTo.acOutputReport ...