Search results

The tutorials I've found have me run another page. This takes me away from my submitted form. I would like to stay on that form after submitting. It's a basic "Edit" form that lets you view a single record and edit it at a time. I'm trying to get an upload image function on this page so the...

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

Let me try this first instead of re-inventing the wheel... How do I get it to save the record and the used number as soon as the new record begins being created? This way as soon as someone types into the new record and the number is assigned, it will be saved and the next user will not get the...

Before this they printed out a sheet of paper from excel with the numbers already on it. They would fill in the rest of the information like job number and supplier when they needed to order something. If someone messed up then they just erased the info and reused the number. I'm trying to make...

Would this keep from creating duplicates when 2 people are creating records at the same time? I need a way to do this without skipping or wasting numbers.

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 did try me.filter="" didn't work

Not the full db. It has personal Info stored in it. I will have to move the needed items to a new one and post it later.

Awesome. That worked. Now I can't get the Reset to work. I've tried "Filter = "" and Me.FilterOn = False

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

Basically I need to fix how it imports the XML. This is the XML. I need to combine the track list and the recording tables... <track-list count="10" offset="0"> <track id="361863fe-8f24-33b7-8188-de56a99f81c1"> <position>1</position> <number>1</number> <length>224360</length> <recording...

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'm trying to use a query. Something like 433093 should return 7:13

I know how the numbers work. I just can't get the query to spit out the correct answers.

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 have found this code to make the PDF fullscreen by setting the PDF viewer toolbar and nav panes to 0. Doesn't seem to work on Access 2013 with Adobe Reader XI webBrowserControl.Navigate(filePath & "#toolbar=0&navpanes=0&scrollbar=0")

If your DB is that large then it wouldn't hurt to separate the tables and then have 1 "linked" DB that reads from the tables. I have even been experimenting with using mysql as the backend and using access to link to the data. My access dB doesn't store any info and is made up of just linked...

This almost works. It will find the file if I have no extension but not if the file extension is in the address. Also the TestStr returns only the file name and extension into the address box and not the full file path. The FileType doesn't fill with anything. I don't think parts b and c are...

That would be useful since my next task is to have it automatically input the file type.

How do I do that?