Search results for query: *

certain queries within my access application need to be protected from user changes, they can read only. How can I set a query property to protect it against any changes. I'm not using Jet security, but do captuer use names. Naturally I need to have read/write/change for mysely. thanks in...

How do I imbed an & with displayed text....I have tried "&", '&' and a combination of both ("'&'")...in this situstion the single quote is displayed but not the &. I know & is a special char. thanks in advance!

Word defines the black down point triangle special character as alt X, or using character code 25bc. I'm trying to use same is Access in VBA, within an if statement on a procedure for streaming stock quote, that character being used as a negative if the change in stock value was negative. In...

I have 2 applications, each with a PW on DB and PW on visual basic editor. Tyring to copy 1 form from 1 to other....prompts me for DB PW on other....ok....prompts me for form name on other..ok..prompts me for a 2nd time DB PW on other...just like copy of tables or queries to other....but then...

Business situation where a max amount/policy can be paid only, lets call it a maxbonusperpolicy. The totalbonus is made up of many policies and the rule is the ratio of members one policy to the total members all policies, a ratio (on each policy)applied to the totalbonus can not exceed a set...

In a multi user Access environment, I included on the quit routine a docmd.save before the actual quit. Seems this causes Access DB to be put in a state by user type error. Is this 'save' command at the global level...saving for all users within application? Is save included within the 'quit'...

Exporting an Access report to Excel results in certain text column data getting translated incorrectly. This happens only on certain records, not all. Example in Access the text defined value "0000006285-010" gets translated to Excal in a column defined as General as "1601864". Another example...

I have a report with one to many subreports. The number can vary. How do I refer to each subreport (or all) when trying to sum a field in each subreport producting a report total. I have tried to sum from the page break section...but understand Access won't allow and an error is produced. I...

Access, how can I control and validate the sum of the allocated amounts equals the original totals exactly. When percentages are applied against an original amount, how can I verify programatically that all the parts equals the the original total, and/or adjust the total to equal that amount by...

I have created an semi-secure Access application using front end PW,plus a 2nd PW on modules, and restricted the properties windows to be 'design view only', set view properties on startup to off (menues,short cut keys/menu and I control 'allowbypasskey' via VBA. It is menu driven only, no...

How to I add a password to the docmd.transferspreadsheet command moving data from Access to excel. I have seen examples how to pickup an Excel file thats protected with the similary docmd in Access using an Excel object and the filename statement? Thanks in advance!

When a forms window is opened by a user (even in a semi-secure environment),I don't want then to see or use the forms properties window....I know I can turn it off (not visible) via the main menu (alt-enter)....but I want to control this option via VBA code. Its part of my desire to restrict...

I loaded code examples and modified as required...designer = , open form "mine" and seems to work step by step in module....autoexec also setup....by when I close and reopen access i get the following error....and thereafter i can't open it at all. The error is "command line used to start MSO...

New to PHP/MySQL....looking for an integrated editor for PHP and MySql using Apache. I have DzSofts PHP Editor and PremiumSoft MySQL Studio....but they are not integrated as one....is there such a editor utility for this combination. Dz' is ok for PHP....and Studio is great for MySQL...but i...

I have reinstalled the latest version of PHP for Windows 98 using PWS and a MySQL database. Used the install utility and although I'm not getting any errors (previously I got security error 304)...the simple function PHPInfo() just keeps running...never any output...like its searching for some...

I have reinstalled the latest version of PHP for Windows 98 using PWS and a MySQL database. Used the install utility and although I'm not getting any errors (prev I got security error 304)...the simple function PHPInfo() just keeps running...never any output...like its searching for some...

Trying to test PHP installation in a PWS/windows 98/MySql environment on my home PC. Created a PHP extension page with standard html and the PHP tags with the PHPInfo() function. Storing the file in my root directory and using the URL 127.0.0.1/file name.PHP. The error is 'forbidden execute...

Can you recommend a good PHP based utility to load/display images to a secure user account. Display ideally would be in a photo album style. The database is MySQL using windows 98. Thanks in advance....Jim

I'm developing a new MySQL DB and have a need to support the import/display of a series of images by user account. Should I design the DB (seperate table)to include images related to this user account or save the image files to a seperate directory with a indexed unique name representing this...

Has anyone worked with this tag from CFDEV at Allaire. I'm in a local server environment trying to get it up and working. Their looking for there variables to be set imagepath= thumbpath= imagedir= thumedir= I believe the reference to image is the uploaded picture path or dir. in my...