Search results

First of all you are not bothering any one. If we're here is because we want to :) . I guess that you're missing something here. Your Customers form is just to enter data about customers no to add orders The Orders form is to add orders to existing customers. Why? Let's suppose you add orders...

G'd Afternoon, I don't think that creating 50 rows beforehand is a good idea. You can count rows in table right? so, before a user attempt to add an object your form should check how many items already exist and respond accordingly. G'd luck

The problem is not the code. Get the content of your var strOfile and make sure that it is a full path file. strOfile = "\\geno-pc\4WheelPics\" & Forms!frmLookupPartNO.[PartID] & ".jpg" Debug.print strOfile

G'd morning, I think that you should change your approach (like i suggested before) Instead of sending to all recipients at once do it one by one. Otherwise you'll never be able to know which is/are the offending address(es). Why to send them all together?

G'd evening, Use the vba.shell function like this Dim strOfile As String Dim strApp As String strApp = "C:\Program Files\Microsoft Office\Office14\ois.exe" strOfile = "C:\ThisImage.jpg" vba.Shell strApp & " " & Chr(34) & strOfile & Chr(34), vbMaximizedFocus...

G'd evening, I guess you may want to start Reading this. Here is a sample code from MS to create a simple note: Option Compare Database Option Explicit 'Add references to 'Microsoft OneNote 14.0 Object Library 'Microsoft XML, 6.0 Public Sub CreateNote() ' Connect to OneNote 2010. '...

You're very welcome my friend. I'm glad it helped :)

I avoid as much as i can to refer a form from another object. My common approach is: A public variable, a public Enum/Type or a Class. In your case i would do something like this: In a module Public Type RepDates BDate as string EDate as string End Type Public tReportDates as RepDates...

Have you tried compact & repair? In other computers happens the same? I'm asking you this because i'd been trying to reproduce the same behavior with no "luck". i got big table with countries and IP's to test the report with no issues. My environment differs from yours mainly because of my MS...

I'm glad have found the source of the problem and most important the solution! :)

G'd evening Hemish, You may want to start here G'd luck

G'd evening, Access has no pop/imap libraries, but ou have several choices: 1. Use Winsock (lot of vb6 samples) 2. Use a third party library (Chilkat, componentOne, etc) 3. Automate Outlook (the easier, lots of examples here) 4. Build your own library in another environment. G'd luck

G'd evening, Access doesn't work that way. acFormReadOnly is just that. What you can do is to disable all controls (by hand or a controls loop) and let just that one combobox enabled. G'd luck

G'd evening Eddie, The last parameter of TransferText is Codepage. For your requirements should be 65001. here is the MsoEncoding Enumeration Page G'd luck

G'd evening Mile-O, Just curious, in your first example, before the offending line. Wouldn't it work setting the vField as variant or object? I don't know why Access loves to figure out (or not) the type of object. Even to loop through forms' collection the looping variable should be type of...

G'd evening! In a SELECT statement, always use an ORDER BY clause with the TOP clause otherwise it may not work. If that's not the case change you query and instead of TOP use COUNT G'd luck

G'd evening, MS Access has no garbage collector, all what you (manually can do) is dispose your variables. That being said. What is your Access Version? how much RAM do you have? how many reports do you build simultaneously? Without looking at your code is hard (or impossible) to say. But i...

G'd evening Kvar, How are you getting the params? does the vba query run setting the parameters from the code itself? can you post your vba code?

Hello, Let me ask you a couple of questions: 1. what are these tables for: tblBusBusRole and tblBusPersRole? tblBusBusRole Linked to: tblBusiness tblRole tblBusPersRole tblBusPersRole Linked to tblBusiness tblRole tblPerson They look to me more like a query result than tables What kind of...

Ok.. i see. One more question & suggestion A loan is a complete entity or belong to another entity? I'm asking you this to know who's depending on who. At the beginning "Participation" seemed to be something related to nothing. Build a db with the main entities (upload the mdb) and lets start to...