Search results

vbaInet, I think that I am in over my head. I am not sure what you mean. I am trying to use the query to pull back 5 days worth of information in a report using the DateofOrder field. So lets say the user enters last Friday 6/11/2010 I need the query to pull all the records from Monday...

If the user entered a non-Friday date then they would get the last five days of orders. So the user will need to make sure they enter the correct date for Friday.

I have tried this and had no luck Between [Orders]![DateofOrder] And DateAdd("d",5,[Orders]![DateofOrder])

I have a Form named Orders that has the fields OrderNumber, DateofOrder, and Price. I am trying to create a query that will give me the data for Monday through Friday if the user enters Friday's date when they run the query. I am not sure what I need to enter in the Query Criteria for...

Well after trying different things I found out what I needed. Here is the solution. Private Sub Number_BeforeUpdate(Cancel As Integer) If Len(Me.Date_of_Work & "") = 0 And Weekday(Date) > 2 And Weekday(Date) < 7 Then Me.Date_of_Work = Date - 1 ElseIf Weekday(Date) = 2 Then...

DCrake, I think your idea will provide the solution that I am looking for. Here is what I have. I am not sure how to do the lookup on the alternative date where the holiday date = the revised date as you stated. I have bolded my failed attempt in the code below. Any thoughts? Private...

Missingling, Thanks for your help. I think I will take some time and see if I can rethink this.

I agree and updating them after they are stored would be my preference, but since the dates are being used by the users of the form they have to reflect the correct date on the fly.

I know this is a unusual request. The reason the date is being changed to the previous work date is that the database is being used to check the work completed on the previous work day.

missinglinq, Wow thank you. I did not know that about the field name Number so that is good to know. I will rename it to a different name. One last question....How would I get the code below to account for any holidays that fall on a weekday? So lets say for example that it is Monday and...

So in other words I am looking for the workday (assuming the workweek is Monday through Friday)

Here is what I have done to get it to work. Private Sub Form_BeforeUpdate(Cancel As Integer) If Len(Me.Today & "") = 0 Then Me.Today = Date End If End Sub How can I change the code above to get it to display yesterday's date when the current date is a Tuesday-Friday and Friday's date when...

I am still learning Access and need some help. My table has a field named Today and Number. I need the Today field to automatically enter the current date when the Number field is changed. I believe I need to use =Date() to accomplish this but not sure where to put it. Any help would be...

Well I am very confused....I added the debug.print rst.RecordCount right before the line where I closed rst and now it is returning 3000 records as it should. Just to test I commented out the debug.print rst.RecordCount and ran the code again and it is still doing 3000 records. Do I need to...

I have a Module titled Random that is suppose to randomly select 3000 records from a table. The problem I am running into is that as the Names table has higher number of records in it...there are more records selected. For example if there are 100,000 records in the Names table the code will...

Here is what I have so far. The command button Private Sub SendWelcomeLetter_Click() MergeIt End Sub Function MergeIt() Dim objWord As Word.Document Set objWord = GetObject("E:\Customers.doc", "Word.Document") ' Make Word visible. objWord.Application.Visible = True ' Set the...

I am not sure where to begin to make this work and any help would be greatly appreciated. I have a access table name Customers. The table has 4 fields customer number, name, address, and phone number. I have a letter in microsoft word titled Welcome Letter that I would like to be filled in...

Sounds to me like I need to talk with the Admin before going any further. Thanks to everyone for the great responses.

Where would VB runtime DLLs be stored on the computer? I can check and see if they are installed since it is a custom build. I do know that the some users have MS Office XP Professional which includes Access but then their are some users that have MS Office Standard installed with no Access...

I have created a MS Access Database and then found out that the users that need to enter and edit information in the database do not have MS Access installed on their computers due to licensing issues. I was going to use the Access runtime and change the database from MDB to MDE but I found out...