Search results

OK Guys and Girls, I got it to work with a little help from my friend. The code to check the existence of the file has to be a Public Function (Module coding) See: Public Function FileNotice(Filecheck) As String Dim XDir As String XDir = Dir(Filecheck) If Len(XDir) > 0 Then FileNotice = "File...

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

Thank you for your comment. I understand, but it would be far easier to do one mapping of the x: drive than to run a fix running through 40,000 records to change the beginning of the link. Should we change the server drive I would keep my folder names the same and map the drive on the lan...

Thank you for your response, but I need to find a way back to use the mapping drive letter. The Network Technician argues that the share name will change the moment a new drive is installed replacing the current drive and the share name will differ. The Data Base has 8000 records linking to...

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

Re: [Solved] Access printview export to Outlook as pdf or save as pdf problem Minty, Yes, It was on the Windows side. I have come to learn that the printview when exported to Outlook and converting to pdf, needs an uncorrupted default printer driver. I have installed a new printer driver and...

Minty, OK someone said something about orientation. My Standard landscape report in a different db comes out at 75%, hence dropping off 25%. see samples. So the convertion via Microsoft from out of Access to the finishedpdf file in Outlook is not according to the printview. Hope someone has an...

Minty, Thanks, I can't think of any programs, the last programs installed were virus programs, and then i modified my startup nemu. I have 5 data bases current running, only the one is effected. I imported the modules into a new DB......It did not solve the problem... The problem stayed. I...

I forgot. On my wife's PC the same DB set running under MS2010 works!!!

Minty, I do not understand. I have'nt made changes to this DB set. I worked on other Data bases. I havetested another DB, my Cashbook and it exports to outlook, change the file to pdf, margins are fine. OK. I'll open a Blank DB import some forms and tabels, and do a test. Blessins.

CJ Thanks, but I haven,t change to program, it was standard for 3 years!!! I have a novaPDF printer installed. In word it picks up the driver but not in Access. The save as option when selecting PDF as output, what does the save as dialog box use, or windows for that matter to format the pdf...

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

Thank you, I be reporting back soonest. Blessings.

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

@Uncle Gizmo, Good day, When capturing data, into a text box like this one for example. How do I get symbols added in? I got the answer in the link below. Example: Hoër Skool meaning High School (It is all about using the ALT key codes, but you can't use the horizontal keys apparently, you need...

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

@gemma-the-husky, Man! MAZELTOV!!!!! (Jewish) (Afrikaans slang: "LEKKER") I have taken the first 10 records in the file, adding a "X" to the back of the field, whether numeric, number, or date/time it imports all as short-text. Thanks, Blessings.

@Doc Man, I am still exploring all avenues. Linked as an excel spreadsheet, nor importing the spreadsheet into access doesn't work. Access converts fields depending how it recognises it, (My impression) I thing I'll read it in as one complete text with delimiters and then unpacking it using VBA...