Search results

still the same issue with the dll.. bunch of thoughts running around my mind if a button is the best option or a combo box...

one thing to note is that it states there is abroken reference to the file acedao.dll when i open the file you attached. Looking at it now and trying to figure out if there is a way to put a requery in there once the button is deselected. This is quite interesting.. is this the preferred way...

no i had to actually add a 5 to it as none of my dummy records were setup with that value. Taking a look as we speak. I was looking at the other thread you referenced and wondering if the if statement is the way to go.

i could be doing this wrong as I am very fresh to this so please be gentle on me if I didnt do something right

while i get no error code i set the below code you provided for the on click however it does not filter anything.. no error is especially nice though.. resulting code for the list box is as follows Option Compare Database Option Explicit Private Function basOrderby(col As String, xorder As...

SELECT tblPrimaryData.Project_Name, tblPrimaryData.Project_Creator, tblPrimaryData.Project_Status FROM tblPrimaryData ORDER BY tblPrimaryData.Project_Name; this is what I have setup for the row source of the list box this is the vba that is setup rivate Function basOrderby(col As String...

I borrowed and modified this listbox to be able to view and select records and bring them up in the main form. However projects should be defined 1-5 5 being complete. I am trying to filter the listbox view of the 5s if there were any by a selection of a button so that when selected all 5s are...

ok i tried that and it came up with an error and self corrected through excel to (dont ask me what the difference is and why excel caught it as i dont see it :) ) =IF(G85="na",0,IF(G85<1,COUNT(G$78:G$91)-(RANK(G85,G$78:G$91)+COUNTIF(G$78:G85,G85))+2,"")) it seems to work now. I appreciate...

I know you can nest a limited number of if statements but not sure what i am missing to get this work. I am ranking items based on a list but want to omit that item from being ranked if another associated cell equals 100%. I hope this makes sense this formula works...

it looks like word doesnt work and allow for an easy format for users to edit. I have sense gone to excel and frozen the panels so that i get the policy number and column headings fixed as you scroll. It is much easier to have someone edit 115 lines in excel than 115 pages in word. Still...

ok, i just tried to export to excel and it doesnt come out like anything i expected. It is even missing data that is within the report itself. (and there are no subforms) I did run it within word and it preserves some of the formatting but it does not show blank fields or allow for easy...

That is exactly the idea i had. Some of the tables for the many reports are different but the table from which the main start date and end date are criteria against are within every report. I just did not know how to link a field to this criteria like i can do easily in excel when i write a...

Well my goal is to give an outside user access to put comments within the report/data next to the field. It is currently sorted by policy number and name insured. The rest of the data below it is about 20 fields of txt. If there is txt in one of those fields that i query i expect the outside...

wow, i appreciate the quick response. Looking at the code it kinda scares me away as there is a ton of it. Something i will have to go through and have to start learning to try to understand. I thought there might be an easy way to link an unbound item to a bound item. My goal was to have...

i think i follow what you are saying but let me see if this is along the same lines that i am thinking I ended up starting my reports today just running a query for the data i need and putting in a >= [start date] and <= [end date] in the date criteria field. Each time the report is run the...

I currently have about 20 fields on a report some with varying txt length so the box it is in changes size. Next to that column i have a set of unbound boxes for later use that are empty for user comments outside of the db. Is there a way to link an unbound field to a bound field so that when...

there is limited vba that runs the current forms but I have yet to use vba to do any sort of reporting. My goal is to just have a format where the reviewer can put comments in the report. These comments dont need to be saved to the db but are rather for the reviewers notes that can be saved...

can anyone point me in the right direction for producing multiple reports with a date variable?

I didnt get much of a response last time so i figured i will try to restate this. I have one main table with 20 other tables that are linked depending on a user selection. I will basically have 30+ reports one to two per table based on a user selection from the main table. ie who the data...

for a second date field to be driven off of another field would it be as simple as doing an or statement? taking each of the combo box items iff 1 or 2 or 3 then =NOW() ? Will that work to autopopulate another field in a form that is not viewable on the form? Also will that =Now()...