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 TouchToneTommy 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: striker73
  • Content: Threads
  • Order by date
  1. striker73

    Row Height Issue

    I'm having trouble with a row height issue. I have a table with 4 rows and 3 columns. The middle column is going to hold text and is row spanned through all 4 rows. I would like the first 3 rows to be static heights that I have specified in my code. I would like the bottom row to accomodate...
  2. striker73

    Query Issue: Enter Parameter Value

    I have a query that has the following field: Planned_Test_Date = IIf(IsDate([TestDate]),[TestDate],"else") The TestDate field is a date field that is sometimes null. When I display the table, it looks like all of the entries are either a date field or null, so the data is fine. When I run...
  3. striker73

    Order By in Form properties

    I am trying to change the ordering of entries in my form by using the "Order By" field as part of the form properties. I have tried entering the field name (ie: MethodDesc), but that doesn't work. I also tried entering "MethodDesc ASC", but that didn't work. Any ideas? I could change the...
  4. striker73

    Sub Form

    I have a form that contains a subform. The subform contains a list of items (test types) that are pulled dynamically from one of my tables (TestType). The idea is that the user can go through the list and check off as many test types as he/she wants. These values are then stored in a...
  5. striker73

    Application-defined or object-defined error

    I have the following line of code in a VBA global module in my Access database, but I am getting an "Application-defined or object-defined error". Can anyone help me out? Forms!frmTestReport.chkScanned.Value = TestReport_Query.fields("Scanned") It looks like TestReport_Query.fields("Scanned")...
  6. striker73

    Outlook 2003 Date Recieved Time Stamp is off by 1 hour

    I have a client who is using Outlook 2003 for email. When she receives an email, the "date received" field is set to an hour before what it should be. The time on her computer is set correctly. I set up another computer to download her email and the date received field displayed properly...
  7. striker73

    isDate() function says invalid date is valid

    I am trying to use the isDate() function to do some data verification. I am importing data from one table to another and am checking text fields to see if they are dates or not. In the new table, they need to be set as dates. I have a query that I am running that is supposed to flag the...
  8. striker73

    calendar plugin?

    I was wondering if anyone knew of some code to use for a GUI for a calendar on a form? I saw one once that was made with ASP. What I'm envisioning is a textbox with a button to the side where the user clicks on and it pops up a calendar where he/she can click around and select a date. If not...
  9. striker73

    field name issues

    I have a really long field name (ie: Date_RMA_Part_Received_From_Customer) in my SQL Server database. When I pull the data out in my php form, I get an error: Warning: Field "Date_RMA_Part_Received_From_Customer not found in ... I have typed the field name correctly- I copy and pasted it...
  10. striker73

    OnClick supposed to go to pop up window

    I have the following code on my page: <form> <input value=&quot;Preview Saved Changes&quot; name=&quot;Submit&quot; onClick=&quot;window.open('table_preview.php?Product_ID=123', 'Table Preview', 'width=800, height=600');&quot; type=&quot;button&quot;> </form> Theoretically, when the user...
  11. striker73

    Union Query: Data type mismatch in criteria expression

    I am having issues with a union query of mine. I have a table that tracks certain tests. I have created two different queries (ie: one is all the tests that need a draft test sent, one is all the tests that need a final test sent), basically each query has the same exact fields. I am trying...
  12. striker73

    Two color printing

    I am entirely unfamiliar with creating Photoshop files for print media (I am much more familiar with web optimization), and I need a primer on creating an advertisement for print media. I would like to create a mailer, approximately 8.5 x 5.5 with color on something thicker than paper. As far...
  13. striker73

    (file) isn't a valid win32 application file

    When I right-click a file to open with Adobe Illustrator 10, I get the following error: (file path) isn't a valid win32 application I started with Illustrator 7 and have upgraded up to 10.0.3 (I think that's the latest one). Is there any way to fix this error? Thanks!
  14. striker73

    datasheet

    Is there any way to set up a datasheet in PHP? By datasheet, I mean some sort of table-view of the data in a grid format that allows the user to edit information just like they were just looking at the table itself. Is there anything like this available in PHP?
  15. striker73

    datasheet?

    I am new to ColdFusion and I was wondering if there is any way to set up a datasheet in ColdFusion. By datasheet, I mean some sort of table-view of the data where the user can see a grid of data and type in any data field he/she wants and be able to update a database.
  16. striker73

    character limit on textarea (HTML or JavaScript)

    Is there any way to set up a character limit on a text area in an HTML form? Is there any Javascript function that will work kind of as an OnMouseDown() event?
  17. striker73

    date format: MM/DD/YY

    Is there any way to format a date on a report to display in the MM/DD/YY format? Thanks!
  18. striker73

    Microsoft Access can't find the field '¦' referred to in your ...

    I am running into the error message &quot;Microsoft Access can't find the field '|' referred to in your expression. My report is tied to my query which contains a field called &quot;Next Due Date&quot;. The line of code that the compiler is having trouble with is as follows: If IsNull([Next...
  19. striker73

    redirecting users

    What are other methods for redirecting users to a different page? So far I've been using: echo &quot;<META HTTP-EQUIV=Refresh CONTENT='0; URL=mypage.php'&quot;; exit; What are other ways of automatically redirecting users to a different page? I'm trying something tricky with dynamically...
  20. striker73

    ORDER BY clause

    I have a table called WorkOrder. I ran a query that says &quot;SELECT WorkOrder_ID FROM WorkOrder WHERE Order_ID = '16'&quot;. This query returns the following: 80 81 82 I run the following query: &quot;SELECT WorkOrder_ID FROM WorkOrder WHERE Order_ID = '16' ORDER BY WorkOrder_ID&quot; and...

Part and Inventory Search

Back
Top