Search results

Hello, I don't want my user to type in the parameter value for a query in case of miss spelling. Therefore, I'm using a dialog box form with a combo box field. The row source of the combo field is a table with one field for the list. I've added VB code (Event Procedure) to a buttons on the...

Hi, Thank you!! That did the trick.:) NLR

Hi, I'm sorry but I cannot access that site (controlled/limited access to some websites). Would you be able to send an attachment with the info? Thanks! NLR

Hello. I've created a button on my ACCESS 2010 form that will send a PDF via email. However I only need to send the single record displayed on the form not all records. The on click command of the button sends the PDF of the report. (I read that this is what should be sent; but still get the...

I'm not using SQL. I've attached a word doc of a picture of the query. Please let me know if this will work for you. Thanks, NLR

Hi, I need a little help with the following access query. I have a large table with many fields, three in particular that may contain the verbiage, /CTO/. I want to see all records except those that contain this verbiage. My query is using, Not Like "*/CTO/*" in a separate Criteria row for each...

Hello, I believe you are seeing my view of the download. I wanted to make sure it was there. Sorry, for the confusion. Your help is still appreciated! NLR

Ok, I've attached a copy.:confused:

Hi, The forms record source is a table. The changes I made to your code above is as follows; did I miss anything? Option Compare Database Function RunSum(F As Form, KeyName As String, KeyValue, _ FieldToSum As String) '************************************************* ********** ' FUNCTION...

Hi, I'm sorry; but I don't know VB. I've copied the code to a module and saved it. Changed all "KeyName" to the unique ID key field, changed "FieldToSum" to the field name. I'm not sure how to use this on the subform or if it will take the ItemAmt and keep subtracting the PaidAmt. Sorry, I don't...

burrina, I'm not very good at using modules. Would you explain how I would use the code you've provided? Thanks, NLR

Sorry, here is a better example of what I need... Example Record ID ItemAmt PaidAmt Need a Net field here? (not part of form; description only) 1 $500.00 $100.00 $400.00 500.00-100.00 2 $500.00 $50.00 $350.00...

Hello, Is there a way to add a field to a subform that preforms a net value calculation on all the records in that subform? Fields: Record ID ItemAmt PaidAmt Need a Net field here? (not part of form; description only) 1 500.00 100.00 400.00...

Hi, Can anyone help me? I would like my user to be able to enter dates on a report. I have entered unbound fields on the report; but it doesn't keep any of the information (dates) for printing or otherwise. (I don't need to save these dates since they change monthly.) Can anyone tell me how I...

Paul, Thank you for providing that info. I was able to view the field info using the arrow down. Thanks so much! NLR

Hi, I'm trying to obtain all of the information in a text field for a query. The user entered information and used a return (enter key) to enter information on a new line within the same field. The information after the return is not captured in the field in the query. Is there anyway I can...

[Day and Time1] etc. are concatenated fields in the same query. I have Day1 and Time1 for the 5 days of the week to record possible days M - F and different times in each day in the table. Not sure how else to collect this info?

Hi, I'm using the following for a field in a query: ITINERANT: IIf([Day and Time1] Is Not Null,[Day and Time1],IIf([Day and Time2] Is Not Null,[Day and Time2],IFF([Day and Time 3] Is Not Null,[Day and Time 3],IFF([Day and Time 4] Is Not Null,[Day and Time 4],IFF([Day and Time 5] Is Not...

That's just what I needed. I never thought of using the sum in the query. Still learning this stuff. Thanks for your help!!! :) NLR

Hello, I need some help with what I think is a running total for each day. I have a form that collects data several times in the day. I want a report to show a total for each day and subtotals for each column and grand totals. I can add the dates and used a running total to the report but the...