Search results for query: *

I have a form that pops up to collect query parameters for a report. If you click on the cancel button on that form, a pop up box comes up requesting the parameter value. How do I stop that from happening? I have put a CancelEvent in a module but it doesn't seem to work properly. All help is...

I want to write code that disables the messages that appear when you run an action query. I have a database that configures a large report and I don't want the user to have to keep clicking the OK button. Any help is appreciated.

I'm trying to export a query to a text file. It's a file that contains a list of social security numbers. I don't want anything in the file but the numbers. I just want a space delimited file. How can I do that without the file having the lines and stuff in it? Thanks!

I just learned Crystal and am working on my first report. This is probably one of those "duh" questions but - How do I use a .txt file as a data source? I can't figure out how to identify it. Help is appreciated.

I have a report that, when run from a switchboard, prompts the underlying query to open a form used to enter the parameters. I have a cancel button on the parameter form. When you push it, the form and the report close but the query still looks for the parameters and pops up a message asking...

I have a form that is used to collect parameter data for a report that runs from a query. When the form is opened, it's blank. There are fields there in design view - but none of them show in form view. Please help! heidi

Want to have a stardard text file that is imported when a button within a form is clicked. I have the standard text file. It is CURRENT.TXT Users will replace the current text file every couple of weeks and then hit a button to import the new data to an existing table. (Old data has been...

If one user is viewing the record, I really don't want the other user to be able to pull up the same record. Does that make sense? It works as far as not letting more than one person edit/save the record, but I don't even want them to be able to see it. Thanks for all of your help.

I have record level locking checked (Access 2000). I want it to lock the record upon reading it. How can I change that default? As Ken Reay said above...the default locks the record at the time of update.

I have a form for data entry that pulls some information already existing in the table. I have five users. How do I lock a record when someone is working on it. Currently, all five users could pull up the exact same person. Please Help. Thanks.

Have an autorun inf file that brings up an HTML file on a cd. I want to define the size and position of the window on the screen. How can I do this?

I need to write SQL to pull every nth record from a data warehouse. How would I write this to give me a true random sample? Thanks.

that's what I wanted it to do. I'll try this and see if it works. Thanks.

I want to populate a field on a form(and in turn the query that runs the form)with the current date. It's a survey database. I want to keep a record of the call dates (up to five). I want the date fields to automatically populate with the current date when a submit button is pushed. How do I...