Search results for query: *

vbrocks- Thanks for your response. What I've learned is that it is possible to show an mdi child from a modal form, but only in the load statement. Do you agree? Thanks, Jamie

I guess I'll answer my own post in case someone else has the same question. First of all, a nonadministrator can download files to the System32 folder if they have been given write priveliges to that folder. This means the adminstrator must give them rights. Unfortunately, I haven't found...

I have an MDI child form called frmPlsWait. I show it in my project whenever an HourGlass isn't sufficient and the user needs an explanation of what he is waiting for. There's only one problem, I can't use it if the calling code is in a Modal form. If I load frmPlsWait as a Modal form, the...

Does anyone know if there is a way to Register DLLs and OCXs using Visual Basic code and API calls if the user is logged in as a Non-Administrator? Also, I am downloading files from our ftp site to the user's System32 folder, but I can't do that either unless the user is an administrator, or...

Hello- I am baffled, and I need help from someone who is smarter than me! I am using a Visual Basic App to restore a backup db file to my SQL Server. dbConn.Execute "RESTORE DATABASE MyDBName " _ & "FROM DISK = 'MyPath\MyFileName.bak' " _ &...

SELECT Visits.PID, Visits.[Date/Time] FROM Visits WHERE Visits.[Date/Time] BETWEEN #9/9/03 4:00 PM# AND #9/10/03 12:00 AM# OR Visits.[Date/Time] BETWEEN #9/10/03 4:00 PM# AND #9/11/03 12:00 AM#

Hi, try this: SELECT Visits.PID, Visits.[Date/Time] FROM Visits WHERE Visits.[Date/Time] BETWEEN Date()-7 AND Date()-7+#4:00 PM# Thanks, Jamie

Excellent, thanks JayKusck! In case anyone else uses this for reference, let me correct a typo ("Dat" instead of "Data"): SELECT RTRIM(filename) FROM YourDatabaseName.dbo.SysFiles WHERE Name = 'YourDatabaseName_Dat' Also, you can get more DB info if you use...

Does anyone know of a stored procedure that I can use to determine the file path of an attached db file? Essentially, I need to be able to use ADO in VB 6.0 to determine the path of the db file, so any stored procedure that can be used in Query Analyzer would work. Thanks in advance, Jamie

From what I understand about Random Access, I can't use it because the records are a fixed length, but my lines are all different lengths.

That is a good idea, but it could be slow to read through the file every time. The file I'm using has approximately 3,000 lines.

Ouch. My lines are not all the same size. I was hoping there was an easier way than to load up an array. But...if that's all there is, that's what I'll do. Thanks for the help!

Quick overview of question: If I open a text file with the Open Statement in Sequential Mode, is there any way to jump to a specific line number? ---------------------------------------------------------- I know that it is possible to jump to a specific byte, or char position using the Seek...

Here are a couple of ideas. Have you tried making the main form an MDIForm and the sub form an MDIChild? Have you tried putting the routine AddSubFormItemToMainForm inside of the sub form? The two forms can communicate using Property Let and Property Get statements. Create modular variable...

For Access, you either need to use my first option, or create a link to one table inside the database where the other table resides. Here's the code I use for that: Public Function CreateLink(p_strTblName As String, _ p_PROJ_DB As ADODB.Connection, _...

What type of database are you connecting to? The only way I know how to handle this in MSAccess is to create a copy of one of the tables in the database where the other table resides. The easiest way to create a copy is to create a table with the fields you need and spin through a recordset...

That's exactly what I was looking for! Thanks a million! Jamie

I would like to set up some predefined constants for use as arguments in routines stored in my class. I'd like for the names of the constants to pop up as suggestions when I'm calling the routines. If this isn't very clear, it's because I'm not sure how to state it. Let me try an example...

You've been a HUGE help. Thanks so much for your time. Jamie

Are you saying there's a com object inside of VB that registers dlls? If so, what is it called? I didn't see a component named DllRegisterServer. The closest possibility I found was called "RegwizCtrl 1.0 Type Library". Thanks for your patience, Jamie