Recent content by serino64

Wow!! It Worked. Thank You, MajP

Dim sql As String Dim f As Form Dim db As DAO.Database Dim rs As DAO.Recordset Dim mynum Dim getmultiLine Dim i As Integer Set f = Forms!fCalendar For i = 1 To 37 f("text" & i) = Null Next i sql = "SELECT * FROM...

MajP I tried simply inserting f("text" & i) = getMultiLine(rs!InputText) but I receive the message "Sub or Function not defined" Is there somthing I am missing here?

Hi, I have a calendar that I am using in my database. The calendar I found on the web and works superb! for what I am using it for. Now, I am looking for a way to structure or cleanup the way the data is pulled into the textbox on the form. The textbox I am referring to represents a day on...

Thank You PHV. Worked out great.

Hello Everyone, I have run into a problem and I cant quite figure a way around It. I have created a form which has a listbox which contains a list of reports. The listbox refers to a table for the report names. I then have a Print Preview button which then looks to see if the Listbox is...

All, I figured out what to do here. I placed the below code in the no data event which took care of the error I was having. Thank you anyway. Private Sub Report_NoData(Cancel As Integer) MsgBox "There is no data for for the Washout Report during this period" Cancel = True End Sub

I have serveral reports that will open when a macro is run. The Macro hangs when comes to a report that contains no data and produces the following error: "You entered an expression that has no value". In the detail section of each report I have the following code in the On Format event. I...

Thank You! Dhookom worked out great.

I have table called "ClientTBL" with four fields: JobName, Division, CRPrice, LSPrice and ServicePrice. JobName Division CRPrice LSPrice ServicePrice Record1 Smith Maintenance $0.00 $0.00 $500.00 Record2...

Thank You So Much, Worked out great!

Hello Everyone, How do I combine three columns into one column. I have one Table Called "SalesSource" with Four Fields. Source TotalAdvertise Total ColdCalls Total Website. Source TotalAdvertise TotalColdCalls TotalWebsite Advertising $4,000.00 ColdCalls...

Our company uses a Sales and Leads tracking software that allows us to export to a CSV. format in excel. I am using MS Access to create a linked table to that excel file, whereby allowing to create better reports. The information it inports into MS Access is in the above aforementioned...

First of thanks for the assistance. Now I have a one more problem similar issue different query. Here I need to populate the null values with the account rep. Records 2-6 belong to susan and 7-9 belong to Derek. Account Rep StageChange Record 1 Susan 03-1st. Meeting Record 2 "IsNull"...

Thanks PHV, that worked just fine!