Search results

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"

I don't know if this is possible. I need to filter on whether the value of a field is "BIN/" or "BIN*" or various other things. The data is from a mainframe system, and whoever created that was wonderful enough to allow these characters in text fields.

Look at the RowSource property for each combo box. You can type queries in by hand or use the query builder. There is also VBA running on that form and without that it won't work either. As I said, that method is more advanced and requires some basic programming. If you want to build this DB...

You renamed the form, that's why it isn't working. The queries in the combo boxes have to refer to the fields on the form - and right now it's still looking for frmRegistrationAlternate, which is no longer there. You either have to rename the form or edit the queries to reference the new form...

Have you added the new classes to a class offering? If you have no class offerings, you can't add any registrations. I can't see your class and student forms so I have no idea if they are working correctly. Sounds like they may not be.

Where are you entering the new students and classes? Did you make a form? That's what you should do. What object is asking for a parameter? Also, you can't just delete the names and classes because they are foreign keys in the registration and classoffering table.