Search results for query: *

Hi All. I have utilized ADODB for a recordset and used a inner join to combine two tables. rs.open "select table1*,table2* from table1 where table1.tableid = table2.tableid.. you get the drift. How do i refer to the joined field name through code. WHen i try to use RS!table1.tableid it gives...

Hi all, I am trying to create a database that we can utilize to track employees (working rotating shifts) vacation, sick time.. etc..etc. I can't seem to find a place to start, I guess I need to make a table with the date, but how would i accomplish that. I would like any help with getting my...

I all, I have a database that consist of approximately 40 different reports. Each time a different report can be generated. Right now I have a list box which lists each different report generated. What I would like to do is have one report open and have all the reports collated inside. Any help...

Anybody have any suggestions. I have a report that needs to display a range of records. I would like to have it in a grid format. I need the records to "grow" sort of like a textbox with the cangrow feature. I know this is not available in a listbox, and I can't use a continuous form...

Hi, I upsized my access database to a ADP, one of my reports does not recognize the below SQL statement. anybody know the correct syntax ? Thanks. rs4.Open "SELECT * FROM TABLE WHERE TABLEID =" & INTTABLE & " AND TABLEYESNO = FALSE", cn4, adOpenStatic

Hi all, I am creating a database in ms access. I was needed to populate some reports. I was wondering if there was any difference in opening several recordsets as to joining them all under one recordset. I have used both approaches, but after I tried to upsize to sql I got several errors with my...

Anybody know how to clear all items from a combo box (set to value list) I've tried combobox.clear and cannot seem to get it to work, any suggestions ? Thanks

Anybody know how to clear all items from a combo box (set to value list) I've tried combobox.clear and cannot seem to get it to work, any suggestions ? Thanks

Hi all, I am trying to use the microsoft rich textbox control 6.0 in a access database using vba. I am trying to spell check the rich text box and have it behave like a small word processor. any suggestions will be greatly appreciated. Thanks in advance.

Anybody know how to incorporate a word processor into a microsoft access form. What i need is to have the user click a button, have the word processor (wordpad or word) open up and when the user hit's save the information is stored in an access table. Any help or suggestions would be greatly...

Hi, I have three seperate reports, the amount of copies of the reports varies on an array. How do I create an array to handle the printing of multiple copies of the same report with different data?. And can I have all my reports displayed in the same preview as page 1, page2 and so on. Any help...

Hi, anybody experience problems with the listview 6.0 controller and full row select. When I click on first item in box, it reverts from full row select to individual column select. Anybody know why...Thanks.. Later.

Hi, I am trying to link or embed documents from either a scanner or microsoft word into a access database. I want to be able to scan from the access database and link them to the current record. Any suggestions is greatly appreciated.

Hi, I am using two multi select listboxes that transfer data from one listbox to another. My code is the following. dim (i) as integer Dim i As Integer For i = 0 To List1.ListCount If List1.Selected(i) = True Then Me.List2.AddItem Me.List1.Column(0, i) me.list1.removeitem (i)...

Hi, I need to use the Tab key to indent inside a Text Box. The Text Box will be used for a MEMO field which can be several pages, or is there another control for this purpose? Thanks.

Hi, I was wondering if anybody had any experience linking an informix 7.0 database to Microsoft Access. I want to be able to look at the structure of the informix database to determine how best to convert into SQL. I know I need ODBC drivers, but I have no idea what else it will take. Any help...

Hi, I know barely nothing about informix. I have a informix 7.0 database running on Aix. I want to link or export the data into Microsoft Access, or probably in the future SQl. I know I need to utilize ODBC drivers, but I am still lost. Any help to get me going would be greatly appreciated...

Anybody know how to change forecolor in listview control and also to enable full select. I found article on web about changing full select but could not get it to work. any help is greatly appreciated.

CAN ANYBODY GIVE ME ANY RECOMMENDATIONS FOR AN ACTIVE X LIST BOX THAT I CAN CONDITIONALLY FORMAT. I NEED THE NAME OF THE VENDOR (3RD PARTY) OR IF IT IS AVAILABE IN THE OFFICE DEVELOPER KIT. ANY HELP IS GREATLY APPRECIATED. THANKS.

I AM TRYING TO QUERY IN AN ADO STATEMENT ON A TEXT FIELD, I AM ABLE TO QUERY ON A NUMBER FIELD WITH THE BELOW STATEMENT WITH NO PROBLEM. IS THERE A WAY TO QUERY ON TEXT. BELOW IS MY STATEMENT LIST0.ROWSOURCE = "SELECT * FROM TABLE1 WHERE NUMBER ="&ME.TEXT0.VALUE **THIS WORKS GREAT...