Search results

Thank you Arnel, much appreciated. I went from #Type! error to a #Name! error which ended up being me naming the module the same name as the function which now I learned you cannot do that. Once I ironed that out works beautifully. Pat, I will need more time to dive in and understand what...

Thanks Pat I will check that out too.

Arnel, sorry to revive this old post. I was trying to follow your example for my project and was hoping you may be able to tell me what I am doing wrong. I've got it calculating correctly for anyone with a [StartingDate] and [EndDate] however anyone who has no [EndDate] (so current employees)...

Hi Pat, Thanks for your response. Not exactly sure what your referencing, nevertheless... I did try building IfThen using both of your suggestions today and it is still not exiting like I would expect - not that I know much. If Me.JobStatus & "" = "" If Len(Me.JobStatus) = 0 I just need to...

It's numeric. I've resolved by sandwiching my if then around my preexisting code. So if value is between 1-4 then code will run and else msgbox. Probably not the most efficient way to go however it works. Its apparent I need to go back and re-read my Wrox VBA book and search for some...

I've looked as so many examples that I have tried to follow.. and have thoroughly confused myself. I declared that as a Boolean. Deleted that and went back to: If IsNull(JobStatus) Then MsgBox "This job needs to be added to WOH prior to generating a project sheet.", vbOKOnly, "Error" GoTo...

I did also attempt IsNull and it is giving me the message box regardless if there is a value in JobStatus or not.

Hello! I am stumped here. I am trying to incorporate the following code attached to a button merging information into Excel. JobStatus is a field on my form that would have a value between 1-4 if the PK is on the table at all. The form is based on a query tying my main table tblProposals...

Neither Pat, tblWOH holds my PK along with job status, and a few yes/no columns, and the two currency fields. My form fills based on a qry that filters based on job status. These currency fields change constantly based on the project managers estimation of what is left to be completed...

Hi Mark, Thanks for your detailed explanation. I will have to put some thought into how to modify things. Although these number are only temporary in nature - I'm not recalling any of this information at any point in the future. So, I am not sure it would be worth my time to redevelop. As...

Pat so what is wrong with my structure? My first field is this years work load and my second is next years contracted work load. Once a year when we get to Jan 1 - I want to push a button and magically move all my totals to the current year.

No worries - I appreciate the help. Here's what I came up with very basic - and it works however only for the record that has focus. How would I get this completed for all records? My thought goes to loop which is what scared me off to begin with. Private Sub cmdCombineValues_Click() Response...

Makes complete sense - sometimes I overthink and make it way more complicated in my head.

Can someone please point me in the right direction?! I can't even begin to wrap my head around how to do this. I have a continuous form called frmWOH; on the form the two fields I want to manipulate are ScheduledValue and ScheduledRemainingValue2. Both of these are currency fields. I'd like...

Gasman- I just saw a review where someone was complaining about not being able to install 32 bit on it. They didn't specify what program they were using. It just got my radar up but I found this article Windows 10 ARM-based PCs FAQ (microsoft.com) so I am thinking that they were mistaken. And...

Can anyone speak to installing Access 32 bit onto a Surface Pro X? Specifically if it is possible. I've read some reviews stating it was not possible/and other contradicting that point. Thanks in Advance, Samantha

Sorry for the delay in getting back to this- how I would love it to be my first priority! ActiveWorkbook returns as nothing and I double checked that excel references are selected. I incorporated Arnelgp's suggested code and so far so good. Thank you!

Well, in either condition if I comment that line out or set it to False it saves it to the file in a locked condition that I can only open in read only. Additionally it will not let me delete the file from the network at all. I will have to look more into your other suggestions next week. I...

Hi Arnel, Yes, I am creating the object and saving it to the file location however when the file folder is open and the preview pane is activated it is failing to save and giving me the error 91. I am looking for a way to use vba and either make the network file close completely before...

Hello, I am looking for help in resolving error 91. In my DB I am creating an Excel file generated from a template then I am saving it to the network. I am getting the error on this line ActiveWorkbook.SaveAs strFileNamePath and have found the cause to be created by having the preview pane...