Search results

This might seem like an old topic which it is. But I've come a long way and can now finally worked with this code and actually make it work for me. So here is a very delayed Thank you for your help. Bob

hi David. I you talking about the topic that I left about trying to put together my linked forms. If so, I have been to many forums and never got off to first base. Eight months later and I'm still trying to figure out how to do it. If you're talking about the above structure it worked out...

I'm trying to create a forum that uses tabs so I can open other forums whenever needed. when on the form. I also need a browser, tubular display of the data so I can scroll through all of my data. The form will be a data entry form. The form also will need links to other tables that will contain...

From getting a bunch of file-names, 9000, into a databases has been a long journey, but I'm there. Now with my limited knowledge of Access I need take a field, holding image file-names, and the name into a matching field in a different table as an attachment. Both table's share the same...

Thanks for the help Pat. Bob

Thanks to you both. Bob

Some time ago I watched a technician creating structure from a table, using 2013, as fast as 123. I have been looking through the menu system in Access, and can't find how to accomplish this. Saving active table as a structure. Bob

Back in March of 2010. It wasn't much of a chance for me to understand the code that you help me with. You would think by now I would have a better understanding. I'm really not much closer. But I do appreciate your putting together the code. I wish I had the ability. Bob

So I'm assuming, from the response, that the filename would have to be part of a field. And that would be okay but how would I get the filename into access, 365, as a field name. I also failed to mention that the file name has to be changed to the second set of characters, B, or 427900 and than...

I'm trying to split up the filename into four separate fields. Here's an example of the filename: 123112 427900 55261 1156833.jpg A 12312 B 427900 C 55261 D 1156833 The values A, B and C are always the same number of characters. The last value, D, changes in size. It can be anywhere from four...

I have a field called "SC" with a value 13-251. I need to remove the "-" ending up with 13251. I tried using, as a starting point, Mid(String, Start, Length) with no success. I found this in another topic, and thought this might be close to what I was looking for. I sure did not know how to use...

I was able to get a solution using Microsoft community my answer. UPDATE PERMIT INNER JOIN WICHK ON PERMIT.seal = WICHK.seal SET PERMIT.[WI-WI] = "okay", WICHK.[WI-WI] = "okay"; I will bit surprised. AccessWorld used to be the top-of-the-line. Maybe I just didn't explain myself as well as I...

I've tried several ways to match two Tables with no luck. So I changed my thoughts a bit: Permit->Seal (also contains a field called "SEQNO") SealCHK->Seal (also contains a field called "SEQNO" which are all empty fields currently) If Permit->Seal = SealCHK->Seal than SealCHK->SEQNO should...

I have two tables Permit PermitTest Both have a field, column, called seal. if they match I have another field in Permit called "SealMatch". this is what I'm trying to do. Permit-> Seal linked to PermitTest->Seal If PermitTest->Seal exist in Permit than Permit->SealMatch should be yes, Yes &...

Yes the mission was to capture all the filenames. No one was able to figure it out anywhere. But by chance I resolved the issue by capturing over 6500 files in less than 30 seconds. So even though it's not part of Access I did want to share this amazing accomplishment: I'm afraid I was trying...

I have been searching around looking for a solution. All in trying to do is find out if a filename, in one folder, exist in my Access database, table. I was thinking that Access cannot look into a directory itself what may be VBA could. It's a matter of a file, name, existing in Access, and if...

Yes. It would be a table. Either way I see notning can work Bob

I did check it out. It's a bit over my head. I also think it's probably far greater than what I'm looking for. I just have a stack of files and I want to create a record in the database that contains the file name and a link to it. Based on my limited knowledge of Access I might have to run some...

Permit can be anything Table or database. What ever will work best. Permit is a table or database that has a field called "SC". "SC" contains the filenames of images that reside in a directory on my hard drive. I have added an additional field to Permit-"SCART". I need to create a link to...

Logically I'm thinking what I need can be done. I just don't have a clue on to the direction start. Basically it's trying to take all the files in a given directory and add them into a existing database. I have a database called Permit. the database has a field called "SEAL" and they will be...