Search results for query: *

Hi! How can I round up any number to the next interger or long. i.e. 30.00001 = 31 Thanks in advance, Paolo

Hi! I'm sure this is real easy. When I divide two numbers, or have a decimal number, I only want the digits to the left of the decimal. Aside from: Left(MyDecimalNumber, InStr(1, MyDecimalNumber, ".") is there a more mathematical way of doing this? Please note that I'm not looking to round...

Hi! How do I clear all the values in a Combobox? The values were loaded by "Value List" Thanks in advance, Paolo

Hi, I have several mdb files that are used for reference purposes only. I link to them and I create run-time connections to them to retrieve the data I need. Do I need to compact and repair these files? Any comments or suggestions are greatly appreciated. Thanks in advance, Paolo

Hi! I know it's important to close recordsets and connections and set them to nothing when we're done with them. Is there a need to erase arrays as well? Thanks in advance, Paolo

Hi, I trying to create a program that'll run off a USB drive and as such I won't always know the path of the application. I tried a couple of the methods on this site but I must be missing a reference. I'm really hoping for a simple straight forward solution as I'm not sharing the data...

Hi! When Something = False I want to skip the balance of the code within my For Next loop. Right now I'm using a GoTo SkipToNext but I was told that GoTo commands shouldn't be used like this. I'm also not crazy about how the "SkipToNext:" flushes left in this instance. Any suggestions or...

Hi, How do I set this type of connection to current file I'm working on, i.e. vb code in Access. I get an error that the files been locked. Any suggestions will be very much appreciated. Thanks in advance, Paolo p.s. I've tried a variety of things, but from VB6 this works, provided the file...

Hi! I have a process that takes a fairly long time. Is there a way to show a clock, a timer clock I suppose, that counts down the time the process is taking. When I press the command button to run my process the clock, either digital or dial (both could be fun) would start to show time, like...

Hi! From within access I'd like to use SQL to import all the records from a .csv file to a new table. I'd really appreciate any directions or suggestions. Thanks in advance, Paolo.

Hi! From within access I'd like to use SQL to import all the records from a .csv file to a new table. I'd really appreciate any directions or suggestions. Thanks in advance, Paolo.

Hi! I can't figure out how to close and/or unload the current form. Essentially, once the user has pressed a command button and the code is executed, there is no further use for the form and I would like that form to close automatically. Any comments or suggestions are appreciated. Thanks in...

Hi, When I run an Update Query I get the following error "Operation must use an updateable query." Any suggestions? Paolo

Hi, I want to update a group of (not necessarily all) records from one table with query results. I don't know how to write the SQL code. If it can be done, I expect it to look something like: "SELECT * FROM qry WHERE qrySymbol = tblSymbol UPDATE DestinationField WITH SourceField"...

Hi, I want to update a group of (not necessarily all) records from one table with query results. I don't know how to write the SQL code. If it can be done, I expect it to look something like: "SELECT * FROM qry WHERE qrySymbol = tblSymbol UPDATE DestinationField WITH SourceField"...

Hi, Is there a way to connect to a Query as with a Table using an ADODB connection. To open a table I do the following Set rs = New ADODB.Recordset rs.Open sTable, cn However that doesn't work with a query. Any instruction and/or comments are appreciated. Thanks in advance, Paolo

Hi, In a query, design view, I calculate the average of a number. I don't want to show any decimal places. How can I reformat the number within the query. Any assistance and/or comments will be greatly appreciated. Thanks in advance, Paolo

Hi, On an Access form I have a "Microsoft Office Spreadsheet 11.0" control. I'm trying to figure out how to programatically change cell alignment/orientation properties. Specifically, I want to change a cells Orientation by 90 degrees. As an example of what I mean, when I open an Excel...

Hi, When the user clicks into a text box, I would a certain option button to be selected or check. Any recommendations would be appreciated. Thanks in advance, Paolo

Hi, From outside of Access, I'd like to create a query in Access programatically, just like you can create a table. Background: I've created a number of queries which I modify at run-time. Instead of modifying them, I'd prefer to just create them at run-time. Frankly, I have to many queries...