Recent content by sirkistova

Thanks, I managed to do it. I placed the suggested code in the field's lost-focus sub. Using the form's before-update sub, I can hold the current record if validation failed. (I searched the forum and found what I needed in this case.) And the 'E' problem is solved by: If...

Where should I place this code? In lost-focus subroutine? What if validation failed - I need in that case to pop a msgbox and hold the focus in the field and hold the gui on the current record (in case focus was lost to the arrows thingy that navigates over records) - how can I hold these two...

I need to make a validation rule that would allow digits and spaces - any number. Something like: Like "[0-9 ]*" but I need a '*' whose meaning is "repeat zero to infinit times" like in regexp. How do I do that? What is the repeat charachter in Access validation rule? The field is a list of...

Hello, I found out how to set a query - using CreateQueryDef . Thanks Tova

The 2 queries: SELECT IIf(ReciprocityCount>FG,(ReciprocityCount-FG),0) AS ReciprocityBillCount, ReciprocityBillCount*PG AS ReciprocityCost, RegularCount*PG AS RegularCost, (ReciprocityCost+RegularCost+ReciprocityOptCost) AS TotalCost, (TotalCost-AmountPaid) AS BalanceDue, (AmountPaid*1) AS...

Doesn't work :( I get "query is too complex" when I try to open the report. The reason I want to edit the query from code is to workaround "query is too complex". Thanks Tova

Hello, There is an "Options" form to configure some values (prices). Upon hitting OK, I would like to run a piece of vb code that edits a query with the updates values. How can I edit a query from code? (The query is the data source of a report) Thanks Tova

This is the function: Public Function event_PetekFooter_GetFocus() MsgBox Me.PetekFooter.Locked If Me.PetekFooter.Locked = True Then MsgBox "This field is locked because a report that uses it is open.", vbInformation End If End Function It is located at the code of the form. The line: MsgBox...

I tried that but the value of Me.ControlName.Locked is always false. Even when it is really locked. :( Tova

Hello I made an "Options" form in my DB to edit some fields. When a field is used by a reoprt that is open, that fields in "Options" form is locked. This is fine, but the user has to know why is it suddenly locked. How can I make it pop up a message when the field is locked due to report that...

OK, here are the 2 queries that had changed when I changed the 4 values from scalars to DB fields: qryInvoice: SELECT IIf(ReciprocityCount>FreeRecieversNum,(ReciprocityCount-FreeRecieversNum),0) AS ReciprocityBillCount, IIf(ReciprocityBillCount>0,ReciprocityBillCount*RecieverCost,0) AS...

I am getting "Query is too complex" when I try to open a report. The DB was working fine, but 4 values that were hard coded really needed to be soft coded, because a. they repeated themselves in several queries and reports, and b. they need to be configured easily in 1 place. So I made a new...

I tried all widths, from widest to third of the page width, and none work. I also get an error msg. And the report does not display the whole list of names. (It does when no of columns is 1.)

Yes, I filled in '3' at page setup, but with no effect on the report.