Search results

i have a report with 'AdvSectionID' header and 'AdvSectionID' footer. in the detail section there's a field called 'NetDays' (the amount of days it takes a Section to do something). in the report footer i have 4 fields: Total cases cleared in 10 days...

this is my problem... i havea form, with 4 fields (there are more than 4 but that's beside the point). [Guide Type ID], [GuidDateReceived], [txtRetdBySol] and [TargetDate] I am trying to populate [TargetDate] and have created the following expression, which doesn't work: =IIf([txtRetdBySol] Is...

My problem is that i have a query which displays a series of totals for a nominated period of time, based on date parameters entered by the user. This works fine. I also have a query that does exactly the same thing, returns a series of totals, but without the date parameters. What i am trying...

I'm sure this seems very simple to some, however i am finding it difficult to obtain the results that i want. I am trying to create a crosstab query to display the following... 2 columns, C1 and C2. 4 rows, R1, R2, R3, and R4. Values displayed in these fields are derived from 2 queries...

I have created form on which users enter payment details, and i want to put some kind of input mask on the form to prevent the following... for instance: i would like the user not to be able to change the value of the field 'status' to PC (Project complete) whilst the 'balance' field on an...

I have created a tabbed form, based on a multi-table query, with 4 subforms in it. Application is the main table in the db, with the primary key,id, being an autonumber and all other tables are related to this table via the id field, which is a number field. For each new record i create, there...

Can someone help, I have a main table in my db called Application, which has a primary key 'Application ID', which is an auto number. 19 other tables are connected to this main table by and ID field (primary key in the one-one tables) which is a number field. These tables either have one-many...

When inputting text in to a combo box, is there any way of increasing the number of characters allowed on one line. I have tried the usual... pulling the line out to the right, but it still only allows me to enter a limited number of characters. thanks.

I have a problem, i have a report that details payments made on certain dates. when i run the report, i should get the company name, payments made, and the date the payments were made. If there is more than one payment made, these extra dates and payments should be listed below the company name...

I'm building what i thought wasa straightforward query, though i keep getting the following message when i try to run it: "you tried to execute a query that does not include the specified expression 'PREFIX' as part of an aggregate function." 'PREFIX' is a field, the following is the expression...

I have a small database, and I want to archive data held in one of my tables. I intended doing this using the append query. I created another database, called 'Archive.mdb' which I want to append the data to. This worked successfully on my hard drive, and the data was appended accordingly...

I have a database which, when opened, the user is promted to enter a username and password. depending on these details, forms are made available to a user on different levels, ie. manager enters u/name and p/w and gains access to the whole db, but user enters u/name and p/word and is only...

this is a form, with 3 command buttons on it. this is the code behind the command buttons. the first opens the form "Part 3 financial details main form", the second opens "Payments & Receipts Main Form" as input only, and the third opens the form "Assessment Navigation Form" as read only. ...

Based on the username and password entered, i want the Payments & Receipts form to open as a read only form. this is what i have so far. If Me.txtUserName = "Username" And Me.txtPassword = "Password" Then DoCmd.OpenForm "Payments & Receipts Main Form"

I have created a switchboard, however i do not want every user to view each of the forms/reports on it, so what i want is something, that when i select a particular form from the switchboard, the user is asked to enter a password, and if they don't know that password, they can't view the form. i...

Trying to return a 'year' in a query. I am converting a db from Lotus Approach to Access, but i can't work out how to convert this query. i know Access doesn't use 'Combine', so would anyone know how to convert this. please. The expression should return the 'Financial year' each time...

my problem is that i want to find the average productivity, based on members of staff. however the number of staff is likely to change from month to month. i have a table 'staff', and 'productivity' is a calculated field in a query. at the moment the chart that produces the figures that i...

I am trying to put a charts on reports. the charts will display various things, representing 6 members of staff, the number of days they work in a year, the different types of days they work etc. ideally what i would like to do it type in a staff member's name, then up should pop a chart with...