When I am in the code & design view, I can see all the codes, but the design view panel is blank (ie I cannot see the layout of the page at all) - the page can be displayed in browser preview without any problems.
I tried relaunching DW and opening a page from another site that I could see the...
I try to use the clone stamp in PS7 but when I press the alt button, instead of getting a little stamp icon, I get an icon that looks like a target viewfinder (2 circles with a plus sign in there), and the clone function doesn't work at all. This is happening for the healing tool also.
It...
I have created a query via the database results wizard in FP to obtain data from Access. One of the search criteria is for the field "City"---- I already have a data table in Access for storing a list of cities. How can I change the free text box (create by FP DB results wizard, code...
I don't seem to be able to find a way to modify existing Excel menubars. What I'd want to do is to disable the "Save" and "SaveAs" in the "File" menu but leave the other menu commands intact when a user opens a specific file. I have already got a macro that runs...
Still a problem with that line of code. I get an error message:
Run-time error '-2147467259 (80004005)':
Method 'Visible' of object 'CommandBar' failed.
Presumably the codes in Auto_Close are used to restore the user's setting of the toolbars to their original states.
dsi,
Thanks..... But now the next line doesn't work :-( (Sorry but I am not good at VB codes). Looks like it's something to do with cmdbarname(iIdx) not defined.
Thanks once again.
Al
dsi,
Thanks for the code. I have tried the auto_open part (with the modifications) and it worked great!!
However, when I try to close the workbook, I get an error message about the type mismatch in the line:
If sCmdBarName <> "" Then.....
Al.
Is there a way to stop Frontpage automatically inserts a blank space (nbsp) after a table (if the table is at the end of the page)? I have tried deleting it in normal view but FP adds it back afterwards.
How can I create an Excel macro that will run automatically on opening the file as non-read-only? (I don't want to run it if it's open as read only).
Also is there a way to suppress the toolbars when the file is open, or does that depend on the user's setting?
Thanks in advance for help.
Al
...connect to an Access database from FP2000. However, I got the following error message when I try to view the .asp page:
This problem can occur if:
* the connection has been removed from the web
* the file 'global.asa' is missing or contains errors
* the root folder does not have Scripting...
Recently I notice that when I am using the internet on a standalone PC at home, the McAfee virus scan/Vshield (version 5.21) starts the system scan when I visit some of the websites (usually ones with dynamically-generated pages), even though when I click on the system scan properties, it says...
Is there a way to refresh the data in a pivot table (in a different worksheet from the raw data sheet) automatically in Excel? What I'd like to do is to allow the users to modify the numbers in the raw data sheet and then the numbers in the pivot table will be re-calculated automatically so that...
Without having access to SAS at this very moment, I cannot check out why my previous solution didn't work (sorry about that).
Another solution is to try PROC SQL and specify your variable order in there.
PROC SQL;
CREATE TABLE Y AS
SELECT item_num, category, description
FROM...
To create a SAS dataset with variables in a certain order, I find it easier to do it using the retain statement in the data step.... eg:
data y; set practice.xmas_in_out_checklist_2001;
retain item_num category description;
run;
If you do a PROC PRINT on dataset Y you should see the...
I have an Access DB that is split into frontend and backend, with backend being the Jet DB. If two users open the same rows of records in a form but actually edit different records (ie records 1-20 are displayed on both users' PCs, but person A only edits records 1-5 and person B only edits...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.