Search results

I thought that might have something to do with the problem... So I changed all the formats to medium date on the query and on the underlying table...but I am still having the same problem. thanks for the reply.

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

thanks Wayne.....worked like a charm.

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

thanks that worked great.

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 am using early binding. I am using an excel object to create a chart. The chart is a "stock" type chart that is not available in Access 97. I have it all working fine.. I am just interested in finding out what steps I need to take to make sure it will work on all my user's machines. Thanks

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

fantastic! I knew it had to me simple but could not find it in help. Thanks!:)

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

found the answer myself.... When using sendkeys statement on modal forms you must put sendKeys statement before the loading of the form you want to interact with.

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

thanks..I used the on format option and it worked like a charm. You guys are the greatest! p:) :)p

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

well, that kind of worked......but as you said it is not ideal. I think waht I want is a sub that checks if the field is null and then makes its height = to 0 if null....but this still does not move all the other controls up to take up the space of the empty control

thanks a bunch.... that will work for now and I would not have thought of it. ps I accidentally posted this message in the wrong area....meant to put it in reports... sorry folks p