Search results for query: *

In a date field in an Invoice form, the user enters a value. Then they move to a Line Item form which also has a date field. How can I get the date field in the LIneItem form default to the entry in the Invoice.Date form-field? The system is set so that the user makes entries in the Invoice...

I am trying to update a field (memo) to equal the previous entry for the memo field plus some text and the value of the AltPhone field when the AltPhone field is not empty. When I run it as a select query I get the answer I want. When I change it to an update query, it does not work. Does...

I am trying to figure out how to get the Notes data out of ACT without buying 3rd party software. What I see on the web is that this is not easy because Notes are not stored in a field. The data is in there somewhere, is there any reasonable or semi-reasonable way to get at it?

I am trying to make a text box have no fill, using a macro in PowerPoint 2007. I went to an XP version of PowerPoint and recorded a macro to do this. The code it created was: With ActiveWindow.Selection.ShapeRange .Fill.Visible = msoTrue .Fill.Solid...

I have a time calculation (end time minus start time) that is not working quite right. It is used in time logs to pay people. If a time entry is 8:00am - 11:00am, it will return 3 hours. But if it is multiple entries, the people type entries like the following: 8:00am - 9:15am 9:16am -...

I know this is a naive question, but my books just do not answer it. I need to use a form for both new customer data entry and for customer lookup. (It is actually an order entry form). I see the property that I need to set to allow a form to do both. So first I make fields for first name...

Is there a way to link an excel table to an external data source? The is a set of government data that is published periodically that we use. Ideally, we would to link a spreadsheet to that data and have it refresh automatically, or to refresh when we ask it to. Either way would be fine and...

I need to run an append query in MS Access from Excel. The research I have done goes on about doing far more complex things in Access from an Excel macro, but not how to just run a query. I want to use DAO (I think). I think I start with dim db as DAO.workspace dim qry as DAO.queryDef Then...

This is probably a naive question, but none of my books answer the question. If I link an Access table (2007) to an Excel workbook, there are two things I do not know for sure. 1. If changes are made to the Excel worksheet, does the linked Access table update immediately? (I have opened many...

I need to change a large number (but not all) text boxes in a presentation so that they are positioned exactly the same and so that they have the same width. That is, I want to run a macro that changes format and position (width and Horizontal and From position) on the currently selected...

I am trying to subtract one field from another. At the moment, there are values in one field, but not in the other. Thus, the result of the subtractions should equal the values in the field has entries. Both of these selected "tables" for the query are actually sub-queries that total invoice...

I have an application where I need to return all records from two tables (actually, predecessor queries). My goal is to see the difference between two different calculations of what should have been the same data. But in some cases, the data was not calculated in one or the other of the two...

I am building an app that at one point compares two versions of the same records. That is, the data in question is input at two different times in two different databases. I import the version on a mainframe into an Access application in which the other input has been performed. (Sadly, the...

I need to know how to use a table-field reference in the criteria for a query result. I want to see all records where field 1 is different than field 2 by a certain variance amount. I do NOT want to enter this amount as a number each time the query is run via a parameter query for reasons not...

I have an application where the salesperson enters sales orders into a local Access application, including all the normal details one would expect. They are nearly always new customers that are not yet in the corporate computers. These same orders are submitted to the company who enters the...

I want to have Access import one worksheet from a workbook with an Access macro. Access macros apparently will not allow you to select a specific worksheet, but will allow you to select a range. Therefor I need to select a range and assign it a range name in Excel so that Access can then...

Within an Excel macro, I want to check if the first letter of a cell entry is the letter z in small case. I tried: If Left(activecell.offset(-1,5).characters.value,1)="z" Then But this returns an error. Following the pattern of someone's answer on a different help site, I then tried to just go...

Is there a way to not show a control/field name in a form if it is identical to the "line" above it? In my example below, I only want to see each client's name appear one time even though some number of subsequent records have the same client name. In the following simplistic example, I would...