Search results for query: *

Exactly what I needed! Thanks.

I have a newly loaded Access 2007 on a client PC that does not respond to the VBA code attached to the forms. On my PC the code runs fine. I have looked for possible reasons -- where the options are different between the two systems and all looks okay. The format used is Access 2003 MDB. Any...

Thank you rose4567. Your suggestion is a good one. But I am having trouble making it work. I now have two group footer lines: first one that prints if no page break is requested, and secondly one that should print with a page break. However I am not getting the page break on output when it is...

I am trying to add a dynamic page break feature to a report that already has dynamic grouping, but I am having a problem. As some background, this report has a parameter for grouping that is used to control the printing of the group header and footer sections which work fine. The original...

This is the basic command line I built (data modified for security): c:\windows\clientconsole "192.168.20.150" "09TexAnnMtg~2549~Lana~Green~Guest~Complex Community~ ~ ~ ~ ~ ~ ~(555)550-9126~(555)550-9128~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~EOR" Basically it calls the vendor program...

We are moving from using bar codes on our event badges to using mag-cards. The vendor has provided a utility where a one line command can pass the information to the mag-card printer for each card. We only will use this for the 1-off on-location cards. I can build the command line in my Stored...

RiverGuy and Borislav, That did the trick! Thanks.

I have a need to present a column of data as a single row field. For example if a query returns a single column with 3 row values: rec1='AAA' rec2='BBB' rec3='CCC' I want to present it as: rec='AAA; BBB; CCC' How can this be done? Ideally I would like to have this coded in a function...

Riverguy, Can you access the mainframe data with a query that returns DISTINCT data rows? If so, the dups will disappear from the resultant dataset.

I am a little confused by your advice. Is this a Visibility property setting for the main or sub report? Also, is it row setting (set from clicking on the 3-bar line handle) or is it a setting for the sub-report or detail line? I like the simplicity of the code, I just hope we can make it...

I have just started using sub-reports in my design (RS2005). On the whole they work fine, but on the occasions that no details are included in the sub-report, the empty line still prints. Does anyone know how to "shrink" the line when the sub-report is empty? It "grows" just fine when there...

My vendor finally responded and was able to get it working. All the same, I'm glad to have a source like this for help! Rik

I am trying to design a Meeting Badge for Avery 5384 stock with a barcode for the ID number. I was using a template supplied by our membership software vendor, but I'm running into a problem with the barcode. The template uses the Table control (without a header or footer section, only the...

Thank you! And DUH! That's what happens when you copy code from one project to another. Best Wishes.

I know I have done this before but today it is just giving me grief. I have set up a DB with one table and two forms. First form is a list of the table recs, and the second form displays a single rec when the list line is double-clicked. Fist form uses a query to show the table recs, and the...

Thanks for the help! This was exactly what I needed. Rik

I had left out my test logic for dropping the procedure from my code example. But your note that "CREATE PROCEDURE must be the first statement in a batch" is helpful. Is there a way for the SQL Server test for an object's existance to return a status to the VB program? I can see where I may...

George, you have given me a good boost down this path but I'm still having a problem. Here is what I am trying: s_Text = "If Not Exists(Select * " & _ "From Information_Schema.Routines " & _ "Where Specific_Name = 'sp_myproc') " s_Text = s_Text & "CREATE...

I'm still missing something. As a test, I tried creating a new VB project with: Option Explicit Private Sub Form_Load() If Exists(Select * From Information_Schema.Routines Where Specific_Name = 'sp_myproc') then MsgBox "OK" Else MsgBox "Fail" End If End Sub The...

Thanks George, but what I want to do is automate the process so the user doesn't have to know anything about SQL Server. I want it to be self contained in the VB app. Can I do this?