Search results for query: *

I have a series of queries that, according to a number of conditions submitted on a form, only ONE of the queries will execute. That's working fine. I then put the result of that query into an array. It's only one field that I want, but there will be a variable number of records returned. I...

Hiya. I have a spreadsheet which produces a pretty chart based on a bunch of data thrown at it from Access. The number of rows of data the chart needs to show varies, according to the selected output from Access. At the moment, with a fixed data range, the legend shows symbols for a full...

I have a website hosted on "SiteHost1", but the email is handled by "MailHost2" through an MX redirect. General email is working fine and dandy. The problem is that the PHP Mail script that I use to send emails to new users I have registered on the site is no longer working. In short emails...

One of my forms has a combo box for 'bin type', which has three fields in the combo box: bin id bin desc bin weight 'bin id' is the bound field, which is correct. However, I'd also like to be able to make use of the 'bin weight' field on the form. Specifically the form is recording the...

That's it in a nutshell - I have a table where I want to show the sums of a list of items, but also show the percentage each of these items makes of the total. Now, I can achieve this simply by dragging the 'value' field into the data area twice - formatting one as 'sum' and one as 'percentage...

... he gets a bit tetchy when I reply "how long is a piece of string?" Background: small/medium company of consultants (not IT). I'm the resident geek - run the network, training staff in general office apps, website and database development (Access). NB: I'm also the FIRST resident geek -...

I have a form for payments received. On each record there is a payment type textbox (combo) - eg, payments are received in installments, so options are submission, interim, final. If 'final' is selected in that combobox, I want another field to appear in which they can enter data -...

The query below is used to bring my blocks and sub-blocks (of land) together, and define the season I want to look at, and is a base query for another query. SELECT [DAT - Blocks].[Property ID], [DAT - Blocks].[Block ID], [DAT - Block Sub-blocks].[SubBlock ID], (select [currentyear] from [BAS...

Going a little nuts here (nothing new in that). I'm getting the following error message after I try to run one of my queries. "This action will reset the current code in break mode Do you want to stop running the code? To halt the execution of the program so the Module window can be closed...

This may belong in the tables forum, or forms for that matter. I have a table where data is entered for exporter indicative prices (horticultural industry - exporters release prices at the start of each season for various markets, fruits and growing methods). Fields are: Season ExporterID...

Hiya. I'm using a lot of Nz([myfield],0) at the moment to get around tables that may not have matching records, and it is working fine on that level. The problem is Nz([myfield],0) causes the values in that column of the query to left align, and apparently no longer be defined as numbers...

While I still have some hair left, could someone give me a pointer on this one, please. I have a simple union query used to add an 'all' option a list of dates in a combo box: SELECT Date FROM [DAT - Payments Total] GROUP BY date ORDER BY date UNION SELECT "*" FROM [DAT - Payments Total]...

Hi folks I have a challenge and a half on my hands, and I could really use your help. I have been developing Access databases for several years, and we now have some rather nice products that the boss wants to start selling/franchising to other businesses in our group. NB: Some are...