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 believe it is v 6. It is a very simple db application. Who would have thought ACT would make some fields into not-fields and difficult to access.

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 made a mistake in my posting. The code I posted returned a fill on purpose. The code generated to remove the fill was: With ActiveWindow.Selection.ShapeRange .Fill.Visible = msoFalse .Fill.Solid .Fill.Transparency = 0# End With

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 understand everyone's point about telling other people they need to do things the right way. I stopped tilting at the windmill of perfection long ago, it just is a lot easier and more peaceful to do what people ask. In this case, I am asked to just add a minute to the times in the macro...

...Dim lLastGRow As Long lLastGRow = ActiveSheet.Cells(Rows.Count, "G").End(xlUp).Row Range("H2:H" & lLastGRow).FormulaR1C1 = "=(RC[-1]-RC[-2])*24" Essentially, the cursor is in the column that needs the total and it subtracts the entry 2 columns to the left from the entry 1 column to...

The problem of not seeing the entire record is solved. I used the third option in the combo box wizard to look up a record. If I do not find an entry in the combo box drop down, then I want to enter a new record and would prefer not to make the user go to the bottom of the form and press the...

I am doing something wrong. I have a form and the source of the data is the customer table. I have 3 dummy records with names as first & last, first2& last2, first3 & last3 as the entries for fname and lname fields. (I also have an address entered for the first record.) I created a combo box...

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

I think the problem is that you do not work extensively in PowerPoint. I am sorry that you are upset that your response did not answer my question. I am sorry that I cannot make use of the tool you provided as I am sure it works very well. Now that I have apologized, maybe you can stop with...

I have no idea how this answers my question. I do not want to search for text boxes. I do not want a list of existing properties for existing text boxes. I want to create a macro that will give me just one step (run a macro) when I want to change multiple properties for any text box I...

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

Yes, I think I want a full outer join. I have two tables and want to see every record in every table, in both cases regardless of whether there is a matching record in the other table. So do I understand correctly that I will essentially take the entire SQL code I posted but with a LEFT OUTER...

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