Search results for query: *

Hello Tek-Tips, My app currently uses the JRO.JetEngine CompactDatabase method to backup my Access 2002 database. I have two concerns. 1. My first concern is that when by db gets too large to fit on the removable media, it will not allow the file to span multiple disks. 2. My second concern...

Hello Tek-Tips and thank you again for taking the time to read my question. Is there a way to declare a variable in a SQL Select statement which will allow me to assign through VB6. I am generating a SQL statement which uses 4 dates as parameters. However these 4 dates are needed several times...

Hello Tek-Tips, My question today is I wish to extract info from a Table (Access 2002) called (RevenueDetails) which includes the Fields (Rooms) and (Revenue). I wish to display today's Rooms & Revenue and month to date Rooms & Revenue in one statement. I am having some difficulty doing this...

Hello Tek-Tips, I have struggled far too long on my attempt to summarize data in my Access Database. I wish to code a SQL statement that will total all of my customer's revenues and group them by CustomerName. Here is the structure of my database: Events Table: (one Event to many EventDetail...

Hello Tek-Tips, I am attempting to summarize customer totals into one amount from two different Access Tables, the Events and EventDetail Tables. The Sum() function from the EventDetail table returns the correct result, however, the amounts returned from the Events Table are duplicated by the...

Is is possible to either set parameters of a child command or set the .CommandText of a child command. I am attempting to generate a DataReport using Access 2000. I wish to list my employees (from the Employees table) and have their Gratuties (Gratuty table) listed (grouped) under them sorted by...

Is is possible to either set parameters of a child command or set the .CommandText of a child command. I am attempting to generate a DataReport using Access 2000. I wish to list my employees (from the Employees table) and have their Gratuties (Gratuty table) listed (grouped) under them sorted by...

Dear Tek-Tips, I am attepting to generate a report which lists all my employees and under them a detail of the Events and their Gratuties. I have Employee, Events, and Gratuity tables in MS Access and I am using the DataEnvironment for my conneciton. I want to set two parameters in the CHILD...

Hello Tek-Tips I have searched the archives unsuccessfully. I wish to add the ability to attach files to emails sent utilizing my code below: **General Declaration Section** Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" _ (ByVal hwnd As...

Hello Tek-Tips, I wish to add functonality to my app which will allow the user to send an e-mail using their default e-mail client, will place the subject in the subject line, e-mail recipitant, file attachment, and e-mail body letter. I wish to "Shell" the e-mail client app and have...

Dear Tek-Tips: I created a setup package successfully. However when I run the Setup.exe file I receive 'Error occurred registering msado25.tlb.' I viewed the install log file and pulled this piece of it out: *** ERROR: No entrypoint for DllRegisterServer() was found in...

Hello Tek-Tips, I have written an app and wish to use the Package & Deployment Wizard to produce the setup files. I have two .exe files that comprise the application, one is the actual app, the other are data tools ran outside the app. Instead of creating two setup packages, one for the app...

Dear Tek-Tips: I would like to add code to backup an Access database from within my VB6 application. I don't just want to use FileCopy, I want to be able to span it over several disks if necessary and then code a Restore menu option to restore the backup if necessary. Any suggestions are...

Tek-Tips, Is there a way I can check for NULL value in a SQL SELECT statement and if NULL is TRUE then change that value from NULL to something usefull like 0.00? For example: SELECT Sum(Quanty * Price)AS ExtendedTotal FROM Events ...bla..bla...bla If ExtendedTotal returns NULL, can I change...

Dear Tek-Tips, Is there a way that I can hide the Print and Export bottons at the top of a DataReport before I envoke the .Show method. I thought I read this somewhere, however I do not remember where. Any and all help is always appreciated. Thank you, Tom (maxflitom)

Dear Tek-Tips, Is there a way that I can hide the Print and Export bottons at the top of a DataReport before I envoke the .Show method. I thought I read this somewhere, however I do not remember where. Any and all help is always appreciated. Thank you, Tom (maxflitom)

Hello Tek-Tips. I left this same question in the VB Database forum and got some feedback but I still cannot resolve my dilema. I have the following SQL statement on an Access database. The only issue I have is when there is no entry in the EventDetail Table matching the Events.EventID field...

Hello Tek-Tips. I left this same question in the VB Database forum and got some feedback but I still cannot resolve my dilema. I have the following SQL statement on an Access database. The only issue I have is when there is no entry in the EventDetail Table matching the Events.EventID field...

Hello Tek-Tips. I have the following SQL statement on an Access database. The only issue I have is when there is no entry in the EventDetail Table matching the Events.EventID field, the aggregate functions (GrandTotal & SubTotal) return a null even though there is an entry in the...

Hello everyone, I am attempting to create a SQL statement to summarize revenues in an Access 2002 database. In my database structure I have an Events, EventDetail, MenuItems, and a RevenueCategory Tables. I am attempting to create a join to group the details on the Revenue Categories stored in...