Search results for query: *

I’m trying to set a Access2007 query criteria to return records when today’s date falls within a range of a database date field “Selection Made” + 14 days. I’m trying to get the records to show up in a report for 14 days after the date field “Selection Made” date. After the 14 days, the...

I'm trying to set a date field criteria in an Access 2007 query to only display records for a datefield's date + 14 days. It's been awhile and I can't seem to remember how to do this. I've only only found online references for today's date "Date() + 14". I need to return the date field's date +...

I’m trying to update an Access 2007 database with FY2009 data via ODBC. I’m using a simple make table query and setting criteria only on a date field. “>#9/30/2008# And <#10/1/2009#” When I run the query, I keep getting this error. "Scaling of decimal value resulted in data truncation." I...

I'm trying to compare a previous report total to the current or refreshed total. For instance, the user opens the report and sees the previous day's total before the report is refreshed. Once the report is refreshed, I'm trying to flag any change in the totals. I don't need to flag the change...

Is it possible to put the selection dates into the title? When pulling records that fall between two dates, it would be nice to have the beginning and end date show up at the top of the page. Not necessarily the record dates, but the selection dates. I looked in Special Fields and found where to...

Is there a way to turn off the preview of converted documents? I have to convert about 100 individual Access reports to PDFs, and having to close the Acrobat preview after each conversion really adds time to the job. Is there a switch for this? I can't find it. I'm using the older Acrobat 5.0...

Acrobat Reader 7 states that you can fill out a fillable form and save the form with the data if the form was created with "Special Usage Rights". I use Acrobat 5 to create my PDFs, but I can't find where I set these special user rights on the form. After searching through Acrobat 5 and the...

I'm working on a fillable document in Word 2002. Is there a way to create a required field in Word? I'm trying to do something similar to the "Required Field Validator" in .Net. Thanks Mark

I am creating a form that collects text from various inputs; checkboxes, Dropdown Lists, etc, and puts it all in one Textbox. I would like to put a "Select All" button and a "Copy" button on the same form to allow users to select and copy all the text in the Textbox1 to the clipboard. Even...

I need to rename a file type to allow access through our mail server's antivirus software. This is a temp work-around until they allow zip files passage through our scan mail software. In Win98, I could see and rename the file name and extension with no problems. In XP, I can't see the...

I'm re-writing a web form in ASP.Net that was written in HTML &amp; Perl. The old form had sections that would open or roll down when clicked. Can anyone suggest how I might do this in ASP.Net, or somewhere to research it? Please see the link below to see the old form, and an example of what...

I converted several report bar charts from 97 to 2002. Afterwards, the charts seem to be only displaying a portrait view of the charts, even though the page is set and displaying in landscape. This makes the charts appear to be &quot;chopped off&quot; on the right side. Has anyone experienced...

I have several charts that were created in Acess97, and converted to 2002. They have worked great after conversion for some time with no problems. After this month's running, I noticed about a half inch on the charts right side is being cut off (not displaying). The charts are from separate...

I am inputing text into a text box on one form, then passing it to a label on another form. The text will wrap in the textbox on the input form, but will not wrap in the label. It just continues in a single line on the output form. I have even tried to put the label in a table to contain the...

When I change my report layout from portrait to landscape, the fields on the far right disappear. I can see them vanishing as I drag them from left to right. They start disappearing about about the old portrait right margin. What am I doing wrong here? Thanks Mark

I'm pulling text from a SQL DB fed by a web form. The DB field is set &quot;nvarchar&quot; at 1000 charcters. The DB field is getting all the characters, but my CR8 report is only displaying what looks like 256 characters of the record. A physical increase in the report field makes no...

I'm pulling text from a SQL DB fed by a web form. The DB field is set &quot;nvarchar&quot; at 1000 charcters. The DB field is getting all the characters, but my CR8 report is only displaying what looks like 256 characters of the record. A physical increase in the report field makes no...

I have an ASP.net web form writing to a SQL Database. It is a basic form with checkboxes, option buttons, and textboxes. It worked perfectly when located on our internal server. We moved both form and DB to our external web server for unrestricted access by employees. After the move, the form...

I have an ASP.Net web form populating a SQL database. The form includes checkboxes, optionbuttons, and 3 textboxes. In CR8, the select expert does not see the 3 text box fields. I am using the select expert to filter out empty record fields. This works fine in everything but the 3 text boxes...

I have an ASP.Net web form populating a SQL database. The form includes checkboxes, optionbuttons, and 3 textboxes. In CR8, the select expert does not see the 3 text box fields. I am using the select expert to filter out empty record fields. This works fine in everything but the 3 text boxes...