Recent content by karmacable

As gemma mentioned, if you see you have the trial version of Acces then don't install (like it did for me, it'll simply blink for a second and then the installer will go away). To answer your actual question, NO it will not negatively affect Word / Excel.

Nevermind, I just figured it out in both cases. For those wishing to learn; DoCmd.OpenReport "rptDetail", , , "ProjectID=" & Me.ProjectID should be changed to DoCmd.OpenReport "rptDetail", acViewReport , , "ProjectID=" & Me.ProjectID And -...

Aargh, celebrated too soon! Two more questions.... 1. It appears now when I click on my command button to open my report, it sends it printing and does not pop up on the screen? I'm using; DoCmd.OpenReport "rptDetail", , , "ProjectID=" & Me.ProjectID The last part is simply to have it tied...

Excellent, thank you!

All forms appear to have a limit of being expanded to 22". Each of my subforms are 11" (just like an 8 1/2 x 11 inch printed page). If I were to expand each subform in design view to show itself fully, my main form couldn't hold more than two. The only way you can see the full contents for...

Great suggestion, it seems to work for printing! However, is there a way to get the 'print preview' version to show up when a command button is clicked from the main form (e.g. so it shows all the pages). This version only shows the small subform boxes, not very helpful for my users until...

I am looking to create a 5 page report based on a record. I was initially using a form to detail my reporting (just because it simply served my needs) where I was creating the first page to exact size, using a page break and then creating the second page to size. In printing this looked...

Thanks for the tip. I tried that without success, but then I tried referencing the function that I have doing the calculations after the Paste/Append, and it appears to have worked!

I got some help (thanks to missinglinq) in another post on how to setup my code in a command button to duplicate a whole record, and then add on a revision #. Now that I'm checking the duplicate records, all looks fine except a few textboxes where I'm using calculations...they're coming up as...

I think I figured out what the culprit was. Even though my Access files were not being recognized on these W7 computers without Access, it appears that they did have the 'MS Office 2010 Trial' installed. They then registered for Word & Excel, but Access must either have been instantiated for a...

Perfect, that seems to do it! One more question, is there anyway to get rid of the Access message "You seemed to have copied a large amount onto your clipboard....", which happens after you've duplicated a record and are ready to close your db? Thanks again for the pointer missinglinq!

Okay, so I figured out the VBA to write, but my logic for the counter does not appear to be working. Here's the code; Dim Revision As Integer Revision = Me.txtRevisionNumber.Value DoCmd.RunCommand acCmdSelectRecord DoCmd.RunCommand acCmdSaveRecord DoCmd.RunCommand acCmdCopy DoCmd.RunCommand...

Good suggestion, but unfortunately it didn't make a difference.

Yes, you are definitely right as I have not properly coded in error handling. Will get on that and hopefully that will at least narrow down what's happening....

Yes, they're on W7, and the download link above indicates the installer is for W7. I did try to manually install as well (that's where I'm having the problem with the 'disappearing' window).