Search results for query: *

That was the problem. Again, Thanks for looking.

I think I found my problem. I have a database where information on the "Map" that is in PDF format links to comments, gate codes etc. via the "Path". My code passes the "Path" string and not necessarily the files true location. (On my work computer they are the same) When I moved it off of...

I'm using code I found a few years back that was posted at a VB site used for printing *.PDF files. Here is the code that calls it. On Windows 7 Machines the lStatus returns 2 and sAcroPath returns nothing Private Sub PrintPDFs(PDFArray As Variant) '' Accepts one dimensional array PrintPDFs...

Private Declare Function FindExecutable Lib "shell32.dll" Alias "FindExecutableA" (ByVal lpFile As String, ByVal lpDirectory As String, ByVal lpResult As String) As Long I have a program that prints *.pdf files using DDE and must open Adobe Reader to work. The program works on the XP...

I did a google search for "vba to read com port" and found this. http://www.thescarms.com/vbasic/commio.aspx You might also be able to reference the comm control (never tried it) Hope that helps.

This is from a VB6 forum but it should work faq222-179

Control + spacebar will pop up intelisense for properties and control names etc. I don't think access IDE has a way to show field names.

Also note, fewer records does not equate to fast speed, especially when the server can utilize indexes. Search the net for SQL performance tuning etc. and there are several examples where they create queries and show examples where, depending on the number of records, different methods run...

Check this out, it should answer your question and then some http://www.sql-server-performance.com/tips/t_sql_where_p2.aspx

Are you using a control array or just a series of command buttons or ??? You did not offer much information on what you are trying to achieve. Did you know there is also an on screen keyboard that comes with windows? thread222-1589849

I think you are over complicating it. Make sure the textbox has multiline set to true and set the focus to the textbox. I tested it using strongm's code with the setfocus to the textbox and it worked. Option Explicit Public myExec As Object Private Sub Command1_Click() Set myExec =...

If you want to futher limit the number of vin numbers that show up in the listbox, the code below clears the listbox until there are at least 3 letters or numbers entered into the textbox. When I created the program this ran on there were over 200,000 APN numbers and it work great. Private...

If you would of created a simple test form you would see that the listbox filters down with each letter or number added. In my test app the database has 150 names, enter "a" and every name with an a shows up, now a "d" = "ad" and only names with "ad" etc. to the point that you are down to two...

Another option that might work better would be to add a listbox that displays the vin numbers and as they enter the vin, update the rowsource. I tested this on a small database I have with a personnel table and it works. I did a similar thing on another program I created some time back that...

What are you using as a criteria to find what is "Not IN" table B ? Seems to me a simple query would be your best method, not VBA You could use a left join or a "Not In" type query to show you the records not in table B

I assume there is more code then that, but the problem you are showing is probably because you do not have quotes around the yyyy's Try this Private Sub Command0_Click() Dim tday As String tday = Format(Date, "yyyy") MsgBox tday End Sub

You did not say which flexgrid but msFlexGrid has: FlexGrid1.TopRow = 1

Take a look at this, you might be able to make it work, you did not specify what SQL server version you are using. (MS SQL server 2005 and above, I believe, have crosstab functions.) http://www.sqlmag.com/Articles/ArticleID/23162/23162.html?Ad=1

That is because each entry is missing 59 seconds 8:00am - 9:15am = 08:00:00 to 09:15:00 skipping 09:15:01 to 09:15:59 (Not counting 100's) 9:16am - 10:15am = 09:16:00 to 10:15:00 skipping 10:15:01 to 10:15:59 (Not counting 100's) 10:16am - 11:00am = 10:16:00 to 11:00:00

For 1, you are pulling in all of the records from the table. how big is the table? Next, since you are just adding a new record, why not create an insert statement and then use DoCmd.RunSQL to do the insert?