Search results for query: *

On my main form I am using text boxes with their control source pointing to their respective queries IE: (=DCount("*","QueHVBServiceOrders"). On my PC this data populates instantly. However as soon as I dump it on the server it takes several minutes to populate. If I open a query on the...

I have sub reports based on queries, I am trying to total their values however if a sub report has no records I get an error. I was thinking Nz may help but it doesn’t seam to work. =([RepTimeSheetsQuery]![TotalM].Value)+(Nz([RepHelperTimeQue]![TotalH].Value,0)) How do I get a default of 0 is...

Is there a way to change my Subforms source object from a command button on my subform. What I am trying to do is have a welcome subform, That when the user clinks on a link it just changes the subforms source object

Is there a way to change my Subforms source object form a command button on my subform. What I an trying to do is have a welcome subform and when the user clinks on a link it just changes the subforms source object

I have a form that I am populating with Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[CustomerID] = " & Str(Me![List1]) Me.Bookmark = rs.Bookmark On this form I would like to populate a subform based on the value from [List2] Being a novice I would think this...

I have a sub form based on my parts table. The form is a Continuous Form. On this form I have a unbound (Total) text box where I run the calculation =[List Price]*[Quanity]*(1-[Discount])*(1+[PST])*(1+[Markup]). This part works well. In the footer I also have an unbound text box where I am...

Since taxes can and will change I would like to save the tax rate in my orders table. I was thinking of having a table called tax and in that table having a sales tax and GST rate. How can I take the data from this table and have it automatically populate my orders table via my order form?

What code can I use to show the total number of records resulting from a query in my sub forum?

How can I take the result of calculated data and apply it to a cell in the table my form is based on. Normally I would not require this, however in this case I need this valve as once the table is populated it will be exported.

I have a report from my weekly time sheet, In this report I have different types of work. I would like to total based on my Type. My Type’s are S,M,B… I am using =Sum(Abs([Type]=[S])*[Hours]) When I run this, I get a pop up asking for S If I change the Type to a number then use...

I am trying to generate work order numbers based on a type. Maintence is Mn… Construction Cn.. and Service is Sn.. My table is Called “TblPO_numbers” my type field is “Type” and my stored numbers are in “WOSeqNum” In my “Type” field I have M,C,S… and I get these from a combo box once I have...

I am trying to automate our work order system and incorporate it into my data base. Just having a bit of trouble with the design. I have 4 different system for work orders depending on their use, each has a distinct beginning. Construction for example is BCx , Maintence is Mx, service is SJx…...

How do I get a query to populate a text box? I can have it populate a combo box or list box, I just can’t seam to figure out the txt box. I have a query that populates several list boxes. I then run a email script that takes this data and emails it. The problem is I have to click on every box...

Help sending email. Thanks to these forums I have figured out how to send my form’s information via email. Is there a way to edit this code so it does not send an attachment as all I need is the fields as I am sending the code to our employee’s cell phones? This is the code I am using...

I have a Query and Report of our employees weekly billed hours. In this report I have a PO column and an Hours column. Right now I just use a text box with =Sum([Hours]) to show me the hours and this works great. However now I would like to add the PO area to the Sum. I have reserved all PO...

Each user has their own PDA and I create a unique ID based on their user ID + and auto number field. Each week they sync this data into a access group table. In this group table my primary key is this combination ID from each user. The problem I am having is. I wish too add a record to this...

I have a query with the code and in the criteria field [Forms]![FrmPO_numbers]![CustomerID] I use this to filter data on one of my form and this works great. When I save the form as an active server page the query will not operate. I thought an easy fix might be...

I have customers that have many locations. On my order form ( joined to my order table) I have 2 combo boxes. One is customer and the other is the location. After selecting my customer I would like to run a query so that the only options I have in my location combo box is the locations that...