Search results for query: *

I integrated a product that pulls in the daily weather forcast and places it in Outlook as an all day event. The subject of this event reads "Alexandria - Monday: Intermittent Clouds; Hi 77 F ; Lo 56" It's too long. I want to edit the Subject so that it only prints everything to the right of...

I have a product that pulls in the daily weather forcast and places it in Outlook as an all day event. The subject of this event reads "Alexandria - Monday: Intermittent Clouds; Hi 77 F ; Lo 56" It's too long. I want to edit the Subject so that it only prints everything to the right of the...

I had a switchboard with several menu options. Now, when I open Access (2007) I don't see any menu options, only a blank square checkbox. I don't think that anyone in the office has "done" anything. Any suggestions for troubleshooting and getting my menu back? Thanks. Anna Jaeger iMIS...

I have a table (tblTime) that tracks the amount of time someone spends working in a certain area. The field (tblTime.TimeEntered) is defined as a Short Time field. Data entered might be: DateEntered TimeEntered Area 7/1/11 1:10 Marketing 7/1/11 2:00...

The database tracks employee time by day and cost center. I have a continuous form that has a row for each day of the month. In the columns are different cost centers: DATE ADMIN MKTG MTG TOTAL 7/1/11 4.5 3.5 0.0 8.0 7/2/11 1.0 0.0 7.0...

On my menu form, I have a command button that takes me to a data entry form, frmTime. Via code, I am trying to open up frmTime so it displays one record/row for each day of the current month for the employee who is logged in. The form would look something like: [In the header] Employee: Bill...

I have a form (frmTime) in an Employee Time database that displays all the days of a particular month (the records) and a few fields (Columns) for them to track where they spent their time that day. Upon opening frmTime, the following runs: strSQL = "SELECT tblTimeLog.TimeID...

Access 2007. I have lines in my report to make it more readable. They are visible, not transparent and color is black. I can see them in Design View and Report View, but not in Print Preview. If I add new lines, they follow the same habit. It's as if all lines are suppressed in this report...

On the On Load event of a form, I'm trying to set the control source of a text box to a public variable. The code I've tried is: Me.txtLoginAs.ControlSource = "=" & pstrUserIDValidate I get #Name? in that field. Thanks. Anna Jaeger iMIS Database Support www.axcedesolutions.com

I have a trigger on one of my tables. When the administrator updates the table from within the software, it drops the trigger on that table. As a solution, I want to have a "create trigger" statement scheduled to run periodically in the SQL Server Agent. Most of the time when it runs...

I have a report laid out for a 2 column, 3 row badge stock. The first row, left column badge is the name badge. The first row, right column is an order summary (I have these setup in the group header #1.) In Group header #2 (second row, left column) I have an "Ad ticket" that everyone gets...

I have several hundred excel files and I need to insert a row above a certain value. For example, the files look like: Column A 1-Company 2-Affiliates ABC Affiliate DEF Affiliate 3-Company Description 4-Committee Affiliation Since different .xls files may have different numbers of affiliates...

I have a query that pulls from a SQL table. It pulls a field, COMPANY_DESCRIPTION that is defined as a text field. When I look at the query results in Access, I see all the characters in that field, for example, I see 1245 characters for Company A's description. When I export it from within...

I have a database that is used only in the fall for a month or so. It was working last fall without issue, but in the last year, an upgrade to Access 2007 seems to have adjusted some functionality. Users log in using a UserID such as "Administration", "Conference", "Programs" etc. In the data...

I have a form (frmSponsorship) that had two subforms on it and was working fine. I created a new table and form (frmPromotions) and added that to frmSponsorship. I set-up the parent and child fields to link the form and subform. Now I can't open the form in Design view or Form View. The...

Here's the trigger that I have. I need it to work when a new record is inserted in the Orders table. Currently it only works when an existing Orders record is updated. Create trigger [dbo].[UpdateMeetFunc-Insert] On [dbo].[Orders] After Insert, Update As Begin ;with cte as ( select...

I'm getting the error "3134 Syntax error in INSERT INTO statement" when I try to execute the following code: sql = "Insert into dbo_Order_Lines (ORDER_NUMBER,LINE_NUMBER,PRODUCT_CODE,DESCRIPTION,QUANTITY_ORDERED,QUANTITY_SHIPPED,UNIT_PRICE...

I have a database that was originally written in Access 2003. Now when it's opened in 2007, none of the DoCmd.OpenForm "frmABC" commands work. My forms won't open. If I create a new form and create a command button with DoCmd.OpenForm "frmABC", it doesn't work. If I follow the wizard (which...

SQL 2005. I have and Orders and Order_Lines table. There is one record in the Orders table and one or more corresponding records in the Order_Lines table. For each order (determined by Orders.ORDER_NUMBER), I need to concatenate a few fields from the Order_Lines table. The syntax I have...

I'm using Crystal 8.5 and have the following formula as my record selection. When I run the report, it shuts down before prompting me for the password. If I delete the state part in bold, it will run fine. (isnull({Activity.THRU_DATE}) or {Activity.THRU_DATE}>=CurrentDate) and...