Search results

Hi, Ok, so this says you want to list all the jobs (open this table first in query builder). That is assuming you have a list of jobs table (organisational chart?) Now the other part that looks to be tricky, but I'm sure there is a good reason its set up like this... You want to join the...

Sounds like you have assigned a relationship, but got it wrong? Try looking at the relationships first and see if there is an obvious error. Vince

Hi, Different tack... SELECT qryProHrsByStudent.StudentId, qryProHrsByStudent.SumOfProHrs, tblLUBands.[Band] FROM qryProHrsByStudent LEFT JOIN tblLUBands ON (qryProHrsByStudent.SumOfProHrs < tblLUBands.BEnd) AND (qryProHrsByStudent.SumOfProHrs >= tblLUBands.BStart); This is from a quick db...

Your output is in a string.. just enclose that with the function cdate() which converts string to datevalue....?? Just a thought. Vince

yes - string manipulation - save the html file with the data to your hd. Note - copyright info may be on the data - your risk and depends on what you use it for... If in doubt ask the wensite admin person. Vince

I guess its record locking and I am guessing again that the front end and backend are all in one (all tables, queries, reports, forms amacros and vba code altogether). When a person edits a record (bound form) it holds that record open until they save (and move on). It holds around 2kb on...

Oh, I assumed that hte listbox was on the top form and the sub form showed the results depending on the selection in the list box.... Same principle, but with the listbox instead, filters on a specific search field in the top form and then needs requerying... not quite sure how you'd do that as...

Don't suppose you can post the table names and the keys involved (connections between the tables) ? Maybe someone here can then post an Sql statement to help you ? Is it a read only form? Vince

SELECT UserInfo.SURNAME, UserInfo.FORENAME, UserInfo.YR, UserInfo.[E/DATE] AS [Relevant Date], NZ([TPHrs],0) AS [Total No Provision Hours], NZ([TPDs],0) AS [Total No School Days Excluded], FormatNumber(NZ(IIf([Total No School Days Excluded]=0,0,([Total No Provision Hours]/[Total No School...

woah! :eek: Right... first thought thats struck me is that you seem to be filtering the ... hummm nope... scary. And thats using queries too... Does this run fairly fast??? General notes... -- These two are filtered by the start and end of financial years... qryProvisionHours...

SELECT 1 AS Area, '2003/2004' AS [Year], Sum(QueryA.BandA) AS BandATotal, Sum(QueryB.BandB) AS BandBTotal, Sum(QueryC.BandC) AS BandDTotal, Sum(QueryD.BandD) AS BandDTotal FROM QueryA Group By Area, [Year] I think the above is ok - as you'd need to group by those not included in...

Bound (urgh)... You'd need the query for the subform to be pointing (and filtering) on the open forms listbox. Then you need on the on_click event of the list box a subformname.refresh or subformname.requery. Vince

How good an Asp programmer? :) Think of the access form as a blank html form, your choice if you want bound/unbound. If bound, use SJs post above. Vince

Sounds like a non updatable query with no records returned... Access being nice vanishes all the text boxes... A problem when you use bound controls :) Good luck fixing Vince

Since you're new at it, go with SJs suggestion. Later on when you have some experience and if you have some time and want to experiment I'd suggest the following: Form for the Inquiry - allows user to enter enquiry details - validates entry (possibly if editing copy record to archive/audit)...

I'm refering to the initial post... As pointed out by newman SELECT tblQualification.Type FROM tblQualification INNER JOIN tblUniversityQualification ON tblQualification.Id=tblUniversityQualification.QualificationId WHERE tblUniversityQualification.field = 4 The first colour is the second...

I am guessing you are using bound controls, if so use Rustys example. If not, you can place validation checks on the Save button, which won't let the user save anything unless it passes all validations. This is harder to implement but you can make one sub to do the checks and it can affect the...

Insane ;) :D tblQuotes tblRepairs tblQuotesToRepairs QtRID - autonumber - pk RepairID - number QuoteID - number The Quotes to Repairs (or visa versa) holds the repair id and the corresponding quote id. Or you can do it the other way around and hold a list of quote ids with corresponding...

To me that statement looks crap. Glad you managed to get it working though. Select table.field, etc From table1 left/inner join table2 on table1.field=table2.field Where table.field=<value> Not even sure how you got the first sql statement to work right, I guess access is forgiving... or...

Select tblAccounts.*, nz(tblTrans.amount,0) as TAmount From tblAccounts left join tblTrans on tblAccounts.AccountNo=tblTrans.AccountNo Looks like a stright retrieval (as above). If you need it summed it would change it to.. possibly the following: Select tblAccounts.AccountNo...