Search results

Is the Table from which the Combo Data is coming from, Linked to the Database (Front-End)? If so, try deleting the Links and Re-Linking the Tables again. If the Combo is getting its Data from a Query, then check over the Query to ensure there are no errors. .

Here is your Sample DB with the required options you seek. Place the mouse pointer over the Mem buttons and read the Control Tip Text that is displayed on all buttons....before storing to memory (so to speak) and after storying to memory. .

Over 64000 lines of Data into a single field of a record. I personally would never consider such a thing. If large blocks of data such as this are to be stored, I would be doing it into Text Files and then merely have the path to that file stored in table. Read in the File when needed. I...

Copy and Paste the URL directly into the Address Bar of your Browser. If the Web Page does not display then there is a problem with he URL itself. If it does display when directly applied to the in the browser but not in code then there is something wrong with the URL string. for example...

The first argument within the DSum function should be the Table Column you want to Sum...not the Accounting Period. The Accounting Period should be placed within the WHERE clause of the DSum function. Me.Orders = DSum("[TotalsColumnFieldInTable]", "PLMaster", "[Type] = 'Orders PS' And [Area] =...

Well....It because those look like serial numbers for components to Nuclear Warheads and he if he told you, then he would have to kill you. :D In any case....Use the Split function. .

Yes....See MS-Access VBA Help regarding the Shell Function. Yes....but no guarantees. To access the Scanner, you will need to Reference the Microsoft Windows Image Acquisition Library v2.0 within the VBA IDE (VBA Editor). This library is the WIAAut.dll which is used for connecting to the...

Move the drec.MoveNext just above the Loop statement. You can go here and see other solutions to this sort of thing. .

That's all very interesting but......just to be sure, you provided a sample DB, what is the Form Name within that DB (Database)? .

Hi amriasg, Which Form are you having difficulty with? Are you trying to set the Record Source property? Or are you trying to set up a Combo List? I am looking at the 1st sample DB you posted. .

Glad it worked for you and always keep in mind: It takes only one rare occasion to accidentally blow up a Nuclear Reactor. I wonder of often they said the word "rare" while building the Space Shuttle. :) .

Re: 'Run-time error 13: Type mismatch' occurs for CreateObject("Outlook.Application") Reference priorities have already been played with in this situation. Anti-Virus....good point nIGHTmAYOR. Could very well be, mind you, I'm not sure about anyone else but I have never had a problem with any...

Re: 'Run-time error 13: Type mismatch' occurs for CreateObject("Outlook.Application") I'm afraid I am not much help to you with regards to this particular situation since I can not get this error. I don't get an error with your code but then again, I don't use the 11.0 library. I use the 10.0...

Here is how..... - Set the Back Color property for the Detail section of your Form to oh....let's say white. - Set the Back Color for all the Form Fields to a color you would like them to have should that particular control have focus (let's say Cyan for now). - Set the Back Style property of...

Re: 'Run-time error 13: Type mismatch' occurs for CreateObject("Outlook.Application") Just off hand...do you have the Microsoft Outlook 10.0 Object Library listed within the References List? If so.....remove the Microsoft Outlook 11.0 Object Library and try the Microsoft Outlook 10.0 Object...

Ensure that the Combo Boxes referenced within the SQL Statement are actually providing the proper Column of Data. .

As far as I know Steve, you can't do that sort of thing when in Datasheet view. You are at the mercy of MS-Access when it comes to the design of the Datasheet. Yes, you can change Cell Spacing (overall), Font Size (overall) and Cell Color (overall) and really, that's about it. If you want full...

If you are dynamically creating the SQL strings with VBA code then you can either display the String within a Message Box or a Text Box on Form. Dim StrgSQL As String 'Create the SQL String. StrgSQL = "SELECT tbl05to06 FROM tbl05to06 WHERE tbl05to06.Centre)>='2A7T1';" 'Display The SQL String...

Well....in reality, the easiest way is to simply copy it. With your current Database project Open, also open the Northwind.mdb database file while holding the Shift Key down. In the Form section of the Northwind Database Objects Window select the Startup Form then from menu select Edit | Copy...

Re: 'Run-time error 13: Type mismatch' occurs for CreateObject("Outlook.Application") Then it must be something with your References. Move it up in the references chain. Open the References Window from within the VBA IDE and select the Microsoft Outlook 11.0 Object Library and click on the UP...