Search results for query: *

Hi- Does anyone have experience using PDF::Create? I'm trying to create a landscape view PDF, and can't figure out how to use the "Rotate" method for new_page. I've tried a variety of syntax, including: 'Rotate' => 90 'Rotate' => [90] 'Rotate' => '90' I keep getting an error: "Can't use...

Hi- Does anyone know if there's a way to add a sub report to a report at runtime, in the OnFormat event of a section of a report? My problem is this: I have a table containing many projects from different years. Some of these projects are continuations of each other through years. For...

Hi - I searched around this forum & wasn't able to find what I was looking for. I am writing a script that loops through a variable number of Users who answer a survey & creates hashes for each of the Users that holds how they answered each question. I want to have hash names like %user1...

Hi- I have mySQL running on a linux machine, with several databases in it. One of the databases is very huge, it's updated with thousands of rows daily, and it can fairly easily be re-populated if soemthing were to happen to it. Another database is pretty small, and I want to be able to keep a...

Is there a way to refresh the contents of a form, but remain focused on the current record? Or is there a form function where you can jump to a particular record (i.e. saving the record id, refreshing, then jumping back to that record)? I'm using Access 2000.

I am trying to test a unix script, which will eventually be a cron job, using ./ at the command prompt, but computer comes back & says "bash: ./build_current: No such file or directory" I know I had this problem months & months ago when I first worked on these scripts, but I can't for...

Does anyone know how to format an RTF document as a landscape document? The "RTF Cookbook" on cpan (written by S Burke) says that just including the command "\landscape" after the prolog does the job. I haven't been able to get this to work. Thnks. Emily

I have a MySQL database, located on a remote server, with an Access 2000 front end, located on my local desktop. The server has a new ip address from when I first started. I changed the address in the ODBC Administrator for my machine, but every time Access opens it still tries to use the old...

Hi- Is there a way to have the new record be located at the top of a continuous form (as opposed to at the bottom, underneath all the existing records)? Thanks, emily

I am having problems getting mysqlhotcopy to work. I am being informed that access is denied for my root user (using a password) before I am prompted to enter the password. Is something wrong with my syntax? mysqlhotcopy -u root -p Database Databasebkup

I have a mySQL database set up on a Linux red hat 6.0 machine, and I've been accessing it with MS Access on a windows machine. Recently I've been getting this error whenever I try to open a table in Access: "Lost connection to mySQL server during query" I can SSH into the Linux...

Hi- I am currently trying to extract all the data from an Oracle db and upload it into a mysql db. I ran SQL queries in SQL Plus to get all the data, spooling the output to a txt file. Now I'm trying to upload the data into the new db (using a perl script), but there are these weird characters...

I have lots of files, which are in the format: &quot;date&quot;, &quot;message&quot; &quot;date&quot;, &quot;message&quot; . . . I am looping through all files (INFILE) and putting each line of the file into a database table with the following code: while (my $line = <INFILE>){ my @line =...

I'm using ADO in some VBA code (access 2000) to run a simple query. Some of the time this query will have no records associated with it. However, this is apparently not ok with VB. It gives me the error &quot;You entered an expression which has no value&quot;. I don't care if the resulting...

I have this really enormous file that I would like to print only sections of. These sections are set off by the key words &quot;Table&quot; and &quot;End Table&quot;. So the file looks like this: [stuff I don't want to print] Table [stuff I want to print. there are about 50 lines] End Table...

I have a set of interrelated forms. One of the forms I have (&quot;Projects&quot;) has a button on it that opens a &quot;Project Log&quot; form. The user can enter notes, close the form, and I have some VB code that refreshes the Project form. However, I want to use the Log form even when the...

Hello- I posted this in the VBA Coding forum too. I have a mysql database which I've linked to an Access db in ordre to create forms and reports for my users. I have this table (called funding) which has an auto-increment primary key (called f_id). It doesn't do anything other than uniquely...

Hello- I have a mysql database which I've linked to an Access db in ordre to create forms and reports for my users. I have this table (called funding) which has an auto-increment primary key (called f_id). It doesn't do anything other than uniquely identify each row. I am trying to write a...

Hello- I am creating a web interface for a database in which I store lots and lots of data. The idea is that people can come to the website and and select what kind of data they want to see, such as: &quot;Energy Prices between may 2001 and july 2001&quot; or &quot;Load between january 2000 and...

Hi- I want to be able to get the domain of the ip requesting infomration from my webpage. Basically I want to show one thing if it's a .gov domain, and another if it's anything else. I've been able to obtain the ip number address with my $ip = $ENV{'REMOTE_ADDR'}; Is there a way to resolve...