Search results for query: *

If I have a query that has 5 parameters but I am only passing in 3 of them how can i delete the parameter or what can I set the parameter to if it isempty??? This is to an Access Database. Public Function GetRecordset(sSQL As String, Optional arrParams As Variant) As ADODB.Recordset Dim...

I have some image files in a folder. I would to resize them by changing their properties (pixel width and pixel height) from user input. I have two text boxes and a command button on a form. When the user clicks the command button all the files in the folder change according to user input...

I have a mainapp.exe that calls update.exe. Before update.exe can run I would like to shut down mainapp.exe. This will take any user action out of the picture, which is what I want. Any suggestions? Thanks!

Solved my own problem. Imagine that. PrepareSQLString = Replace$(Trim$(Replace$(s, Chr$(0), " ")), "'", "''")

The string that I am passing into a function to build a sql statement is "b's" How can I search the string and find the single tick(s) and then once I find the single tick I can add another single tick to it so the sql statement will not error out when querying an access database...

Thanks!!! That worked!!!

What if I don't know what the number is going to be between the !? Thanks for the help!

I have a string: abc!246!def I need to replace the 246 with the ö character which is 246 on the ASCII table. Is there is a way to search the string for the ! and then replace whatever number is in between then ! with what ascii character it is? Thanks!

I wish I was back in college. We have a client/server application that uses Access. The data structure is normalized right now but we are having to use lots of joins in our sql statements for reports and also lots of functions inside our classes that enables us to get access to certain data...

What are the advantages and disadvantages between Normalized and DeNormalized Data Structures in an OO environment?

Thanks that worked! -J420exe Apologies to anyone that I offended for not responding sooner.

VB app connects to server over http. How can I initiate a download of a self-extracting exe to the clients machine? I would then use the shell command to run the .exe And ideas? Thanks.

I have 3 text boxes. Month, Day, Year. The text boxes are limited to two integers. After the user enters 01 for the first text box how can I have the cursor advance to the next text box so the user doesn't have to use tab or click in it? Thanks1

Design question: What is the industry standard or best practice for updating a clients version of the software electronically? Our vb app allows the user to connect to our network and upload newly created orders. We would like our software to check if a newer version of any component (dll...

Can you pass a variable assigned by an ASP object into a javascript function? I have a date assigned to a variable and I need to pass it into a javascript function for a language conversion. Is this possible? If so any ideas?

Thanks!!! That worked!!!

int i; char buffer[] = &quot;abc def&quot;; char replaceChar[] = &quot;+&quot;; for(int i = 0;i<strlen(buffer);i++) { if(buffer[i] == ' ') buffer[i] = replaceChar; } I am receiving an error when this line buffer[i] = replaceChar; is being executed. Is this line going...

New to C: I have a string that is 35 characters long excluding the (): (New City ) I would like to create a new string that looks like this: (New+City+++++++++++++++++++++++++++) How can I go about this?

I am displaying all the contents of a database table in an ASP page. The table has 30 columns. If the users presses the browser print button its 'ugly'. How can I display the page in a &quot;Printer-friendly page&quot; format? Or is this even possible because of the amount of data being...

I am using win2k server, access 2000 and IIS 5. The page will display the contents of the database but when I click refresh I get the unspecified error message and the line reference is to my DSN. I have double checked the DSN and the database and everything seems right. Here is what I have so...