thanks for the advice, but I already tried that and that is when I get the error saying that I do not have an exclusive lock on database MODEL. I know I can't have an exclusive lock on a database that doesn't exist according to the master database, so I am looking for a to attach the model...
I backed up the master database from one server after I had detached the model database. I then restored this master backup to a new server and now I do not have a model database referenced in master on this new server. I have the .mdf and .ldf files for the model database and I have tried...
Thanks, that did it. I appreciate the patients.
By the way, congraduation tlbroadbent on being voted TipMaster of the Week. Good luck on winning that leather jacket.
P
Not sure what I'm doing wrong. Select the query name, click on design, then inserted a new column. Left "Field" "Table" "Sort" blank. Typed MYSTATUS: IIf(Left([STATUS],1)="C",1,IIf(Left([STATUS],1)="P",2,3)) in Criteria. Go to click on...
I copied your statement and pasted into a new column criteria in the query. I get an error message. "The expression you enter has an invalid...", click OK and the cursor blinks on the first open parentheses. I have four open parentheses and four closed parentheses. I do have the...
In my report I would like to have, under Status, show all entries that are "Complete", first. Then all entries that are Partial, second. Then all entries that are Incomplete, third.
I have a column in my report called "Status". The Status will be either Complete - Incomplete - Partial. How do I make the column list by Complete - Partial - Incomplete??
I run the report from a query.
P
In Office 95 after I draw the control button it prompted me on what macro I wanted to assign to the button. Now in office 2k it doesn't ask. How can I assign an already made macro to a control button with going into visual basic and copying and pasting the code??
P
I tried to copy all of my Outlook Contacts into an access table. I used the “Get External Data” and had the wizard make a table for me, but it only copied 15 of my 54 contacts into the table. I noticed that it only picked up the contacts that have e-mail addresses. Some businesses don’t have...
When I turn on my computer the first screen comes up with 3 lines in which one line has "SGRAM Size 8.00". Then another screen comes up which has the Energy Save symbol and does a memory test along with plug & play. Then it loops back to the first screen and keeps cycling through...
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.