Search results for query: *

That got it working. Thanks, I think I tried everything other than that :)

I need to access from a Pervasive 2000i server via ODBC. The ODBC is working fine but the data names in the table are causing problems. The datanames were named as _name, _address, _faxnum, .... I realize this is not the best naming convention, and it was a different company that did this...

I have a spreadsheet that has a cell with the following value: (note: true file path removed to keep it clean) =IF('C:\[1025.xls]Information'!$B$63<>0,'C:\[1025.xls]Information'!$B$63,IF('C:\[1025.xls]Project Information'!$C$7<>0,'C:\[1025.xls]Project Information'!$C$7,&quot;New Job&quot;)) I...

Just installed a new Seagate IDE TR40 Tape Drive. The manual backups work fine, but each time I schedule a job for 11:55 PM I get this: ====================================================================== Job server: NTSERVER Job name: Backup 0001 Job started: Wednesday, September 18, 2002 at...

Never Mind... I created a new report which groups by customer and then I removed the detail area of the form and used the group summary. Gave the desired result... if there is another way to do this, let me know please.

I have a form that is pulling records from a table and sending them to a report. All works fine. BUT I want to select records between #date1# and #date2# no problem... I wrote the sql like this stLinkCriteria = LDateOut>=#01/01/2002 AND LDateOut<=#08/30/2002# ... Unless I use the LDateOut...

k, that works BUT is there a wat to use Defined Variables from the form in the report? If not I could create some hidden form fields and transfer them that way OR create a global or something. Just wanted to know if you can Define a Variable in a form and then pass it to the report?

I have a button that prints a report based on the data of a form. This works great, BUT... I want to label the report depending on the contents of the form... for example if the StartDate and EndDate of the report are based on 2 fields on a form, how can I show these values in the header of the...

I love this forum!!! You guys are great, thanks! [2thumbsup]

How do you format a Time for 24hrs with VB? The following uses 12hr without Am/PM: StartTime = Time Thanks Again [bigglasses]

Cool, I tried this and works great!! Thanks Much! Dim Rs1 As ADODB.Recordset Dim SQLCode As String Set Rs1 = New ADODB.Recordset SQLCode = &quot;SELECT COUNT(LTicketNum) As test From TransIn&quot; Rs1.Open SQLCode, CurrentProject.Connection Rs1.MoveFirst...

Ok, that gives me some ideas... but what I really need to know is the proper way to load variables from the tables for use in calculations/field population/inserts/etc. Since my post I have figured out: Dim Rs1 As ADODB.Recordset Dim SQLCode As String Set Rs1 = New ADODB.Recordset...

OK, I have not done much with Access 2000 VB so here is the problem: I want to create a variable in VBA that for example loads the sum of a column in a table. Sounds simple, I know, but I am missing something. Any help is appreciated!!! [bigears]