Search results

got it in an update query suppose there were two strings to omit, both always the same string - how would they be nested?

yes the string is always the same how would i assign the code below to work on a field on a table or would i somehow send it through a query? IIf(Left([yourfield],17)="!FC:\MP3S\TOP 40\",Mid([yourfield],18),[yourfield])

I have a table of 10 fields most with obscure info like: !FC:\MP3S\TOP 40\Cry Little Sister - lost boys.mp3 And i am trying to strip "!FC:\MP3S\TOP 40\" out without much luck. I have tried a few suggestion from past posts which through public functions. I would like to say: Go to table...

I have added both to the motiv-8 web site links page.

When powerpoint tries to share data from a access db i get the "jet database engine cannot open file" However, i have installed the security wizard, etc and a set up the database it still does not work. If i rightclick on the db file in explorer and select security and add "Everybody" and...

i feel silly now. yes brackets. Cheers

I am trying to do this: bet2 = 100 odd = 4 [textbox] = [bet2] * odd + [bet2] /2 the answer should be 250. But i am getting 450. I Understand what is happening but unable to reslolve the calculation. the final [bet2] is being devided by 2 and applied to the first part of the calculation.

No, But what did help was this from datapoint http://www.take-off.as/datapoint/index.htm

Any help would be great Here's what i have so far counter = 5 DoCmd.OpenQuery "Append DJ", acNormal, acReadOnly smallbar.Width = Bigbar.Width / counter Me.Repaint Me.smallbar.Width = 0 Me.Repaint DoCmd.OpenForm "thanks", acNormal, "", "", , acNormal 'DoCmd.RunSQL...

I have been using access for years and it is now easy to use and managable code, excel is all new. Thanks

I already thought of that idea. But my form has 10 text boxes that display each teams score. I only use the 1 record on the form. I may need to transfere this to excel. Your thoughts please.

I have a database with one record in it and 10 fields It basically totals and keep track of quiz results. Therefore 10 teams - 10 fields. I am trying go design a query that will sort the scores into ascending order. HAs anybody any ideas?

How? How do i use them together: int & Max([total1])?

I need to use the Int and max functions together. To find the largest number and then crop to the whole number. Can It Be Done I am working in the control source property of the field. Here is what i have so far: =The Leader has £" & Max([total1]) & " In the Bank"

The macro recorder does not work in ms graph. I am trying to automate the import of a simple 2 field tabbed seperated text file into the graph datasheet using VBA. I can do it VIA THE EDIT menu and selecting import file, and selecting .txt file type, etc But how is this done in VBA? I has to...

using a select query i am trying to omit data. I do not want any records with £999 in the total field considered. However my "rank query" which is part of the select query i am working on, still ranks those records that have been omitted using "Not 999" or "<>999" in the criteria box. Here is...

Tnak you very much - it works a treat, and your explanations have also sort out my next coding situation. thanks again.

I am trying to find the value in field 1 (called "winselect") and if the value entered in field 2 (called "winselectb") is the same then i want to make the value of field 2 null. here is what i have Dim jim As Integer jim = [winselect].Value If [winselectb] = jim Then [winselectb] = ""...

Using Left function to select the field name I am constructing a where statement within a update query. this is what i have so far: DoCmd.RunSQL "update bets SET bets.[bettotal] = [bet1] * odd /2 + [bet1] where (winruner2race1 = left([r1n1],4);" it is the where statement i am having problems...

Does any user know how to open a report at 120%? I know the method of opening at zoom box percentages.