Search results

hmmm. Mind boggling. I changed the code and it works. Before I posted orig post however, I checked in the immediate window the following: ?txtDate.text and got 6/9/2007 then I tried ?cdate(txtDate.text) and got 6/9/2007 and then I tried ?Date and got 6/10/2007. But I changed the code as...

I have code that is activated by a command button. One of the first things the code does is check the date that a user has just input and in the specific code below, it makes sure the date is not a date in the future. When this code executes however, the if then below is determined to be...

I worked around the problem by doing away with the param array argument altogether and just declared a public array that holds the information and that can be accessed by the call addseries subroutine.

I'm looking for a recommendation on an excellent book about the subject of visual basic (I'm using vb6). I don't want a beginner's book, I want something that gets into the real meat of programming with VB. Any suggestions? For reference, I have a VB5 book and while it teaches the basics...

I have code that is used to build graphs in Excel. A particular section of the code takes input passed via arguments in the call line of code that identifes a section of the associated spreadsheet from which a series of data is identified to constitute the data to be displayed on the graph just...

can't explain it as the lost focus code was written first and only after that did not work did I move to different code in the after update event.

ahhhhhh......explains a lot. You know, I haven't had anything but trouble with this database since I tried to get fancy and put subforms inside the main form... It's mind boggling and frustrating. You read the help screens, you read your reference books and get nothing. google search is like...

Way cool for the assist. I'll add the code tonight when I get home. Any thoughts on why me.txtordernumber won't work?

sorry bout that. It's the frmPartsInformation. textbox is txtOrderNumber

just sent you a pm.

Can't find anywhere else to post this so... When I joined this forum last month, I attempted to enter my current email address and I got a message box that my email address had been banned. I tried several times to enter the correct (current) email address and each time was told that email...

ok. here it is.

Yes. it will take me a couple days as I'm going out of town and won't get it done before I get back. Should be posted around Friday/Saturday time frame.

ok. did that. default value does not change. additionally, code no longer changes default value of text box. If I didn't say this, the textbox is in a subform to the mainform. Does that change anything? thanks.

Is this what you're asking: if me.txtYourTextbox>0 then 'calculations here with your textbox when it's greater than 0 else 'other calculations here when it's <= 0 end if

it's a bound textbox. If I import, you're saying build the form again from scratch, right? I guess I'm reading what you wrote two possible ways: 1. export data to blank database, then build new form 2. new blank database, export form to database. I'm hoping you meant #2....Am I right...

no. default value at the table level is blank. no quotation marks, just blank. Also, remember that when I check the text box's property sheet, it shows the correct default value, ie the one I changed it to via code...

I did a search both here and google. I found previous discussions and tried to implement what I learned from them but my problem continues... I have a text box in a subform to a form. When I enter information in this textbox, I want it to become the default value for the next new record. I...

I know. I played around with that as well in the immediate window. It didn't seem to have any effect and I took it out of the code (at least in the immediate window code).

Interestingly, this is what I get when I paste into the immediate window: ?"[chrordernumberfromparts] =""" & strOrderNumberFromParts""" [chrordernumberfromparts] ="s1543cg31119865" ?"[chrordernumberfromparts] =" & strOrderNumberFromParts [chrordernumberfromparts] =s1543cg31119865 I can see the...