Search results

Listed material Pat - Sorry for not explaining properly but this is confusing me too. I hope you can help me now if this is possible - I don't know. Attached a part of the database

Items report Is their realy no one that can help me with this Posted on 17 May and had no reply so far

Hi all I have a table where I capture Items (Material) used on a job card. The table have 20 fields for items used. On the form there are 20 Lines that can be used for items used. (ROW 1- Paint, ROW 2 - Brush 25mm, ROW 3 - Brush 75mm, ROW 4 - Cloth.) (Row 1 captured - store in table in Field 1)...

Thank you it work perfectly.

Is there no one that can help me solving this problem

Auto Number Hi Yes it is easy to say search, I did search before but coudnt find any posts that suits my request. I do not know if I can make use of the examples because I do not know how to edit the codes to make it work. Attached is an example of my database. Can anybody edit it and sent...

Hi All Is it possible to do the following? I have a column with a heading EventNo. The Event number must be 06-00000 The first 2 digits is the year. In the Input Mast I have - 00/-00000 and the Default value set as 06-00000 How can I set it up so it can go to 07-00000,08-00000 and so on...

IIf Problem solution Thanks it works perfectly

IIf Problem John What you gave me is exactly what I have I want Narrow to display if the result is -1, -2, -3 etc. If the reading is 0 (Null) display OK. Display Wide if the reading is +1,+2,+3 etc The IIF expression allow you to enter only 2 - "Wide","Narrow"

Hi all I have a field where I enter a measurement. Then the reading will be callculated in another control and then display a number - -1, or 0, or +1 1050 [text222]-1045= 5 IIf([Text223]>=0,"Wide","Narrow") If it is -5 it display "Narrow" Thats Fine I can't get it to...

Open Switchboard Open Switchboard inn edit mode Click on VB icon Look for :- Private Sub Form_Open(Cancel As Integer) ' Minimize the database window and initialize the form. DoCmd.Maximize ' Move to the switchboard page that is marked as the default. Me.Filter = "[ItemNumber] = 0...

Problem solved Thanks the problem is solved

Hide fields From a other forum I have the following Me.Sup1.Visible = (Sup1 >= 0.01) Me.Sup2.Visible = (Sup2 >= 0.01) Me.Sup3.Visible = (Sup3 >= 0.01) Me.Sup4.Visible = (Sup4 >= 0.01) Me.Sup5.Visible = (Sup5 >= 0.01) Me.Lab1.Visible = (Lab1 >= 0.01) Me.Lab2.Visible =...

Someone else?? is there someone else who can help

Copy of DB Here is a copy of the db if you can solve the problem I thank you

Every field(on report) have a column in the query. This mean there are 120 culumns where I have to put in <>"0.00". Then I get a error "query too complex" What now??

Hi everybody I have a report (see attached file - unwanted.zip) It display all the R0.00 if there is no value for that fields. Is it possible to hide all these R0.00 fields I only want this fiels displayed if value is >R0.00 (R=South African Rand) pls help me with this one

Thanks I think I can handle this now.

?? Help!! I can't get this working, Am I too stupit? Is there an easier way or give me more detail help! I do not know much about coding. :D

Hi all Quite busy these days but never too busy to visit this website. I have a question. I am busy create a "Logsheet" database. Where you enter all your trips done with your vehicle. Trip;Date;Trip_From; Trip_To;Start_Km; End_KM; I do have a textbox where get the...