Search results

Does anyone know if it is possible to use code to move to the next record on a form without opening a recordset. I am trying to loop thru records on a form in code behind another form.Basically I need to mimic a key press or a click event in code.

This code is finding an estimate based on one selected on a form and then editing a field on this record . Maybe there is an easier way of doing it.

That's correct, the users tell me the part names are never the same but I'm not convinced. It makes it even more complicated when the partno or name can be blank.

25000 and growing. It's taking about 6 seconds. I'll change the &'s

Thanks mate, everywhere else I use it I am searching on the PK field so the indexing was already done. Thanks alot

The following piece of code is terribly slow in my app. How can I speed it up. If Me.txtpartno = "" Then MyPartName = Me.txtPartName rstEst.Find "PartName = " & "'" & MyPartName & "'" Else MyPartno = Me.txtpartno rstEst.Find "PartNo = " & "'" & MyPartno & "'" End If I have used the rst.Find...

I am using autoexpand on all my combo boxes but it doesn't seem to work if the field is an autonum (should it) ? It works fine for character fields.

Is there a Max Records limit set on your query or form ?

Just discovered a problem with this - when you email the report both &'s appear.

That did the trick (couldn't find it the last time- bad day) now I hope someone can help. Here it is.

I am getting the error You can't assign a value to this object when I try to enter data in the Part No field when i am adding a part. I have narrowed down the problem to the Master Child link but I have used a similar link on other forms and there is no problem. I have tried to attach my...

That happens when I try to run it Access reformats it that way.

This is what I am trying to do in Access 2003 .adp SELECT rec_batch, rec_jobid FROM tblctmist WHERE (rec_batch <> ' ') AND rec_jobid = [Forms] ! [frmWorksOrderComplete].[Form] ! [fsubWOrderHead] ! [txtjobid] ORDER BY rec_batch DESC but I get an invalid sql error

Found it I think it was Active x. I was using 2.8 instead of 2.5 but I'm not definite on that. I removed most of the references and then readded the right ones based on a back up of my app.

This error has just started to occur in my app. The only thing I can think of that may have changed is some references have been removed. Which reference (if any) would cause this error. If thats not the problem what is. This was fine for the last 6 months.

Perfect thanks.

I am trying to use & in a label in a report but it is not being displayed if I replace it with + it is fine but I need the & to match company stationary.

I have a combo box on my form and I need it to show all distinct part numbers as this then provides the record source for a form. The problem is that I can only get it to display 10000. if I then go to the query and change it I can see all recs but when I run it again it is back to 10000 again...

Your posts have just showed up now. I used your code and it seems to work great after I made a few changes to the way I had other bits written. Thanks a million for all of your help. Hopefully I wont be back on this topic again.

In a standalone mod and I have tried referencing the module and the function. .adp might be more hassle than it is worth