Search results for query: *

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...

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...

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...

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...

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...

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...

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.

I have a report that is grouped by phone numbers. The report provides me with infomation on the use of the phone number such has how many calls were made to any particular number, the time of day calls were made, and the cost per call. My report is based off a table with the following fields...

I need help with a count function. I would like a subtotal for column C. I need to count the number of dates in the format below. For example; column "C" would return a count of "2". Column "C" Rows 1 2 16-18 DEC 3 N/A 4 24-26 DEC I tried using =Count(C1:C50) but the...

I having trouble with my Date Query. When the user enters a “Beginnning Date” and “Ending Date” the query should display the required info and the dates the user specified. My query does provide me with the correct info but is not displaying the dates I specified. FIELD: DATE TABLE...

I have a checkbox called UNREP. What I would like to do is sum all the values checked "Yes". I have the following code. =Sum([UNREP]) The problem I am having, is it returns a "negative" value. How do I get rid of the "Negative sign"?

The square control buttons in Access are to boring. How can I design my own custom shape buttons? Any assistance appreciated!