Heres is a good example...
If this is your code...
"Public Function ProcDataMIN(ByRef xlwb As Workbook, ByRef xlws As Worksheet, _
ByRef currentrow As Long, filename As String, fpath As String, _
SearchValue1, override, xCount) As Long
Dim adoXL As ADODB.Connection
Dim adoRS As...
Ok,
I might be dumb, but what as far as recruiters does ADO mean?
If you use VB 6.0; dont most use ADO? Is ADO where the SQL is built in? Are you doing ADO by using the MSGRIDS?( is that the definition?) Is it a special packaging within VB?
I specialize in user interface and reporting and am...
Here is a way if you have a database of numbers...
You can use MSFAX is you wish. You just need to set up in outlook (thats my email client) add a new email called Fax Mail Transport. It is in the list you chose from. Then in the modules section place this code...
I use XP Pro. Here is what works for me...
You can use MSFAX is you wish. You just need to set up in outlook (thats my email client) add a new email called Fax Mail Transport. It is in the list you chose from. Then in the modules section place this code...
You can use MSFAX is you wish. You just need to set up in outlook (thats my email client) add a new email called Fax Mail Transport. It is in the list you chose from. Then in the modules section place this code...
You can use MSFAX is you wish. You just need to set up in outlook (thats my email client) add a new email called Fax Mail Transport. It is in the list you chose from. Then in the modules section place this code...
You can use MSFAX is you wish. You just need to set up in outlook (thats my email client) add a new email called Fax Mail Transport. It is in the list you chose from. Then in the modules section place this code...
You can use MSFAX is you wish. You just need to set up in outlook (thats my email client) add a new email called Fax Mail Transport. It is in the list you chose from. Then in the modules section place this code...
I was having the same problem. I have it i Think.
The problem is the "Like" . You dont need the IIF. Just change criteria in the query to read.
"Like [Forms]![frmQuery]![cboAccount]"
With the "Like" in the front. Then use the other example with the * as the holder.
Column 1 | Column 2...
Question,
I have a combo box that gets its data from a table/query.
How can I add a value that is not in the table or query? I want to have a value at the top such as a "*" or the word "All".
They are searching by 2-3 criterias. They dont have to select a region for instance. Thus they would...
There is no source. I add all where credit = CR and deduct all where credit = db.I could set 2 boxes and then another to the sum of the 2. But I want to get it working first, before I "hack" a solution. :)
If you have never used code you haven't used 1/2 of what you can do with the reports...
Help...
I have a field, totaldollars. It is a sum of all credits minus the debits. This is done during the onformat property of the detail. I Then set a text box to the number. At the group header i reset the number to 0. I have the variable declared and everything looks great, until I print...
Ok..
I have this nice report. I have made all the details invisible, since I only care about the totals. I have it looking correct in access, but when I export to excel i get a blank sheet.
Why? Does access not export totals?
I know I can go and make the query with totals first then base the...
When I do that it gets stuck in a loop and keeps saying the entry isn't there. Yet when i look, it is..
It is really annoying to have it say its not there, then it is... :((
OK, I have a combo box (cbo), that gets its values from a table/query. I want to add the entry to the table if its not there and then reset the drop down.
Here is what I have so far..
Private Sub cboVendorNames_NotInList(NewData As String, Response As Integer)
Dim strSQL As String
Dim...
Question,
I have made databases, but never compiled them into exe except vb projects, which of course didn't contain the DB in them, just the connection strings.
If you compile your Access DB, how do you do the enhancements?
Won't upon install overwrite the previous db or is that an option to...
Thanks.
As I thought, and you pointed out, the reason my object wasnt working was because the excel was invisible. So I couldnt ever get back to it...
Thanks,
Jeremy
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.