Search results

The way you want it No. Your main form is set to display a single record at a time, your subfrom displays all the courses by student. Now you want to make the subform a main form and the main form to become a sub. Well ... just create another form which will be called in by clicking on the...

What do you mean by starting the form with blank fields ... does that mean you want to start the form to enter the new record or you don't want the new record but want to wait till somthing will be selected in lets say combo box ? in criterion for the record source of your report reference to...

Hmmm ... This method was as an example from MS. But ... :) DoCmd.quit worked fine. Thank you

I have seen this problem somewhere but could not find the solution. I have dbase opened with db window hidden. When exiting the db, access application resides in the memory. I can see it in task manager, processes. the code i have is: Private Sub cmdExit_Click() CloseCurrentDatabase...

This is probably because your newly entered record is not saved yet. What you needed to do is to on customers form on activate me.requery on newcustomer form on deactivate me.refresh

I assume the SQL for the query shold look like this. PARAMETERS Datevar1 DateTime, Datevar2 DateTime; SELECT AVAILABLECARS.ZONE, AVAILABLECARS.CARCATEGORY, AVAILABLECARS.DAILYRATES, AVAILABLECARS.FROMDATE, AVAILABLECARS.TODATE, CARPICS.CARPICTURE FROM CARPICS INNER JOIN AvailableCars ON...

Although this is not truly visible/invisible thing :) but ... You would need to set enabled/disabled property in conditional formating dialogue and pick up the color of your fonts,textbox background to match the background colour of your form. See example

Sure, You can use conditional formating not to mess with vba.

Where does the data for datevar1 and datevar2 come from ?

Simply add the same table to the query ... and link your Field#3 ... to the personID

This is a good example of search form.

What exactly are you trying to build ?

Will it work for you?

Is not it that your sub and main form are linked? Logically if you make your main form to go to a new records there should not be any records in the sub form at all. Or your sub is linked to an unbound field ?

Is this what you wanted Open Profile form, double click on the shared mail text box select items and then close. The changes will be reflected in the text box

What events trigger the change in calculated field ?

Create blank db. Then open this db, go to file>get external data >import. Point to your old db. Select all in tables, queries, forms, macros and modules. Click options and select definition only . This will copy only the structure of your dbase.

You can create another query with Select distinct yourtable.user_id Then join two queries in summation query grouping all the records from 1st query with Total: first

I think you can use union query SELECT PrimaryTable.PkeyID, "" AS ParentID FROM PrimaryTable Union Select Subtable.Fkeyid, SubTable.PkeyID From Subtable;

Option Compare Database Option Explicit Public Function ExecuteDDL(strSQL As String) Dim db As DAO.Database Set db = CurrentDb db.Execute strSQL Set db = Nothing End Function Public Sub CreateTempT() Dim s As String s = "CREATE TABLE Yourtemptable (ID Counter, MyTime DateTime)" ExecuteDDL (s)...