Search results

Good day to all, I have a simple query reading the records in a table and testing if the link on file has a folder\file on disc. I get alternative messages that both entries does exist and when I run the report again I would get both not to exist. (Only two records on file) The truth is only...

Good day to all programmers, For the first time I do not understand why a mapped drive shows the share name and not the drive letter (example x:) See attached jpg file. the mapping should come out as x:\.... Thanking you in advance Kobus

Good day to you all. All of a sudden my Access 2007 causes a problem when converting a printview page as a pdf file to outlook. Even when I save/publish it as a pdf to disc. (It vertically cuts off a quarter of the page vertically. see images. Appreciate your feedback. Blessings, Kobus

Good day to all, I have successfully linked, and imported the Outlook inbox containing my input emails. The only problem is I need the email address in all cases. As you know Outlook displays the actual email address, or the person's label name. Question: How do I get the actual email address...

Good day to all, I need some help about using dates, I don't understand why it is not working. I have a date field defined as Date/Time format short date default value now() in the table. Now running a query with criteria #26/10/2015# or now() return no records. Could it be the time embedded...

Good day to all, I have a patient record with orthodontic images linked. (See zip file Form.jpg) When I preview, or print the result it SOMETIMES drop a image as can be seen in the zip file. (Print.jpg) It is marked with an X This is becoming a norm. In this example the image dropped was the...

Hello to all the lovely programmers out there, I have two questions. (1) I am displaying a paragraph with VBA coding into a unbound text field. But I need to high-light some text, not all text. Hence some next in the paragraph needs to be RED and BOLD. so ln1 = "hello there " &????& "this is red...

Good day to all, The code I have used before within the program to set the focus is not working. It Goes to the next field. I have put the code into the Private Sub section using the LEFT FOCUS attribute. As I click into the next field, thus leaving the date field, the if statement below...

Good day to all, May this post find you well. I do need some expert advise. Attached in the ZIPPED file is an Excel spreadsheet. Columns A is all numeric, and needs to be represented in access as a text field. Column B is a mixed format of dates entered and in some instances only plain numeric...

Good day to you all, I need a facility in the access VBA coding to check if a directory exist. I it does exist, I need to open it and check for a specific file. Or if the directory (folder) exist, to determine or display folders within. I hope someone can help me in this regard. Much...

Good day, I must be getting old, Many times I have appended tables. But now I am struggling even trying to append 4 fields defined as text. Please view attached zip file.

Good day, I have setup a test query ("Query1") whereby the query has to display a running total as long as the Department is the same. The problem I am having is that I get a total of all records being displayed. Appreciate the help, Blessings

Hello once again to all out there! The Libraries in Access is a pain, to many, but to all the gurus, please tel me why would I get this error? I am setting the field label, as in other programs. Your help is appreciated, Blessings. Object doesn't support this property or method (Error 438)

Hello to all, hope you are all well. Sometimes I don't understand Bill Gates. Here is my code: tWhere = " [P_DateF]='" & txtSDate & "' ORDER BY '" & "[P_DateF]'" ' strSQL = "SELECT * FROM [Prices] WHERE " & tWhere Set rs = db.OpenRecordset(strSQL) both [P_DatF] and txtSDate =...

Helllo, to all, I have a select clause, it executes fine, BUT the totamt is not calculated. The field is Amount. I have checked various helps, including VBA's help function, BUT the code is not working. strSQL = "SELECT Account, Dept, " & "Sum([Amount])" & " As [totamt] FROM TB201410 GROUP BY...

Good day to all the Access Professionals, I have a program running with VBA coding, whereby the user enter a password which then sets the field attributes to enable the user to change them. This is working on my laptop, on the client's LAN, it also worked through REMOTE DESKTOP, but the Head...

Hello Again, Blessings to all. I don't know, I have noticed that the SETVALUE argument is not openly available in the lookup tables when setting a macro. (But that aside) I have set my drives c:\ and d:\ as trusted, and also thicked the sub folder option. :banghead: Your comments will be...

[Resolved] Hello and Herewith a syntax problem Hello to all, Blessings to you all. I am Kobus Dippenaar, MSAccess programmer, Photographer, and Website Developer. My problem is in reading a DAO recordset containing a text field of 12 Characters. Here is my extracts; The Find First statement...