Search results

Try this Private Sub Booking_AfterUpdate() On Error GoTo Err_Booking_AfterUpdate If Me.booking_type = "occasional" Then Me.booking_date = Now() Dim strTblName As String, strValidRule As String Dim strValidText As String Dim intX As Integer Dim thedate As Date Dim seconddate As Date...

try nesting if statement first to tell sub to do nothing if there is no related records. eg Dim rstCount As DAO.Recordset Set rstCount = Me.Recordset if rstCount.RecordCount = 0 then else If rstCount.RecordCount > maxRegels Then Me.Form.ScrollBars = 2 Else Me.Form.ScrollBars = 0 End If end if...

Create an unbound text box. Use expression in unbound box. try having event on form private sub form_selectionchange() me.repaint end sub Hope this helps Ash

What you are wanting to do is filter records based on a form value. Try searching for that. Ash

how do you have the query linked to the form. Ash

I spend alot of time on the road. average about 2500 KM a month. In Australia we have had the mobile ban for a couple of years. I get quite irrated by other drivers that fail to observe basic laws. The laws are there to benifet all drivers. People who talk on mobiles don't indicate, as they...

try on form load set me.village_party.visible = false on village_party_allowed after update set if me.village_party_allowed = true then me.village_party.visible = true else End if Ash

i recently purchased a navman pin 500, Has all features of standard pda's but also has built in gps navagation. I have found the unit remarkable. As I travel all over australia the unit is handy to have. No phone but i have never liked the pda's with phone. I find the phone function on most of...

is invoice detail a subform. If so change its view to datasheet. Have a look at the northwind sample db. Hope this helps. Ash

you need to create a select querry with the information you want. In the field year make the critera subject to the form combo box. eg [Forms]![formname]![fieldname] This creates a parameter for the query that must have a value for the query to return results. Hope this helps Ash

Current Security Model for Outlook requires that each email message sent from access be approved for sending. Ash

RV You shouldn't drink if it makes you nasty. was your original post that suggested just to combine the two tables. Now your suggestion is: Which was my original point that you needed a field to distinguish between the customer data. Date was just a suggestion. AngelsGuardian then offered...

The other way would be to set an input mask on that field so that it has to have the @ in it. That way the if the field is typed in incorrect the user will not be able to continue without fixing the field. Probably easier then having code. Ash

Have you related the tables so that access knows which information to draw from with (pk) and (fk) Ash

Create a command button with wizard you have an option of find record. it is the easiest way Ash

is the drop down menu to see old orders. If it is make the combo box an unbound field and use an sql statement as a filter for the form. Ash

why not try after update event. You should post the code as there may be a problem with the code. Ash

Why not do one combo box that shows both fields. Create an sql query that lists both rows in the combo box. eg: select distinctrow table.supplier id, table.suppliername from table order by suppliername then in the properties box set the format property coloumns to two. Or you could create...

i know exactly what you are after, have nearly completed a similar project. It is not as simple as it seems. You need to think about what you want as i have some 12 tables in my project. Set out a plan of the specific data that you want to show. and then design tables around that data. My...

use the report wizard when setting up report it will let you sort report by up to 4 groupings use a query to show report by dates. Create your report based on that query Ash