Search results

Yes, that sure looks like it! Excellent, Thanks a lot! I'll have to dig into it a little later so I know where I went wrong. Couple quick questions: How do you go about building that type of query? I've seen a couple like that online here lately and wondered how they were constructed. And...

JHB, it brings up an interesting point that it only works on a couple of numbers. That's something I'll have to look into. But even with those brackets added, I'm not getting the result I wanted. Your picture only shows the first table populating the form, when it should be each table that a...

It didn't make sense to me that my two statements were identical (except for the report name) and only one worked. This one didn't work: DoCmd.OpenReport "Datasheet", acViewPreview, , "[Equipment Number]='" & Me.[Equipment Number] & "'" This one worked: So right or wrong I began...

I've got the "Print Combined" button working correctly. I hadn't entered the 'Link Master Field' and 'Link Child Field' info. It now just leaves white space where the 'invisible' sections would have resided, but I'm confident I can get rid of that. One thing I noticed though, is I can build a...

OK, I've attached a zipped copy. What you'll see is three different print options that I was working on, Because I wasn't sure what I was going to want in the end. The one labeled "Print Pages" was my first attempt and it works, in that it makes preview versions of each current tab. It wasn't...

Now it asks for applicable!Equipment Number Then previews the report without the data.

I think that's one I tried. And it gives me: "Run-time error '3079': The specified field '[Equipment Number]' could refer to more than one table listed in the FROM clause of your SQL statement" which is where I'm having difficulty. I want it to get data from the applicable tables, but can't...

The database consists of 9 tables. Each table represents a different aspect of the equipments' configuration. In it's most simple form, equipment would consist of a motor and a directly attached, driven piece of equipment. In other cases they'd be attached by a connecting device that could be a...

I currently have a Access 2007 database on a network, in a protected folder. I have a form built within it, which uses macros to "output" reports which are then made available to the users in a different networked folder (read only). The form is a simple one, containing 10 buttons, each with a...

Ok, I think I heard the nickel drop. I think I was misled by the label of "lookup column", even though I mostly had it working. I looked at the join option after seeing Rain's response, tried it, and I do like it better in my application. I put a field in my main table dBValue and also in my...

I'm not trying to save two fields into one. I wanted to save both fields into two different fields. I wanted to select the dB value, and save that value in one field as well as the associated CFM value in another field. I can understand the "user should not see a Primary Key". But in this...

I've tried it numerous ways, but here's one of the last: I created a combo box (which started the wizard). The label tells the operator to select the dB. Selected it to lookup the data from Table/Query. Selected my lookup table. Selected both columns (ID and EstCFM). (Using ID for the dB...

I am trying to modify a database that stores leak data from air leak surveys. Currently it has basic data such as date found, date repaired, type of leak, etc. We use a simple form to make new entries to the database. Air leaks are quantified by a dB reading on the collector, but need to...