Search results for query: *

Thanks to anyone trying to answer my question but I solved my issue by adding the following code to On double click Dim stLinkCriteria As String stLinkCriteria = "[lngProductID]=" & Me![lngProductID] DoCmd.OpenForm "frmMSDSDetails", , , stLinkCriteria End Sub JLopez lopez2059@bellsouth.net

I've seen several posting related to this question and on FAQ but have yet to solve my problem . I'm hoping someone will help me see solve it. My 1st form works well and consist of combobox and subform. I select my combobox product and the subform is populated with related item. I want to open a...

hi all! I'm still somewhat of a newbie but with your help from previous years I've been able to handle all of my db problems. thank you all I would like my form to stay in the current record when I use the addnew record function but my form jumps to the first record on requery/update. Maybe...

When I click to open a new blank document in WORD, it opens up a document my daughter generated and saved. Did she save her document as a template? I don't think so but I've been to templates, options, etc and don't see how the new document format could have been altered to open the way it does...

yes this is what I do now but I was hoping that I can automate the exporting. Presently I manually export my values and plot them in an existing excel report. I somehow think that I'm missing a step in my exporting. Is it possible to link the query with the existing excel report without me...

Presently I calculate two values, PercentWater vs DryDensity in Access and tranfers my values to excel to plot. The plot yields a polymnomial curve that is given to the client. ex. PercentWater DryDensity 4.80 122.36 6.69 126.94 8.80 128.89 10.70 124.15 I'm hoping to have Access take these...

I have a query that calculates values for plotting in both Access and Excel, however I've always copied these value to excel or "analyzed them with Excel" and plotted them. I've also finally figured out to have Access plot the values that I give it. My questions is how can I have a form or...

I have an Access query that calculates data points for plotting a curve that is Moisture Content vs Dry Density. The curve is a polymonial and I'm interested in automatically extrapolating the values at the tangent or max value in excel. Is this possible? I don't know excel capabilites that...

Thank you, Andy that worked JLopez Lopez31@ATC-Enviro.com Environmental Services @ Your Service

I have a query where I'm able to select every tenth record using *0. Now I want to flag only those record with a sting saying "QC". Is this possible? JLopez Lopez31@ATC-Enviro.com Environmental Services @ Your Service

Thank but I found my answer by searching val(format ([CS]/10,"0"))*10 JLopez Lopez31@ATC-Enviro.com Environmental Services @ Your Service

In Excel I can round to the nearest tenth unsing ROUND(A3,-1). Example 3426, Rounds to 3430. I don't seem to find an an Access query function that does not do this? I've tried ROUND([CS],-1) and I get an error. Thank you JLopez Lopez31@ATC-Enviro.com Environmental Services @ Your Service

I want a form to view all reports, select one and print the one selected. Just point me in the right direction, I take from there. I originally thought that a combobox orlist box would show me these reports but is only allows for queries or table. I don't know where to start. A somewhat newbie...

...Sites's Recordsource Select Case optChoose Case 1 ' Site name mstrSQL = "SELECT * FROM dbo_tblSites Where " _ & " SiteDescription Like '*" & DoubleQuote(Me![cboSelect]) & "*'" Case 2...

I want to open Clients, Site or Buildings forms depending on user selection. Ex. choose option1 (clients) and have combo select existing clients, then open the form to that selection. I've found an address db with the this code but it only opens one form and I'm not too well versed on VBA...

Thank You Randy, I understand the code but where do I place this code. On the combo box or in form 2 JLopez Lopez31@ATC-Enviro.com Environmental Services @ Your Service

I want a form to open and display only those items related to my selection on another forms combo box. My relationship is one site to many buildings. So if I select site 1, form 2 will display the many buildings associated with it. This is easily done via query where I set the criteria and...

I have an update query that works to update the other fields in table to be identical to other fields in the same table Example: Mailing adress equals physical address. My problem begin when I use a command button to run this update query but does not change the items on the form. What am I...

I'm needing an Arccosine function. I don't see anything access to do this. Thank You JLopez Lopez31@ATC-Enviro.com Environmental Services @ Your Service

thanks bmpmike but I found out how to format it anyway. It does'nt give me the rd or th after day but it works JLopez Lopez31@ATC-Enviro.com Environmental Services @ Your Service