Search results

File look up I tried your suggested code and get a similar response to the previous method. I think it might have to do with the reference library, but in both cases, I have selected the required reference library and still does not work?

Same problem I too am having the same problem. I have the reference library check (office 10) and have tried several bits of code but alway come back with the same problem. Any comments?

Can anyone tell me how to make the .find method in vba(excel) find an exact match. I need to return nothing from the method when an exact match is not found. ex: I need to return "nothing" on a search for "1230L200"...even if "1230L20" is in the list. .find is returning a range even if...

Thanks for the input. I had trouble with the Right() function when the entry ended in #.0 it was not picking up the 0 it would pick up the first number to the left of the decimal point. I went with using the mod operator to determine if the value was divisible by .5: Private Sub CheckMod()...

I am trying to create a validation rule on a text box so that the user can only enter a number that is in a .5 increment. ie: 1.5 is OK 2.0 is ok 2.6 is NOT OK Here is what I have in the validation rule property field.... Like "*.0" Or Like "*.5" but it will...

I am trying to create a new export spec... problem is that I can not get the Export Text Wizard to fire up so I can not get to to where I need to define and save the new specification. I am selecting the query I want to export... clicking save as/ export... then choosing "to external file"...

thanks, an interesting thing though.... I am using office xp developers edition... When I fired up an access 2k db it loaded fine.. didn't even ask me to convert it.....hmmm question is: if I save it in xp will it open again in 2k.. I guess I will find out tommorow. I was out of the loop...

Can I install access 2000 on my machine that already has access xp installed? I would like to be able to use both on my machine at home.... at work we use 2000. Is there anything special I have to do or can I just go ahead and install 2k?? thanks for the help Pungent

thanks.... there was two spaces in name! as it turns out the reason it was not working was that there were two side by side spaces in the file name...... thanks for the help.

I am trying to work with a series of excel files from access that sometimes have spaces in the name..... example "Hello World.XLS" instead of "HelloWorld.XLS" I have no trouble opening space-free filenames but when there are spaces , I get a file not found error. Is there a way to open files...

resolved thank you all for the help... I went with fGetEstimate = rst4.Fields(0) it works great... thankyou

perhaps you could help me by giving me an example of the syntax... I have tried fGetEstimate = rst4![0] and it did not work also fGetEstimate = rst4!0 also fGetEstimate = rst4!"0" thanks for your help

I have a bit of code that creates a one field recordset... however, the record set does not always contain the same field. How can I reference the first field in the recordset without always knowing what the field is called? I sthere a way to reference it by its index?? for instance does...

RESOLVED I fingered it out.. .thanks to using a better search string on this forum.... I removed the reference to active x data objects 2.x and it cured the problem. RESOLVED thanks all.

when I run this code I am getting a type mismatch error showing up at "Set rst ........." line of code. I don't know why.. Please help. Thanks Dim rst As Recordset Dim dbs As Database Dim var As String Dim sql As String Set dbs = CurrentDb var = Forms![sFrmTimeRec]!cboJobNumber.Value MsgBox...

Thanks.......That werks great!! Don't know why I didn't think O' it meself... Thanks Agin' P

I am using access 2000 ...... ":form" only shows up when in design view.... not in form view

Go to design view of the form, click in the box at the top left of the form to select the form... access the form properties and change the caption property to the title you want. or you could code me.form.caption = "Your Title" in any event within the scope of the form.

Is there a way to count the resulting records from a sql expression without explicitly creating a recordset object. I am using sql statements to filter form results and I need a way to determine if the sql statement that has been built is returning ZERO results....so I do not display a blank...

I tried the >= and <= with the same results....I guess I will have to use dateAdd to add a day to my outer date. thanks for the suggestions p