Grn Xtrm commented: Thanks for the help. +1
Use Publisher.
I thought Photoshop opens with the last tool you used.
When drawing shapes in photoshop, make sure that you do not have one of the options for the tool set to path only. Path will not physically draw a shape on the layer causing this. You need to have the options of either fill pixel or shape layers selected in order to be able to select Layer --> Layer styel.
The path only button has a little box with the pen tool in the center. The other tho have boxes. Leave your cursor over these options for a few seconds in order to see what they are called. They will appear on the toolbar at the top of the screen after you select your tool from the toolbox.
I didnt read it but would this work?
http://www.kitebird.com/articles/access-migrate.html
and here's another
http://www.howtodothings.com/computers/a3744-how-to-convert-access-to-mysql.html
What is the field size for the number fields in the table?
Check out this post for Question A. It seems similar. http://www.daniweb.com/forums/thread224378.html
Question B I'm not sure.
This is for school work isn't it?
You know jpeg does not support transparency, right?
Hi Enthused,
sorry for being late to reply. As you suggested, I would like to show you a screenshot of what the page looks like but do not know how to paste a screenshot here. I did check to make sure that the art file, which is Adobe Illustrator (saved as GIF 128-no dither) is not a transparent web file. All of the photos were assembled in Photoshop in different layers but flattened when they were converted to high quality jpeg format.
Thanks again for your interest!
Personally, I hate websites that play music. If there is not an easy way to turn off the music on the site by clicking a button, I will go to another page that sells or talks about the same thing.
Are you sure the image is transparent at the top? Maybe the white strip is in the image.
What exactly are you saying?
1. You were working on a file in photoshop when everything shut down and the only version of the file you have is .jpg and not .psd?
if so, there will be nothing you can do about that. You will need to redo whatever you had done in photoshop before the shutdown. This is a great learning lesson to save often. It's fast and easy. ctrl + S.
2. When you are working with photoshop the only option for saving pictures in is .jpg?
How are you trying to save images? File-->Save for web & devices or file-->Save As?
Here is a fast simple way to do it. Rename the extension from .doc to .jpg. Now it wont do anything unles syou change it back to the correct extension ;)
Gifs do support transparency
Illustrator has a type on path feature in which you can draw a shape then click on the type on path tool, click on the path and start typing. I have not heard of doing that with images though.
Seamless images for when they repeat on say a webpage? or you are putting 2 pictures together in photoshop and want the transition from one to the other to be seamless?
One way would be to have the store number entered from a combo box.
Have a table of all your store numbers, locations, etc. Make a combo box based off that table and add in all the fields that are needed for the autofilling. For the properties of the combo box, only have it display the column of data for the store number. In the text boxes that you want auto filled on the form, enter this as the control source:
=[Combo Box Name].[Column](1)
or
=[Combo Box Name].[Column](2)
and so on to display the other columns of data from the combo box.
That is how I have done it in the past. Good luck.
Just a guess, but maybe set them as unread in Gmail. Generally the send/receive will only pull down new mails.
I don't wuite understand why that would be tricky unless it was illegal. I have installed and activated adobe products in the past and as long as you put the code in correctly, it works without a hitch.
Open the problematic word document, highlight everything (or ctrl + A) create a new word document, paste (ctrl + V), save it, then try to convert this new document.
This same problem has happened to me before and this was the solution I found worked. Hope it works for you too.
Check your caps lock. I dont ever remember it looking like a pen, but then again I haven't used PS7 for a while. I just know that the cursor will change appearance by pressing the caps lock key.
Hmm, I wont get onto the topic of legality so . . .
Just found this site and started using it. Quite interesting really. It recognizes when people copy or highlight text from your webpage and/or copy pictures. If they paste a passage somewhere, it automatically places a link form your page underneath the copied text. It is completely free. Webmasters might want to check it out.
I'm sure there is a VBA approach to this, but you could also make a macro with 6 lines in it.
Make a new Macro and use the following:
SetWarnings = No
OpenTable = table you want to remove all records from
RunCommand = SelectAllRecords
RunCommand = DeleteRecord
Close = choose table and specify table you just opened
SetWarnings = Yes
After the macro is made, make a command button and assign the macro to it.
No need to use a query to do this.
Good luck
Check out this little sample I just made. Is this what you are trying to do?
Also, if you are creating the expression, then the table field should be left blank. The query will not add this data to your table nor is the new field you are creating in your table. It is basically just a display only look at it so you do not need to put in anything in the table field.
Is your field called HomeSum or HouseSum? You have it written both ways in your question. Try it without putting [ or ] around your constant.
Hence taking a picture with say a 10MP or greater camera and using that for pictures in advertisements. It should be more than large enough and shrinking is not too much of a problem.
Turn on the text tool (looks like a letter A), click somewhere in your image, then start typing. For the sake of being easy, after done typing, click on a a different tool (any other tool is fine), then click back on the text tool. Click in your document and type again. You now have 2 different "text boxes" using the arrow (select pointer tool) click on either of the text boxes and you can format the text differently.
Hope this helps.
Just so you know though, you can have multiple fonts within the same text box. You just have to highlight the text with the text tool and using the property panel specify the formatting.
Try doing a google search about action script to see what will pop up.
I'm pretty sure Access says it can handle up to 255 concurrent users, but I personally would not trust that.
I have made databases in which 5 - 6 people used it at the same time and it handled perfectly fine.
Just to beat a dead horse, think of them as the heading styles in MS Word. It's preformatted to standout.
The simplest solution would be to use Microsoft FrontPage. You can create a form in it, and tell it to link to a database. FrontPage will make the database and set up all the necessary connections.
It will not be the most organized or efficient database, but it will allow for a web frontend if you do not want to get into any programming.
I do not know of any good books off hand.
Good luck.
gmalsack do you want to just have the name display that way, or do you want the names to be entered into your database permanently after typeing them in like that.
If you want to just have them display that way, you can do so on a form or report by having an unbound textbox and putting in a value of =[Lastname] + ", " + [Firstname]
You might need to use & rather then + depending on the data in your table.
Have both the last and first name controls on the form or report and just set their visibility to No.
Found a solution that works. I should have figured it would be easy.
IIf(IsNull([forms]![frmFilter]![DeptCombo]),[Department],[forms]![frmFilter]![DeptCombo])
I put this as a criteria for each of the fields in the main query substituting the combo box field.
If anyone can point me in the right direction I would greatly appreciate it.
I am making an Asset Management database. I'm looking at having about 50 fields in a table. Of those 50, 25 could potentially be used for searching. In some cases multiple fields would be used to narrow the scope of a search.
I have created a query for each of those 25 fields and set it to group by so I have a list of unique values for those fields. I then made a form with combo boxes based off those queries. My thinking is now on 1 form I have 25 combo boxes and a user can select what they want to sort by, by choosing it from the combo boxes.
I made another query that references all of those combo boxes as criteria for the fields.
This of course doesnt work and I can't figure out a way to ignore fields the user does not use to filter the data. The query always comes up empty. Is there a way to ignore unused fields? I set a default value for each of the combo boxes as "Choose Filter" but I can't figure out how to have Access ignore the values listed as "Choose Filter" while filtering based off the used fields.
I have tried to look up stuff about cascading combo boxes, but I do not think that will work for me because the user might use different fields …
FLA is the editable Flash file. It contains all the layers, key frames, motions guides, programming, and everything else. It is the source file of the SWF. Before you put the movie (FLA file) online you save it as a SWF. The SWF is what people are actually seeing. SWF is not editable.
SWF would be like merging all layers in a Photoshop image before giving it to a client. It is a way to protect your work (people can't see what you did or how you did it) yet they can still see the end product.
You did upload the .swf into the folder specified in the path?
Why do you want it to be a vector graphic? Photoshop is mainly used for Raster images. Use Illustrator if you want a vector image.
What does the boundary look like? Is it a border on the edge of the image. Save the picture and post it up here and it will be easier to think of a way to fix the problem.
If you want to save things in a GIF format, do File --> Save For Web then choose one of the GIF settings. That is the best way if you ware planning on putting it online because it will remove all extraneous information that is not necessary to allow the picture to display.
If you want to work in a GIF format while within Photoshop, you need to change the color mode (Image --> Mode) to Indexed Color. Remember GIFs can only have 256 colors.
People would still have to download the picture from flickr to be able to see it so IMO I still think it would take just as long for a user.
You can tell when something is flash by right clicking on it and looking at the menu.
If you can't get timothy's suggestion to work, type null rather then "" in your condition.
So again I'm not a programmer, but here is the finished product after searching through a lot of websites. It works so if anyone is ever trying to take Word form data and import it via Access, use this code. It will search all of the .doc files within the directory containing the DB and after it imports them, rename the file to have an "xx" in the front. It will not import those files again.
Sub GetWordData()
Dim appWord As Word.Application
Dim doc As Word.Document
Dim cnn As New ADODB.Connection
Dim rst As New ADODB.Recordset
Dim strFileName As String
Dim blnQuitWord As Boolean
Dim strPath As String
On Error GoTo ErrorHandling
Set appWord = GetObject(, "Word.Application")
strPath = CurrentProject.Path + "\"
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" + CurrentProject.Path + "\WorkstationRefresh.mdb;"
rst.Open "tblData", cnn, _
adOpenKeyset, adLockOptimistic
strFileName = Dir(strPath & "*.doc")
Do While strFileName <> vbNullString
Debug.Print strFileName
If Left$(strFileName, 2) <> "xx" Then
'don't process
Debug.Print strPath & strFileName
Set doc = appWord.Documents.Open(strPath & strFileName)
With rst
.AddNew
!LName = doc.FormFields("LName").Result 'put in the rest of your fields in the same way
.Update
End With
doc.Close
Set doc = Nothing
Name strPath & strFileName As strPath & "xx" & strFileName
End If
strFileName = Dir()
Loop
If blnQuitWord Then appWord.Quit
cnn.Close
MsgBox "Workstation data imported!"
Cleanup:
Set rst = Nothing
Set cnn = Nothing
Set doc = Nothing
Set appWord = Nothing
Exit Sub
ErrorHandling:
Select Case Err
Case -2147022986, 429
Set appWord = CreateObject("Word.Application")
blnQuitWord …
I'll start off saying I am not a programmer. I am making a database that imports data from Word forms. It requires code and I found some that works almost perfectly for me at http://msdn.microsoft.com/en-us/library/aa155434(office.10).aspx
It does exactly what I need. The only thing that would make this code better would be to use relative references to the database and imported files.
strDocName = "C:\Contracts\" & _
InputBox("Enter the name of the Word contract " & _
"you want to import:", "Import Contract")
Set appWord = GetObject(, "Word.Application")
Set doc = appWord.Documents.Open(strDocName)
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\My Documents\" & _
"Healthcare Contracts.mdb;"
rst.Open "tblContracts", cnn, _
adOpenKeyset, adLockOptimistic
In a previous database, I was able to use CurrentProject.Path to allow for relative paths, but I can't figure out how to get that to work with this code.
Can anyone please help me by letting me know how to set up a relative path for the referencing. I am planning on storing the database and files to be imported in the same folder.
Thank you
remove the _blank for the target. I think you can put self or _self. I cant remember which
If your whole website is made in Flash, then that code would work. You just need to name frames P1 and P2 where you want to jump when those actions are performed.
If you want to go from Flash to a webpage, then you would use getURL like Peter said.
Not really sure why, but you can try to reset your preferences.
Hold Alt + Ctrl + Shift when you open Photoshop.
I use Fireworks
I have a database used for Phone record auditing. I am trying to see whether it is possible to have labels within a section disappear for 1 page but appear for another. I'll explain below.
In the page header, I have it display the customers name and phone number as well as the date range for the billing period. Currently, I also have the labels for the details section also in the page header (this is what I want to disappear for the first page of the phone number group).
I have a group based off the phone number and in that I have a write up that the user needs to sign verifying the phone charges are accurate. I do not need the labels for the detail section to show above this.
Next I have the details section which can span multiple pages. I want to be able to see those labels at the top of all pages.
I have a footer for the phone number which forces a new page after the section. This way the write up that needs a signature in the phone numebr group heading will always appear on a new page thus allowing me to give the report to the customer without them seeing anyone elses info.
So in essence I have many reports within my 1 report, but I did not use any subreports.
So is it possible to make controls not be visible for the first …
I've never encountered that before. Does the flash drive have problems with any other types of files?