Search results for query: *

That did it Remou Your the Man. it was RS.field("table2.tableid") .... It works like a charm. Should have posted sooner. Thanks again.

Thanx Remou, I already tried all those options. When I try to refer to the joined field (Primary Key). I get the run time error 3265. Item Cannot be found in the collection corresponding to the requested name or ordinal. I am attempting to fill a listview and wanted to use the joined field...

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

Just fixed this problem. Easiest solution is to take out all adobe readers and install 4.0 reader. Then re-install 7.0 over 4.0. for some reason it works.. Later

''on the on gotfocus event for the text box put the code me.text1.backcolor = vbgreen 'Color you want' ' the backcolor can be either vbwhite, vbyellow etc or a number that corresponds to the color you want. ''on the on lostfocus event for the text box put the color back to its original...

sorcerer11, for some reason I just could not get started. That was my problem. I was able to create the table utilizing the current date and adding one date until a period of time. Believe it or not this was my hardest problem. I just could not figure how to get this started, I really was hoping...

sorcerer11, Thanks for the post. But I have experience. I have created several large DB's utilizing Access, SQL and MYSQL. What i need to do is reference a schedule and have to create a table to store who is working on any given date in the future.

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

Try declaring itmx as : Dim ITMX As MSComctlLib.ListItem

To conditionally format a listview control try this. ' Using ADO recordsets dim lv as object dim itm as mscomctlib.listitem dim rs as adodb.recordset ' ado recordset dim cn as adodb.connection ' connection set rs = new adodb.recordset set cn = currentproject.connection set lv = Listview1'...

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

Sorry I did not get back to you John I was on vacation. Will give it a try. Thanx for the post. Later. David.

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

I see what you mean, that is the function I used to copy and paste the information into the spell checker. Below are the two function I used to copy and paste text into the spell checker. copy these into your module section of your project. Let me know how you make out. Later. Option Compare...

I use this code to call Microsoft word spell checker.. This is the only way I know how to spell check a rich text box. Later. Good Luck Dim OWORD As Object Dim OTMPDOC As Object Dim LORIGTOP As Long Set OWORD = CreateObject("WORD.APPLICATION") Set OTMPDOC = OWORD.Documents.Add...

GOT IT... Use 0 for True and 1 for False, unbelievable huh.

upsizing wizard changed format to yesno, but I changed it to true/false. I still get an error with the above statement. Thanks for your time Chip.

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

Charles, excellent alternative. Thanks for the post.