Search results for query: *

Thanks a lot Rolliee, with your help I produced a code that works. Here's the code if anyone ever needs to do something like this. Dim i As Integer For i = 0 To Me.Controls.Count - 1 If Me.Controls(i).Name = "Frame Name" Then Exit For Next MsgBox Me.Controls(Me.[Frame...

How do I find out what is the number of the selected control ?

Hi, Is there a way to get a caption of pressed command button in an option group. So what I have is Option Group with let's say 4 options, and they're all command buttons. So, when user selects one, and clicks some other button to run some code, I'd like to get the caption of the option...

Is there a way in Access XP database that is on the network, to prompt all the users that are logged in with the message by clicking on the button on a form ? Thanks, Dragan

Sorry for not reponding yesterday, but here I am today, so try this: DoCmd.OpenReport stDocName, acPreview, , "(arepsec = '" & Me.List7 & "') And (submit1 = 'X' )" Hope it helps.

I have a form and 2 subforms in that form in access. Subforms are connected to the parent form, so their data changes when data in the parent form goes to the next record. Is there a way to run some code to check the numbers in those 2 subforms after they're done updating ? Data in the parent...

Try this DoCmd.OpenReport stDocName, acPreview, , "(arepsec = '" & Me.List7 & "') And (submit1 = X )"

PauloRico, you are right, that is the problem. I changed some records to see if that is the case, and it was. I changed one record to December 6th, and it didn't show up until i picked June 12th. So, how do I correct this ?

I have a report, and when I click a button for report preview, follwing code is executed: sCriteria = ([Date of First Issue] <= #&quot; & [Forms]![DirectivesForm].[cboLastDate] & &quot;#&quot; stDocName = &quot;Report&quot; DoCmd.OpenReport stDocName, acViewPreview, , sCriteria...

Ok, stupid me again. Me.ReportHeader.Height works fine.... I was missing &quot;ReportHeader&quot;.

Well it's me again... I have one more problem now.. I want to modify height of the ReportHeader, and I get the error message that says &quot;This property is read-only and can't be set.&quot;. This is the code i'm using : Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As...

I'm so stupid .... After reading your reply I've realized that I've put the code into OnPrint event, and that's why it wouldn't allow me to modify control's Top property. It works fine now that it's in OnFormat event. Thanks for your help. Dragan

Is there a way to move any object, like texbox, label, checkbox through code when you run a report ? I tried .top property and .move, and they both didn't work. Is there some other way of doing it ?? Thanks. Dragan

past1 = Format(date_received, &quot;yyyy&quot;) that will take out year out of the date_received and put it in past1 variable. Dragan

I have a report that has a query with around 30 fileds. I need to check 15 of those 30 fields to see if they're empty, and if they're not I want to put them in the string, and print them on the report. I know I can do it if i go field by field, and check if it's empty, and if it's not, add it...

Sorry guys... The code that I've put up works fine... In my original code I had a spelling and that's why it was looking for that Parameter value.... because the field didn't exist in the query. Sorry once again.

Hi, I have a little problem. If I do following code in VBA, and try to run a report, it works fine, and it filters all the records for the name Jason. sCriteria = &quot;[Name]= 'Jason'&quot; stDocName = &quot;Query&quot; DoCmd.OpenReport stDocName, acViewPreview, , sCriteria, acWindowNormal...