Search results

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...

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"...

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

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...

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...

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...

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 am using between... and operator to set the date criteria for a query.... According to the help files this operator is supposed to be inclusive (include both the dates specified) I am finding that it is only icluding the first date and not the second ie: between#1-1-02# and #1-2-02# only...

I have built a wonderful form that generates custom SQL statements.... These statements can then be used to make queries. The idea was to generate a custom report based on the SQL statement. I thought I could just put the SQL string into a variable and then use a custom built function to...

here is the code. When I run it it says expected variable or function and hihlights on the .Edit part of the code.....Any help would be greatly appreciated.. Sub WriteSyncDate() Dim db As Database Dim rsDat As Recordset Dim varNewDat As Variant Set db = CurrentDb() Set rsDat =...

I have been noticing some problems when I use the Date() function in vba... It always works fine on my system but often will cause errors on other machines. Is there a reference that needs to be set in order for Date() to work? Now() seems to work almost always?? thanks again P

If I set up reference to microsoft excel object library in my db....do the reference settings carry over to other users machines when they load the db...? or is it neccesary to set the references on each individual machine? Do I need to create a sub that sets the references when the db...

Ok here goes..... I have a 2d array that is holding the proper information. The array is poulated in access. I need to use excel's cahrting capability to build a chart based on the info... How do I pass the array into excel so I can use it as the base of my chart? There seems to be plenty of...

I want to populate a 2d array using data from a query. The first set of data for the array are dates in "ww" format......problem is that I want the array to be an Integer datatype. I guess the dates are variant data type. Any one know how to change the dates to ints? any help would be greatly...

view more than one report Is there a way to preview more than one report at a time? I have report generation code that creates seperate reports for each address that has been selected by the user. I would like the user to be able to review the reports before thay are printed....but I can only...

I am having trouble getting the sendKeys statement to work on a printDialog box has anyone tried this and succeeded? p

I have the following for next loop to open a report(s). code: For i = 0 To iac DoCmd.OpenReport "rptMain2", acViewPreview, , "qryGetSelectedAddress.[recID] = " & intID(i) Next i end code: The idea is to create an instance of the report for each address the user has selected...

I have a global variable that I want to have show up in a text box on the bottom of a report. this (below) works fine if I preview the report , or preview and then print from the preview. Private Sub Report_Activate() Me.txtFile.Value = varTransNumber End Sub but if use the acViewNormal to...

I have an address section on a report. I would like to know a way to make any txtboxes that are empty not take up a line in the report. example: if the [address2] field is empty I would like the next field [City] to be directly under [address1] rather than have an empty line seperating...