Search results

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 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 & "," _...

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

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

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 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 in advance for your help!! Please help me get the synatax correct for the Case statement in access. I can get it to work in SQL Server 2000, but not in Access. I keep getting a Syntax error. Select otherStuff, (Case When Station = 'B' Then Sum(dbo_z_dtbl_1604_Pareto.Num_Defects) End)...

I am in desprate need of help in figuring out either the proper syntax for inserting this Me.lstChangePMDate.Column(1) into a Dlookup or how to properly pass a variable into a Dlookup. Here is what I have done so far. Both give me a syntax error. Trial 1 EqType =...

Hi and thanks in advance! Could someone please help me understand what is happening? What I have is linked tables in SQL Server. In a sub routine, I created this code to insert records into this table. It looks like this; Set Myrs = CurrentDb.OpenRecordset("WorkOrders") (debug stops on...

As I was told at one time, the only dumb question is the one not asked! I tried several time to load both Access 97 and Access 2000 on the same drive. Each time 2000 takes over. Is this the nature of the beast or is it just me. The reason is I have clients who use 97 and some who use 2K...

Please Help me understand how to use the varible SizeHdr in a Dlookup. I get the message of data type mismatch. The column RollSize is of type text! Select Case SizeDeterminer Case Is >= 270 SizeHdr = 270 Case 80 To 269 SizeHdr = 80 Case Else MsgBox ("You will have to...

Hi and thanks, I have just completed the upgrade to XP and am trying to reinstall Access 97. Through the setup.exe on the office 97, I installed everything. The problem is when I try to open Access 97, I get a message that there is no license on this machine! All other office products run...

What I want to do is create a report with a bar chart. I want the user to be able to input a date range and have that data charted. What I have done is create the query to pull the data and "hard coded" (between #8/01/02" and #8/30/02") the date critera in. I then created the report with the...

Thanks in advance for your help! I have a database that I have linked to several tables in SQL 7. Today I created a new table and linked to it, however when I try to do a lookup, I get a error that the ODBC failed. I can run queries against the link table with no problems. What did I miss...

Thanks in advance for the help I am about to receive! Amen. I have two tables that have the same type data in them. One was used for one reason and the second was devevloped later by another group for a totally different reason (lack of communication). Without recreating the wheel. I need to...

Thanks in advance for any help rendered! I have a form that I am using several lookups on to check values used in conditional statements. I have cluttered the form with hidden text boxes to hold the values of one lookup so that I can pass them to the next lookup. The top lookup works fine but...

Thanks in advance for any help given even it is as simple as that can't be done start over! What I have is two tables (in 2 different databases). They both contain the same types of data about the same type machinery, but entries were originated for totally different causes. Yes, they could...