Search results

More than you can imagine.

Actually (I counted) it is 133 fields. I am coverting a 18 year old DOS based foxPro db to Access. Many fields are not being used and will be deleted once I complete the conversion. Right now I do not want to delete any data fields until I understand the need and use. I created a select query...

I am trying to merge 2 tables into 1 and I get an error "Multi-Valued fields are not allowed in SELECT INTO statement" error when using the Make Table query. How do I find the offending field? Between the 2 tables there are close to 75 fields.

Thanks to all. Taruz solution works. I just cannot figure out the ' vs " vs """. Makes my head hurt.

Thanks all. JDraw suggestion worked. Now a new issue (see below) ' Check for Date Range dim varWhere as string If IsDate(Me.txtStartDate) Then varWhere = varWhere & "[NewWOdate] Between #" & Me.txtStartDate & "# AND #" & Me.txtEndDate & "#" End If I am also adding a search feature where the...

I get a type mismatch error when opening the form sdate = clng(cdate(Me.txtStartDate)) dim sdate,edate as integer sdate = clng(cdate(Me.txtStartDate)) edate = clng(cdate(Me.txtEndDate)) varWhere = varWhere & "[NewWOdate] Between " & sdate & " and " & edate

I am using a combobox with the 4 common values. Therefore the on change event. But I get what you are saying. Never used Case before. Thanks that did it.

I am building a dynamic filter in code and am trying set the date range for a query. The text fields work fine. I am having trouble with the code for date range. I think I am missing "#" sign to pass to the query. Here is what I have. Any idea how where to put the # ? Thanks. ' Check for Date...

I am trying to set the value of txtCPdate to blank field If Me.txtCPno.value does not contain certain values. Here is what I have. It works correctly when then txtCPno = 220160 or 225203 or 225204 or "22051C". I want it to change to blank if you change the txtCPno to something other than the...

I am VERY saddened by this news. His help and guidance have made me a better person. I have learned so much from him I can't express. My thoughts and prayers are with his family. He will be truly missed.:(:(:(:(

I am using: =DLookUp("city","tblParrishZipCityAreaCode","zip = forms!xfrmWONew!LocationZip") in a control on a form to get the "city" from the zip control on the form. Works Fine. HOWEVER, I need to be able to edit or enter a city if the Dlookup doesn't return a value because the zip is not in...

I searched everywhere for that simple answer. It works perfectly! Thanks..... It is something i will NEVER forget.

I have a function: Public Function fnCalcIncome(nYear As Integer, ClientMonthlyInc As Currency, InflationFactor As Double, xTaxchk As Double, yTaxRate As Double) As Currency Dim I As Integer Dim IncludeInfl As Integer For I = 1 To nYear If I = 1 Then StartIncomeAmt =...

Thanks. I couldn't quite get the syntax right. Also my second form was based on a query looking for criteria from that form. I got it working now. Thanks

I have a form that I select the CLient and then want to open another form with the client data. The following works EXCEPT I have to hit the Refresh ALL button and It refreshes the form and returns all the data. Probably something simple... Thought the Me.Refresh would work.Thanks I tried to...

Thanks. That works, but I have 10 External Amounts so the query field will be huge. Is there a way to do the same thing in the function to set any null arguments to zero?

I HATE NULL - How do I deal with a null value in a function that requires the argument? I want the function to run even if any of the arguments are null. I am using the function in several queries. Below is an example of the the query. Here is the function: Public Function fnCalcIncome(nYear...

Nope.... does the same thing.

I have two combo boxes on a form [StartMonth] and [EndMonth] the controls are unbound and using 2 column row source with it bound to column 1. Column 1 is the month number 1,2,3 etc. I am using the values to return records from a query using the criteria Between...

Thanks for the image and the flicker advice.