Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. annie52

    Design View not available on Menu

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

    Design View not available on Menu

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

    1000 Separator in an Expression

    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!
  4. annie52

    Extracting Medium Time from General Date

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

    Extracting Medium Time from General Date

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

    Calculating... shown in taskbar when opening form

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

    Calculating... shown in taskbar when opening form

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

    Message Box Displays Twice

    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." &...
  9. annie52

    Display field values horizontally

    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 =...
  10. annie52

    Display field values horizontally

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

    Display field values horizontally

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

    Display field values horizontally

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

    Import data retrieved by Cognos 8 into Access database

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

    Import data retrieved by Cognos 8 into Access database

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

    Import data retrieved by Cognos 8 into Access database

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

    Edit Import Specification in Access 2007

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

    Edit Import Specification in Access 2007

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

    Edit Import Specification in Access 2007

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

    Report Label Value Based on Parameter Query Value

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

    Report Label Value Based on Parameter Query Value

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

Part and Inventory Search

Back
Top