Search results

Thanks Rich, I am sorry to say I don't understand what you mean. I have attempted to use the format function on the dates but still have no luck. Jeff

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

When I have done this in the past I have ended up with the folowing: 1. One backend database (you have this already) 2. One user Front End (you have this already) 3. An Admin database which runs the updates daily send the reports etc What you would do is create a new front end which I call the...

What I do to get around this problem is link to the company adress book, them compare the names, if the name doesn't exist I send the message to myself.

This might be a really stupid question but what do the $ mean I don't get understand the purpose of them. Thanks

ghudson First thanks for the reply! As for too many quotes that is what I thought, this is how I came up the number of quotes. 1. Copied the command line from a working batch file which I currently use to launch the database 2. Pasted that into a runapp step of a blank macro 3. I then...

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

By the way thanks for the reply I apperciate any help!

I found most of this on this site but I am trying to pass a password to the backend database. This way I can prevent people from using anything but my frontend to edit the data. Code: Function Relinktables() Dim dbs As DAO.Database Dim db As DAO.Database Dim tdfNew As DAO.TableDef Dim tdf As...

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.

Mile-O-Phile I have been able to remove the Bank Holidays parts of your code, but now I can't figure out what part to change in order to calculate a start date instead of end date? Example: I have product which takes 10 work days to build, I want it completed on 1/31/04 what day should I...

Mile-O-Phile Thanks for all the information, I just wasnt understanding what the purpose was now I understand it was to figure out British bank holidays, I was making more out it. I will try your suggestions and just work off of holiday table, I may have more questions tommorow if you don't...

Mile-O-Phile, I am sorry for such a basic question but I dont understand the parts about GetBankHoliday? I am trying to modify this to do the following, enter an End Date and number or work days to come up with Start Date, I have a table of holidays to be excluded. Any help would be...

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

FoFa Thanks for your reply.

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

You can call the macro something other than autoexec then edit the task to use a command line switch to run a macro. "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\yourdatabase.mdb" /wrkgrp "C:\program files\common files\system\system.mdw" /User Admin /pwd /x mrc939 mrc939 is...

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

No, here is my understanding (it may or may not be completely right) when your sending with CDO your not using an outlook type mail program so the exchange server can't authenticate based upon the "tags" outlook or other mail program adds to your messages. again this is only my understanding...

chewy, Most likely your problem is your exchange server is authenticating outbound mail, this setting which can be turned on and off in the exchange server. One way around it is to ask your exchange server admin to not authenticate mail from a particular email address.