Search results

Not sure if this method is going to work for the task I'm trying to accomplish so was going to get some input from the experts. Currently I have a table with all my information stored in it (tblOverall). Everytime the information has reached a certain level of completeness it is issued. When...

I have 2 subreports that are comparing information and I want it to flag the newest version if a change has been made. For example: 1st SubReport is record of 2009 Car Models Engine MPG Cost 2nd SubReport is record of 2010 Car Models Engine MPG Cost So lets say that in 2010 the cost and...

I've created a Report with two Subreports on it. The problem I'm having is that the report is only 4 pages, but it keeps repeating the same 4 pages until page 680. Any idea what is wrong?

I have a form that issues documents. I'm trying to get the form to add the RevNo to the field in the main table to show what Rev it's on. The main table has all the required information and it shows up filtered based on a project selected. Form: Issue document When document is issued Rev...

I'm having difficulties deciding on how to go about saving past information, but I believe an append query is the route to go. What I'm trying to do is once a project's information has been issued then the append query takes those line items from tbl1 and dumps them in tblRevA. So only the...

I'm trying to use the tool inside Access 07 to convdert my MDB file to a MDE file. The problem I'm having is once I open the MDE file none of the VBA works. So I can't get past the login screen without the code working. Any idea what could be wrong? Is there any typical errors that usually...

I have a report that pulls data in from a table and query. The query runs a product calc and what I'm trying to do is to put a function in VBA to show the product sum per group. The issue I'm having is that it finds the first groups answer and repeats it through the list of groups. For...

I'm trying to setup a Filter that once a project is selected it Filters all the items that don't associate with that project out of tables. So when the user pulls up reports and add items to these tables they can only view items with associated project number.

Have the following code and it seems to be giving me an error cboEquipmentName.RowSource = "SELECT ID, EquipmentName & ' ' & TagNumber" & _ " FROM " & TotalStr & _ " WHERE ProjID = " & StrProj & _ " ORDER BY EquipmentName;" cboEquipmentName.Requery TotalStr is a defined variable and so is...

I'm pulling fields in from a table and I'm checking to see if the item should be in the report. I've typed in the following code: IIf([InReport1]="Yes", [EmployeeName],) I want it to only pull in the "Yes" items and I don't want it to leave blanks in the place of the ones with no. The "Yes"...

I've typed some code in to have a VBS document find my database and then open it. Only problem I have is that when Access opens it isn't maximized. How would I maximize Access itself, not the db's opening form. Current code: dim accessApp set accessApp = createObject("Access.Application")...

I'm trying to code a combo box that based on a previous project selection the combo box will list items from that project. Form: The form allows the user to select a project number. Once this project number is selected I want the next combo box to pull info from that project's table...

I've developed a database that starts with a user login and then allows the user to select a project number. The project number is then used as an OpenArgs to concatenate with a string to form a table's name. I'm having a syntax error with the following code: Tables: OverallProjectReport-101...

I've developed a database that starts with a user login and then allows the user to select a project number. The project number is then used as an OpenArgs to concatenate with a string to form a table's name. I'm having a syntax error with the following code: Tables...

Trying to do the SumProduct in a Report. My question is how do you type it in VBA to work. I've got the following fields coming in XLift and Weight. If I check the box to allow Excel worksheet functions I've come to this: OverallWeight = Sum(Weight) 'Note I've got the total here already...

Is there a way to make the Page Header start on a certain page and go from that point forward? My Report Header is a bit long and goes into two pages and I want my Detail to come in at the middle of the page not my Page Header. So is there a way you can make it Report Header-Detail-Resume Page...

Curious what the coding would look like for an equivalent to the "match" function in Excel. I have a table for MaximumAllowableStresses for metals, and based on what the user selects as a metal and temperature it looks up both in a table and gets the value needed. The table for...

My problem is occuring due to the following: I have a form that the user inputs information into and clicks a button to save this data to a table. Then the user goes into another form that on load pulls some of the table information. The initial form value entered is based on a combo box...

Access 2007 I've searched several threads and I haven't come across one that deals exactly with what I'm seeking. I developed a database for multiple users to access. I've set up user login tables that keeps user/pass/accessLevel information. So based on who signs in depends on the user...

If you filter your table and you're pulling fields into your report based on information in the table how would you apply the filter in the report? Table has all data, but you filter it for example just use cars: Initially has all cars so when you open report it pulls in all info You only want...