Search results

I'm trying to use a code to check if a file exists. The code I have already works and gives a MsgBox telling if it exists. It gets the file address through a query that combines multiple fields. This works great when I have the file type entered in the proper field. How do I get this to work if...

I think it would be easier to transfer them to a new table. I will look into that.

I thought about that but I already have over 400 records set up the other way. I did figure it out using a rather complex multiple query and vba combo. I will post the process later.

So I have a table with a list of actors and roles that could be over 10 records long. Then I have a table for movie titles. I want to copy the first 5 records from the actors table into the movies table. The problem is the movie table has them broke out into seperate fields such as... Actor1...

Would you happen to know how to make the PDF stay full screen inside the webbrowser? When I go to a new record it automatically has the PDF controls.

That must have been the problem. I reinstalled Adobe Reader and then finally found the extension in the IE under the tab "Run without permission". Took to searching but now it works.

The WebBrowser is still not showing the PDF. All it does is open Adobe to full screen and shows the PDF that way. I'm trying to get the PDF to view in the form itself. Navigating to the file is the easy part. The part I can't figure out is to make it stop opening Adobe and just show the PDF.

When I tried to use the Navigate command it didn't show up in the list of commands. When I typed it in anyway it gave an error saying that is not a valid command. This is the first time I've seen the Object put in front like that. I will give it a try.

I'm only using VBA to create the file path. I use this code to find the file... Public Function GetDBPath() As String GetDBPath = CurrentProject.Path & "\" & Me.SetNumber End Function I then have this to put the path into a text box for troubleshooting and to ensure the path is correct...

I've been reading that all I have to do is put a Webbrowser control on a form and point it to the file path of a PDF and it will display the PDF in the box. Instead it opens Adobe and the browser is just blank. Is there another way to display a PDF inside a form? I have both Adobe AcrobatX and...

I'm trying to view a pdf in a form if the file exists. My search has brought me to trying the WebBrowser control. I have it loading the file but it launches Adobe instead of just showing the PDF in the window on the form. Am I missing something?

That worked. I used Year(CDate([FieldName])) and it worked perfectly. Thank you.

Do I put that in the updateto field? The XML imports into the table as short text by the way.

After importing an XML file. I have a table with a date of "1980-12-31 00:00:00". I want to put the Year portion of this information into another table.

How do I get an update query to only copy part of a fields value? For example: The original field has a date in month, day, and year. I only want to update the new field with only the year.

I have it working. I have the data split into 3 subforms that show the images. All 3 subforms are on 1 form. Now how do I get all 3 subforms to synchronize scrolling?

Any suggestion on how to do the math on these records?

I get the feeling this is going to be very tricky and difficult

Then I need to find a way to get the results of the code into a field. I can get that part. But I can't figure out how to make the form show columns of images like that

Yes. Like that