Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. shaiss

    Save DataGridView Control to my.settings

    I have a DataGridView Control that looks like this _________________ Name1 |Name2| _________________ JOE |JOE | _________________ SHAI |SHAI | _________________ STEVE |STEVE| _________________ STEVE |STEVE| _________________ I have a button called "save" What I want: When...
  2. shaiss

    Probem with WHERE only in code

    Hi Everyone, Thanks ahead of time for the help. My Code: Private Sub btnExport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExport.Click Dim Conn As New ADODB.Connection Dim Rec As New ADODB.Recordset Dim SQLqry As String On...
  3. shaiss

    Using PHP to get the ID3 tags of all the mp3 files in a folder

    Trying to use id3 code found on http://www.go4expert.com/forums/showthread.php?p=22064&posted=1#post22064 which worked fine, but I'm trying to step through each file in a directory and get the id3 info Here's my code <HTML> <HEAD> <TITLE>MP3 Playlist</TITLE> </HEAD> <BODY> <?php...
    • shaiss
    • Thread
    • Replies: 1
    • Forum: PHP
  4. shaiss

    Connecting to dat file from access or VB

    thanks dhookom, True MS shouldn't support it. But if the dat file is just a flat file it shouldn't be complicated to import it. What I don't understand is why I'm getting the #num error. I'll post some screen shots later. I guess thats my main problem, the #num error. I can create the link...
  5. shaiss

    Connecting to dat file from access or VB

    Thanks JeremyNYC, I will try this when I get home. Seems like access should just easily be able to read the dat file. But it doesn't surprise that MS would make it complicated. Do you know if I use your meathod, will the DB updated in real time? Or do you need to hit a "refresh button"...
  6. shaiss

    Connecting to dat file from access or VB

    Hi there, I'm trying to connect to a dat file used by auction sentry (popular ebay bid snipping program). I need to have a linked table of some sort, that upon oppening the access database connects to that .dat file. I have the layout for that dat file as it is a fixed width file. The import...
  7. shaiss

    How to close Excel from Access using VBA?

    Yeah, there has to be some way to kill the process itself. Maybe finding the window handle and sending the kill message?
  8. shaiss

    Text Box - Line Breaks

    this all seems way to complex, why not use iif(isnull([MyVar]),"",[MyVar]). I use this in all my reports to eleminate the blank fields. A concatenate would look like this: iif(isnull([Title]),"",[Title]& " ") & iif(isnull([FirstName]),"",[FirstNamee] & " ") &...
  9. shaiss

    How do I create a Running Clock on a Form?

    You dont need to declare StringVerb its not used. You only need to declare variables your going to use. I was using it to test the code, so you can remove the stringverb=15 part. I would create and unbound control on the form with the controlsource=[HoursAndMinutes]([TimeOut]-[TimeIn]) and...
  10. shaiss

    NEED HELP:dynamically passing variablesto subforms

    I use this code to hide my forms, but ive used it to change fonts on open forms so i think it'll work for you Function ShowHideForms(View As Boolean) Dim frmCurrent As Form For Each frmCurrent In Forms frmCurrent.Visible = View Next If View = False Then DoCmd.Maximize End...
  11. shaiss

    Can't open MSWord app from Access 2000 db!! Help!!

    This error occurs in excel as well. when you .quit the word object your just closing the created instance of word. The problem is your not closing the word.exe process, so when you open word again it gets confused. Try this: run your function, then close the word.exe process from the task...
  12. shaiss

    call cmdsave_click from key press event..

    I think this will work, i havnt tried it, but here goes: Private Sub txtQ28_KeyPress(KeyAscii As Integer) call ASCITest(KeyAscii) end sub private function ASCITest(KeyPressed as Integer) if keypressed=enter or keypressed=tab then call cmdsave_click end if end function i think that should...
  13. shaiss

    How do I create a Running Clock on a Form?

    Hope this helps, DoCmd.SetWarnings False Dim StringVerb As Long StringVerb = "15" DoCmd.RunSQL "INSERT INTO YOURTABLE( YOURFIELD) " & " SELECT " & YOURVARIABLE DoCmd.SetWarnings True YOURTABLE= the table to insert the record into YOURFIELD= the field in the table to insert the data at...
  14. shaiss

    Adding Data to Calendar Control ?

    maybe have it use the calendar check the for and based on the that use conditional formatting to change the font. Basically all days have an X but it blends in the back, but when hes sick the condition is true and the font is set to red. hope this helps
  15. shaiss

    Fixing the size and position of a form

    I read this topic and all the threads but havnt found an answer. I have one form thats set to pop-up but and auto-resize. But for some reson it wont. It opens as a datasheet with 2 coloms. For now theres only 10 records, but that may grow to 50 soon, i want the form to resize with the list...
  16. shaiss

    Ensuring that everyone has the current Front end and doesnt change the filename

    I've read the two FAQs posted here and searched on the net for ideas. Basically, the two here didnt work, plus, why rely on VB scripting, and what if you dont have access to the startup folder. this is my solution. All done from within Access. The DB opens and compares its version to the...
  17. shaiss

    How to close Excel from Access using VBA?

    I've searched the web for hours trying to figure out how to open, print, then close the excel file. This is all triggered by a button on the switchboard. Well, this code seems to do the trick. Only one problem, when i open another excel file manualy excell doesnt seem to repaint itself. I...

Part and Inventory Search

Back
Top