Search results

I have a field in a table that represents a bin location for inventory items. Within this string of characters are 2 digits that represent a product code. The product code will group similar products like screws, paint, aluminum, etc. I would like to create a parameter query to be able to enter...

I'm having a little trouble knowing what to search for to find an answer, so I'm hoping someone here will be able to help. For a novice like myself, it is difficult, but for the experienced, this should be a piece of cake. On a report I have the following code to concatenate two fields...

I'm trying to create a form in datasheet view that can also show data in another table. View the link to see a screen capture of the table and you will see what I would like the form to look like. Also I have attached the image. http://screencast.com/t/qxRvLNPd47Hd This is a table view which...

I have a form that has a subform that is NOT visible. I would like for the subform to be visible when the carrier is set to UPS Small Package, but I cannot get it to work. Attached is a screenshot of the macro and form design. There is also a link to the screenshot just in case the images...

I have a report in Access 2010 that totals the amount of transactions that each department has spent and it appears in the summary footer. What I would like to show as well is the remaining amount of the department's budget and if there is not any funds left, to show a statement that there is...

I created a database on my personal laptop that has Access 2010. There are several reports that are generated via a parameter query and with the use of macros, they are then emailed in PDF format when I click a button on the main form I use. However, the version of Access I have at work is 2003...

I would like to add the day of the week and date to the subject/body of an email being sent when a command button is clicked on a form in Access 2010. How is this accomplished? Attached is a screenshot of the macro. I converted the macro to VBA, but until I become better familiar with VBA...

Hi, First off I want to admit that I'm a student and also an aspiring database developer, but still in the beginning stages. So the help I'm requesting is a combination of a project to help me do my job more efficiently and with the bonus of gaining more knowledge of how a database works...

Below is a formula as I have it in Excel that I'm trying to move to Access and looking for a little assistance. DENSITY =(weight/((length*width*height)/1728)) Excel Formula CLASS =VLOOKUP(Density,Class!$A$3:$C$10,3) Excel Formula for class 125 (lookup from the table...