Search results

Spoke too soon This fix Set MyRS = New ADODB.Recordset MyRS.Open "tblMain", CurrentProject.Connection, adOpenKeyset, adLockOptimistic works fine in 03, but when converted back to 97, it does not recognize the CurrentProject.Connection. Any suggestions as to what I can do differently? OR the...

Thanks! Thanks! Set MyRS = New ADODB.Recordset MyRS.Open "tblMain", CurrentProject.Connection, adOpenKeyset, adLockOptimistic That did it, but why did it work before and not now? As I said, I imported the 97 stuff into 03 and then converted it back. It would not work in either the 97 or 03...

Thanks in advance! Long story short. In the process of upgrading from 97 to 03. Some users still have 97 others 03; may be several weeks until all are converted. Had a database that I could not convert, instead had to create new db in 03 and import all (could not open in 03 because of...

Thanks in advance, I have a combo box that displays the concantanation of two fields. Both are text. The first column holds a alpanumeric value that does not give much description. The second holds a the description of the second. The problem I am having is the second field ends in (R)...

Thanks in advance, In the past i have used dlookup to find specfic fields from a table. I was thinking that a select statement would be more efficient as I need to return 4 fields for one specific record. I tried the following but keep getting error 3061 Too Few Parameters Expected 1. My...

Thanks so much; that did it.

Thanks in advance, I am getting the error 3024 cant find C:.\..\dbo.mdb Could someone shed some light on the problem? EventLookUpAnswer is a variable of type integer DoCmd.RunSQL ("UPDATE dbo.R_D_Event_Date SET " _ & "dbo.R_D_Event_Date.LineNum = " & Me.cmbMech & "," _...

Doc, It was my mistake! I was using the "Browse" (in the module >> tools >> references option) to find the MSCAL.OCX file. Since it was in the system32 file it was hidden (dah) from that view. When i went to windows explorer, i was able to find the folder (system32) and the ocx was there...

Thanks Doc that showed me where the problem lies. The db is calling the Calender activeX. It is located in the system32 file. There is no system32 file on that pc. What is the easiest fix? Can one be copied from another similar pc or will we need to reinstall the operating system? Thanks...

Hi and thanks, My company recently upgraged from Office '97 to '03. However, they decided to wait a while for Access '03. Since the upgrade, I have gotten an error message(see attachement) that prevents Access from launching when clicking on an db. If you open Access first, then choose the...

Okay, thaDate is still not properly formated to allow you to use the variable in the sql statement. However, if you create a text box on the form and format it as Short Date you can pass this to the statment and it has worked for me. If you don't want to display the text box, set the Visible...

I did not insert the data into a table but I outputted the strSQL in a message box and it looked okay. Try Dim thaDate As Date Dim strSQL as string thaDate = [Forms]![Enter Participation Count]![MonthCombo] & "/" _ & [Forms]![Enter Participation Count]![DayCombo] & "/" _...

I think that I stumbled onto something. it is not seeing the input of date paramaters as dates. I added text box to the form and formated them as short date and it seems to work. again thanks, lee

Thanks in advance! I have a query where I am trying to filter out records using a date column and another column with an integer value. What I trying to do is set the criteria for a date range and depending on the date colum + interger colum return the recordset. This is statements I have...

What I did is I went to the chart properties, data, row source and clicked ... I then used the build option to link the query to the text fields in the form that held the criteria. then when I opened the form, I got the stated error that is above. This is exactly what I did on the first...

Please help! I have created a chart on a form based on a query with critera tied back to the form. Everything worked great. I now wanted to do the same for a different table. I went though the same steps as I did the first time (create query, built link to form objects, created the chart)...

Thanks in advance! Please bear with me while I ask this question! txtExspectedLife1, txtExspectedLife2, txtExspectedLife3, .. etc. I have variables that passes the values to the text boxes. Now I want to loop through the Dlookup pass the values to the proper text box. For example. Dim i...

Thanks Wayne that did the trick!!!

Thanks in advance!! How do you reference a list box in a dlookup?? for example ........ [Answer] = Me.ListRightAnswer.Column(2) gives me an error for unknow function. ....... [Answer] = [Me.ListRightAnswer.Column(2)] gives me an error for improper bracketing Thanks, Lee

Thanks!!! That'll work!