Search results

  1. Samantha

    Report based on cross tab query

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

    Possible Automation

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

    Solved Trusted Location Error

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

    Best Approach

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

    Solved Lost on IsEmpty?

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

    Solved Combining Field Values

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

    Solved Microsoft Surface Pro X

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

    Solved Resolving Error 91

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

    Solved Statistical Reports

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

    Solved Transferring data to Excel Template

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

    Automation on Server

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

    If Then Statement or Dlookup?

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

    Run Time Error 462

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

    Split Form Open and SelectObject

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

    Using Split() with MultiValue Fields

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

    Update form field after MkDir

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

    Outlook GAL

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

    Command Buttons in Windows 10

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

    Excel 2013 Template Not Operational Since Upgrade

    Hi, Let me start by saying thank you for anyone reading in an attempt to help. I am by no means a pro at this, and have borrowed and changed all of the VBA in my DB. I have spent a few days searching for examples and clues as to what is going on and this is beyond me. I am running Windows 7...
  20. Samantha

    DoCmd.OpenForm

    Hi all, I am using 2013 and always learning. This should be really simple although all of the variations I have tried haven't worked out. I am sure it is something simple that I am overlooking. The following code is located on my form frmProposalLog which is a datasheet based on qryProposalLog...
Top Bottom