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!

  • Congratulations Chriss Miller 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: *

  • Users: pdldavis
  • Content: Threads
  • Order by date
  1. pdldavis

    Wmv Files on Web Page in Firefox - Refresh Page?

    Hi, I have two .wmv files embedded in a web page (I use Firefox) using this simple code: <object data="images/howl2.wmv" type="audio/x-ms-wmv" height="240" width="320"><param name="FileName" value="images/howl2.wmv"><param name="AutoStart" value="0"><object data="images/howl2.wmv"...
  2. pdldavis

    Cross Fade one time then stop.

    Hi, I would like to add to this code I found to where it performs the cross fade one time and then stops. The idea is to display a logo on my web page on load and then fade to the picture of the month. I know very little about js and would appreciate the help. This is the code: Image Cross...
  3. pdldavis

    Recordsets - not my strong suit.

    Hi, what I am trying to do is this: I have a table which lists out business months with a business month start and business month end field. I have a table which lists out quality incidents and the dates the incidents were found. I would like to cycle through the dates in the quality...
  4. pdldavis

    Declarations

    Hi I have a question about declarations. I understood this: Dim eAR, eCI, eCN, eEL, eME, eST As Long to mean all these items are delcared long. I was told that actually eST is the only one declared as long and the preceeding four are variants written out this way. The correct way to do...
  5. pdldavis

    Run a command built from a string.

    Hi, How do you run a command created from a string? I have: Dim txtString, txtDate As String Me.calDate1.Value = Now() txtDate = Me.calDate1.Value txtString = Me.txtFormName & Me.txtDateField & " = #" & txtDate & "#" This produces...
  6. pdldavis

    Updating Tables with differing fields....or something

    Hi, I am unfortunatly on loan to the programming department and have a bit of a problem. Table 1 has five fields and will always contain those five fields: Date Date (first monday of the week) (Primary Key) Electrical Numeric Mechanical Numeric Civil Numeric Structural...
  7. pdldavis

    Moving to next Item selected in a List Box

    Hi, I am trying to obtain the values of items selected in a list box for the purpose of building a string. I can get the count of Items selected and loop through the count but I can't move to the next item selected to obtain the next value. This is what I have so far: Dim frmCnt, frmListCount...
  8. pdldavis

    Field Titles in datasheet.

    Hi, I have a subform set as datasheet. The subform recordsource changes depending on user selection: StSql = "SELECT tblProcess.ProcessID as [Process Code], tblProcess.ProcessDesc as [Process Description] FROM tblProcess; " I would like the field headers in the datasheet to display as...
  9. pdldavis

    Access Citrix thru Rdp and Print Locally

    Hi, I have an .rdp that allows me to access a citrix server. The boxes are checked for allowing local drives and local printers. I can access citrix and run anything I wish on it, but cannot see my local drives or printers. I'm a bit out of my element here as to if this is possible. Reading...
  10. pdldavis

    Adobe Acrobat 6 Pro - Can't 'see' some docs.

    Hi, we have Acrobat 6 Pro installed on one computer and are having problems seeing files and it appears to be caused by some sort of gray scale setting for lack of a better description. If you take a piece of white paper and do a pencil sketch and then tiff and convert to adobe, the view screen...
  11. pdldavis

    Sorting Problem - Numbers and Letters - Max Value or ?

    Hi, I have a table that lists drawings and revision numbers. Revision Numbers is a text field. Revisions are lettered A - Z when a drawing has not been issued. Revisions are numbered starting with 0 (zero) when a drawing has been released for use. Example: Dwg Rev 001 A 001 B 001 0...
  12. pdldavis

    Clear Subform Filter

    Hi, I have a form with an unbound subform. The subform has several labels used for filtering on the onClick event. When I move off the subform, I need to clear the subform form filter and am not having any luck. I've tried on Lost Focus, On Exit and a few other things. What is the correct way...
  13. pdldavis

    The dreaded where clause - second list box

    Hi, I have two simple select list boxes , lstType and lstPriority I am using as part of the Where Clause. I can pick up all the itemsSelected from lstType but can only pick up the first item selected from LstPriority. I believe I need to do another For-Next with the second list box using...
  14. pdldavis

    Subscript out of range - building a list.

    Hi, I am reading the contents of a list box that contains computer names obtained from a .ldb file. I split the string and then perform a dlookup on each computer name to get the person's name who is in the database: Dim StrSql,strsql12 As String Dim varInstTypes As Variant Dim varInst0...
  15. pdldavis

    Form Filter - Radio Shows and Guests

    Hi, I have built a database that stores radio shows, guests and the related mp3 files. The main table has ShowID - Autonumber and show information. The guests table has ShowID, GuestID - Autonumber and Guest information The main form contains the show information. There is a subform that is...
  16. pdldavis

    Stopping a date building string.

    Hi, I have some code here I am working on where I am building a string of dates for a month excluding Saturdays and Sundays. This much working. I need to replace the For - Next statement with something like While it is this month, build the string. If a date falls into the next month, stop...
  17. pdldavis

    The 'Where' Clause & List Box

    Hi, I am having trouble picking up items past the first item selected from a list box and was wondering if someone would have a look at this 'Where' statement and tell me what I am doing wrong. If (lstTagType.ItemsSelected.Count = 0) Then Exit Sub For Each varItem In...
  18. pdldavis

    Runtime Error 2467 - object does not exist.

    Hello, I have a Time Entry Form that has a subform which is unlinked. There are a series of buttons on the main form that build the subform recordsource based on the user selection. This worked well and something has happened. What happens now is when the user makes his selection, the 2467...
  19. pdldavis

    Help with DSum - Two Criteria

    Hi, I have three Dsum Statements here. StaffTime 1 and 2 both work fine by themselves. I would like to combine these to make the Dsum statement I really want, which is StaffTime3. When I try combining them I get a criteria mismatch and I don't know what I am doing wrong. StaffTime1 =...
  20. pdldavis

    Format Chart for 11x17

    Hi, I am having no luck formatting a chart for 11x17 paper. I've played with Stretch, Zoom, Clip and cannot get the chart to fill the whole area. I have also tried setting the chart height and width from vb, but the same results. Any suggestions? Thanks

Part and Inventory Search

Back
Top