Search results

I'm using mysql and php to create a website. I want to upload an image to a folder on my server and rename that image to the records ID field and convert to jpg. Any suggestions on where to find this info? I have found tutorials on uploading and even renaming, but nothing on setting the new name...

I have a DB that is used by multiple people. It has a "PO" field that uses a VBA code to generate the next number instead of Autonumber due to needing the numbers to actually be in order. The problem is that if 2 people are creating new records at the same time then it will create the same PO...

I have a form with 5 options in a group. This works fine when I only have 1 filter applied to each button. I need to select the "Not Collected" button and have it filter out and show "Collected = No" and "Deleted = No". Here is my code... any help? Case 3 is the one I'm currently working on. I...

I'm having a hard time finding the answer to this. I get XML's from a site and want to import the data to Access. If I use the native import then I get multiple tables and the data is a little jumbled. For instance: I get 1 table with track names and a different table for track numbers with no...

I have a VBA code to import info. The problem is it imports the times as milliseconds. I can't seem to find the formula or code to convert this into minutes and seconds and the math work out correctly. It's either a little off or goes from 5 minutes to 52 hours... any help on converting this?

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...

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...

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?

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 want to make a form or report that acts similar to a "bookshelf" view showing around 4 or so images in each row. When an image is clicked on it takes you to that record. Any suggestions? I know a report can be used to make rows but how do I get the images to display? They are stored in a...

I have a form tied to a table. Some fields on the table have the exact same info on them. This data is basically a description of the "Job Number". The Tech creates a new record each day he uses this "Job Number". I want to be able to just copy the recurring data if it already exists.

I have a form that has a date worked at the top and then an area to enter times in and out. The times in and out use the default Date/Time field and then calculate the hours worked. How can I have the times in and out read the date worked field for the date section and only require me to enter...

Ok. So I have learned my lesson on saving images into an Access DB. Now I'm using VBA (another good learning experince) to save the images back to a folder. I have a code working that will save the images but I need it to also rename the images after saving. The section "MyFile = OldFile"...

I'm trying to learn how to automate my Access database to get information from a web site. Any suggestions on how to learn this or where to learn this?

I have a TV Episode database. In the database I want to number each episode of a show. How do I autonumber a show's episodes when sorted by season then episode and have the autonumber restart at 1 when it hits a new show title?