Recent content by alelover
-
A
sub form listbox based on auto number field from main form
Thanks for all your help. It did teach me a couple things. -
A
sub form listbox based on auto number field from main form
I've done that too. It kills my search by Track Title ability. My search code works good if everythings in the same table. How can I make it search and find data from a different query than the main one I have set as the Record Source? -
A
sub form listbox based on auto number field from main form
The subform always shows the right records. But it shows a recordingID record for all the records in the subform. So if one concert has 10 songs there will 10 records for the one RecordingID. In my Condensed dB I have 4 concerts but it show 69 records. There are 69 songs in the qry. If I make my... -
A
sub form listbox based on auto number field from main form
Hello folks, I am having a similar problem. I can search my records with no problem but I end up with a main record for each subformrecord. So if a concert has 20 songs I get 20 records of that concert. I tried entering the criteria the way you have it there and it keeps asking me to Enter... -
A
Form with Subform Datasheet shows too many duplicate main records.
Is there anybody out there. -
A
subform datasheet shows too many records
And this when I debug. Highlighted in yellow. Me.FilterOn = True I'm guessing it can't find the Track data. Is there a way to get it to pull the data from a different record source than what the main form pulls from. -
A
subform datasheet shows too many records
I think I may have tried that already because now I can't search by track title anymore. Which was the original main problem. I got the search to work but then I had all the extra records showing up. I need to be able to search by track title and not have all the duplicate records for each entry... -
A
subform datasheet shows too many records
Hello all, I have built a database for my music CD collection. I would like to be able to search by track name and pull up the records that have only those tracks on them. I can do it to some extent but it isn't right. I have set up different parameters I can search by. They all work exactly how... -
A
Form with Subform Datasheet shows too many duplicate main records.
Hello all, I have built a database for my music CD collection. I would like to be able to search by track name and pull up the records that have only those tracks on them. I can do it to some extent but it isn't right. I have set up different parameters I can search by. They all work exactly how... -
A
Calculating an Expiration Date from 2 Different fields
I have 2 columns with dates in them. InstallationDate and InvoiceDate. If the InvoiceDate column has a null value I want it to use the date from the InstallationDate column. Once in a while both columns will have a date. If so then use the date from the InvoiceDate column. If it's from the... -
A
Calculating an Expiration Date from 2 Different fields
Hi All, I'm kinda new at this access stuff and not real good at all this code stuff. What I want to do is calculate an expiration date for 2 criteria. If a product is invoiced I want it to expire 1 year from the invoice date. If the invoice date has a null value I want it to use the install date... -
A
Combo BOx Filter Issues - Can get passed it
Re: Combo Box Filter Issues - Can get passed it I too am having the same issue. I'm pretty new to Access so I'm an idiot when it comes to database stuff. I have a combo box with serial numbers for machines. When I select a serial number from the drop down I want it to show the data from that...