Search results for query: *

I am trying to create a database that has a login form for users. I found some code that seems like it should work, but it's not working completely. The code is shown below. Everything seems to work except opening the password change form. The only things on the login form are a combobox...

Good Morning! Let me first explain how this database is set up before I get into what exactly I need help with. The company I work for has a report that is sent out weekly to the executives. Each department has a section in this report. Before this week, each department typed something in...

I have the following code: Sub test() Dim ws As Worksheet, wsSummary As Worksheet, lRow As Long, bCOPY As Boolean Set wsSummary = Sheets("Final") Application.ScreenUpdating = False For Each ws In Worksheets With ws Select Case .Name...

I have two tables. One is for jobs that require a boat to be down for repairs. The other is a list of Purchase Orders. I would like to be able to somehow select which purchase orders are associated with the job. The problem is, the purchase order list gets overwritten twice a week because it...

We have a grocery order that comes from our boats and when we receive it, it's in an excel file. However, everything is spread out in one single row. So you'll have what looks like below: Category Item Qty Price Notes Category Item Qty Price Notes Category Item Qty...

I am not the most proficient person in Access, but I can usually manage to work my way through it and learn as I go, but I am struggling with how to set up this database and any guidance or suggestions would be greatly appreciated. The database is for a tugboat company. First, before the year...

Good Morning! I have been given an Excel file that was already created from our safety department. It is going to be used for audits. There are multiple sheets in this file. The safety manager wants a button on the last sheet that the crew can click to "Finalize the Audit". He wants this...

I have a form that I created in Excel. I added a button to "Submit" the form. I would like this button to send the file as a PDF to a certain e-mail address. I tried to record a macro to do this, but it doesn't actually send the e-mail, only opens the e-mail with the attachment. This will be...

I have a form with order information and within that form there is a subform with order details. For each order, there may be several different items entered in the order details subform. These two things populate two separate tables. I have a query called order details extended that puts it...

I am fairly new to Access, especially Access 2007. I am creating a requisition database for a tugboat company to purchase equipment to repair the vessels. I have several tables, some for the employees, the approvers, the "Orders" and the "Order Details". One form that I have is called "Order...