Search results

Doug Steele and Graham Seach have a 'more complete' Date2Diff Function here that may work for you: Diff2Dates Linq ;0)>

This is one of those times when I think you're going to have to Remove any confidential data Compile the app ZIP your file and attach it to a post here Linq ;0)>

Are these actually designated as Lookup Fields in the underlying Table(s)? Linq ;0)>

You need to Do a compile Remove any proprietary data ZIP the file up Attach it to a post Linq ;0)>

Sorry...but cannot reproduce the problem, using Access 2007. Perhaps someone else will have an idea. Linq ;0)>

Once again...you'd do better posting your questions in an Excel forum...here are a few: https://www.excelforum.com/ https://www.excelguru.ca/forums/ https://www.mrexcel.com/board/forums/excel-questions.10/ Linq ;0)>

Why are you posting a question about Excel VBA on an ACCESS forum? All VBA is not created equal! You should probably try a forum dedicated to MS Excel. Linq ;0)>

Wouldn't you need to move to a new Record...between DoCmd.RunCommand acCmdCopy and DoCmd.RunCommand acCmdPasteAppend or else you'd just copy the Record to that same Record? Linq ;0)>

I can't get a clear view of the image @ypma was kind enough to post...in case you can't, you go to Options - Current Database - and the actual name is Document Window Option. Set it to Overlapping Windows. Linq ;0)>

If txt_NewVolume is a string, i.e. "3" then it must be defined as Text...it needs to be defined or at least Formatted as a Number. Is txt_NewVolume bound to a Field in the underlying Table? Linq ;0)>

CRT...what's a CRT? :unsure: 😊:unsure: No, all screen types that I've come across, in the past 30 years, are capable of multiple resolutions. In point of fact, I believe (although I'm not really a hardware maven) that screen resolution is determined by your PC's graphics card. Try going to the...

You do know that you can adjust the screen resolution on your PC...right? That's what @theDBguy is talking about. Linq ;0)>

As a first attempt I would try setting Data Entry to No on the Subforms and simply go with the DoCmd.GoToRecord , , acNewRec in the Form_Load event. Linq ;0)>

Not in this case...as soon as you checked the box, you'd realize that you forgot to enter something...or had made a mistake that needed correcting! More importantly...you can't set AllowEdits to False for a Record you are currently entering data into...it would only take effect as you moved to...

If you want us to help you debug your code, for the print preview button...you have to show us the errant code! We're good...but not clairvoyant...well, except for MajP! Linq ;0)>

But what are they set on the Main Form? If the Main Form cannot be updated, the Subform, which is a Control on the Main Form, can't be updated. I'd check but I can't run the attachment...I only run v2007. Linq ;0)>

At the top of the code module for the Form...you could simply replace Option Compare Database with Option Compare Binary and all comparisons, for that Form, will automatically be case sensitive. Linq ;0)>

I go to Allen's site anytime I run into a new problem, and have done so for years...it simply can't be beat...but this particular solution is really very simple: In Form Design View: Hold down <Shift> and select each Control to be included Go to the Ribbon - Design Tab and click on Conditional...

Here's code to add to your Form to do this: Private Sub Notes_Exit(Cancel As Integer) With Me!Notes If Len(.Value) > 0 Then DoCmd.SetWarnings False .SelStart = 1 .SelLength = Len(.Value) DoCmd.RunCommand acCmdSpelling .SelLength = 0 DoCmd.SetWarnings True...