Search results

  1. R

    Form - Select a certain entry

    Thank you for your replies. In the mean time I search and find an easy solution In the properties of the Combo Box I find the Row Source. I click in ... and a window Query Builder open.. I add the Tool_Type field. and In the Criteria field I enter "Power Tools" . This will filter the entire...
  2. R

    Form - Select a certain entry

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

    Edit entries(List) of Combo Box

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

    Limitations

    No images only relevant data from asset register and inspection readings. A realistic figure is about 10gig space per year that will be used. I spend so much time to create this db and really don't want to do it all over from start. Convert to Java or SQL might be the solution but I don't know...
  5. R

    Limitations

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

    Auto Date entry

    Thanks it work perfectly.
  7. R

    Auto Date entry

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

    Future Date input

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

    I need expert advice please.

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

    Date question

    Thank you for guiding me the right way. I agree it is useless to store these dates. I will do it in a query. I do have it in a Unbound Text box for every record.
  11. R

    Date question

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

    Date problem

    I have done that in the past to set the default to =Now()+180. But the problem is that the inspections was done a few days+ ago. So the date must be entered the day the inspection was done. The only solution seems to be that you type in the next inspection date.
  13. R

    Date problem

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

    If Function

    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"...
  15. R

    Previous row entry

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

    Can't open Excel from Access

    Thank you so much for the help, I will try this and contact you again. I do not know much about VB, but it is a challenge. :D
  17. R

    Can't open Excel from Access

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

    Numbering

    Code: =Right(Date(),2) & Right(NZ(DMax("[EventNo]","[tbl_EmgCalls]","Left([EventNo],2)='" & Right(Date(),2) & "'"),"9900000")+1,5)-What this does is takes the last two digits of the current year (Right(Date(),2) ) and appends the last 5 digits of the largest number found for the year, plus one...
  19. R

    Combination of data from two field

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

    Help on Date

    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]...
Top Bottom