Search results for query: *

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...

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...

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...

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...

How come when I call this it works, but if i leave the window and comeback it is never on top and I am forced to cntrl-dele and end task. I cant cntrl break or anything out of it. I dont see a way to make it modal. Any suggestions on how to make/keep it on top? The idea is that if you needed...

I want to get all the reports in my db into a recordset so I can poplate a drop down. Any ideas on how to get this info? I could make it a table, but then i have to update it. I would prefer to do something like rsReports = currentdb.listreports (I know thats not real, but just as an...

In VB there are controls you can set to allow the user to select the drive, then the file they want. Are there such controls in Access and I am missing them? Any suggestions? I am passing the path the a module. Thanks, WZ

In VB there are controls you can set to allow the user to select the drive, then the file they want. Are there such controls in Access and I am missing them? Any suggestions? I am passing the path the a module. Thanks, WZ

hello , I am having a problem with Access. I have a recordset. I want to convert this bad date to a good one, restore it in the recorset and then write it all to a table (create/append table). I must just be missing something since It has been a few months from coding this, but why is saying...

I have the day. IE "365". I need to convert it to the month and day. Ie "December 31" .. Or "1" ie "January 1". Does anyone know of any expressions to assist in this? Thanks, Ziggy

Ok. I am working on a database that I didn't write. I am fixing it though to the best of my ability and am running across an unusual error. There is a form that when loading, loses the 'USER' variable that is populated at login. The exact time of loss is not specific. If you step through the...

I have a question I hope someone can help me with.. I have a VB app that uses dao to open a database (Access). It opens 97 fine, "DAO.OpenDatabase(JobDBPath)", but I get the "unrecognized DB format" when I try to open 2000. Anyone know why this is? Is the only solution to...

hello all, Stumped here, i have hyperlinks to say the cd rom.... I want to check to make sure the correct CD is there before hand. I can use the FSO.FileExists(path) to check and and send appropriate message (if anyone knows a better way I am all ears..Does FSO require an install? ) but I...

Hello all, Is there an easy way in Access 97 to detect which drive is the CD? I can use the VBA if needed, I am just stumped as to the easiest way to find out which drives are CD ROMS.... any suggestions? Thanks, Jeremy WZ

I have a question... When I open a 97 workbook with office 2k it asks me if i want the formulas changed. The answer is always 'No'. Is there any way to default this? I am running some VB apps that open the files and I do not want this message to keep popping up. Thanks, Jeremy WZ

Ok, I need to use a field (names.txt) with the table (me.tbl) to run this macro (Malcom). I need to run (Malcom) for every line in the table (Malcom(names.txt)). I know how to connect my access DB to outside tables, but for some reason am having a brain lapse as to how to utilize a table...

Hello all. I am pretty new to ASP so this is my first crack at it. I have some code I wrote, could anyone give me their comments/suggestions .. <HTML> <BODY> <% 'Variable Declarations Dim SQL ' Used for building SQL strings to open recordsets Dim CONN ' Connection Object Dim rsInvoices '...

Help! (Please!:)) I am trying to create a new report using either an array or a text file. I have set up the new report using the data definition, now I need to get data into it. Any suggestions or places to look would be appreciated... Thanks, Jeremy