Search results

Turns out I had "" around my field names like this !["ExpectedContactDate"] = DateAdd("d", 7, Me.StartDate) So the only thing that remains is the period. The first one is easy because it is simply a 0 (zero) records 2 through 7 are the numbers 1 through 6 I am going to look at this in the...

I placed this code where you suggested. I had to make one minor change in two places, Below is a section of the code where I made the changes and where there seems to be a problem. With rst_output ' add first followup 7 days after the create date rst_output.AddNew ![ExpectedContactDate] =...

Yes Each record added needs to have .. One week added to the StartDate on the first record And each consecutive record added needs 1 month added totalling 7 records and 6 months In addition each record added has a different StaffCode and a Different Period

So I have been hard at work. I am taking this a step at a time and have code that successfully creates seven new records in tbl_FollowUp. It also populates the fields I need populated. Dim i As Integer Dim db As Database Dim rs As Recordset Set db = CurrentDb Set rs =...

So I have been hard at work. I am taking this a step at a time and have code that successfully creates seven new records in tbl_FollowUp. It also populates the fields I need populated. Dim i As Integer Dim db As Database Dim rs As Recordset Set db = CurrentDb Set rs =...

I have a question or two. I just spent several hours researching this and watching some amazing tutorial videos. When working with AddNew I understand how to add a new record within a recordset and assign values to fields. My first question is can I pull the field values from an open form I...

I did. As I mentioned I have no idea how to do that hence the reason I asked for some reading material.

Thank you. This db was a split database but I joined it for simplicity. It is also locked down somewhat so I created an admin user called papa smurf with the password of password Using Shift double click will bypass startup options in this version

I would prefer to use code. I simply have no idea where to begin. Can someone sugesst a resource where I can read up on this. Again many thanks

I have read a number of posts regarding this and most people suggest that this is a bad idea. Having said that I can not think of another way to do what I need done. I will explain this as best I can but please bare with me as I am still learning this stuff. The purpose of the DB is to track...

I'm sorry I wasn't clear. I have not actually implemented any code yet. I was simply testing what Pat provided to see if it would work for me. That is when I discovered that it did not seem to work as I thought it would. My understanding is that given a startdade of say Sep 12, 2013 and the...

On the Business Days tab I am using the function that is on the bottom

Thankyou for this. However I do not have a clue on how to account for the holidays in this example. It seems I have one that does holidays and another that does weekends with no idea how to merge them

I am trying to find a simple way to determine the work date based on knowing the Start date and how many days ahead I want the date for. These means I need to exclude weekends and holidays. I tried Pat Hartmans solution located at...

Hi I downloaded this and attempted to use the Business Date + Days = Next Business Date and it seems that it is out by one day for every weekend. Does anyone else encounter this and does anyone know of a fix.

THANKYOU I have some code that runs on the onOpen event. This same code was also on the onLoad, onCurrent and onActivate. This was the problem as one of these was trying to reference frm_LogonStorage after it had been closed. Problem Solved

Thanks I will try this. The weird thing is this only happens if I open the db with Access 2010. In access 2003 it works perfectly.

I am afraid this did exactly the same thing. And unfortunately I am not able to debug the code because the database does actually closed.

Ok this is just bizarre. I have a database that I created in Access 2003 some time ago. I have ported everything to Access 2010. I started by importing everything in both the front end and back end into clean new .mdb files. I then had to make a few adjustments to to startup issues and custom...

So I have read a lot on this subject and I seem to be getting nowhere. Here is the senario. There are two forms and a subform invoved. pfrm_AddClientNote has an embedded subform called sfrm_ClientBillableActivityFromCN. There is another popup form called pfrm_AddClientBillableActivityFromCN...