Search results

I have a report listing members of a social group. The report is split between Current and Past Members. I have a yes/no check box on the main form based on weather each member is a current memebr or not. This is recorded in a table called "data" within the column called "member". I have a...

When i press the page down key to cycle through the record set it often ends up past the last record, and i get an error 3314 about the id being set to true. I have tried the following code on the forms "before update" and in the ID fields "before and after update" with no luck. Private Sub...

I need help with this one. What i am trying to achieve is: Bag 1 [4] Bag 2 [7] Bag 3 [7] bag 4 [10] Bag 5 [6] bag 6 [3] bag 7 [5] Bag 8 [2] Column one contains "bag 1", "bag 2" etc. It is text, and is always the same and in that order. Column two (with the []) contains data taken form a...

I am starting a new project. I have 9 forms and any ONE form could be open. I have 9 option buttons which opens the forms. When the user clicks option button one, forms one opens but i need to close the other open form. How do i to declare (dim) the current open form? so that i can open the...

I'm looking for a way to keep a form maximized even if the user presses the minimize or maximized buttons in the top right hand corner. Or even gray out the min and max buttons altogether. I have code in place that grays out the close button but not the min or max. Any help would be great!

I have a form called card and it is bound to a table called cardtable. On the form there are several unbound fields (one is called "winselect") that i would like to be saved (or bound) to another table called winner. Is this possable? thanks

If somebody tries to close the program or the database, I am looking at setting up a password system. I know that if the password is unsucsessfull then: docmd.resume What i have so far: Dim pass As String Dim db As Database Set db = CurrentDb() Dim docname As String If Forms.Unload.pass...

I am trying to format a sum expression, then pass the results to powerpint. the experession i have the the field cell is this: newtotal: Sum (Format([bets].[total1]-[bets].[leaders].[total],("£#,##0;(£#'##0)"))) Inorder to display corectly in powerpoint, It needs to display the "£" without the...

Is there a way to disable the return key on a form, or perhaps assign a function to it?

I have been pulling my hair out over this one. Table One has 4 fields, 2 of which are called Logo, and company. I am trying to "connect" them both to gether, so that if the user selects "john's hotel" in a form then the corresponding logo will link. I beleive the i need to split the tables...

When manually doing a .txt import all is fine using my own import specification. when i use this code DoCmd.TransferText acImportDelim, "song specification", "list", "\\disco\djpower\Songs Played.his", True the first record in the text file to import is missing any suggestions??

I have the following code i would like to run every 5 minutes DoCmd.RunSQL "DELETE * FROM data;" DoCmd.RunSQL "DELETE [list].song1 FROM [list] WHERE (([list].song1 = ""!F:""))" DoCmd.RunSQL "UPDATE list SET list.song = Mid([song],2)" At the moment the code is on command "button19" Q. How...

I have a table called "list" The field "sendto" contains time data. I am trying to copy all the data in the "sendto" field to a nother field called "omit12" Both fields are in the same table - can this be done so far i have DoCmd.RunSQL "INSERT INTO list SELECT [list].sendto FROM list;"

I have searched and searched. What i want to do mus be simple. I have a form with the calendar control set to mile-o-philes spec, which is triggered from my "diary" form. I am trying use the calendar to find a record on my "diary" form. The control on the diary form is called "Date of Func"...

I have a table with a a time/date field. Is it possiable to delete every record that is 10 minutes old?

have a ")" at the end of a string of text which i need to omit, any ideas? i have this IIf(Left([time],10)=")","",([time]))) but the whole thing deletes

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

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

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