Search results

I'm trying to refresh a subform on the main form after updates or deletes has been done from an edit form. I tried putting it in an OnGotFocus event on the main form but it doesn't fire at all, even if I put a SetFocus to the main form on exit form the edit form. In what event should I put...

I want to avoid the usual Access multiple form hell by placing my different forms in a subform window on my main form = one form, one level all the time. I change the forms like this: frmMain.SubFormWindow.SourceObject = "frmAnotherForm" How do I put in a criteria for what record...

Hi all, I have a text message in a fixed format where each piece of info is enclosed in slashes like: TYPE/TIME1/TIME2/ROLE// F15/260730/260810/CAS// How do I search the text string to find for instance the first "//" then search for "/" and then copy the "260730" part??? What is the ctrl +f...

The fields in the query says "#Error" where there are no records matching the WHERE criteria (Null passed to the function). So I made a form with a textbox and a button that passes whatever contents of the textbox through the function. Then I get the error description "type mismatch"... Does...

Data type is Long. The function is called in a query like: FormatMins([tblLog].[totalMins]) AS [TotalTime] WHERE... Function looks like: FormatMins(lngMin as Long) as String Dim strHrs as String Dim strMin as String strHrs=Int(lngMin/60) strMin= lngMin Mod 60 FormatMins=strHrs & ":" &...

Have tried: Nz(SomeField) = "" Nz(SomeField,"") = "" Nz(SomeField,0) = 0 Nothing works :(

I get type mismatch with the below: Function(lngAmount) as string if lngAmount is Null Then Function = "" ... :confused: Why can't my input be Null? -and how do I solve this? I get the error in this part: "if lngAmount is Null"

Is there any way to put the action query in the startup sequence instead? Before the startup form loads?

I want to run it when I click the form's "control box" x... What is "exit db"?

Won't work since I call the function in the Form's own close event... (It's a form with a tab ctrl with multiple subforms...) I'm guessing it's trying to close itself, or...!? I get runtime error "Close action cancelled" referring to DoCmd.Close acForm, Forms(0).Name.

I have put an action query in a close event of a form. DoCmd.RunSql(DELETE * FROM tblLog WHERE [tblLog].[Delete]=True;) DoCmd.Quit The query works fine when nothing is opened, but when it's placed in the close event, records are still locked as the form is not closed, unloaded or whatever...

And now it works... Stupid quotation marks!!! :p

I have a query like: [table].[Hrs] & ":" & [table].[Mins] that produces an output like "12:31" However if [table].[Mins] is 1 then the output will be "12:1" I tried Format([table].[Mins],00) but since it is still an integer Access changes my query to read Format([table].[Mins],0)... How do I...

I have qryMyquery, based on tblMytable. The query uses a function to calculate a value from tblMytable - [qryMyquery].[calc_value]. I want to sum all the [calc_value]s for records that meet the criterias of another select query to the same table - (SELECT... WHERE...

You're right. Sorting can mess it up, so be careful out there. Fixed it in my qry though... Thanks!

Try the two new buttons about and page2, in the attached. Best rgds Steff

I do either a save or undo before returning to the calculated form.

I have a form based on a calculated query. To allow users to edit some of the non-calculated fields I change the form's recordsource to a non-calculated query, but I still get "Database or object is read only". I tried putting "msgbox currentdb.udateable" just after where I change the...

This was exactly what I needed. Thanx a million!!! :D :D :D

It works as long as there are no posts with same date value... Date, value, totalvalue 12/03/2005, 1, 4 12/03/2005, 3, 4 14/03/2005, 2, 6 ... Is there any way to add an extra criteria in "where s.[date] <= o.[date]" ? There is a field in the table called [RRHrs] that could be used when [Date]...