Search results

  1. E

    Using shell in a function

    Hi Guys I have a working function that plays a movie on a form from which ever selected movies command button is pressed. Function PlayVlcPlayer(pstrVlcfile As String) Dim strVlcPlayer As String strVlcPlayer = Chr(34) & "C:\Program Files\VideoLAN\VLC\Vlc.exe " & Chr(34) Shell...
  2. E

    Turn a query Formula into a function

    Hi Guys I need Help to turn this query Formula into a function that saves the results to a table. The table name is ZHTCalc and the field is SeqID. The formula is SeqID: DCount("*","ZHTCalc","CoverID=" & [CoverID] & " AND SortID<" & [MovieID])+1Any Advice would be appreciated
  3. E

    How to display 10 Images horizontally on a continuous form using vba

    I have a form with 10 image boxes side by side set to continuous, I use it to display pictures from a folder. this I've done using a cross tab query to divide the picture column into 10 columns then assign a column to each image box. This works fine but its slow when running the query nearly...
  4. E

    Hello from Perth, Western Australia

    Howdy all I'm a new member to this forum. I know my way around Access pretty well, but I'm a novice when it comes to VBA programming and I'm trying to learn to write my own code. Being a disabled Pensioner it's like teaching an old dog new tricks So any help you patient guys can offer...
  5. E

    How to fill a Column with repeating sequence till full using query or vba

    I have a table with ID, and PositionID ID is Autonumber and PositionID is Number. ID is linked to another table of Records There is currently 3625 records in ID so HOW do I fill PositionID with the Number sequence of 1 to 10 repeating over and over till the last record and save to a temp table...
Back
Top Bottom