Search results for query: *

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

I just discovered that the owner of the external spreadsheet made changes to it that affected my import specification. Wow! Let's hear it for internal communication. I re-wrote the spec and am good to go now. Thanks for taking this trip with me.

Yes, I knew that. Actually, now I'm not sure whether the 3011 error refers to the spreadsheet I want to import or the destination table. I just realized the table was missing so I imported a backup copy and tried to run the import specification again. I got the same error and the table is...

Is there any way to view/edit saved import specs in 2007? I had a number of import specs that imported xls files quite nicely but now we have to import xlsx files. I re-wrote them and they worked just fine yesterday. Today, I'm getting error 3011. The file is exactly where it should be so I...

Duane, thanks a million! I would never have thought to do that but it's perfect!

I want the value of a label on my report to change depending on the value of the [PIINType] field. For example, if the [PIINType] is "Purchase Reqn", I want the label to be: "Estimated Award Date: " & [ContractDate] If the [PIINType] is "Contract", I want the label to be: "Contract Delivery...