Search results

Hi all. I have a list of different codes in a table. Now on a form I create a combo box but it display all these codes. I need only a certain code type to select from. Example: The code list have all tools in it. Power Tools, Hand tools, Steelwork tools, Welding tools, Woodwork tools, etc. On...

When I tried to edit or add an entry of the combo box, Access stop and reload the database. Access don't display any error message. I re-install Office but it stays the same. Did anybody experience such a problem and what is the solution.

I have a huge problem. I create a database in Access. The db is really big. As far as I can remember Access have a limit (2gig) of data that can be stored. Is this correct? If correct then I'm stuck. The data for register an asset, two different inspection and the planning for just one asset...

Hi I need to know how to auto enter the date of the previous record into a new record. I have this db for my vehicle log sheets and I submit monthly a claim for the business km from my company. I usually cant remember the date of the previous claim and have to scroll back until I find the field...

Hi, I want to force the users to plan their work at least one day in advance. I need to know how to enter a plan date that is one day in advance. If you do planning today you can only enter a date from tomorrow onwards. Access must not allow you to enter a date earlier than tomorrow. Can...

Good day all. I have created an access database for the Railway industry to do the following. 1. Register assets. (on Track, Off Track and Structures) 2. Capture and manage Safety inspections. (On 23 Asset types) 3. Capture and manage Condition Inspections (On 14 asset types) 4. Capture and...

Hi everybody. Compliments for 2013 to all of you. I struggle a long time to solve this on my own but I can't. Table Fields: Asset_No, DateInsp, NextInsp. (This is only 3 field names in the table) On the form I enter the Asset No that was inspected. Enter the inspection date. This is always...

I have the following: We do inspections every 6 months on certain types of assets and the readings are captured on a form. I have a field where the date of inspection [InspDate] is entered. I also have a field where I enter the next inspection [NxtDate]. I can get the next inspection date on...

Hi, I struggle with the following. I have 2 fields (CantLH and CantRH) where I enter a reading. Then a text box to give me the difference. =[CantRH]-[CantLH] 12 -0 = -12[A1]. Or 0-12 = +12[A1]. One will always be a 0 (zero). 0 left hand and 0 right hand is the ideal reading and in the "A"...

I have a dB called logbook The table have Date From To KmStart KmEnd Length Etc. 1234 Start 1250 End 16 Length 1250 Start 1350 End 100 Length In the form where I enter the start km and end km of a trip I want the previous [end km] entered in the next row start km. Without typing the start km...

I am using Windows7 and Office 2010 but cannot find a way to open an Excel spreadsheet from a form with a button. :o I have a database created in Access 2007 and I could open these spreadsheets. I have many inspection forms in Excel that I want to open with different buttons. In the button...

Hi all I have a table with data like Field 1 = Ref_No (IM1006/0548) Field 2 = Loc (CBUS) I want to combine these two fields in a separate field Must look like this Field LocNo = CBUS0548

In my table I have a field named Lic_Date (Licence Date). This licence is valid for 1 year. On the query I ad a Lic_Exp field - Lic_Exp:([Lic_Date]+365.25) Format for both is dd/mmm/yyyy Lic_Date - 15/Oct/2005 LicExp - 15/Oct/2006 In the Lic_Exp field I enter the criteria - Between [DateFrom]...

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)...

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...

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...

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

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...

Hi all I need to run a certain file from the form I create a button as follows Select in the categories "Applications" then select "Run Ms Word" I have tested it and it open Word but not even a blank page I then open the code as seen below and want to insert the filename but do not know where...

Hi all :confused: :confused: I have a table (In Oracle) where we store all our assets - almost 35000 of them. In the table there are fields named KM_From and KM_To These fields are Text fields on the table, Now what I tried to do is the following I want to set up a query where I query...