Search results

  1. M

    Connect MS Access 'front end' to online database. possible? or, best alternative?

    Thank you Nidge and Paul. Nidge, I am blank in this subject (yet). Can you please explain to me some dumb questions, so I will know what to do in the next step? like... Do I need to buy a program to be able to create/convert ASP items? Is the Front End and/or Back End an ASP item, or is ASP...
  2. M

    Connect MS Access 'front end' to online database. possible? or, best alternative?

    (There are no satisfying results on a Google search for this subject) SINCE I'M GOOD IN MS ACCESS VBA, WHAT WOULD BE MY BEST OPTION FOR THE FOLLOWING CIRCUMSTANCES? I know VBA quite well, and I want to create a database to be used by users worldwide, and hope to grow to thousand's of users...
  3. M

    .OCX (ActiveX) editor?

    I got an ocx file to use. I want to see the content to understand better how to work with it, and maybe make some changes too. So, what can I do to be able to see the code within the ocx file?
  4. M

    Simple function to Check if date is DST (Daylight Saving Time)

    Yeah. As long I glanced - but not examined - Lagbolt's code, mine 'looked' to 'me' simpler. I'm actually changing my code to his. Admit. :o
  5. M

    Simple function to Check if date is DST (Daylight Saving Time)

    Correct, much shorter. (Hmm.. but not 'simpler' though.. :mad: (there is no option of 'stubborn' face. lol.) )
  6. M

    Simple function to Check if date is DST (Daylight Saving Time)

    Here is code to check any given date if it is within the DST (Daylight Saving Time) period or not. It returns True for "Daylight Saving Time", and False for "Standard Time" (non DST). It is based on the DST rules of USA. If you don't know how to change it to your country rules, you can reply...
  7. M

    Link to search this site on google.com

    Right, but... In that sticky thread, there are only advises of how to MANUALLY enter the words "site:access-programmers.co.uk/forums" on the Google page. there is no straight link that does it AUTOMATICALLY. the link I provided brings you automatically there. all you have to do is, type your...
  8. M

    Using Google to Search the Forum

    To get better results when searching this site, use the link below to open a Google page that is ready to search your term exclusively at "http://www.access-programmers.co.uk/forums". Just click the link below and start typing your search term...
  9. M

    Link to search this site on google.com

    To get better results when searching this site, use the link below to open a Google page that is ready to search your term exclusively at "http://www.access-programmers.co.uk/forums". Just click the link below and start typing your search term...
  10. M

    How do I prevent moving text from blinking? (Timer interval = 10)

    I guess I have to give up on having smooth moving text. I'll either set the interval to a couple of hundreds or alternate my design ideas. I attached here an .mdb (2000) example of how it would look in intervals 10, 20, 50, 100, 500 and 1000, where you can see that '10' is the smoothest but...
  11. M

    How do I prevent moving text from blinking? (Timer interval = 10)

    The purpose is to have notification textboxes moving up. Let's say showtimes. "Showtimes start at 10:00 10:30 11:10 11:50 12:25 1:00" etc. I'm planning to use code to also make the upcoming showtime textbox should start blinking 15 minutes prior to the show start time. Edit: If I set the...
  12. M

    How do I prevent moving text from blinking? (Timer interval = 10)

    Repaint just slows down the process, DoEvents appears to not do any change. Attached is a short video where you can see the moving text is flickering. Timer interval = 10. Form_OnTimer = Private Sub Form_Timer() If Label2.Top < 100 Then Me!Label2.Top = 10000 End If Me!Label2.Top =...
  13. M

    How do I prevent moving text from blinking? (Timer interval = 10)

    I have labels moving up in my project set by the forms' "On Timer" event. When I set the "Timer Interval" to "10", the moving text is slightly blinking (like if it didn't have enough time to set itself before preparing to go to next position). What do I have to do? Do I need a quicker monitor...
  14. M

    Moving from one Form to the Next. please help

    Can you send the file or creare a sample of it and send it. But I'll be able to try it out not before Monday.
  15. M

    preventing duplicate records where two field are the same

    Can you send the file or create a sample of it and send it?
  16. M

    Update Query

    Works perfect for me... :confused: Maybe information in: TBL_VINList_Main.MAI_PK_Number don't match information in: TBL_Temp_Import.F2 ?
  17. M

    Update Query

    Explain the problem give an example scenario
  18. M

    preventing duplicate records where two field are the same

    Put the following into the BeforeUpdate: Dim lngCount As Long Dim strCriteria As String strCriteria = "[Nom]" = True strCriteria = strCriteria & " AND [ID] = " & Me.[ID] lngCount = DCount("*", "XXX", strCriteria) If lngCount >0 Then Cancel = True End If
  19. M

    Moving from one Form to the Next. please help

    1. You did not define the content of the 'stLinkCriteria' variable. 2. you should declare it before closing the first form (DoCmd.Close).
  20. M

    Why doesn't .GetFocus get the message?

    Re: Why doesn't .SetFocus get the message? I got a way to workaround. I added "KeyCode = 0" to the code, so the focus is not going out of the control. I would like though if somebody could explain to me the reason why the 'enter' button (13) doesn't follow a SetFocus command. Here is the code...
Back
Top Bottom