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,"New Job"))
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...
Cool, I tried this and works great!! Thanks Much!
Dim Rs1 As ADODB.Recordset
Dim SQLCode As String
Set Rs1 = New ADODB.Recordset
SQLCode = "SELECT COUNT(LTicketNum) As test From TransIn"
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]
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.