Search results

Hey, guys thanks for the help. I finally remembered having this stored away from a post here somewhere. I don't recall who it came from, but thanks to them and you guys for your time. Check out the search form here. This is what I implemented. Thanks again.:D

Can some one direct me to some information on the best way to set up form filter. I need to set up a form so that it looks like a search form. I need two, maybe three fields to drop down, choose the value and then show me the related records. I have an action item database and i want to...

I have a form that users use to input new report information (tblLog). Each entry has a 8-digit report number (PK) based on the following convention, given 12345678 as a hypothetical report number: |12| = the site code |34| = current year |5678| = next report in sequence from 0001 - 9999 Up...

Open your form in design view. Open the properties box. Click on the subform. Click on the data tab of the properties box. You should see 'LinkChild Fields' and 'Link Master Fields'. Select ProductID for both of these and it should work. That should show you batches for that ProductID.

Sorry Andy, couldn't go along with you here.:D

I needed this list about 20 years ago!;)

Is this healthy?:p

Search Access for 'delete duplicate records'. It lays it out real nice.

Ain't that the truth!

Only having a little fun with my buddy Hayley. All is well. :D

Hayley, Hayley, Hayley. This is all very disappointing.:(

Just so you know Mile isn't the only one, the table structure would be the best thing to change. I would talk to whoever it belongs to about normalising the data. Honestly, it doesn't sound like they have the firmest grip on Access.

Come on, Mile. Surely you didn't just pull that off the top of your head. Nobody can just come up with that unless they are a freak of nature.;) Just wanted to say it was pretty cool stuff.

If I understand what you are saying, search the forum for 'cascading lookup'. There is a lot of information here on it.

Sounds like you have an object in the report looking for a piece of data about books that isn't in the query. Make sure all your control sources are set to the correct data source.

You're right but apparently there was something in the wedding cake and she has never been the same.

Hmm ... that makes tooooo much sense. I put that command in the On_Open event of my object that opens when the application opens. (Assumed that was the proper place.) That did it! Thanks guys.

That's VB for forms or reports. What about the application window itself?

How about this? If I link from one database to another db, the second db window is half-size. I would like each window to max when it opens.