Search results

I would like to create a calculated field in a query that returns different values based on values of other fields. I did not succeed in entering a conditional statement in the query grid. For example, here are my fields and values: Fld1 Fld2 Fld3 Calculated(conditional) -1 0 0 "Text1" 0 -1 0...

'Summary' is a report. Its not bound to a query. Everything is intact, nothing moved.

I run Access 2002 on Windows 2000 Pro. This is painful but I have spent quite sometime figuring this Report and every time I saved Access asked me to confirm the name. When I closed the report to open it again, I got this rude message "Microsoft Jet Database engine could not find the object...

I am designing this report that should display results from several queries. Most of the queries are counting records meeting various conditions and thats why i figure Imust have various queries. I do not want my report bound to a single query so that I can pull values from the various queries...

Wayne, when I click the Add Record button, nothing happens appart from creating a new record. I have thought of another way, not sure if its the way to go. I have added this code to the button Me!Age.setfocus Sendkeys "{TAB}" so that when the addrecord button is pressed, it sets focus to the...

Sorry wayne but that didn't work.

I have this quite long form that I have made for data entry. Its spans line 1.5 screens so the user has to scroll down. Wonder is that's a good design but anyway, my user is complaining that after entering data to the bottom and saves and creates a new record, she has to manually scroll up and...

Pat, here is the detail of why I'm doing that. I am using an ArcMap ActiveX which has a script to read a table within the database and use that to display points on a map within the access database. This code opens the database again using its interface IWorkspaceFactory and method...

I have a script in my database that accesses a table within the database but kind of opens the database anew and causes problems warning "you do not have exclusive access to the database, changes will not be saved etc". I tried to have it read the table by opening a recordset but it wasnt happy...

Lister, it worked! This is excellent. I know there had to be a way to do it simply but had no idea. I did it a long way; created a function which would accept an animal name as argument and respond with the count. I then created an unbound form and inserted individual controls which...

Thanks, worked like magic. Will tread carefully knowing what might happen if someone ever edited the table directly. Glad I now know how to do it.

Its the controlsource of the invisible text box that I have set to =[txtArea]*[cboUnits].column(1) therefore I dont know how to bind it to a field. The textbox into which the user types the area is not bound, it just holds the value before its converted to the correct area units and...

I have a form that I�m using to enter data into a table. One of the fields in my table is storing area measurements. The users have areas in different units of measurement (Ha, Acres and square meters). I intend to allow the user to enter the area in any unit but to specify in a separate...

Sorry Lister but I did not seem to get this correctly especially about changing from SELECT query to SUM query. Unfortunately I cant view the sample you attached, whenever I download it, my winzip just cant open it! ColinEssex, I did just that and what I'm trying to avoid is to create a query...

Summarizing data I have a field in which data is entered by a combo box thereby a record can take one of the following: lion, elephant, baboon, leopard etc. Typical values for the field would be; Lion Lion Elephant Giraffe Leopard Lion Etc I need to summarize this to know the number of times...

Thanks, this worked fine and I further linked it to work with my date picker.

OK I could do that, actually I have thatalready, only thought of making it easy to produce the reports by picking a month and year eg "January 2004" or "November 2003". Thanks.

Currently just one criteria is changing. Specifically, its picking out data for various dates so my criteria is begin date and end date with an option of just picking a month so the code computes the dates as the first and last dates of the month.

I have a query which passes on values to a report. The criteria used for the query changes depending on what options the user selects in a user form. I'd like to create the query in VBA so that I can use IF, THEN, ELSE to determine what set of criteria to use. If someone has a code to do this...

Thanks FoFa, even though this did not give me the exact solution I wanted, it prompted me to build the query I wanted. The next issue I face is that my criteria will keep changing depending on the user input and I would like the query to read this criteria from a user form. I think it would...