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

    checking dates wether they are previous or posta current date

    I want to take a current date and check it against existing entry dates. For integers you can say if x>y or if x<y, does the same logic work for dates. example var1=03/01/07 var2=04/01/07 if var2>var3 then......meaning if var1 comes after var2 is this right?
  2. autoIT

    vbokcancel

    i am attempting to use an inputbox but I cannot get the cancel function to work, how do i code it to actuallt make the input box go away if cancel is selected Adam
  3. autoIT

    PASSING VARIABLE FROM ONE FORM TO ANOTHER

    how do i pass a value ina variable from one for to the next?
  4. autoIT

    inputbox parameters

    Here is some of my code, whats wrong with it? Dim answer As String Do Until answer = "A" or "B" or "O" answer = InputBox("Would you like to update A,B, or O time?") Loop what is wrong this coding, I thought that is the right way to write it.
  5. autoIT

    Comparing variables to tables using currency

    OK easy problem but I dont know the cure: how do you compare a variable to a value in a table whose colum is set to currency. The variable is dimmed as currency as well. Here's an example if TempBid=rs.Fields.Item("Bid Amount")then ................... in other words the value in the...
  6. autoIT

    run tim error 3021

    ok pretty simple question: I am attempting to write date to a table. There is nothing in the table yet, therefore I get a run-time error'3021'. I am trying diligently to get write an error handler to get get that one first record in but to no prevail. This is a table that stores queries info so...
  7. autoIT

    data in date format

    I have a field of a table that has a date in the following format: OCT-1-06 I wrote a data base in VB that will do something specific if this field is OCT-1-06, or will do something else if this field is OCT-2-06, so on and so forth. My dilema is actually checking what the information is in...
  8. autoIT

    batch vs batchupdate

    Someone please clarify, I believe batchupdate updates all records as opposed to batch which only updates current reord correct? I have a simple data base with some textboxes for user input and a next and a previous button that moves a table to the next record and populates the texboxes with...
  9. autoIT

    07 vs 2003 properties

    in 2007 upper case is coded as Ucase(Name) I'm getting an error in 2003. What is the difference? Adam
  10. autoIT

    empty value for an date variable?????

    I have a table with a column set as date I have a textbox that I want a date entered into I want that value in that textbox passed into the table Issue is that sometime a value for a date is empty. I have tried many combinations for dimming a variable and setting the column in the table=date...
  11. autoIT

    Value will not clear from a textbox

    I have a form that works as so: There is a field for user input. This TextBox has an inout mask in it. The next tabstop is another textbox that is transparent and when focus is set on it will retrieve info from a table based on what the user has input. At the end of all this is a button that...
  12. autoIT

    deleting from a recordset

    if ***.delete will delete one record at a time, what deletes all records from a table with a single click of a button. I tried writing a do until eof loop but I get a multistep OLE Db error. Any suggestions? Adam
  13. autoIT

    opening and closing recordsets

    I am attempting to open a recorset gather info into variables, close that recordset open another recordset and put the info from the variables into that recordset. Here is a skeleton outline of my code: rs.open "employees",,,,,,,,(there are arguments here) rs.close rs.open"Query...
  14. autoIT

    help opening access to a form

    I need to be able to have an EU double click an access icon and have it open to a menu form. How do i do it. Adam
  15. autoIT

    stop code from running:require user input

    The DB is for HR. HR inputs information on the employee. If it's the first record of the year for the employee, the starting vaca hours will be set to 0. I have a msg box that asks if the employee has vaca hours to use or would they like to enter the ammount of hours the employee has to start...
  16. autoIT

    case sensitivity

    I've written an entire DB and cannot figure out how to make text in a textbox uppercase when sending info to table. Please help. Thanks Adam
  17. autoIT

    how does .find work??

    I am trying to figure out exactly how .find property works. Will it be better to use that the following code. I plan on having a button on a form that will retrieve the latest vacation time remaining based on the employees whose name is the employee names textbox. x=rs.Fields.Item("Employee...
  18. autoIT

    need help appending table

    OK i've been pulling my hair out here and my eyes are bugging out. I need another set of eyes to look this over. I am including code that will allow the EU to enter info for a new record and this info will be appended to a table int he same database. I will include the code from form load to...
  19. autoIT

    Type mismatch run-error

    ok i know this is a common freakin question, but i've been at this all day and i can't figure this out. I am including code from a db I wrote. it is the general declaratins and the form load page. When I dedug the error handler kicks in at the line that defines the recordset. I have tried it 2...
  20. autoIT

    trouble creating recordsets

    I think i need to activate a rference library, but maybe it's more than than: dim rs as adodb.recorset rs.open "Employees", cn, adOpendynamic, adLockOptimistic, adCmdTable **at this point when i start typing ad..itellisense doesn't give me options for any of these, anyone know why? also i...

Part and Inventory Search

Back
Top