Search results

Hello, I have been driving myself insane for the better part of the day trying to manipulate this gantt chart. The conditional formatting is not cooperating as I would expect. I am determining calendar days by listing workdays * manpower and then eliminating weekends and holidays, That part is...

Time to waive my white flag and give it to the pros ;). I have a continuous form that I am trying to flag every project red that we are only working off a "Notice to Proceed" and the contract value exceeds $5000. [ContractStatus] should display with red text. I've highlighted the record which...

Good morning, I have been working to create a solution to get our payroll from our time keeping app, build a report to review, and prepare the data for upload to our payroll processing company. My specific questions today (or this moment): 1.) On the report when I replaced December dates...

Hello, I want to determine if Access can automate some of my Payroll woahs. So my example table is what pulls out of a timekeeping app. The first column is an employee ID; so we are looking at one person. The last two rows from 12/01 was originally one line that I have manually split into...

Hi All, I'm back for more advice. I've got my database up and running and it has been for a long time. Haven't made any recent changes to cause an error. Running split DB - back end lives on the server front ends (accde) live on users c drive. I am on Office 365 subscription on semi-annual...

I currently have an HR database which contains as you would imagine employee information. It also contains training records, and most recently I am adding wages and raise history. My questions are more related to the attached pdf. We use this excel sheet internally for payroll and we use...

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

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

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

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

Hello, I have this wonderful service oriented database and I want to include some statistical reporting. I have created a parameter qry that the user inserts the filter data on my form and the report generates. All of that is well and good. I attached a partial image where I have the report...

Hello, I am thumping my head looking at different methods of transferring data into my template file. This used to work perfectly prior to I believe it was moving from Access 2013 to 2016- so its been going on for sometime. I now have a subscription to 365 and am on semi-annual updates...

Hi, I am wondering if anyone knows if this is possible. A co-worker wants to be able to set a specific email address that will automatically insert attachments into the file folder on the server. We have a server onsite running windows active directory and use windows exchange for email...

I have a form called frmProposalDetails in which I can click a button and another form opens allowing me to pass the JobNumber on that form to another table called tblWOH. This allows us to add an approved job to be scheduled and so on. This has grown over time most recently adding send email...

Hello! I have the following code that sends info to a word document to create a label I would like the code to find and highlight text on the label. The first time I run the code it works fine. Any additional occurrences produces runtime error 462 breaking at Selection.HomeKey wdStory. I have...

This should be very simple and was working up until about a week ago. I have been searching all day for a resolution. I have unbound modal form that acts as my menu. It contains several buttons in which the user selects and another form opens. Simple right? For some reason all of the forms work...

Hi there, I am not sure if what I am attempting to do is even possible. Let me also preface this with: using a multi value field - I know, I know. When I started this DB it was a fabulous idea, now that the functionality has grown so much it makes it difficult. My field...

Happy Friday! I have been making minor improvements to my database and most recently I have added some code to make a file folder on the network with the click of a button. In order to take this procedure one step further I would like the code to then insert the hyperlink into the hyperlink...

This really isn't an Access question, but I have been searching off and on everywhere for a few weeks for a solution and am totally lost. You guys have always been a great well of knowledge and if anyone can point me in the correct direction it would be much appreciated. I have come to the...

Hi all, I recently updated one of our computers to Windows 10. Seems okay - I am not thrilled although I really haven't performed any real work on it. I am running Access 2013 on both machines and my computer is running Windows 7. While running Windows 7 everything is fine. In Windows 10 my...