Search results for query: *

Hello all, I'm in need of some batch script help. I need to create a formatted text file that looks like this: ROOT l_comm_info.e00 3,939 l_mt1_lomc.e00 7,985 ROOT/SUBFOLDER1/ l_stn_start.e00 2,677 l_wtr_nm.e00 8,845 study_info.e00 4,608 ROOT/SUBFOLDER2/ s_base_index.e00...

I've built a spreadsheet we're using as a template to track certain things in a Access database. Using the Import External Data, I set up a simple query using a test database. Everything returns fine, all my calculations do what I want. But now I want to duplicate the template, keeping my...

Background: I've got a single spreadsheet I'm using to track changes to certain fields in 7 separate Access databases. So, I have 7 DB queries using the Get External Data... tool dumping into a single sheet. The tables and fields have the same names and data types in each database. I've got...

I've got a handful of macros in Word 2003 that format table rows. I can get them to loop x number of times no problem, but only if I hard code it in the macro. What I had envisioned was a userform popping up that would ask how many times to run the macro, user enters a number in a text box...

I'm trying to create a simple form that builds a select statement based on two comboboxes. I was following a tutorial online, but have gotten stuck. I think I have the combobox and variables set up correctly, but I'm new to this whole coding thing and am not sure what needs to happen next...

For reasons explained in another thread, I need to overlap the page footer with the page body. I tried setting the page margin to something very low (0.5cm) and set the footer to start 3.2cm from the edge. Seems to me, that would cause the two to overlap. Any ideas? Thanks, dylan

I just discovered the repeating headers function in MS Word (Office 2003 Pro). Is there some way to create repeating table footers as well? Thanks, dylan

Using Crystal Reports XI, I've recently finished a relatively lengthy report for a client. At the client's request, that report is exported to .rtf (and then saved as a .doc). However, it seems that when CR exports to MS Word (2003 Pro) it exports everything as an individual graphic field...

I'm trying to automate some footnote work, but need a way to find out the maximum value a certain number variable reaches at any point in the report. I need to be able to tell CR to leave room in the report footer for 7 footnote descriptions, or maybe just 3, or maybe only 1, or maybe 15, and...

I'm trying to work out some footnote automation. I thought I was further ahead than I am though. I need to be able to check if any record returned on a page meets a certain condition. Meaning, if any record in the report has mapxsln.bw = "Yes" I want to change a variable value. I thought...

Is there a function to print the datasource somewhere in the report? dylan

I need to create a report that selects records only if 1 of any, say, 10 fields is blank/null. What is the syntax for null values? Thanks, dylan

I have an interesting issue with grouping in a longer report. It is fine for group details to spill over into the next page, but occasionally there is only enough space left on a page for the group name. So the last line in my report body is the group name. The group name then repeats on the...

I'm trying to write a formula that will display all the group names on a page. Does anyone know the syntax to call the group name for all groups that appear on a page? Thanks, dylan

I'm in need of a little assistance creating a formula to change the group name if the group continues across a page break. I need to add "(CONTINUED)" to the group name and I'm not sure what condition to check for in an IF THEN kind of statement. Thanks! dylan

I was recently having problems printing to a networked do-it-all printer at the office. Usually, if I sent a job it didn't do anything. Starting last month, it started printing text-only pages at about 3 every 10 minutes. Our IT dept. told me my "[account] login priorities weren't configured...

Is there a way to stop guidelines from snapping to lines or other objects already in the report? Something like holidng down the space bar, or maybe a setting? I can't draw a second guideline within almost a 1/4 in of a feature I already have drawn... Thanks! dylan