Recent content by Gazzza

Hi, I'm trying to do something that was pretty easy in VB6 and I can't get it working under vb.net we use a product called Aperture and it has a fairly large ole library that can be used. In VB6 this would have given me the current open projects name. Dim oAperture as Object Dim oProject as...

I can't answer how to open the app window to max but to open the report to max after .DoCmd.OpenReport ReportName, lAction put this on the next line .DoCmd.Maximized The only way I can think of that you can get access to the app window state is using the shell command. Does anyone know of a...

Hi, This is what I wanted to do, The com can now be set up to interact with the db and the client is being passed a record set for it to display. You will need two projects and a db with the Customers table from Northwind.mdb the connection string is setup for an access 2000 db. Create a...

Hi Can anyone tell me is it possible to pass a recordset from a COM to a VB app and how. It seems that I can only pass back standard datatypes like strings, integer ect and not objects or user defined datatypes. I've tried a couple of differnt ways like sending the rs as an adodb.rs and...

Hi, I'm a new to sql so forgive me if this is really basic I've made a database for booking workspaces for a date, start time and end time. I have written a query that the user selects a workspace, date, start time and end time. Having converted the date and time into timestamps that look...

Hi Mangro, I have this for you if its any help. It was written to move all the table from one access db to another db. Dim dbSource As Database Dim wrkDefault As Workspace Dim strSourceFile As String Dim i As Integer Dim y As Integer strSourceFile = "Convdata.mdb" '...

Hi Wraygun, Text1.Enabled = False Text1.BackColor = vbBlack Text1.ForeColor = vbYellow This will do what you want but when a control is set to Enabled = False it dulls the color and the yellow goes pale. To have a better yellow you will need to find a color that turns yellow when...

I do have one other problem that I'm having some trouble with. In this VB program i'm working on, I create a icon on the desktop using the fCreateShellLink function. ie. lReturn = fCreateShellLink("\" & MENU_NAME, "TCS - " & strCompanyName, strPath1, strArgs, -1...

Hi What I need to do is close a named application through code from another application. There are three apps 1,2 and 3 1 is running 2 is checking that it running and 3 may or may not be running. If 2 detects that 1 is no longer running it needs to shut down 3. I'm using FindWindow to check...

Thanks to both of you I'll be able to use both examples for different things Garry

Hi I want to stop users from having more than one session of an application open. I'm a newbie and have access to the code that was written by someone else. How can I check if the app is already running when someone fires up the exe? If the app is running I just want to display a msgbox...

I have two applications one is a financial app the other is a drawing app both have pretty good OLE librarys. What I can do is open the drawing app from the financial app or I can open the drawing app from the desktop as normal. Is it possible to tell where the call came from either the...

We have an Access db on a LAN with about 12 users and every so often it has a record locking error I have jacked the setting for Update Retries to 10 (max) and Update Retry Interval to 1000 (max) this has slowed down the number of record locking errors but still it happens. Sometimes it happens...

I've been asked to write a program that will play a wav file while recording another one if required is this possible? Any suggestions on how it would be done. Thanks Garry

Hi, Can anybody suggest a method of storing large amounts of data using Access 2k table. I'm trying to replace an application that is using scheduing software to monitor room booking for 25 rooms that can be booked on the quater hour. I've built a table with 365 fields and store a key for what...