Search results for query: *

First off, I know -- "Why?" But before we get into "why," just let me know, is it possible? Can I manipulate/create macros from VBA? Possibly through: DBEngine(0)(0).Containers(5).Documents(x) Or is the a table that stores the macro definitions, similar to MSysQueries? Any help would be...

OK...so I was having problems scheduling my DTS's, but those are now resolved. They run on schedule, and succeed. The funny thing is that one portion of the code doesn't run. I use this ActiveX in the DTS to open a database, and run its macro: Function Main() Dim objDB Set objDB =...

Hi everyone, I know that MANY people have had similar problems in the area of a DTS package executing fine, but failing when scheduled. I've read all the threads I could find that dealt with this type of error, but I couldn't find anything that solved my problem. The DTS is a simple ActiveX...

Hello all, I have a couple of functions that do a formatted export to Excel using an xlt template. Option Explicit Dim XLApp As Object Dim XLTemplate As Object Dim XLSheet As Object Public Function fncEE_SetupFile(locTemplate As String, locOutput As String) Set XLApp = New...

OK, the setup is a little complicated -- I've brought my laptop into work, and I am connecting to one of our SQL Servers. Because it's my personal laptop, I'm not logged in under my network name, nor is it under the network domain; but i can still access shared network drives (it just prompts...

OK, here's my dilemma: I'm dynamically creating criteria depending on what day of the week it is. I use a function that I made to determine the criteria. I want the function to return "In(3,4,5)" to the query's criteria (but without the quotes). I just want In(3,4,5), meaning it will look...

I'm really kind of stumped on how to do what I want to do. I've looked into flexgrids, datagrids, and listboxes, but none of them seem to suit my needs, or they're for .NET only. What I need to be able to do is this: --The user opens a record (it has a unique record id) --I give the user a...

This query will work in the query analyzer, but not it the DTS package: I receive this error -- Error Source: Microsoft OLE DB Provider for ODBC Drivers Error Desc: {IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL]SQL0204 - GETDATE in *LIBL type *N not found. I am trying to hit...

OK... I'm trying to builder a querier for someone who doesn't know Access. They select states from a list box, which populated the states "code" into a text box (like this: 1,2,3,6,30) That writes to a table. Now, those numbers need to serve as the criteria for my query. I've tried...

Hey all, I'm trying to open a recordset and write to it. I've done it a million times, but this time, I'm getting an odd error (see subject). Here is the code: ----------------------------- Dim db As Database Dim rs As Recordset Dim SQL As String lngLoan = Me.Acct_ SQL =...

Ok, I went the unconventional route, and made my report on a form. I also designed the form in a high resolution. My users use 800x600, normally. When I print the form, it prints the whole form... but when they print the form (through the me.printform in the form_load event) it cuts off the...

Hi everyone - I'm using a form as a report. The whole data report thing was confusing me, so i worked around it. I have all of the information, and now I'm formatting the labels (I put a label array on the form, then populated the labels with the values I needed.) Anyway - When I bold...

Hello, I have a series of text boxes that will hold integers. I cannot get the to line up to the right instead of the left. I set the DataFormat property to Number, but that didn't do it. And no matter how accurately i click on "True" under RightToLeft property, it goes back...

Hello... Sorry if the subject line is confusing. What I'm doing involved concatenating a string and variable to make a field name, then storing that in a variable, then using that variable to assign a value to a recordset... that probably doesn't make sense, so I'll paste the code...

Hello all, This has to be easier than it seems! I'm doing my 2nd VB6 application, and previously "programmed" in Access. All I want is to have the the text in a textbox selected when I tab to it. It did this automatically in Access. I know I could build a function utilizing...

Hi... I have experience with VBA, but am new to VB6. I'm trying to utilize the date() function, and it's not jivin'. When I assign the value to a unbound control, or even just test it in the immediate window, the result is blank. I've checked the references, and tried adding the Office...

Hello, I've developed a problem... I don't know exactly what caused it. When I log as Administrator, or any other for that matter, anything that is queued to start on startup "generates errors" and has to quit. I disabled the startup items, but I still get a few. The first one...

Hello, I am a fairly versed Access user, but I always have problems with my reporting queries, namely, counting what needs to be counted. I need to count the number of records created/updated today, yesterday, this week, and year to date. Do I have to create a different query to get each...

Hello, Is there any utility that will help me convert an old quickbasic program to visual basic. The program was made for my company before i got here, and now my boss wants to expand its capabilities and make it easier to use. I'm pretty skilled in VBA, but is there anything to make this...

Hello, I'm trying to creat a "search form" in my database. I would like to use the entry in one textbox as the criteria for the list box. So if the user types "f" the listbox will populate with the records that begin with "f". if they then type "o", i...