Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Gazzza

    Accessing external app's

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

    Opening an Access Report using VB

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

    Passing a recordset from COM to VB app

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

    Passing a recordset from COM to VB app

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

    Query for available time

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

    Copying Access tables from one db to another

    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" '...
  7. Gazzza

    Text Color of a Disabled TextBox?

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

    Setting Desktop Icons

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

    Closing an app from another app

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

    Close a window

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

    Close a window

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

    Where did the call come from?

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

    How to stop Record Locking

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

    Playing a wav file and recording wav file at the same time

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

    Storing Live Details

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

    I'm missing all my active x controls

    Hi, I have just started a new job and the pc I've been allocated dosen't have any active x controls. I can find them in the System32 folder but when trying to register them but when I select the controls I want to bring in and click register nothing happens. I'm using Access 97 and have...

Part and Inventory Search

Back
Top