Search results

This is an old thread but I just had the same problem. All the settings were as expected to make this work. The trick was to shorten the height of the main form where the subform was embedded (or use the vertical scroll bar on the main form to scroll down even though the entire subform was...

Re: Security Challenge #2 Thank you Ridders! These exercises taught me about things I never thought to look for. I am going to give one spoiler: Don't over think it; pay attention to what is in front of you.

Have you tried a lower resolution setting on your display? Since we're stuck with a single pixel border, it may help to use bigger pixels. I think you're asking for a way to adjust the double arrow sensitivity to click and drag a form window; if that is the case I believe you're at the mercy...

You posted the same question here at the end of business (US Eastern) yesterday here https://www.access-programmers.co.uk/forums/showthread.php?t=300839 Then posted this at 10 AM (US Eastern) which is basically the beginning of the day. You may consider giving your question some time to get a...

I'm beginning to wonder if I've done too much already. Look at the design view and make the changes you need for selection criteria. Pay attention to the bottom section that builds your WHERE clause and you will have an answer to your question about >=10 on the count column.

I searched "Use VBA to combine PDF Files" on Google and found this: https://stackoverflow.com/questions/29504053/open-and-merge-multiple-pdf-files-using-vba Which led to this: https://groups.google.com/forum/#!topic/adobe.acrobat.windows/GC2vVVPvUOk It appears that the second link has what you...

Pretty much every PSU I've seen on a desktop has the voltage switch. It's easier to put the switch in the PSU than it is to worry about which market it will be used in.

Have you tried the properties form, entering manual Height and Width? Or a new mouse?

I've attached a copy of your database example with the queries built to do what you describe (or at least how I interpret your description). Objective 1: List count of classes for students who have completed 10 courses without failing the course excluding classes in progress...

Use Zero or -1 and filter those out of the selection criteria. I think the -1 value would be good only if it is used as an indicator to exclude the record(s) while allowing a 0 to be used in an average calculation. It would really help to have copies of your tables and some fictitious sample...

I created a table to emulate what you describe then queried it the best I can based on your criteria. I eliminated the specific student data as you can do this with a simple join in design mode. The Courses table looks like this: (Quick and dirty) StudentID Integer, indexed CourseName...

I think Ridders answer is the better one but this addresses the exact question: Private Sub Command0_Click() Dim datDueDate As Date Dim datPlusSix As Date Dim strMessage As String datDueDate = #12/5/2018# 'Use your date field here datPlusSix = DateAdd("m", 6...

I have Access 2000 running on Win10. The issues I've run into so far deal with references while upgrading to O365.

https://www.access-programmers.co.uk/forums/showthread.php?t=262042 Try the code included in the post above unless you need to interact with the email. Then try this: Public Sub CreateEmail(lFormat As Long, toEmail As String, Subject As String, body As String, Optional bSend As Boolean =...

I wanted to offer an odd situation and resolution for an example on this. 1. The database started as Access 2000 and compiled / made MDE with no problems. 2. Trying to convert to 2003-2007 had ambiguous errors. (There is no Object in this control) 3. Trying to convert to 2010-2016 had ambiguous...

To all that helped: Thank you! Part of what I have been tasked with includes upgrading from V2000 to O365 and to use runtimes instead of native Access on the clients. I didn't think managing this with the current method would work in an ACCDE but was willing to be taught a new trick. I will...

:banghead: I have inherited an Access 2000 database that has a routine to change the ODBC connection from the live tables to development copies. When triggering this, the user is prompted to save the changes to the module. I have not been able to find a solution to save this change through...

Other than some minor issues with DVD playback, I haven't had a problem with Win10. The first order of business was to follow the tutorials on how to stop Win10 from spying on you, then Cortana went away. I have heard more complaints from users with the home version instead of the...

I think your issue is with the formatting as a percent. Have you tried using decimals? Your basic evaluation appears to be: If nfld = 0 then 'do this ElseIf nfld > nTier6 'do this instead ElseIf nfld < nTier6 'figure out what tier it belongs to End If Instead of looking for...

Search for FileSystemObject in this forum for help, there are many posts on the subject. When using FileSystemObject, you are actually using VBA to call VBScript code. Start with: Dim fso 'I don't declare the type, this may not be the best practice. Set fso =...