Recent content by annie52

Sorry everyone! Please ignore my post. It turns out that I had accidentally grabbed the mde file instead of the mdb.

I can't create a new query using Design View; I can't open a form in Design View. The Design View option is grayed out (inactive) on the Menu. This is a database that I've been using for six years and I don't remember this ever happening before.

I appreciate all of you so very much. Amazing that I never before had reason to use the Text function! Thank you for your feedback & instruction!

Excellent! PH, you've always been my hero. Thanks!!!

I have a Date/Time field with a General Date (6/19/2007 5:34:23 PM) called MilTxnDate. I am able to extract the Short Date (6/19/2007) by using DateValue([MilTxnDate]) but can't figure out how to extract the Medium Time (5:34 PM). I do not want the seconds.

Interesting. This is my first time using an mde file as the front end. In the past, my users always had their own copy of an mdb front end. It was actually someone in the IT department that suggested I keep an mde front end on the server and simply point my users to that file.

I tried searching but ended up with more than 2,000 results. I have a multi-user database with the BE and FE on the server. Users access the mde FE via a shortcut on their desktop. We've been using this app for nearly 3 years. Recently, I noticed that when I open the FE and click on the cmd...

I'm trying to prevent my users from changing a field on the record but my message box displays twice. Any thoughts? Private Sub XrefGroupNum_Change() On Error GoTo Err_XrefGroupNum_Change MsgBox "Changes to the Tracking # must be" & vbCrLf _ & "accomplished from the Main Menu." &...

The main report (rptDisrepsOpen) is based on qryDisrepsOpen: SELECT DISTINCT Disreps.DISREPNum, Disreps.DateFiled, Disreps.Followup, Technician.Initials, Disreps.Disposition, Disreps.DISREPStatus, Disreps.Reason FROM ReqnWatch RIGHT JOIN (((Technician RIGHT JOIN Disreps ON Technician.Tech =...

Hi Duane. I didn't explain myself very well. I don't display the DisrepNum on the report. I set the subreport with four columns (across then down). When I run the report, it displays four columns across. Each column shows a vertical list of dates that apply to the 1st, 2nd, 3rd, and then...

When I tried using multiple columns, it applied to the DisrepNum instead of the FollowUpDate. I'll try to do some more reading. Maybe I'm doing something wrong.

My main report contains DisrepNum and various fields relating to that discrepancy report. I want to create a subreport using a table that contains the DisrepNum and a FollowUpDate field. After linking the DisrepNum field, I will hide it in the subreport. The problem is that I cannot figure...

Thanks for the feedback. It turns out that Cognos 8 lets me use the Run With Options button to save the file in .xlsx format. This imports quite nicely and I'm back on track again. Thanks for walking through this with me.

Thanks for your response but, unfortunately, you're talking way over my head. I know nothing about Cognos. The report was developed by someone else and I simply run it. Also, I don't have direct access to the main database. We run the Cognos report once or twice daily to retrieve fresh data...

I have an Access 2007 database application that contains an import specification to fill a table with data from an Excel spreadsheet (xls) that was generated by Cognos. Things have been well for two years. We just upgraded Cognos to version 8 and although the filenames of the reports show an...