Search results for query: *

I've read quite a few and of course none that will help me :( I used http://www.lebans.com/reporttopdf.htm and it works the way it's designed. I don't know enough to incorporate it with what I have. Is there a way to incorporate this with the SendObject? None of the options in the default...

I tried searching to see if i can find something first but did not find anything ... I have a query that looks for the last date for an order number. But if the order number only exists once it doesn't show. It only shows the DMAX date IF the order number exists more then once. How or what...

I have this ... Private Sub Form_Activate() On Error GoTo Err_Form_Activate Me.Requery If IsLoaded("Customers") Then If Forms![Customers]!

I need a little help (maybe a lot J) … I am stuck with this statement. This is in an update query Two linked tables by the ProductLine "MonthNo" field in table MP2_ProjDemandMonths (detail table) has months 1-24 representing a 24 month period January of current year to December of Next...

I have all ready an AfterUpdate Event Procedure and would like to add to it. Not sure how to do this ... Basically the 2nd function I need the AfterUpdate to do is after selecting the ItemNumber it needs to update another field of the dollar amount for the ItemNumber. Currently on the...

I was wondering if someone can assist me with this issue. This is for projections for inventory items. There is a file in the company's back office system that stored projections by item number per month. It will show the 12 periods for the current year and you can also have projections for...

Hello, i've seen similiar posts but most seem to be just to add 1 from some existing field, etc ... i need help with setting a restart on counter whenever the QuoteID is unique. The counter is the LineNumber field. It is blank. Basically a line number should exist and always restart with 1...

searched but did not find anything. the issue. I have a main form. This form contains customer info and an auto generating quote number. (CustomQuotes header) then there's a subform of the item header information. (customQuotesDetails) then another subform within the item header subform...

I have a subform and when the user double-clicks on the QteNumber field on the subform table it is suppose to open another form with the data just for the QteNumber (driven by the QuoteID see below). I am getting the following error message. "... an expression you entered is the wrong data...

Well, i know that you can't use the AutoNumber as the DataType for more then one ... but I was wondering if I can use something so that I can have another field also do some sort of autonumbering out of the default AutoNumber DataType? I need to have another field in my current table with an...

I installed the rdwiz.exe (compiler). it compiles but when you go to print and it starts reading the data I get an error Print Enginer Error Cannot Open SQL Server There's no SQL Server involved. When the report is processing I can see that it's reading the main data but when it gets (I...

ok, i have an excel sheet where the first sheet is a data link to pull several columns as a data dump. It has all the reps info on it. What I need to do is on the next sheet have it look up from the data dump sheet the specific rep and pull all the columns of data into this next sheet and so...

Is there a macro that can take the data from the 1st sheet and copy the data into another sheet per sheet everytime the 1st column row data changes? I have an Excel file where it's link to MS Access and can refresh sales data. It has all the reps on this and I need some way of taking the data...

I don't get. It resolves some and not resolving ones that it did resolve not days ago??

I have a query that is to produce the final result from two other queries where these queries Groups from details ... hope i made sense there? And for some reason on my final query with a Group I keep getting this "Invalid scale for decimal data type" on one column. The QOH column. The QOH is...

I have a query that shows all the people that are marked to volunteer to HelpAtHome. Which is linked to a table with the days that the HelpAtHome people are also scheduled to volunteer on specific days each month. I want to create a report, based on the query, but to output something like the...

I have a great form that is used to schedule volunteers by clicking on New or editing an existing volunteer by clicking on the name on the date on the calendar form. Once completed, I need to print it out as a report. I have gotten some help by others examples (the form and all) but am stuck...