Search results

I am using this piece of code which I found on the forum well for US dates it works correctly however with european dates it does not. [/code] Function Work_Days(BegDate As Variant, enddate As Variant) As Integer Dim WholeWeeks As Variant Dim DateCnt As Variant Dim EndDays As Integer Dim...

Hi I am try to get a call shell statment set up but I can't seem to get it right. Here is what I have attempted: [/CODE]Private Sub Command0_Click() Dim CComp As New CComputer Dim straccessdir As String Dim fullpath As String Dim Test As String Dim DPath As String Dim...

Why am I getting question marks in the linked table manager? When I manually link tables the show as icons, when I use code the show up as question marks.

I have a database file which is accessed by about 34 people on a daily bases. Then each day automatic updates are also made. Upon compacting the database it will shrink from 18-19 meg to about 10-11, then it grows at about .5 mb a day until the 18 or 19 mb range then seems to stop growing...

I am a little confused as to what the “best practice” is for archiving records, the way I see it there are two options: A. Two tables one for active and one for archived records B. One table with yes/no field to indicate if its archived or active I choose to use two tables and I am not sure if...

Most likely a simple question: How do make a query to find unmatched records, then delete the unmatched records. I can find the unmatched records but then using the criteria for the delete query is not working at all. I am just stumped. Here is what I have for a criteria In (SELECT...

I have a FE BE database on a network the problem is if the network drops someones connection I get a corrupt BE, is it possible to monitor a network connection and close if one is lost? Jeff

Simple Question: Should both the backend tables and the FE use the same MDW file? I have currently have a database with about 35 users, max of 10 concurrent, I am creating a new front end with added security, so I have created a new workgroup information file. I tested the new FE, with a...

Not sure if this even makes sense: I would like to use a form to hold the values of some variables, so that if thing change (ie name of the mail server), they could just be updated on the form. I can't figure out how to get a text box to hold the value, once I close it's gone. Most likely I...

I have several forms which have command buttons with event procedures for the Double Click event. What I have found is if I click to many times I can cause errors. After a double click is it possible to deactivate the button so you couldn't acciendtly cause it to run the event again?

I have done some searching on this topic without much success, maybe I am missing something. I would like to check the version of the FE against a copy of the FE on the server, and if needed make an update. I dont really understand how to go about doing this. Does anyone have a sample? Thanks...

I currently have a macro which is run nightly via a windows scheduled task, the macro imports a couple of text files and makes various updates based upon the new text files. Currently the macro contains about 53 steps, most of which are running action queries. I would like to convert the macro...

I currently have a macro which is run nightly via a windows scheduled task, the macro imports a couple of text files and makes various updates based upon the new text files. Currently the macro contains about 53 steps, most of which are running action queries. I would like to convert the macro...

Mile-O-Phile I downloaded your sample, and did get an error. The form opens fine in Design view, however as soon I switch to form view access closes with errors. Thanks for the sample

If a command button is set “visible = no” could the user in theory find the button and press it and have it work carry out it function as if it was visible? I think the answer is no they can't but I am convinced. What I am trying to do is control access to various forms based on usernames

I have the following code to determine if a button is visible: Private Sub Form_Open(Cancel As Integer) If fOSUserName() = "username" Then Me.testdee.Visible = True Else Me.testdee.Visible = False End If End Sub I have a table of users with yes/no check boxes for various buttons, I would like...

Thanks First I would like to say thanks to all the members of this forum, I have been browsing for about two months and the knowledge I have gained is really remarkable. So far I have been able to find answers to most of my questions just by searching, but I have a question, which I am unsure...