Recent content by jer

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