Search results

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

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

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?

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

My users do a fair bit of copy/paste from any number of sources. How do I force the paste action to strip out any hidden characters? Now I realize that a return and a space are hidden characters, so how do I strip out everything but the ones that I want?

How do I do: on event enter last saturday (in a control)? The best I've been able to come up with is to check if it's A saturday. Private Sub ctrl_Weekending_Exit(Cancel As Integer) Dim strDay As Integer strDay = Nz(Weekday(Me.ctrl_Weekending.Value, vbSaturday)) If strDay <>...

I have a report, on a control tab, on a main form. On the form are two buttons: one to show all items, and one to filter them based on a boolean field called showitem. The buttons work with the code below. What I want to do but cannot seem to figure out is to have the report default to no...

Is it better to assign values to created_at and updated_at in the database or at the UI? On one hand I would say it should be done at in the database because it feels cleaner. Simply set default value of created_at to now() and its done. Updated_at is a trigger and it's done. On the other...

"rpt_notes_people_condensed" is a sub-report bound to a form called "NavEmployee". When I call the pop-up form "note_enter_todo" it currently displays an expanded view of one of the records within rpt_notes_people_condensed. What I want to accomplish is: - find the record in...

We just converted our database from postgres to SQL Server. This error appears to be all over our code. You must use the dbSeeChanges option with OpenRecordset when accessing a sql server I am only a novice level coder and the guy who often helps me just left on vacation. Any help would be...

Why won't this work? It works with without the 'or' but with it, it just gets ignored. If rs!TermsID <> (4 Or 3) Then

Why is strCreditCheck returning the actual query string and not the result? Of course, this is not working. Please help. Private Sub b_PrintWorkOrder_Click() Me.Requery Dim strCreditCheck As String Dim strCompany_id As Integer Dim stlinkCriteria As String...

Expr1 is a field in a report that is bound to this query. timeline.CompanyName doesn't usually have any data in it, and when it does it needs to be removed and manually input into companies.CompanyName. Is it possible to make timeline.CompanyName output as italics? Otherwise we dont know...

I have a picture stored on a network file share that populates each time a particular form is opened. Every so often we lose our connection (which is a different issue altogether). Right now the error I get after much grinding away, is "Bad file name or number" Is there a quicker way to check...

How do I conditionally change the Back Color and Alternate Back Color based on the value of notes.FollowUpDate? I have a continuous form using the following code: Private Sub b_all_past_Click() Me.resultsFrame.SourceObject = "FollowUp_bystaff" Me.resultsFrame.Form.RecordSource =...

I want to my ImageFrame to open as a picture. My problem is that my picture could be either a .jpg or a .png (or whatever). The code below works if I hard code profile_pic.png or profile_pic.jpg. Is there a way to use the wildcard here? (Its not working as written now) Dim...

fullname shows up in my results as a blank space if either FirstName or LastName are blank. How do I write an If Null into this? Actually what I would really love to write into the SELECT but have no idea how to, is: If NickName is not null THEN fullname = NickName + MiddleName +...

I have the following expression as part of the recordsource for a report: Is it possible to put a mask on the output of [phone1]? Ideally something like: (716) 555-5555 x1234 phone1: [ContactNo1] & " " & [ContactNo1_ext]

Is there a way to call Events from multiple controls at the same time (assuming the action is the same)? Private Function OpenPeopleNavigator() As String '--Open the People_Edit popup in the Company Contacts View Page Dim stDocName As String, stlinkCriteria As String stlinkCriteria =...

What is the syntax to display a particular record inside of a tab located on a pop-up? In other words, I have a pop-up called People_Enter. On People_Enter is a tabbed control called TabCtl89 On tab (2) is a subform called company_contacts_attachcompany that displays a Single Form record...