Search results

hi, I have a form that looks up values that are based on a query. e.g. Name There are only 5 fields in the form. I want to create a button, and on pressing it, I want the form to close and to open the main form that lists all the fields FOR THAT PARTICULAR person. My unique identifier is...

ok here's my problem. I doubt it is possible as I have searched through previous report queries and no-one seems to have asked anything like what im about 2! In my form I want to have a button that will open a report that is based on a query. This query will for example ask you to enter the...

ok Ive solved my problem with the filter button. However when I press the filter button to 'filter by form' I cannot press the button i created to apply the actual filter. HELP!

hi I want to filter records in my database, I know what I want to do, I want to filter by form. I can however only find 2 buttons that will filter in the wizard. One is apply and one is edit. The edit code is posted below, can someone ammend it so that when I click the button, it gives me the...

ok, each person in the person subtable has a postcode, GP code etc. Previously where I have been using other tables from the main table it has only been necessary to store one record as a result of selecting the name from a combo box...and the ID would be sent back into the main table where it...

i dont know whether ur understanding quite what I want!? I have two tables. I want to select the name from the sub table and want the other fields that are also in the subtable to be brought into the master table automatically. i.e. I want to select one field from the subform, on doing this i...

thanks guys, only problem im still not getting is how to get the codes to store in the tables. Ive been told to create text boxes etc, but im not 100% sure what to do now that ive done that combo box + code. Dan

hey, thanks for ur help...i stil cant get it to work though. What do I create in the combo box..lookup name and store as name in master table? Do i write any of the below in the code? ' Find the record that matches the control. Dim rs As Object It says it cant locate my patient name!! How...

hey, thanks for ur help...i stil cant get it to work though. What do I create in the combo box..lookup name and store as name in master table? Do i write any of the below in the code? ' Find the record that matches the control. Dim rs As Object It says it cant locate my patient name!! How...

I have tried hundreds of ways and wasted many hours on this, perhaps one of you could help!?? I have a 2 tables. One contains the majority of my data (call it the main table) and I have another table that contains details about each person (person table). On my form I want to select a person...

how can you base a form on a query, and still when u enter new records in the form, the data gets stored in the required table?

hmm Ok, however i need to enter data through the form. Isnt this impossible if its based on a query? If you can solve this, it should work. Thanks Dan

Hi, I have a really anoying problem that I cant solve!! I have a table that contains fields on people (Name, Address, and loads of codes etc). I then have my main form, here I want to lookup a person using a combo box (done) and for all the fields from the personnel table to import into the...

ok, i have sorted that problem out now. I put that Me.NameOfSubform.Requery formula into the name field on change rather than on current, duno why it wouldnt work your original way. I do however have another problem. I want to select name, address and tel no. from another form, but I want to...

hey, It doesnt appear to work! When I make a change to the name, the subform doesnt automatically update. However if i go to records - refresh, they do! Dan

hey again people, I have a subform that will look up certain data from another form when i select a certain field (name). Is there a way I can get the subform to automatically refresh as soon as I change the name in the form? Thanks Dan

thats wot we'll b doing, but we need to store the code too for numerous reasons... :S

Sorry guys, I am still unsure on how to do this Dlookup, i have never done one b4! Is it in control source I put the calculation. Here's the exact problem = I want a calculation that will lookup a hospital code, once I enter the hospital name. I have a seperate table that contains two...

where would i type this?

Hey people, I have a really (i think) simple problem. I have a field that contains certain records, when i select a record from this field (its a combo box from a table) I want another field to display the code of the record. e.g. Dan Mitchell (in first field) I would then want my NI no. to...