Search results for query: *

I disabled a foreign key by selecting the disable? field in dba studio. Now I want to reenable the foreign key constraint and when I apply the changes I get a missing keyword error. Here is the SQL that DBA Studio creates when I try to make the change. ALTER TABLE...

Thanks for all of your help

We are trying to run an update query everytime the record navigation buttons located at the bottom of the form are pressed. What form event will allow us to achieve this. Ryan

4. Anything that is between <CFSCRIPT></CFSCRIPT> is sent to the ColdFusion application server for processing. The ColdFusion Server ignores client side javascript because that will processed by the browser. <CFSCRIPT> can be included inline and the same results will occur. 5. Any...

We are having problems performing boolean searches using ZTBool on a normalized database structure. The problem we are having is when the user attempts to perform an 'AND' operation. Because our tables are fourth order normalized each entity only appears once in the table and is always by...

Could you describe how to connect to a Access Database? I am having trouble connecting to the database on another server. Thanks Ryan

Hi, We converted a ps file to pdf using distiller 4.0. The conversion went fine, but the Find command cannot locate any words on the pdf document. The text is not stored as an image since we can edit the text directly. Any help would be appreciated. Ryan

We are trying to convert a ps file created in pagemaker plus 6.5 to a pdf using distiller 4.0. After the conversion, we cannot search the text on the pdf. When we enter a word to find, it states that it cannot find it. Is there any settings that need to be set to allow us to search the text...

Hi, We are writing a search application which can display information in English or French. The language preference is stored in a session variable. There are two headers on all of our pages. One is french and the other is english. We want the page to refresh in the different language when...

Thanks. That is what we ended up doing. Ryan

Thanks for your help Ryan

Hi, I have a form which uses as its record source a query. This form displays which vehicles are currently signed out. When no vehicles are signed out, my form is blank. i.e. No labels, or buttons appear. They appear again when at least one vehicle is signed out. Does this problem have to...

Hi, I have a text field which has keywords listed for each study. These keywords are separated by a comma for ex, book,bed,pencil I want to create a query which will take all of the keywords and create a seperate table which will allow the keys to be accessed by a key id. Is there a way in...

Hi, I am trying to use cfloop to iterate through the characters of a string one at a time. I would like to start at the first character and go to the last character in the string. I used &quot;Len(string)&quot; to get the length of the string, and placed that expression after TO =. When I...

Hi, Thanks for all your help so far. It has worked, but we have now decided to use a table to store the constant. How do we access this table so we can assign the value of the constant to a variable in the form? Thanks again Ryan

Hi, I have decided to store it in a table. Can you tell me how to reference the field in the table within a form? Thanks Ryan

Hi, I was wondering if there was a way to state the current directory on the machine for file access, instead of c:\foldername\txtfile.txt. The program that I am developing will be used on different machines and will have different directory structures. Ryan

Thanks, I am worried that I will forget to change the constant. I would like the program to automatically update it at the end of the year. So, are there permanent variables? Stroll

Hi, I am a new user of vba. Is there a way of permanently storing varibles in vba?(without using a table) I would like to create a variable which is updated once a year. Throughout the year, this number would be used in a subtraction process to create another number. At the end of the year...

Hi, I am a new user of vba. Is there a way of permanently storing varibles in vba?(without using a table) I would like to create a variable which is updated once a year. Throughout the year, this number would be used in a subtraction process to create another number. At the end of the year...