Recent content by johnkrytus

I have an image on a form that is stored in a Windows folder. The path to the image is stored in a field in a table in a sql server database My trouble is that when I first put the picture in the folder and establish the path, I cannot get the image to display without completely re-rendering...

How do I refer to that column? "=[timeline_entry_id].[column](3)" is not working.

This is the rowsource for timeline_entry_id. It basically displays a dropdown of any companies that this person has ever been assigned to. SELECT [CompanyName] & " - " & [start_date] AS Expr1, qry_assignment_companies.EntryId, qry_assignment_companies.EmployeeId...

There is a lot going on in this form and there are likely a hundred much better ways to do it (I'm always open to suggestions)... The recordsorce for timeline_entry_id is attached in a pic as is JobSiteID. What I am trying to do is populate JobSiteID WHERE company_id is = to the company_id in...

Just because... here are is the table and query

Here is the query finalQry = "select ((Nz(FirstName, legal_name)) & (' '+ MiddleName) & ' ' & LastName) as fullname,('" + vFolderPath + "' & EmployeeId & '\profile_pic.jpg') as ImagePathJPG, ('" + vFolderPath + "' & EmployeeId & '\profile_pic.png') as ImagePathPNG,* from qry_people_not_merged...

Do you have an sql server if I strip down my database?

Your right. :) The wildcard is solved on a single form. So.. it's part two of my continuous form issue (I forgot that I hadn't mentioned that). I had thought that maybe the issue was how we were writing our query but your example proves that it is likely something else. Here is my (byllc's)...

I can't get your code to work with "*"

Yes sneuberg, it is. Same exact thing. I'd love to have you try, I'm just unsure about the process of sharing the database.. The front end is pretty easy, it's about 7MB. However the backend is a SQL Server database 350MB condensed with sensitive information. edit: I use a Mac running a VM...

No, the trouble seems to be that the image frame only retains the the id of the first record. So first I thought that it was a problem because I had it set to oncurrent. But I cant even get it to work on click of that record. When I try to grab the id of the record to plug it into the file...

I have one picture for each record. They are stored outside of the app in folders on a mapped drive. Each picture file has the same name however some of them are profile_pic.jpg and some are profile_pic.png Is it possible to display each corresponding picture in a continuous form?

Thanks for the hint. I needed the comma. And the end bracket had been in so many places that it just got misplaced in the end. I fixed it by getting away from the stupid wizard generated string SELECT [FirstName] & " " & [LastName] & ", Supervisor" & " " & Format( [ContactNo1]...

Will someone tell me what's wrong with the syntax of the format portion of this? please? I copied >>> !\(999") "000\-0000;;_ <<< from the properties dropdown and am guessing therein lies my problem. SELECT [FirstName] & " " & [LastName] & ", Supervisor" & " " & Format([ContactNo1] "!\(999")...

Control the formatting when you paste text Well the first reason is that this thing will have overhead, and who likes to be slowed down when they are doing data entry? Second, is that what I really want is just plain text. I can see problems sneaking in where odd characters are actually part...