Search results

Anyone know how I'd make a function automatically time out after a given interval, regardless if one of the tasks its running has finished yet? I know how to pull the time info from the Timer, but not how to use that information to time out the function. Thanks!

I've searched for this, but I must not have the right search terms. I am looking for a way to load the contents of a website as a string, into my VBA so I can parse it for the information I need. I have been using: Function getWebPage(strURL As String) As String Dim XML As MSXML2.XMLHTTP...

Ok, I'm a little concerned. Having somehow managed to type the only admin account password twice incorrectly (the same way) when changing my password, and being locked out, I searched for an MDW cracker. I found a handful of different programs that claimed they could tell you the passwords of...

In securing my database I had already disabled the shift key. When I go back and forth editing the front-end of the database, I frequently re-enable special Keys, etc to make things easier. When I'm done, I re-secure the file. Apparently the last time I did this I was a little trigger happy, and...

I have a user I have created. When they open a form, some code is executed. If IsNull(DLookup("[lastrun]", "_sysinfo", "ID=1")) then DO STUFF end if For some reason I always get an error, "You do not have the necissary permissions to use PATHTOMYDB Object" The user has Open/execute...

I'm trying to use the below code for several forms to reference the data on the forms subform. However, it doesn't seem to like Set rst = ctl.RecordsetClone I'm sure it has something to do with the syntax. How should I be referencing this data? Thanks...

How do you create dividers in the menu's you create, dividing the menu choices into "Groups"? Most standard menu's have them (lines seperating two different groups). I've searched the VBA help files, and this forum, but can't seem to find any reference to them. I'm probably just searching by...

I know this is likely a simple question, I just can't seem to come up with the right search terms to find my answer. I have a custom temporary menu that I am creating in VBA, and suppressing all the traditional menu's. I would like to be able to have a menu choice that will let you go to forms...

Is there an array of all the comboboxes on a form, or any other means to cycle through all the comboboxes on that form without using the names of the comboboxes? I'm trying to create a function that can be used by several different forms that would cycle through all the combo boxes and run a...

Okay, I'm new to this and about to go crazy. Whats wrong with the code below? Function addDays(employID As Long, daType As String, daEXPDATE As Date, daREMARKS As String) Dim daNOW As Date Dim daDAYS As Double Dim daSEARCH As String Dim rst As Recordset...

I've got a table that I've run a query on to get a recordset of. Of these values I want to find values that match a certain criteria, and then return the value in a cell of that record. VBA doesn't seem to like my syntax. Is there an easy way to do this. (Code is below) Thanks for your help...

I've been programming in VBA in Excel for awhile, but am new to Access. Is there a way to run a SQL Query and store the values into an array for further manipulation through VBA? (I don't really want the query output to the screen). Thanks!! Query I'd like to run: SELECT accrualofdaysLOG.id...

I've got two tables employees accrualofdaysLOG I'd like to set it so employees.personal for each employee equals the sum of all entries in accrualofdaysLOG where the accrualofdaysLOG.type = "p" for that employee. Any ideas on how to do this? Thanks! Tables are structured as follows: employees...