Search results for query: *

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

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

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

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

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

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

The report is grouped by [ActionByTech] and displays a count of actions taken by each technician daily. Here's my ActionByTech group footer: ="Total Actions for " & [ActionByTech] & ": " & Count([ActionDate]) The report footer displays one grand total for ALL technicians over the period...

How can I specify the saved import specification that I want to run? I don't want my users to have to pick from all the saved imports. I tried: RunCommand acCmdSavedImports "ImportMilstripOpenHistoryCognos" but that doesn't work.

I'm trying to build a report that identifies items that can potentially be worked together. I've played with Unique Values, Count, Group but nothing seems to work for me. I want to identify NSNs that have more than one unique XrefIssueNum. In this example, NSN 5330-01-094-1406 should not be...

I handle the 2501 error in the Report_NoData event but, if there is no data, I don't want this message to appear in the Report_Close event. Should I set a global variable to capture the NoData value or is there a better way? Response = MsgBox("If you are satisfied with the report" _ &...

I want to force the user to enter something into the XrefGroupNum field on the subform before allowing them to enter data anywhere else on the subform. I used the subform's Dirty event to test for null in the XrefGroupNum field. This is fine if the user attempts to enter data in any other...

I just cannot seem to grasp the proper way to use quotes. Now, I want to filter a report and display results based on a timeframe chosen by the user. ===================================== stDocName = "rptFollowup" stSelectTech = "Tech='" & Forms![frmTechnician]![cboTechnician] & "'"...

I have a command button that imports data from an Excel spreadsheet and puts the data into a new table. If the user changed the spreadsheet (e.g., deleted some columns), Access prompts them for the missing information. If the user clicks on the Cancel button, I display an appropriate message...

I have both Office 2003 and Office 2007 users accessing a front end on the server from a shortcut on their desktops. The application is nearly a year old now. Today, I added a new command button on the main menu that does the following: -- Using a saved import specification, downloads data...

We're having a lot of network issues lately. I'd like to be able to personalize Error 3043 ("Your network access was interrupted. To continue, close the database, and then open it again.") I don't know how to trap the error because it can occur while the user is doing any number of things...

I have to move my database and external files to a new server. How can I update the path to these linked PDF files in my table? (e.g., J:\123\ABC\SomeFileName.pdf is moving to L:\456\DEF\NewBranchLocation\SomeFileName.pdf) I expect to use an Update query but can't figure out how to replace...

My Word document has lots of hyperlinked cross-references. How do I get back to the point where I used the hyperlink? In other words, if I click on a cross-reference on page 6 that sends me to page 84, how do I get back to page 6 when I finished?

I have a tab control with three pages containing subforms. On the main form, I have a command button that should only be visible when the second page is at the front. I'm not sure what event to use.