Search results

Hey yea i have tried that and it doesnt work, even if it did i have two tables in the query and i only want one table to have unique records, basicly i need a 1 to many relationship with tables. thanks for trying to help tho ,Leon

Hey, Ok so I have this form that has two subforms on it (sf1 and sf2), these are run by one query called 'test'. Below screenshot of what i dont want happening; Bugger.jpg Now what i want is a distinct command for the 'Document Number' column so it cant be shown more than once. basicly i want...

Hi, Ok so I have a subform where some records are shown twice, but not duplicated in the actual table source. I was wondering if there was a some way i could use vb code to hide any duplicated records that have the same 'Document Number' as the original. Thanks for reading, i would be very...

hi This is all i could find for you its off a website, hope it helps. ,Leon Adding "All" to a listbox or combobox: If the RowSourceType of the control is a "Table/Query", there are two ways of doing this. One requires the use of an Union query, and the other one requires a callback function...

Hi, Overview: Ok so i have document database, and i have a number of forms these forms have a tab control layout on them. There is a 'Search' tab, a 'Add' tab, and a 'Edit' tab. Now what i have is a edit log table linked with the documents table on two seperate subforms on the 'Search' page...

It is a good article but its almost too good that it makes us younger, less experienced people scared to ask questions unless its extremely technical, important, and hard for you to answer; What if the problem seems simple and is actualy hard. Ive also noticed the large amount of soposed...

you could make a piece of code that will change the date back on an event such as opening the form

i have a form with a textbox, this textbox is linked to a table that has a hyperlink column. Now i dont know if this is possible but i want that when a user adds a new record using textboxes that the hyperlink textbox starts to add parts of the hyperlink (this is for a document database and the...