Search results

Yes. I thought I had solved how to find it in the other thread, using instr and replace if I remember correctly.

The value of the field. In my code, the RS!FieldName is the column name.

Try something like this: Do While Not RS.EOF If RS.EOF then Exit Do 'May not be necessary. fieldvalue = RS!FieldName.Value RS.Move (0) 'To requery the field for editing RS!FieldName.Value = Replace(fieldvalue, Left(fieldvalue, InStr(1, fieldvalue, "#")), "") RS.MoveNext 'To move to the next...

Fieldvalue needs to be the current fields value, not the string value. I'll need to check when I get to work in a few hours, but it seems as though you might need a for next, or a do loop to go through the fields. And for each field the value in the current field will be fieldvalue in the...

Well: If isnull(OP_ID) then op_idvariable = "*" else op_idvariable = OP_ID end if strWhere = text '" & op_idvariable & "' text" I guess I still don't understand why OP_ID value and/or text is showing to be "-1" instead of text. Oh well, see if above solves your problem.

Try doing .text instead of value. Or if that doesn't work, leave off value and text all together and see if it works then.

The value is the value of OP_ID. I'm not sure what OP_ID is, so I can't help you as to why it's returning that value. Seems to me, it'd be best to do an if "-1" then "*" or set the OP_ID.value inside strWhere as a variable so that it's easier to control, but I don't think I have nough...

Well, I'm not quite as familiar with the Access side of it, but I have done something similar in Excel. It's going to be a combination of the instr, left and replace functions. From what I can tell so far, the 001# is before the value you need. So, we know what to look for, #, and use the instr...

Well, from looking at the code, he wants to put in the day count. Otherwise I don't understand the reason he would have a text box for amount of days.

That does what you need it to do right?

Well, like I said, I'm just beginning to learn it along with MS Access VBA (used VBS and Excel VBA, fairly extensively over the past 8 or so months) and the SQl statements I've seen are fairly simple if you don't let them get you overwhelmed. Granted, you're right, I've only used MS SQL...

Nevermind, I've looked at your code and realized what ya were trying to do. try this: Dim intCount As Integer Dim Myenddate As Date Dim Tempdate As Date intCount = 0 enddate.SetFocus Myenddate = enddate.Text numofdays.SetFocus Tempdate = enddate.Value Do Until intCount = numofdays.Text...

I'm a little confused, help me out a little bit. If you get an order on Monday, when is it supposed to leave? The following Monday or Friday?

Now, I'm not quite sure this would work, but I'm having a similar issue that I've seemed to solve for my particular problem. Note: Please someone correct me if I'm wrong. The solution I've found is in two steps: 1) I link/import said csv file as a temp table that'll soon be deleted. 2) Execute...

I user Crystal Reports here at work before I started using MS Access and it seemed like Greek to me (I'm not Greek, fyi). So, I'd have to say that VB has helped me the most when using Crystal and MS Access. SQL is actually fairly simple, too me at least, but then again, I'm just now starting to...

I know this has been discussed before, but it seems to me that you'd want to use a combo box instead of using 26 buttons?

After further research, I discovered my data had been "corrupted", when I had opened the csv files in Excel. Also, after those corrections were made, I needed to have a spec template for when I imported that one csv file. Any ideas on why I wouldn't need a template for any others?

After some looking around, I need to have this thread moved to the Tables forum. The reason it was dropping some parts is that the parts serial numbers are "05130520101121" and "05130520101357" respectively. After changing the field to indexed (duplicates ok), the serial numbers show up as...

Preface: I don't know where to post this since I'm using a VBA executed SQL command or if this is a table issue. I'm trying to import a .csv file into a "master" table of several .csv files. I've figured out how to link them and import them even though they have different field names, but the...

Thanks EMP, not sure why I didn't see that, or hell even think of that option.