Recent content by sxchopr

Thanks, but that does not help me. I need a method where I can store the criteria's and call them into the many queries I'm going to create. The reason for wanting it this way is the criteria's change often, with this approach I would be able to change the criteria in one location and have it...

Hi Everyone, I'm creating a new database in which I'm trying to use VB to create criteria for use in query. But no luck. Here is what I have so far Sub Array_Query() MyQry(0) = "In ('0014705','0014710','0014715')": End Sub Function GL_Code(i As Integer) On Error GoTo err_gl Dim...

Hi Everyone, we are currently converting from Access97 to 2002. When I start a conversion it comes back with a message saying the new file to which I'm converting is in use. For ex. if I'm converting Access97.mdb to Access2002.mdb half way through the process it will come back and say that...

Thanks for the link, but now I need someone to explain to me what these variable are and what needs to be input into them.I have very limited knowledge of registries. (ByVal hKey As Long, sValueName As String, lType As Long, vValue As Variant) Thanks Sandman

Hi, Has anyone tried to ODBC into the Stucky system which is an Asset based lending system. I need help to setup the ODBC. Thanks Sandman

Greetings everyone, has anyone made an entry into registry of a computer using visual basic(window95, 98 or XP), if so can you send me examples. Thanks. Sandman

Try this, [Name of control in the main report which links to the Sub Report].[Report]![Name of control in the sub report] Sandman

Thanks Peter, but I was after creating a generic code, which I could just call from the report without having to do anything else. Sandman

Hi Everyone, is it possible to create a new report control specifically a Label, using the no data property on the report? I want to create a generic code which puts a label in a report which has no data. The message I'm getting is that the report needs to be in design view to create a report...

We have a whole bunch of management reports, which need a certain format. All I'm trying to do is put a box around the data. I have already tried the sub report idea but it is not practical for what i'm doing.:)

I do a summary report and I'm trying to put a box(rectangle) around the data. The report has a group header and footer. I'm trying to use the "Line Method" in vb. But the box created does not cross sections of the report. It remains within the section in which I paste the VB code into(I put the...

can someone tell me how to change a data type of a table, using vb. I need to change it from a numeric field to a text field. The reason being when I import this table into another database this field attaches to another table whose data type cannot be changed. Any help would be apprieciated. Thanks