Search results for query: *

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!

Thank you for the reply. Correct, The account rep for the Porter Residence is Susan.

Hello everyone, I have a table called "Accounts" and a field called "Account Reps" and "Job Name". How do I create a query that will update the null fields for records 2 and 3 to reflect Susan and records 5,6,7 to reflect Daniel. Account Reps Job Name Record 1 Susan...

Thank You MajP. This worked out perfectly!

MajP thanks for replying. I am not sure what to do next. Is there a sub function I need to create to open the my access database? If so How do I write this?

Hello All, I would like to create a macro using the vba editor in MS Outlook 2003 to open a Access Database I alredy created. My datebase resides on the server "S:\Shared\AccessDatabase\ProphetModule.mdb". How would I write a code that would open the path above? Any help is well appreciated.