Search results

I have a membership db that occasionally needs to swap members between memberships such as marriages of 2 members. I have just set up a form to select the member from a list box, put the new membership number in a text box and run an update query to change the membership number. The membership...

Thanks for your patience David, I've got it now cheers, David

I got a bit ahead of myself last night, and didn't really look into your reply DCrake, I am still having issues getting my head around my problem. I can see what your form does but I can't work out how to get my thing working. Basically, what I am trying to do is follows: If...

Thanks for the ultra quick reply, so simple when you know how!!

I have a form f_fish that is opened from f_membership and records filtered based on f-membership!ID. I now want to open the form from another location f_select, but f_membership is not open so it asks me for f_membership!ID. How do I get f_select!ID to equal f_membership!ID ? I really am a...

Gemma, This just gives me "object required" If sf_members!ysnJnrSel = 0 Then MsgBox "The condition is true!" End If If sf_members!ysnJnrSel <> 0 Then MsgBox "The condition is false!" End If The subform is in datasheet mode and may have multiple records. Do I need to count the records...

I have a subform sf_members on a main form f_membership. I am trying to conditionally run a macro based on a check box in one of the records in the subform. If one or more of the checks is ticked I want to run the macro else throw a message box. I have tried various VBA syntaxes but none seem...

I have a database that I have been using quite sucessfully for the last few years but now it is time to 'tickle' it up. The database is a fishing tournament database that basically records anglers, boats and their catch. I would like to, say have a button, that will create a new tournament...

But what if... I want to fill in unused membership numbers? cheers, David

Maxmangion, I have a need to do what the displayed code doesn't do!! How do I get number 56 to be the next available number in an "auto number" situation? cheers, David

I have a membership database that my users manage to delete records without realising as they are computer "nuff nuffs". My main form has membership details with a tab control and a linked subforms on each of 3 pages, members, payments, boats. I am trying to find a way to prompt for save or...

Thanks for the replies guys, as this really doesn't do anything apart from please me I feel that Pat is probably right. The database that I am fixing up has had membership nos deleted when there is provision for a resignation date so all i am trying to do is fill in the holes. Thanks David

Lister, Membership No is not an auto number, the only reason I want to do it is for aesthetics. Cheers, David

I have a form [membership] that has a primary key of [membershipNo]. Over the years, people have resigned and I wish to re use their old membership numbers when new members join. I may have nos 1,2,3,4,7 and I need to identify and re-use 5 and 6. Can i do this automatically rather than the...

Would someone please be able to explain how to add the ActiveX Crystal Reports Viewer to a form. I've had a go and frankly have no idea. Thanks, David

I have a fairly basic form that has a number of buttons attached for various things ... record navigation and filtering. They all work fine when i am using the form as a standalone, however when I put the form on to a page 1 of a tab form my filter stops working and asks me for a parameter...

Dave, I get variable not defined error with your code, not great on code myself!!! cheers, David

Stacey, Thats OK, but I am trying to get a button on, in your case, the institution form header to reflect the contact details

I have a membership form that contains membership details and a linked subform that contains member details as there are multiple members per membership. I need a button in the membership form header to open a seperate form related to the member subform. I've tried lots of things but am in brain...

Is networkdays a valid function in access 2000? It is refered to in help but I get undefined function when using it probably because it is not in the list of functions in buider. Any help appreciated. Cheers, David