Search results for query: *

here is a better example of what i mean If rs.Fields.Item("Pay Period") > TempDate Then i am not using the dates per say, the date is in avariable in this case the variable is tempdate. I wouldn't put #tempdate#, would i?

so by adding #date# will compare one date against another to see which one is the most recent? Adam

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?

answer=inputbox("Enter A,B, or O") **I have a do loop that assures something is entered but I need have an "escape plan" by selecting cancel, and have the inputbox go away. Adam

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

Option Compare Database Option Explicit Dim Rep As String Private Sub Form_Load() Form_Input.cboRep.SetFocus Rep = Form_Input.cboRep.Text Like this, still doesnt get the variable, could it be b/c its attempting to get a value from a combo box? Is there a way to set a Variable = to the...

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

OK one more for you guys I want to check 2 condition on one line of code: for ex. if A=1 and if B=2 then ........ is this right?

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.

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...

ok i know im all over the place here, i see what the update function will do, problem is when it comes into this part of the code bidcounter.addnew, it attempts to make a new line on an already empty table, how do i avoid this making sure every time thereafter it creates a new line

problem is i do not want to record every instance, just want to count every instance and put the total instances on one line with the vin #

will that get rid of my error, and if so how?

this also include my attemp at the error handler Private Sub btnQualify_Click() Dim Ctr As Integer Dim TempVin As String Dim VinKeyAnswer As String CurrentDb.Execute "delete from BidCounter" On Error GoTo error_handler Vehicles.MoveFirst Do Until Vehicles.EOF TempVin =...

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...

what i meant was i know where it is but im not familar with how it works

im aware of how to step through but where is the wtach window.

thought about the selec case and by your suggestion tried it but still getting the bof/eof error: also have period variable set as date and column in table I'm sending the data to and the colum in which the info is coming from set to date as opposed to text. Just not sure what else to try. Adam

just tried it and i see what it does, but it turns the date into xx/xx/xxxx format and it needs to be OCT-1_06 format because OCT-1-06 represents first 10 days in October OCT-2-06 represents second 10 day.....

skip, never saw the pound sign coding before, would this work if i'm using access 2007 and vb. What do the pound signs represent, are they a wild card of sorts? Adam