Search results for query: *

I just Googled some sites and was reading up. Will read some more, go thru your code to understand it then give it a whirl. Thanks :-) Anna Jaeger iMIS Database Support www.axcedesolutions.com

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

you should be storing durations of time in a numeric field as the number of minutes or hours" That was my thought too, but I just couldn't get it to work. They initially said 1/4 hour increments were OK, so I had that working an assumed all staff could figure out how many hours/minutes 1.75...

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

Thanks AceMan! I was able to get the total for the day working on my form. Still getting an error in the total by cost center. But I was able to create a new form and have both working. There's something really simple that I'm overlooking. May just recreate everything in the new form that's...

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

Thanks AceMan! That makes more sense to me now. Will give that a try. Anna Jaeger iMIS Database Support www.axcedesolutions.com

Will OpenArgs work with a WHERE clause that includes multiple fields? Also, will it work if you need to return multiple records? My WHERE clause is: WHERE ((tblEmployees.EmployeeID)=1) And (12=Month(tblTimeLog.DateDay)) And (2011=Year(tblTimeLog.DateDay)) This will return a record for this...

No, this is not a subform. I also have the same process on two command buttons on frmTime. One is cmdPreviousMonth and the other cmdNextMonth. The strSQL is the same, it just pulls the time records for that employee for the previous or next month. So my solution needs to be something I can...

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 had abbreviated the fields that are in the query when I posted. There was one field from tblDates that I need for formatting the form later. For now I've deleted it and the table. The query is now updateable. So, if i want to update the query, must I only link on primary or unique indexes...

The query works if I set it up directly as a query. However, I still can't update the data in the query, just as I can't update the data in the form when the same SQL is the record source. Primary Key fields are: tblDates.DateID tblTimeLog.TimeID tblEmployees.EmployeeID Anna Jaeger iMIS...

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

They are thick lines. Anna Jaeger iMIS Database Support www.axcedesolutions.com

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

Yes, you're right, I wouldn't have to anymore. Thank you. Anna Jaeger iMIS Database Support www.axcedesolutions.com

I have set-up the function as you specified: Public Function getUserID() As String getUserID = pstrUserIDValidate End Function On loading the form, the code is: Private Sub Form_Load() MsgBox getUserID Me.txtLoginAs.ControlSource = getUserID End Sub The MsgBox returns the correct...

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