Search results for query: *

I have a 300-page word document with some data that I have to use a macro in Word to copy and then am trying to paste into Excel. I got this to work with one copy/paste, but how do I send the focus back to the Word document, and run another macro in Word, then copy/paste back to Excel? Here's...

I have a client who wants to create a spreadsheet that will have a column that alternates between a "0" and "1" flag. He wants to send all the "1" flag records to a separate spreadsheet and print out the area. I could easily do this in Access with a query and make a new table, but how do you...

Last week I thought I'd try Firefox. After an hour or so, I noticed that when I wanted to copy anything in Excel and paste in Word or Publisher, I couldn't do it. So I uninstalled Firefox from the Control Panel and it helped--but now I still can't consistently copy a chart, text...

This would seem easy but I can't find a way to get it work. I have a Powerpoint presentation with 24 slides that are in Portrait orientation. But I have two slides that have to be landscape orientation. Whenever I change the orientation in the Page Setup area in Powerpoint, it changes the...

I have a basic recordset coding problem that is stumping me. I want to flip a SELECT flag whenever the IDNUMBER changes, but this would be the last date associated with that IDNUMBER. Here's what I've started: Dim Dbs As DAO.Database Dim rst As DAO.Recordset Set Dbs = CurrentDb() Set...

I posted a question like this a couple of weeks ago, but I still can't get it to work. Let me do a better job describing what I need. I have a table full of street segments and addresses. Street Name Start Address End Address MAIN 1000 2000 MAIN 1001...

I have a table of streets, such as Main Street. I want to build a lookup form such that when someone enters the address "123 Main" they will get a message saying they are in the Blue Zone. Main Street, for example, may have a range from 1 to 4000, and addresses from, for example, 1 to 150 would...

I have a client who wants to have an Access database on their server and the capabilities of users to type in a street address on a web page, and the web page would show several possible addresses, from which the user could select one. After the selection, a map would pop up showing their...

I'm trying to insert a record having only one field, VOTER_ID, into a Holding Table before the record is actually deleted from a main table. I just can't get this code to work. (I'm getting a Syntax error from ASP)Can anybody eyeball it and see where the error is? ------ set dbConnection =...

Here's a problem I've spent almost a week trying to crack, and I'll raise the flag here. I have three recordsets to loop through. One of the recordsets, rst1, may have only one record in it but it needs to change the fields each time it loops through the code, if there are records. The rst1...

I have several tables that I would like to use the recordset object to update. An example of the first table looks like this: Col1 Col2 Col3 Col4 Calculation Record 1 1 2 3 4 45 Record 2... 52 Record 3... 59 And...

I'm having a tough time with something that should be a snap. I have a combo box on a form and I just want to move the values from the combo box to the code so that each time the code runs, it selects the combo box values. Each of the tables I want to open end with "_Enrollment" and the names...

I need help on trying to do something.I have about 15 tables that are structured like this: Year1 Year2 Year3 Year4 Forecast Record 1 1 2 3 4 Record 2 5 6 7 8 I want to calculate the following formula, with the above number substituted...