Search results for query: *

I have adobe acrobat and ms office 2010." OP explicitly says they have Adobe Acrobat. I don't feel like that's so much an assumption as me having read the post and trusted OP to know what they have installed. YMMV. TMTOWDI - it's not just for Perl any more

You can gain access to all the functionality Acrobat exposes through what it calls IAC (Interapplication Communication) by setting Acrobat as a reference in your VBA project. Then your pseudocode would look something like this: 'create an adobe AVDoc document object 'open the pdf file in the...

Hi, people. I asked this in the Flash forum, but there doesn't seem to be a lot of activity there. If any of you are well-versed in interactions between Flash and VBA, could you please look at my post over there? http://www.tek-tips.com/viewthread.cfm?qid=1622825&page=1 Thanks for any insight...

Hello, a colleague has asked whether it is possible to use VBA to walk a Flash (.SWF) object to find out what objects and methods it exposes. In particular, he's looking to find the names of text fields he can set or retrieve while the app is running. Is there any way to do this without...

Thanks and stars around. :) This should do what I need in this case. TMTOWDI - it's not just for Perl any more

I'm using .addnew because that's what Sussman and Smith taught me. ;) I'm unfamiliar with the "@@@@IDENTITY" notation. I'm also a little weak on raw SQL. Can you explain in a little more detail what's going on in your code, please? Thanks! TMTOWDI - it's not just for Perl any more

Hi, can I get some opinions, please, on what's the best way to make the record just added with .AddNew and .Update the current record? E.g.: dim rst as DOA.Recordset set rst=CurrentDB.OpenRecordset("tblExample") rst.AddNew rst.Fields("SomeRandomData") = "Trivial Fact" rst.Update ...

The difficulty isn't in refreshing the display, it's in changing the value to be displayed. You'll need to either store that value in your table and make the control a bound control, or have a way to reconstruct the value and use code in OnCurrent() to set the control to this value. If I...

Is cmdReports on the same form as the date fields you're using? If not, is this form open and does it have valid dates in those fields when you test the function? Really, seeing *one* example of the full query, the output when you click your button, and the output when you open the query as a...

This method works fine for me in Access 2000 with Office 2007. Can you provide an example of one of the queries that isn't working, and the results of the query itself when you open it from the database window? TMTOWDI - it's not just for Perl any more

Print #lFnum, sOutput; TMTOWDI - it's not just for Perl any more

Requerying an unbound control won't really do anything. If you need the Jurisdiction combo to remember what jurisdiction is associated with a particular record, you'll need to store or be able to reconstruct that information. Another way: with Jurisdiction unbound, it doesn't have a "value for...

scripting the clock in/out" depends very much on what you want to do with the information. To do it *right*, you'll want to design your app so it remains useful if your brother's business is successful to the point that he needs more employees than he has friends than can be implicitly trusted...

You'll want to start with something like this: SELECT tblDevice.EID, Count(tblDevice.Cell_Number) AS NumPhones from tblDevice GROUP BY tblDevice.EID HAVING Count(tblDevice.Cell_Number)>1 This will give you a list of all your employee IDs that have more than one cell number, and how many they...

I can think of a couple of ways to validate the even quarter-hours rule. The easiest is probably to multiply the number by 4 and see if you have an integer. If not, flag the field and instruct the user to enter appropriate data. For the exploding zeros, I'd suggest setting up code for OnEnter...

Dim rstSrc as DAO.Recordset Dim rstDest as DAO.Recordset Dim fld as Field // do your stuff to get the desired record into rstSrc // and point rstDest at the destination table // Loop the following for each record you want copied: rstDest.AddNew For Each fld in rstSource.Fields...

If the checkbox doesn't relate to a table field, what you would do is generate the query SQL in code. E.g., Dim strSQL as String strSQL = "SELECT * FROM tblData WHERE " If [chkOne] Then strSQL = strSQL & "[Field1] = '" & txtOne & "' AND " End If // additional conditions as desired for any...

My first guess is that it has to do with user permissions in the OS. For users who get this error, do they have access to the search functionality of the OS via Start -> Search? What about for users who do not get this error? TMTOWDI - it's not just for Perl any more

Then you've misspelled the name of the form or named it to something other than what you think you have, probably. What's the name of the form now? TMTOWDI - it's not just for Perl any more

Check out DoCmd.OpenForm; it should do what you want. You'll just have to pass it the appropriate query to use as a record source. TMTOWDI - it's not just for Perl any more