Search results

Ok it displays now! :) So JHB solution works, it now displays the only 2 "records i have" no i just have to make it search :D

This is what i am trying to accomplish, i want data displayed in a list box. In a list box data originates from Personal Info containing UPI, DOB and Consent. When searched against UPI i can then click it and it will open a form full_personal_details... of that record. I don't even think i need...

Hey all, Ran in to a bit of a problem, again. :) DB is attached. Now there is a List Box called listbox1 and a searchbox calld txtSearch. The idea is that when searched in txtSearch box the stuff in list box is displayed and filetered. I used a youtube tutorial to do it, did all like the...

Hello, I want to be able to run a query based on the information that user or i enter. There are currently 3 parameters, one is a date to date parameter. The other two parameters come from slots in tables that have dropboxes. I haven't got the chance to get to other two. Now when i set...

Yep it was. I just enraged and deleted the damn button. I will email it to personal email and give it a go at home tomorrow. I will post back! :) I will remove spaces from the column names.

Thank you! I will do so. Do you maybe know why query is repeating information?

Hey all. Now attached is a screenshot of a main form. I have a button there to start a new record, which works, but if i wanted to create a button to view a specific record i run in to an issue. I need to write a piece of code in to event procedure to open a record selected from that...

Hey all,How do i write an event that would make a record to open on double click or via a button?

Thank you! Im leaving office for today ... i will be back tomorrow! :)

Hi Minty, I think you remember me from this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=281492&goto=newpost Im getting a headeache here. The data is at the front, button to open existing one from the datasheet, that sheet contains only some info from a table, not...

Please see screenshot attached. Hello everyone. I got great help here getting my data structure and tables in order, and have built some forms succesfully, but ran in to a bit of a problem. Before i explain i would like to thank all who helped me to get my data in order, especially Minty...

I ran in to a issue, on main Navigation form im trying to make a command button, that when selected on record takes to that record on the other form with patient info and tests... :( It's says you have chose two forms that can not be linked together... you must have at least one field that can...

No i mean the full blue behind the actual table.... :) I am also havin'g trouble linking the forms together to open it ... says can't be linked or smth, i will meditate on that and try and figure it out!

Sorry here is the main page where i am seeking to remove background.

That is a sub-form. :) So how do i get this damn background away from the main form so that just main form remanis and none of that stuff at the back? :) Its actually nice to see something forming out of it!

Remove it from where? Sorry. Attached is the main form everything will start from. What is bugging me is that background behind it the blue one ... or it is white sometimes. How do i remove it? So that in form view it is just the form. From this form all operations start when data is...

This is the new relationsips attached. Now as far as design wise, here is what i plan to do. As main form i plan to have a form that is like a table that would contain some information from personal_clinical table like: Baby UPI Baby DOB Mother Name Mother Surname Date of transfer to...

Thank you, thought that. I will merge the clinical and personal together, then do relationships as per your advice. Then i can finally move on to forms. :) I know general form concept but there is some things i plan to achieve. Have information input form, what do you think maybe one...

Good day to you all! Ok. It definetelly looks cleaner. If you could help me out with relationships here. Because once the data structure and relationships are out of the way i can start playing with the part i like most! :) Table personal_info has a primary key Baby ID. Table...

Well i want to get it done, with help or without help. I am interested and intreeged. And this is not a hospital system or anything like that. This will not manage births in a hospital... :D I would not go near to building anything like that, its a registar and at the minute 2 people are using a...