Search results

Yeah, I discovered that fatal flaw today, literally just before checking this board again. Thanks for the post though, appreciate the contribution.

I'm pretty sure 'Else If' exists in VBA...maybe you could've considered using that to help condense the code? Then again, I don't really use VBA all that much and don't remember for sure, but just a suggestion!

Tried it, but it threw a "Method or data member not found" error. Thanks for posting though!

Hey all...again... Alright, so the code I've got now works, runs, and doesn't throw any errors, however it doesn't quite work right. What the following code is supposed to do is grab two values from one table, smash them together, then place them into another table : Public Sub...

I've updated the example to better reflect the data I'm trying to perform this operation to.

Hey everyone, new question. Is there any way possible to have row breaks in the imports specs of access 2000? While the data I'm importing is mostly in columns, it does change its "header" (if you will) for different customers. I suppose you could look at it like bank account transactions. See...

Thanks pbaldy, slid this into my OK cmd button code and it worked like a charm, except in place of the hard-coded date (#06/15/2008#) I used the value of my text box (txtDate.Value). Thanks for the help, its much appreciated!

Hey everyone, I'm new here and looking for a little help. I've got a table that has a date field, and I need that field's default value to be assigned to a user-entered date. I've tried the following: - Having the date field's Default Value option call the text field on a form that the value...