Search results

If I understand what you are suggesting... my database already uses tab control for the forms (including form #3). Are you suggesting making the 3 sub-forms used on form #3 tab controls themselves? If that is what you are saying... I am not sure how to implement that considering the nature of...

Well back in Post #3 I explained that I discovered the reason and was making the new table to solve it. As for the question of WHY I believe that the form and sub-form should both be based on the same table... Originally my database was one table and three forms. Data table that held all...

Scolded for not posting enough information and too much information at the same time

Wow... Pardon me and never mind

Sorry... After all the threads regarding my database... I didnt think I needed to explain those details again. Database is split. Only me in it at the time... No other users. The form and sub forms are using the same table. This worked before but for some reason isnt anymore but I think I have...

I know there have been many threads regarding this error but I have narrowed down the culprit but do not know what needs to be fixed. This only happens to one of my forms in tab control but it is complicated. History... Tab control main form (frm_home) Form on a tab having issues...

I forgot to mention that the attachments form will refresh every time you click the submit button and you can continue to add more files one at a time... or.... if you have multiple pictures you want to add with the same explanation you can either keep clicking the browse for file button or...

All of your users have the same rights number. You will not be able to differentiate between them for access permissions... they can all do the same thing. Is it safe to assume your users have to log into your database? There is a users table storing their usernames and passwords?

For visual reference... On the tab on my main form you click the attachments button and the code knows the current record showing on that page The attachments form opens and you can browse for your file and then add an explanation of the file. Once you choose a file and it is displayed in the...

Here is the final code for the attachments form. I made a command button on the form (which is in tab control) that opens the attachments form. remember that my database is used across a WAN so the strPath would be different for you on a LAN Button code: Private Sub cmdLabAttachments_Click()...

What do you mean by "Start using"? Like in a report?

Not hung up on the CopyFile part anymore Actually making good progress on the rest of the stuff I mentioned. I have our in-house code master helping me right now and the code has changed a lot. I will post the solution when it is done so anyone else looking for this can use your or mine or a...

It appears it was the actual CopyFile part... it needed to be FileCopy. Cleaned up the code a bit more and noticed that it is storing the wrong link in the table. It is storing the link to the original file location rather than the new file location. Working on that and trying to make it so...

The first part seems ok Call CopyFile(Me.txtPath, The next part is what I am having trouble with "C:\adBEs\links\" The last part doesn't come into play due to the second part & GetFilenameFromPath(Me.txtPath)) So I am creating a directory under the "Attachments" directory that is using the...

I have been doing a lot on this since I posted this morning... stuck on a small part. I have a command button on my frm_visualinspectioninput that opens the form frm_visattachments. Here is the code for that form: Private Sub cmdBrowseToFile_Click() Dim fDialog As Object Dim varFile...

No worries at all... thank you for your time.

I think I am confused... I need to build the form that is used for the attachment file choice. from your code: Private Sub cmdLinks_Click() Dim fDialog As Object Dim varFile As Variant Dim strPath As String ' Set up the File Dialog. Set fDialog =...

Can you tell me how to integrate the 3 sets of code into one? It seems I need to create a form as the dialog popup for selecting the files to upload. I do not know for your page where txtPath is on the form you showed but I would like to have the images upload and the links created when the...

The reason I am creating directories using the value of the PONumber field is because the users might name their images the same from record to record like "Image1" Image2" and that would get confusing if they were all in one directory so since the records are mainly identified by us using the...

I am working on trying to meld different code together to use this and it work from my forms command button to submit the record update. Currently the form that I am modifying has a dropdown with current records in the database that need updating. Some fields are auto populated to show the user...