Search results

  1. J

    audit trail

    im trying to create an audit trail to record changes made to data on a form. How do i do this? and how do i make it so that a list of the changes will b saved on a table? any help would be great!
  2. J

    Counting

    i got it working. thanks anyway!
  3. J

    Counting

    i figured that out! thnks my problem now is that im getting a figure like 367 days when the date im comparing to todays date was in oct 2011! it this because date() is in the format mm dd yy and i have my excel file in dd mm yy
  4. J

    Counting

    the field where the origional storage date is called Sdate. And this displays the date the tool went into storage on the form perfectly. However when I use the following code in my unbound textbox i get #NAME? where am i going wrong!
  5. J

    Counting

    I have a database that records the location of tools. Is it possible to record how long a tool remains in a location in calender days using vba. Basically when i enter the tool number in a search box, all its data appears. This is done. Now what im trying to do is, there is a text box called...
  6. J

    Converting reports to pdf

    Hi, Im converting my reports to pdf so that i can basically have an electronic book of all my reports. However, after clicking the convert to pdf button, after about 200 convertions, it says that the amount is too large and stops converting and just finishes the 200 it was working on. How do I...
  7. J

    Exporting reports

    Is there any way of exporting all reports such that they effectively can be made into an electronic book? Please help! Jer
  8. J

    Linked Tables

    Thanks but I figured it out. I ended up running a macro in Excel which solved the problem so that Access could read the spreadsheet.
  9. J

    Linked Tables

    I have a linked excel table as the overall source for my db. However when the table is linked and i open it in access, some of the columns of information display #NUM!. All the fields are formatted to text fields so I dont know whats going on! Help Please! Jer
  10. J

    Have several unbound textboxes populate with different records

    its ok, i figured it out using a few IIF statements, thaks anyway
  11. J

    Making texboxes invisible depending on the value in them

    Thanks Mr.B but I figured it out Thanks anyway!!
  12. J

    Have several unbound textboxes populate with different records

    Hi vbaInet, After a bit of reading and research I figured out what you were on about. However I have one last problem. Could you take a look at the thread " Making texboxes invisible depending on the value in them " a let me know what yop think. Thanks.
  13. J

    Making texboxes invisible depending on the value in them

    Hi, How do you make a textbox invisible depending on the value within then. I have a continous form which shows a textbox for tool numbers. However, when the tool number is "UNKNOWN" how do I make it that it substitutes in the Serial number of the Tool in its place? Please help!! Jer
  14. J

    Have several unbound textboxes populate with different records

    Would you be able to create an example for me because im finding it difficult to follow you..
  15. J

    Have several unbound textboxes populate with different records

    change the labels to textboxes? I put a few textboxes in the header but they all just show up the details of the first tool.
  16. J

    Have several unbound textboxes populate with different records

    i have the form in datasheet view so it comes up as a table. You follow? Its the column headings, I want their background colour to change depending on the type of engine the tools are used for..
  17. J

    Have several unbound textboxes populate with different records

    Access 2000 ya i have used that, but can that apply to the header of the table?
  18. J

    Have several unbound textboxes populate with different records

    I have the subform in datasheet view. So from this i get a list of the tools in the pallet. The list grows with the number of tools etc so i dont have to worry about blank cells! However there are different tools for different engines. The form in datasheet view appears as a table with Tool No#...
  19. J

    Have several unbound textboxes populate with different records

    I have done a little research any what I am trying to do cant be done with a subform in datasheet view! Is there any way as i previously said to just creat a list from textboxes, each populating with the name of a tool in a pallet. i.e. if there are 10 tools then the 10 textboxes will populate...
  20. J

    Have several unbound textboxes populate with different records

    I have a subform in datasheet view if thats what you are refering to! but the only porblem I am having is that i cant change the size and colours of the column headings! any ideas?
Top Bottom