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

It was the improper filtering. Thanks for pointing me in the right direction.

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

yah it's location was set to trusted. the error occured due to something in decompiling and then recompiling the code. once that was done the code started working again.

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

ProductSum isn't a function that you can select so can't place that in there. I found a way around the problem, which probably isn't the best way but it works.

Is there a way to code in the report's module to allow for the same summing/count/etc in the group footer? It seems that when you go to the report's module it takes the first group's calculation and just places it into all of the next groups. I'm going over the limit when I try to use the...

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

How system is supossed to work: 1. User logs in 2. User selects a project which to work on (once project selected add filter) 3. User add items to table or views reports needed. 4. User can change project at anytime. (Re-Filter if project changed) All tables/reports/forms have been completed...

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.

That did it. Thanks a bunch.

cboEquipmentName.RowSource = "SELECT ID, EquipmentName & ' ' & TagNumber" & _ " FROM " & TotalStr & _ " WHERE ProjID = " & StrProj & _ " ORDER BY EquipmentName;" cboEquipmentName.Requery The ' ' is a empty space between the fields EquipmentName and TagNumber. I think the error is coming from...

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

More Information: Table is used as RecordSource already predetermined on Load via VBA. Below is what is happening: Jim Bowie Clerk Laura Sands Clerk Joe Brown Sacker Jimmy Owens Carts When I type in the code on which to include in report one I get (Blank) (Blank) Jim Bowie Clerk Laura...

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

Yah just went ahead and made a hyperlink at the moment. Was trying to figure out some stuff because in near future probably going to write .bat file that finds the .mde file on the network copies it and pastes it to the users hard drive (if it exists it paste it over). This way I can just dump...

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