Search results

Ummm, Errr HELP!! Hi Guys Here's a odd ball one for you.... I want to make a form, with a list of Students names in it. this list is from the Students table, listing only the current Students. By the side of each name, a tick box to select them by. When the tick box is ticked, for as many...

Hi guys I have searched and searched on this one, but still in the dark. I have a form, with 4 combo boxes. 1) ActivityType, 2) Actvivity, 3) Statement, 4) Value. What I need to do is when combo1 has a value selected, it limits the list in combo2, and so on. The tables behaind are set up...

Hi guys I hope someone can help here, I am doing a bit of volunteer teaching and the project that has been dictated in the sylibus is Hotel Bookings and school register databases. Does any one have any barebones db and/or tips as to implement a db such as these? I am teaching a load of 14+yr...

Hi All Does any one know a way of getting docmd.findrecord to use a msgbox that prompts for the search criteria?? Or am I barking up the wrong lamp-post, :confused: just need a simple way to find a person or address in a Doctors db. Thanks Bodvoc

Hi all Can anyone help me, i am using a textbox to store personal details that are looked up by a combo box (running of a query)i.e. Textbox=[combobox].column(#) # being the number of the column wanted. But, if I have two or more people living at the same address, though it shows the right...

Hi All Has anyone any good tips or techqinues to do security on an Access 97 db. I have 14 users, most need to add data and / or modify data in various forms and sub-forms, only a couple of them need just to view exisiting data. Don't want to use MS Access's built-in stuff and get bogged down...

Hi All Please help, I am using Dlookup to run my security, but it is os slow.. up two 2 minutes to vaidate! Thanks Mr Gates!!!! Don't want to use a workgroup, "mdw" So... How do set up a good multi user security system, with user access levels, and ofcourse locking out happy hackers...

Help!!! I have a form looking up patient details based on a query, a find patient button opens a pop up with boxes asking for surname and first name to be added and which the query uses to refresh the main form. and a find button that refreshes the main form... But on click, if no one is...

Hi All, Is there a way of making a button on a form change after it has been clicked?? i.e. An ADD button becoming a SAVE button after its first click and then chaging back to ADD on the clicking the SAVE button?? Also making it carrie out the correct option as well... I am doing it with...

HELP!!!:confused: I have a form, based on a query, that loads the form up with the wanted records... A very simple form feeds the query... and all works well......... But!?! If the user enters a criteria that is not found in the query, the open form vanishes and so does the simple form that...

Hi All As a newie... I am stuck! :confused: From my main db form, I have created a command button that opens a very simple form with two unbound text boxes and a command button called "go", these text boxes feed a query the cirtiera, and the "go" button runs the query and opens a form showing...

Hi Guys Tried searching on this but drawn-a-blank........... I have fields in my db that hold a surname and a ref type... i.e.... Bloggs (R) I need to use a wildcard in the query that will bring up Blo *, in short include spaces, and any ending of the primary search.... Can it be done...

I have a db split into fe and be, run on a server. In another forum I was advised to unbound both my main form and the boxes there in. I need to know how.... I can call up and existing record from the table, and filling all the feilds with data from that ONE record... and.... How I can save...

First up thanks to everyone for reading this and, an extra big THANK YOU to all those that read and helped out with my other questions.... I am still stumped on this one..... I have written a db for a charity org, with 8 Users (max about 4 at a time). db split into backend and front end, be...

Hi All Thanks for reading this..... Please help here if you can... First Up.... Does anyone have a working way to disable the mouse scroll?? Tried the other threads here but can't get it to work?? And Lastly... Used a wizard to make a goto next record button, but when it get to the last...