Recent content by odin1701

Well this takes me back! It's been a long time since I've fixed this, but I think I used this here: http://allenbrowne.com/ser-40.html That's a good resource for other things as well. I don't have quick access to my code as I'm not with that company anymore, but try the above and see if that...

I got it to work by building another table to store the comparison info, without keys, and just made a query that references to another table a bunch of times to get the relevant data. Inelegant, but it works and you have to manually setup the report using a form I made to edit this new table...

I'm not quite sure how to go about this. I am wanting to make a query that compares the price of one part to the price of various other parts in a matrix. Example: 60 70 80 10 $20 $25 $30 $40 20 $30 $25 $30 $40 30 $20 $25 $30 $40 40 $25 $25 $30 $40 50 $40 $25 $30 $40 So...

That's just as bad as hard coding anyway...oh well.

There is no other way? So I have to hard code the names then....that's annoying.

I'm trying to add a bunch of reports to a combo box. Here's the code: Dim varReport As Variant With CurrentProject For Each varReport In .AllReports If Right(varReport.Name, 1) = "Z" Then cmbReport.AddItem varReport.Name...

It would be too much of a hassle to take the confidential stuff out really. It's working a slightly different way (I updated the post to say that), but I was just curious how this could happen. I compiled, did a compact/repair, searched the code for a duplicate piece of code that could have...

I have two forms. frmStartup frmMain The startup form just has a logo, db name, version, and an exit button. The code for the exit button is simply: DoCmd.Quit acQuitSaveNone The frmMain has all of the DB stuff for users. This DB has the option of using a local database if the user isn't...

Ok thanks, will give that a shot.

Because the top right of a maximized form is not the same position on all screen resolutions. Or is there a way to do relative positioning that I don't know about?

No, not resize. It's the size I want, I just want to reposition where it's at.

Is there a way to calculate where to put an image based on the screen size the person using a database has? I'd like to position a logo in the top right of a form when it's maximized, based on the size of someone's screen. Is this possible?

Okay, I think I found the issue - the query is causing the date to be a text field. I did a make table query and it set the type to text and not Date/Time. Is there a way to fix this? Even if I could just run it as a Make Table query and delete the existing data and then re-update it, that...

Not sure where to put this, so trying here :) Okay I have a query that combines information from two tables and want to make a Pivot Table with the data. Here is some example data: PartCode ProductType TransDate ActualMT ForecastMT 503220 OTHER 10/1/2008 2.7255 3 503226 OTHER...

I tried that, and it doesn't seem to work. If I put "BIN" in the criteria, it's changed to: Like "BIN"