Recent content by val_87

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!