Search results

The code was in the Audits form. Scores is the name of the subform. It doesn't matter anymore as I realized as soon as you move focus, you can't undo anymore, so I just created an undo button for the subform. Thanks for the me.undo tip.

If i setfocus to a subform, does Me refer to the focused subform, or does it still refer to the main form? eg. If Me.Dirty Then 'Here, Me refers to the form Me.Scores.SetFocus If Me.Dirty Then ' Here, does Me refer to the form or subform? DoCmd.DoMenuItem acFormBar, acEditMenu...

The results from the query are not actually displayed in the form, this form just opens a report. I want the query the subform is based on to use the same date parameter as the query for the main form. Perhaps requery won't work since it's not actually affecting a form??

Error is tripping on the requery method, whether using the with rst or not.

I can't seem to step-through this procedure, it is called from a button click - would that affect stepping-through?

Here's the code. Private Sub runrpt_day_Click() ' Process date Dim qryProcessDate As String, qryProcessDateTXT As String If Not IsNull(Me.qryProcessDate) Then qryProcessDate = Me.qryProcessDate Else MsgBox ("Please enter a process date") End If qryProcessDateTXT =...

A bit of background. Trying to automate production of a report with subreport. I have a single date parameter selected from a form for the report's queries. I want to use the same date as the parameter for the subreports' query. The report queries to which the parameter applies are action...

That has some distinct possibilities, thanks chergh. (Was unaware of any free sql server version)

Didn't know you can just subtract dates, that's cool to know. My concerns are twofold. #1, In a month, I get close to 125,000 records, with every record having 2-3 date fields. When I made the changes it reduced a 20mb compacted file to less than 10mb. #2. The purpose of this database is to...

Access stores date/time fields as a double. (Storage size: 8 bytes) Integers only take up 2 bytes. Comparing dates should also be easier. Instead of; DateDiff ("d", #6/1/2007#, #6/8/2007#) = 7 Could just subtract the integers. 2715 - 2708 = 7

Simply to avoid having to explicitly use the conversion functions in every data insert/update or when displaying in form/report.

I've been playing around with storing date values as numbers (Integer/Long) I'm interested in coding something to kind of "automate" it. My thought was to use the field description to keep track of fields which should be considered dates, and then automating the storage as Integer and the...

The joins were good, it turned out we have multiple users with the same name.

I have a temporary table with all text fields for importing data to a normalized table. In order to import I need to prep the data by pulling the numeric values of "lookup" type fields (nb. not actually using MS Access lookups) My prep query is producing 9 more records than there is rows in...

thanks, I tried changing the fieldname value to val, but am getting the same results. :confused:

.value is actually the fieldname, I believe it needs to be included - but I will check, thanks.

Hey folks, I'll try to be succinct. I have a short module using the transferspreadsheet command importing an excel worksheet into a table. (blahblah_import). Before I can append those records to the permanent table (blahblah) I need to pull the correct # values from various lookup tables. I...