Search results

These are returning an "Overflow" error. Num1 = 54635133914# MOD 181440 Num1 = CDbl(54635133914) MOD CDbl(181440) Is there a certain limit for the MOD operator?

How can I detect through VBA which calender the operating system is currently using? e.g. Julian/Gregorian.

A quick question. Which of these 2 functions should I use - which one will use less CPU etc? I want to return "1" for every 3,6,8,11,14,17 or 19th of every 19 numbers, and a "0" for the others. IF(MOD(MOD(MOD(MOD(MOD(MOD(MOD(<Number>,19),17),14),11),8),6),3)=0,1,0)...

(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...

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?

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...

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...

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...

Why doesn't .SetFocus get the message? Can anybody tell me why .SetFocus does not work in this code in a continuous form? Private Sub ConnectIdentify_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode = 13 Then Dim strFilter$ strFilter = Screen.ActiveControl.Name &...

When navigating to a webpage from VBA, How do I click "Ok" on the website's OnLoad Alert box?

How do I use code to fill in web pages? Lets take Google for example. I want to: 1. Open Internet Explorer AND navigate to "http://www.google.com/". 2. Press the "Sign in" button 3. Fill the "Email" and "Password" input boxes with "string" 4. Press the "Sign in" button Help please?

Hi all, I have a table of students and their parents information. Example: ChildFirstName,_ ParentID,_ ParentFirstName,_ ParentLastName. Child1___________ 1_________ ParentF1_________ ParentL1 Child2___________ 2_________ ParentF2_________ ParentL2 Child3___________ 3_________...

What's the best way to learn VBA Access for free? I have no patience to sit by courses and listening to all things I know but the dummies in the class don't. I'm looking for a website (hmm.. and free..) that is well organized and mainly it should be both "to-the-point" AND well-explained. On...

Problem changing from acViewReport to acViewPreview Hi there, I open my report with a filter with following code: DoCmd.OpenReport "MyReport", acViewReport, , MyFilter On the report I have a button to open the same report in Print Preview view, with following code: DoCmd.OpenReport...

I have 2 Fields: 1. [Message] 2. [Result] I want to see in [Result] the result of the text in [Message]. Text in [Message] is "Application.Printer.DeviceName" (w/o Quotes). Double Click VBA for [Message] is: Private Sub Message_DblClick(Cancel As Integer) Result = [Message] End Sub I expect...

When user confirms his newly created records in a SubForm, I want all the Controls in the Subform to get "Transparent Background" and their 'Font' to be 'Bold'. Will I have to write code for every single Control, or there is a way to apply a property to ALL Controls in SubForm?

I want my database user to enter a record thru a wizard. in step 1 he should put in the product info, in step 2 - price info, in step 3 he confirms the new record to be created. What's the best approach to enter 1 record through many steps?

I am working on a "Toners Bought and Sold" database with a "Box" field keeping track if the toner was bought either normally packaged ('Closed' box), in an open box ('Open' box) or without a box ('No' box). I have 3 BMP files saved on my computer, 1- a closed box, 2- an open box, 3- a big X...

Can anybody please help me? In MS Access, I'm trying to open IE, navigate to Google.com and set my text in the text box. I don't know why it's not going. I used: --- Function OpenIE() Dim ie As Object Set ie = CreateObject("internetexplorer.application") ie.Visible = True ie.Navigate...

If I select MessageBox in a Macro, I only get a single "Ok" button in the Message Box. How can I get a Yes/No Message Box by using MACRO (not VBA)?