Search results

Howzit Glad you got a solution but you may want to do a dlookup to get the results a little quicker, as opposed to looping through the table until you find a match me.LAFA = Dlookup("[Family]","Sciflat","[Genus]='" & me.Me.LAGE & "' AND [Species]='" & me.LASP & "'")

Howzit I had this problem when I first purchased Access 2010. It had something to do with a database that was not fully compiled and access didi not like it, so it closed down. To open it up again I had to decompile it. I think Micorsoft are working on this (if not solved already) but I make...

Howzit Do you have the sql statement encased in double quotes. It may be that seeing the Select part vba wants and expects to see the case part as in SELECT CASE You may want something like Dim sSQL as string sSQL = "SELECT Sciflat.Family FROM Sciflat " sSQL = SSQL & "WHERE Sciflat.Genus =...

Howzit How's life over the pond? I was using Bob Larson's front end updater at the time for this purpose. We had the application deployed on a Citrix environment and it would work ok most of the time, but randomly for some users it would fail. I could never replicate the problem on demand...

Howzit Try this sSql = "SELECT code, name, buildingHierarchyCode FROM dbo_FOODEX2 " sSQL = sSQL & "WHERE (((dbo_FOODEX2.buildingHierarchyCode)<>'" & me.Niveau1.Column(2) & "') " sSQL = sSQL & "AND ((Left(dbo_FOODEX2.buildingHierarchyCode,5))='" & me.Niveau1.Column(2) & "')) ORDER BY 3;"

Howzit I have also had problems with this - and never got a resolution. My problem would pretty much did the same thing. It worked out a new version existed but could not run the cmd script that was generated. It did create the cmd script as an cmd.exe (or something to that effect) shortcut...

Howzit You will get this in a division formula if the denominator is 0 (as you cannot divide by zero) not negatve. So you want something like: iif(yourdenominator=0,0,yournumerator/yourdenominator) AS Proit_PC I'm not sure where abouts in your SQL you have this error.

Howzit Yes you are right it doesn't do anything in this instance. The Case Else handles things that are not specifically identified in your selection. I know that you stated that you only had US or WW but I tend to put in case else in case something unexpected happens. In your case we could...

Howzit Short of finding out why the missing information is not in the table in the first place, the only thing I can come up with is to get the users to populate a static list (in another sheet instead of manually overwriting the formula) that will hold the missing information by job id and...

Howzit Give this a try in your On_Click event procedure Select Case Me.combo376 Case "US" Select Case Me.Text358 Case is <200 me.Text378 = 1 Case is <501 me.Text378 = 2 Case is <1001 me.Text378 = 3 Case is <2001 me.Text378 = 4...

Howzit Glad you got the formulas fill working. For your 2nd problem is it possible to upload a small file to show the problem. I will not need to refresh the data just look at what is happening in the formula - especially where the are no values returned.

Howzit It looks like you are using Excel 2007 \ 2010, not 2003 where my post would have made sense. I have only just purchased 2010 so not that familiar with the changes as yet. I just tried puytting in a formula in my Excel 2010 MS Query file and the formulas copied down automatically. If...

Howzit You need to be on section of the imported data to use the right click >> Data Range Properties... It will not show if you right click on a section of the sheet that does not contain the actual data. You don't have to do anything special if using MS Query to import the data. I assume...

Howzit You will want to perform the loop until it comes to an end as all are empty or until it finds 1 with a value in it - then do your actions Something like Dim iCnt as integer iCnt = 0 For Each ctl In Me.Detail.Controls If ctl.ControlType = acTextBox Then If...

Howzit You can do this by Rt Clicking on the data >> Data Range Properties >> Fill Down formulas in columns adjacent to data Not sure what you mean by this, but if the additioanl columns are not foumulated (is this even a word??) then there is no guarantee that what a user enters would match...

Howzit Never give up - By hook or by crook you'll get there. Which is correct. You have UPDATE [Policy Changes] a space in the table name but then you have SET Policy_Changes.Legislation_ID in the SET part - no space but an underscore. They need to be the same - I would recommend not...

Howzit you may be missing a space before "WHERE" Try ("UPDATE [policy changes] SET [Policy Changes].[Legislation ID]=" & Me.SourceID _ & " WHERE [Policy Changes].[ChangeControlNo]='" & Me.cboBulletinNumber & "'") Also if cbobulletinnumber is a number you will want ("UPDATE [policy...

Howzit It may be because your sattelite computer does not have the same network location mapped to the same Drive letter? So when it tries to run code or do anything that involves a mapped drive it fails. I always use the full UNC file (\\someserver\level1folder\level2folder) path instead of...

Howzit Sorry I have been away on business. If you load your file I'll have a peek.

Howzit Try this in your after update event procedure. I'm not sure if you had typos in your code but I used your table definition you specified me.bcode refers to the name of the control on your form unitprice = dlookup("[price]" , "BCtbl" , "[bcode]=" & me.bcode)