Search results

hello again.. I have a form linked to a query. when the form opens its asks for a part number it takes the part number and populates the form with a bill of material (a list of parts). What I'd like is when a part number is clicked on from the list that part number is then passed back to...

Hi there, I have a number of tablets with access 2016 runtime installed. they all pull the same front-end from a network location. However, I get a pop up regarding trusted locations. I found some registry edits that will allow this, but I dont have those locations...

the spaces maybe there for the ERP software for some strange reason, im reluctant to change any table/s as it may break their software.

FullPath: Left([Path], Len([Path])-219) & [File] worked. i understand the trim function better i would say. thanks to both of you, always a great forum/users

Yes that works! will this work for length of text in PATH? @DBguy ah that worked i tried this before but i had plain text with rich text it removed the spaces after FILE! Thank you to both of you both methods work. now... what one should i use?

my mistake. result is 32

here we go: =Asc(Mid([PATH],[31]+1,1)) #NAME?

I'll give that a go right away

\\SPRINT2\REGISTER\HB\HB101943\HB101943.PDF that seems to...

doesnt seem to work output= \\sprint2\register\hb\hb101943\ hb101943.pdf

=InStr([PATH],Chr(13)) = 0 =InStr([PATH],Chr(10)) = 0 If I use trim it shows fine (no additional lines) but i cant get it to concatenate: https://imgur.com/a/MpRdifY

they were placed in the pervasive database by Globalshop solutions ERP software

ah yes thats it DBguy! https://imgur.com/a/PVjYrlT how would i remove that ? im trying to make a hyper link from the concatenation

=[FILE] I get the expected FILE output HB101943.PDF =IsNull([FILE]) returned 0 Thanks for your help guys

if i could just hide anything that = #DELETED that would do just fine

hows this? PATH=\\SPRINT2\REGISTER\HB\HB101943\ FILE= HB101943.PDF =[PATH] & [FILE] \\SPRINT2\REGISTER\HB\HB101943\HB101943.PDF but i just get \\SPRINT2\REGISTER\HB\HB101943\

file contains the file name with its extension (ie) book.PDF https://imgur.com/a/uiiXrZp

i have two fields from a linked database that I'd like to join. I've put this in the control source but i only get the first [PATH] and not the [FILE] in the output this is what I'm using: =[PATH] & [FILE] I get the same result if I try to do this in a query: FULLPATH: [Path] & [FILE] i...

hey @theDBguy any chance we could pick this up? really thankful for your help, ive just had a number of issues come up, i've finally got some free time.

ah, GMT here.