Search results

Thanks for the reply. I am looking to automatically change this based on a Not In List error. So if the user types in something and it exists in the list, use the combobox, otherwise it is a simple string search. After some playing around, I think I can use the not in list event to trigger...

Hi All, I have some comboboxes setup to build a sql statement and have a subform to be populated with this statement as the rowsource. This works great. I want to give the user, on one field, the ability to use either the combobox or specify a string of text to search for. The combobox is...

You can use an asterisk with a query on a number field. That isn't the issue with this solution. The request is contradictory by nature. Utilizing a wildcard to tell access to locate all of the records that start like this, but don't grab more than one of each value, is something that it will...

Hi Joshery420 I have attached a sample database with a setup like you are requesting. Like DCrake said, you can use any combination of Group By's etc to acheive what you are trying to do. The sample has one query setup to group by site, by year and then provide the avg temp.

Thanks! I figured someone would know where the information existed!

Hi All, I am looking at taking over development of a database and I encountered code for "DoCmd.DoMenuItem acformbar, acRecordsMenu, 5, , acMenuVer70". I don't use this as I use the DoCmd.RunCommand approach and I am unfamiliar with what Command "5" is. Since this comes from a Macro Command...

I concur with PNGBill. Might as well use one of those as the base and customize it. That way you know you have a foundation that works.

A linked field will be an exact match. However, you could set the recordset of the subform to "" when the main form is loaded and then create the recordset when the load is complete. In this case, you wouldn't link the fields, you would simply be creating the proper recordset as you open the...

Good point on the instances reference Bob! My first endeavor lead me down that lonely road... Like Bob said, be prepared to code this. For the templates, I wrote code that runs a batch file when the app is first opened and copies the templates to the directory I have installed the app to...

I just did something very similar to this, merging data from different systems, summing sum based on other criteria, etc. I used option 3, building all of the queries and merging them into one. It works efficiently and sorts through about 15k records in one table pretty efficiently. In fact...

Ok. Here is what you do... 1. for each query with the same criteria, you will reference a form to supply the parameter. For example, you have two queries, one of which updates based on project number and the other on project number and date. your form would have two fields, project number and...

I typically setup excel templates and then send the data to excel and fill in the template. You can use the excel vba references to do just about anything with data in access. In one db, I have a form setup where the user can pick the report they want to run and populate criteria to have it...

Two things. 1. A linked table can still be setup with relationships and the like. I do this currently with an MDB back-end and pull data from 13 linked SQL Server tables and do exactly what you want to do with no issues. 2. Your code references Bemerkung. It looks like that is a field and...

No Problem. Not much of a sample db but it should get you started. Good Luck!

BobLarson is right! You could relate the call records to the customer and then merge them together in any form or report you need. The only "Trick" to this is that you must usea Union All Query with your query and an empty Table template (Table is the first selecgt statement) to force access...

There are a few ways you could handle this, depending on what you want to do with the data. The first thing you need is a table which stores the Territories with a PK (Autonumber is fine). For each contract, you will store the territory PK as a FK. For the form, you create a combo box that...

Hi All, I am trying to setup an interface for a user to import a list of items into the database. What I'd like to do is allow them to pick the file to import and then import that file, creating the records in the related tables as well. The trouble is I don't have the ID from the main table...

I would setup the report with a query on the customer then add subreports for each of the lists to link to the customer ID. so you would use your separate queries for each sub report and then they would appear side by side. You might also be able to figure out a way to group by one of the...

The query you displayed doesn't have a join in it. The only way to merge that type of data together is with a join. An inner join on CID would repeat data if one of the tables had more records that matched the criteria than the others. A left join would yield all charges and only payments...

No, it is not correct if divided by 2. This is because there might be 0 sys2data results, or 15. What I ended up doing was creating a global variable and summing to the variable in the on format of the header section of sysdata1, resetting the variable at the higher level where I want to...