Search results

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...

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...

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...

I want to set the savename of a report by using a report number generated on the report itself. Something like: "Docmd.Save as [ReportNumber].snp" Any ideas? It might be dead simple for all I know. Thanks in advance as usual

Ihave looked throught the forums a couple of times and haven't been able to fix my problem with the solutions I am finding. Basically, I have a repeating subreport, that IS linked to the master report, and DOES run off of a query, but it seems that I get a subreport for each time the query has...

I am heading in the right direction, but I need help getting over the hump. I have a calculation that returns the average turn around time (in days) on jobs. I need to take into account that some jobs are less than one day in duration, and therefore are 0 days long. Can I use something like...

To be honest I am not sure where to start on this: I have a form that locks when the status control is set to "Closed", which is good. The problem is if someone wants to go back and edit the information, there is nothing stopping them from just setting the status back to "Open", and changing...

I would like to use one text box to determine whether or not to lock a data entry box. e.g. If [Equip_status] = "in work" then unlock [start_date] I know that there has to be a way, I just can make it work. Thanks in advance