Search results

Hi Plog, Thanks for your help but I am a not clear on this. I have. DateDiff **** DiffDays: DateDiff("d",[InputDate],#2013-12-28#) should I be putting the #2013-12-28# in here. Mod **** Mod: 14 Mod [DiffDays] DateAdd **** DateAddDays: DateAdd("d",[Mod],[FKMDYDate]) I don't think I...

Hi, Can someone help me. In MsAccess 2007 I have a column with all the dates in order for 2014 I want a query to tell what is the first date and last date of that 2 week pay period. The 2 week pay period would start on Dec 28 2013 and be consistent for the whole year. Like this Date...

Hi Paul, I researched this function And this is what I found and needed. I had to do a lot of digging to find this so i thought I would reply back to this post so others can benefit. It appears that a lot of people are looking for this too. I made a little database for this. It is not my code...

Thanks Paul, I will have to research this function as I have never used it before and I am not sure how to do it. I will see if there is a example for using the Split() function. Thanks Bryan

Hi, Can someone help me. I have imported a lot of data from excel into a table. There is in one of the columns some multi concatenate info I want to separate in it's own individual row. I am not sure if there is a way to do this in a query or if there was an MsAccess2007 example somewhere. I...

Thanks for your comments. If that is the case, I know I do not have the knowledge to do this. Thanks BBryan

Hi, Wonder if someone can help. I want to open the dropdown box on my datasheet view subform from the main datasheet view form when I run over it with the mouse. From my main form textbox [WelderID] I tried this code but doesn't work. I get the error invalid reference to the property...

Thanks Bob that worked. BBryan

Hi, I am trying to call a command button on a form to click it from code. I have this but it is giving an error CallForms![Delete Data from Tables fm].BackUpDatabase_Click Run time error 424 Object required. My form is called Delete Data from Tables fm and the command button is called...

Thanks Guys I tried the Forms![CwbWelders fm]![CwbQualifications tbl Subform].Form.[Expiry Date] it still didn't work but I did get it to work in VBA Thanks a lot BBryan

Hi, I am having a problem with a condition format. I have a Main form [CwbWelders fm] and a Sub form [CwbQualifications tbl Subform] In the Main Form [CwbWelders fm] I have a field [Stamp]. In the [CwbQualifications tbl Subform] I have a field [Expiry Date]. I want to have a condition...

Hi Mihail, Thanks for that is helped me out.It is a very good reference sheet. Thanks BBryan

Hi, Can someone help me. I have a form with 3 levels. main - [Welders fm], 2nd level - [PipingQualificationTickets tbl Subform] 3rd level - [WelderWps fm] This is a pop up form but is related to the 2nd level formVBA Error I have a dropdown box [Wps] (3rd Level PopUp) with an after update...

Thanks very much for your help. That is what I was looking to do. I see I had to put And instead of Or Thanks BBryan

Thanks for your responce. What I want to do is. I have a table [Welder tbl] with a field called [QualificationView] and then I have a sub Table [PipingQualificationTickets tbl] which could have multiple qualifications. I have a field Called [TicketType], [SeeSupercededTicket] and...

Hi, Can Someone Please help. I am using Duane Hookom's Concatenate Module. I am using this right now in my query I have this Ticket(s): Concatenate("SELECT [TicketType] FROM [PipingQualificationTickets tbl] WHERE WelderID =" & [Welders tbl].[WelderID]) this work but it only Concatenates All...

Thanks For All your help.

Thanks Sorry But I might not be getting it. when you say The PK of the "from" parent and the PK of the "to" parent. Do you mean INSERT INTO [Itp Piping tbl] ([Item], [Description], [Sub Description], [InfoDescription], [2ndInfoDescription],[CodeSpec] , [WorkOrderID]) This should be the PK...

Hi Pat, I have this now in a query INSERT INTO [Itp Piping tbl] ([Item], [Description], [Sub Description], [InfoDescription], [2ndInfoDescription],[CodeSpec] , [WorkOrderID]) SELECT [Itp Piping Template tbl].Item, [Itp Piping Template tbl].Description, [Itp Piping Template tbl].[Sub...

Hi Pat thanks In your example I see - Forms!yourform!ToPK as ToPK does that mean I have make a relationship from my template Table [Itp Piping Template tbl] to the table [Itp Piping tbl] I want to insert into and use that ID. Right now I have the template not related to anything.the Key is...