Search results for query: *

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

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

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

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

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

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

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

I have an app that I want to send to some other users. All users have MS SQL Server. The app uses a custom Stored Procedure. I want the app to be able to check if the SP is present on the user's system. If it is not there, I'd like the app to be able to build it. Is this possible? Any hints...

I have a problem when I try to call a SQL Server Stored Procedure with params from VB (actually VBA if it matters). The SP look like this: CREATE PROCEDURE sp_MyStoredProc AS DECLARE @StartDat datetime, @EndDate datetime SET NOCOUNT ON SELECT ... FROM ... WHERE (Table.DATE BETWEEN...

I'm taking over a "legacy" project and I was wondering if there are any tools out there that can document to a report everything about a specific project. I want all controls with all properties and code so there is reference point where I'm starting. If this is easy, I will be very happy -- TIA.

I want to update a field in a table (tName_Security.EXPIRATION_DATE) based on external conditions that I have used to build a field in a view (vDBChk_BadSecurityDates_Active.NewExpirationDate). So far I have a stored procedure designed to process this update, but something is wrong. Since the...

I am at a loss to find this problem. I have a diplay field I build for a Mailing Label in my app. On my PCs this shows properly, but on the users who are testing for me, the field shows "#Name?#. 1. Here is the Control Source for this field: =IIf(Len(Nz([FULL_NAME],""))>0,[FULL_NAME] &...

I have a situation where we need to dynamically be able to convert from one table where multiple items are concatenated in a field. We need to have the output have one line per item to query the results. The original table is supplied by a vendor as part of their app and we can't change it. I...

This may be off-topic for this forum, if so please point me in the right direction. I want to be able to start an app from Windows Explorer by highlighting an item and right-clicking on it to select my app. I want to pass the highlighted file to the app automatically. TIA for any help!

I would like to be able to pass "command line" options to a VB app. Can someone point me to info on how to do this? TIA!

I have created a DTS package using the DTS Wizard. It was set up as a scheduled job to run daily. All it does is transfer a SQL statement to a CSV file. I can run it fine from Enterprise Manager by right-clicking on the Local Package and selecting Execute Package, but the scheduled execution...

I have a table called "Name" which is indexed on ID, and a table called "ChangeLog" which includes the ID along with the date of the change and a description of the change. From this one-to-mamy relationship I want to query out only the most recent change for any ID. Is there an easy answer to...

I have an VB app that I am attempting to teach to export a SQL View to a CSV file. I have gotten as far as: Set NoCount ON exec master.dbo.xp_cmdshell 'bcp "select * from imis.dbo.vDistrictDB3" queryout "F:\data\testout.csv" -c -T -t, -Usa -Ppwd' But there are two problems: 1. I need to...

As a relative newby to Crystal Reports, I am trying to set up a report that needs two parameters. The report is a receipt for dues payment, but we have a number of members who make partial payments during the year. While the member's record is active in the membership app, I want the operator...

I am just getting started with the Internet Transfer Control and I am having trouble getting it set up right. Below is a segment of my code that shows how I am trying to use the control, but at the indicated instruction the system returns an error "35754: Unable to connect to remote host"...