Search results

I have 4 Option buttons where I need it to filter a query based on what Option I select. Assumption, if OptionBtn 1 and OptionBtn 3 are selected then that will put the following criteria in my query >=1 And <=3. Another assumption, if OptionBtn 2 and OptionBtn 4 are selected then that will...

Hi, How would I create a customize "Information Message dialog box" on a combo List where the property value is set to "Limit to List." Since the combo box is set to "Limit to List" property value, if the user enters something different from the list an error message will appear. It...

Try this... Create a report and use the "Grouping/Sorting" function. Group/Sort on the AFE field. Then you can sum the amount in the header or footer of the AFE. If you have an attachment I might be able to show you what I mean.

Need further assistance... What I tried doing which is similar to your advise is, I passed the values from the Multiselect List box to the Main query in the report. Then I did a parent child linkage between the Parent Report and the Three subreports. But b/c it's a multiselect list box the...

Hello, I'm trying to pass values from a Multiselect list box to sub reports. I have a report with three sub reports. The first sub report is named "Graph1", second "Report1" and third "Report2." How would I pass one multiselect list box to all three of these sub reports. This is the code to...

Hi how would I pass a criteria value directly to a query just using VB Sript. On my form I have 2 combo boxes and I want to pass the values directly to a query that then generates my report. Thanks in advance!

Need some help... I have a report where the underlying query criteria is reading from four combo boxes. As of now the report runs based on what you pick in the combo boxes. I need an option where if the users select "ALL" in one of the combo boxes that it'll query based on three combo boxes...

Microsoft Outlook Yes, we use Microsoft Outlook at the office.

I need to create an email notification. I have about 15 clients and each time the Finance department processes the client's purchase request I need for the system to send the client an email notification. How would I do this? The finance department logs in the purchase request into the system...

I used the Case Statement in my VB Code and it came up with an error telling my Access had a communication problem with the Active X Controls. I thought Active X Controls was only involved with Webdevelopment. In this case I'm just doing forms and reports in a database. Why would it cause...

Case1... Help...Select Case Statements are used to check for multiple conditions. How does the code understand whether it should run Case 1 or Case 2? There's no conditional statement indicating which case it should run. Thanks!

Case Statement... Hi Tony, I'm not very familiar with VB code. Based on your response this is what came up with. Select Case Frame45 Case1 DoCmd.OpenReport "rptBus_Size", acViewPreview,,StrWhere End If What should I put at "Case1?" Thanks!

In a grouped toggle button I'm trying to write an If statement that opens up different reports depending on the toggle button selected. example of my If Statement that doesn't work. Plz help. Thanks in advance! Private Sub Command25_Click() If Me.BusSize = True Then DoCmd.OpenReport...

error line... At the beginning of this code is where the error occurs. For Each varItem In Me![lst_FY].Itemselected StrWhere = StrWhere & "FY =" _ & Chr(39) & Me![lst_FY].Column(0, varItem) & Chr(39) & "Or" Next varItem End If

This code is embedded in the event procedure of a button. When I select a Program and year and click the button the error message I receive is as follows: "Run Time error '438' Object doesnt support this property or method." Can someone please tell me what I'm doing wrong? The code I'm...

Me!Refresh... I put the Me!Refresh in the Requirement Pick List Form in the event procedure "On Got Focus." The "New Requirement Document Log" form is a pop up form which allows the users to add a new requirement. That didn't work. is there somehow I can put the a refresh code in the save...

Need help! I've built a form where the users can double click on a selected record to link the record from one database to another record in a different database. If the user doesn't see the record he/she needs, they can add the record by clicking on the "Add New Requirements" button. My...

Typing into a text box in a form and letting it input it's values into the VBCode One more Question. I'm trying to allow my supervisor to enter a time into a text box on a form the time he wants the pop up message box to appear on the screen. This is my VB Code in the Timer Event: Private...

Worked. Thanks, when I added the range to the code it executed my VB Code. Todd

Yes I'm sure Hi Wayne, Yes I'm certain my form is open. I'll write the VB code and then save it in the Timer Event and set the Timer Interval at 3000. Then I'll open the Form in Form view and when it reaches the specified time I put in the VB Code it should execute whatever I tell it to do...