Search results

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!

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

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

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

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

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

Hi Im trying to put the Nz Function into the criteria part of my query. Basically I hace a list box that shows the tool number and description of a tool. However is the value of the the tool number = UNKNOWN how do I make it such that it will sub in the serial number instead? tool numbers are...

Is it possible to have several unbound textboxes populate with different records. I have a list of tools in a box for example. When i search that box i want the list of tools to appear. I cant use a list box because I cannot format it to the set standard needed! any ideas? Basically Im trying to...

Ihave a form which shows all tools in a box. I have images that change with each tool record. However when i put the form on continous view only the image of the first record appears across all records!! any ideas? Also is it possible to have the form in single form view but press a button that...

Hi I have a form which runs off a query. So when I select a box, i.e. box1 from a combo box and press the ok button the form closes and opens another with a list of all the tools in that box. Now here is the problem... When I search the box only the first tool in the box comes up. I have tried...

Hi everyone!! I have a form which uses a combo box. When i select an entry from the combo box it runs a query an returns several results. A list of tools to be exact. Is there any way that I can click on one fo the tools on the list and automatically be sent to a tool data form which is the...

Hi Im back again!! So i will dive straight in. I have my db nearly complete but I have to create one more search form. I created a form form my list of tools. Each with a serial no, tool no and unique id. However all these tools are stored in pallets and several could be stored in one pallet!! I...

I have a form that populates a report. I press a button to email the report and want to send it in snapshot etc! however the selection is defaulted to all and it wants to email all the reports for each record and there are 100's of them. Is there any code that can be used just to isolate the...

Hi Is there any way where I can have a command button on my form which will allow me to send a report via an email attachment. Also when pressing the button, is it possible for a list of contact or a message prompting for an email address to be entered to pop up? Any help will be appreciated...

I have created a report that i wish to email. I did this because I cannot send a snapshot of the current form in an email. But now i dont know how to link the textboxes in the report to those in my form such that when i look up a record in my form, I can press a button to preview the report...