Search results

Looks cleaner thanks. I checked in 2010 (2003 on my home machine, it's here but forgot the extra power cord for it...) it all seems to run fine there (obviously the collision needs work and moving to mouse up but I'll look at that soon). oh, and I messed up before(sorry 2 monitors, looked at...

lol all good for some reason I couldn't access the forum for the last 2 hours anyway!

Thank goodness. That is oddly satisfying, Thanks! *phew*

Ok I uninstalled 2010 re-installed 2003. Now I think about it I never used 2003 access. I used 2000 and 2007 2010 (heck even back to dos...), but at 2003 I was home with the kids for a bit :). I did get errors but seem to have them purged leaving us a format to go back and forth on. If the...

Ok a lot to go through on that :) " The version may be the same but the location may have changed. So while going up in a version may accommodate the change in location, going back in a version may not." Wait, does that mean rebuilding it in 2003 will not necessarily help? :banghead: I'll...

Resolution is 1280x1024 - we do a lot of spreadsheet style forecasting that drives the resolution. Frankly it's as management insists. I keep trying to explain that throwing up too much information at once is bad for the user, I'm ignored. I DID miss one removable reference in the last round...

Ok, I stripped out everything I could find, removed any references that weren't in the one you sent me when I opened it...I have this fear that access 2010 AUTO adds references looking at them :/ having said that the DAO objects are gone and replaced with sql calls like you use so it SHOULD all...

Loading and saving is working ok actually, and yeah I was starting to think a cleanup in the MouseUp made more sense than trying to do it in real time! Having said that I'll get this cleaned up so it'll upload for you. I'm not actually grouping controls on the form so it's more likely...

oops forgot to attach.

Ok admittedly this is an act of desperation, but I've converted it back to 2000 format, removed the form from start up and copied all the code from the form to a separate module that isn't called but you could copy/paste back into the form... I think it's the DAO references if so I suspect I...

Annoying!! seems to open just fine form me! arrrg. Even working out of design mode :/ I THINK it's a references issue :( I'm using 2010 and make calls to the Office 14 library...any idea how to get around that for xp? It won't let me remove them due to dependencies...

It would be the last sample - I'm uploading an db now. Option Explicit is still there I just missed it in the copy/paste....appreciate all your input :) I'm thinking that converting the x values from the main form dates is over the top...but it's hard to work out conflicts in any way without...

You need to code this kind of interaction with VBA really. as soon as you move from data and sql structures to "IF THEN ELSE" logic you need code to process it. Not difficult code but code.

Honestly I'll tell you but I suspect you'll need more help. Let me know how this goes. Here is an example of (see jpg and code) of something that does what you want. This is a form with controls with a SubForm in it. As you change the values of the controls, the VBA rebuilds the SQL for the...

lol whoops I missed that he had a control there already *mybad* Having said that it's a good technique to remember when you're passing data you DON'T want the user to see.

why not just put some code in the afterupdate of the checkbox? I wouldn't even be in the detail_format event for something like this.

Can you paste the code you're using to call the dialog? it would help a bit. Are you making direct api calls?

ah, thanks. Private Sub MoveHorizontally(ByVal sngX As Single) Dim lngNewX As Long Dim testNewX As Long Dim found As Byte found = 0 Erase arrConflictRanges() Dim x As Byte Dim NumberOfConflicts As Byte 'determine number of conflicts(extra jobs on row)...

If I understand you correctly, the main form has trouble talking to the report as it isn't open yet. I'm sure there are other ways to do this, but I would create an invisible text box on the 'homepage' form call txtNewLabelName. Add code to the OnClick event of Command5, that says...

Gidday Chris! All is going well, though I am torturing myself over a point and was wondering if you had any input... Attached is some or your code I've modified (I tried pasting it here but it removes all my indentation, yuck)...I'm trying to get the jobs to move "around" each other so they...