Search results

Good idea to declare your Access version. What issues are you facing ? Recordset not what you expect and or problem with sending email ?

Hi Forum, I have been AWOL for a while renovating houses :banghead: One house is in a "mild" climate and we are insulating it well and installing a wood stove, with wetback. I want to make a warm air collector to pump heated air into the house on cold sunny days. The ideal solution would...

Sadly it won't fly :D The resident, who passed away in November, was born in Wellington.

We are relocating from Raglan to Tokoroa (New Zealand) and this video was made of our Moon House. http://www.youtube.com/watch?v=4NFTt7XiwQ0&feature=youtu. Sad to leave but life must go on:)

You could try this method. In your code where you call for the report, create a TempVar eg "MTRReportGrade" - TempVars are new to 2007. When the Reort opens, you have code in the Load event (try this first) to check for the value of TempVar MTRReportGrade and set the colours and font of the...

Report for < 10 and another for > 9. If this means 12 then yes, too many IMO

I agree, 12 reports mean there should be another way. I will check how we have handled similar issues and inthe meantime, others may advise a better way. You have 6 Reports now ?

I am sure this can be done but not as simply - I understand. One sure way is to have two Reports. One for each age group. Similar code as used will assign the Report Name to be used. ie If ... Then etc This would be included in the code behind the OnClick event where the report is called...

If the Form is set to Allow Additions and is Continuous then you should be able to keep adding a new record.

Paste this code in your On Load event of Mid Term Report Screen by Form Class Dim YearGrade As Integer YearGrade = Me.Year_Group_ID If YearGrade < 10 Then Me.Combo92.Visible = True Me.Label65.Visible = True ElseIf YearGrade > 9 Then Me.Combo96.Visible =...

When you create an Action Query (Append, Delete, Update) it is best to first create a Select Query to ensure only the records you want are returned. In this case you want a number of Fields to be returned - simple task for a Select Query except.. you only want records where the UniqueID...

Everything appears OK. I will study your issue during the day:)

Never heard of Security Token. 18mb a bit big:eek: Try and compress the file. Also, did you Compact it first ? Trust it is not a split database.

See attached database. I used a new qry qryA_Wishlist2 and included a DLookup to reference to txtUniqueID control on your Form. Trust it makes sense:)

Some observations you may wish to consider. Your Field Names use more then one word - good practice except for Title. Title is not on my list of Reserved Words but it could still be one. Form Control Names should be different from the Control Source Name eg frm_AddItem2 UniqueID should be...

When Posting you should have Additional Options below where you type. This includes Manage Attachments. Try and get your database size below 1mb.

At the point where StudentID is known, you are able to have your Form/s display to reflect any stored data eg StudentAge, StudentSex etc. If you can attach a stripped down copy database with no sensitive data I, or others, should be able to assist.

There are a few ways to do this task. When a Service Order is Completed and you wish to create an Invoice you would Select by SQL/Query the required data that matches the record opened on your current Service Form and append same to the Invoice table. This process can be automated to verying...

Depending on where the UDF is called, there are variable Control Source returned ? Can you have a line of code before the UDF is called that holds the Properties you wish to set ? Would a Global Variable be able to hold the key to what color to use ? Late versions include TempVar that is an easy...

Exp 1 & Exp 2 indicate there may be an error in your SQL code. This happens when the sql field name in your query is not the name in your table. Are you able to attach a stripped down copy of your database that does not include any sensitive data ?