Search results for query: *

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

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

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

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

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

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

I want to format date as follows "15th day of March, 2004" or "3rd day of March, 2004" but I don't see that format as one of my formating options in access or am I missing something. Is there a function out there that will do this? Thanks in advance JLopez Lopez31@ATC-Enviro.com...

I have field in a datasheet form that when lost focus, enters N number of records in another table. Below is my code. It seems to work great until someone tabs over that existing entry again,giving me additional records I don’t need. How can I lock or set the code to allow entry only once? I’m...

We can't seem to make a backup of our database cause odbc/sql is running in the server containing the data. We've made a batch file that makes a copy of the data but only if sql is closed. We now we need to somehow run another batch file to close sql and later re-open it after a copy is been...

I've been able to generate my report in columns but is there a way not to repeat the text names for all the data. example: Sample 1 2 3 4 Date 01/03 02/03 02/03 03/03 ID jl pl jk pk Percent 50 80...

I'm new to vb. I have a form in vb that is tied to an access 97 query. The dropdown fields work well in access but when I use them in the vb form, they appear blank and i can not update the query either. What I'm I doing worng. Thank You. JLopez Lopez31@ATC-Enviro.com Environmental Services @...

I need a date function that will give me from my query the earliest to last date across the domain. I then plan to concatenate the following statement "From Date1 through Date2" thank you JLopez Lopez31@ATC-Enviro.com Environmental Services @ Your Service

Our windows NT-4 network server has four 9.1 gig hard drives, total 36.4 gigs. These drives are partitioned in the following manner EISA Utilities: - 36 mb C Drive: - 4044mb F: - 602mb G: Shared - 3443mb G: Shared - 4614mb H: Users - 4614mb G: Shared...

Our windows NT-4 network server has four 9.1 gig hard drives, total 36.4 gigs. These drives are partitioned in the following manner EISA Utilities: - 36 mb C Drive: - 4044mb F: - 602mb G: Shared - 3443mb G: Shared - 4614mb H: Users - 4614mb G: Shared...